DECLARE
result_set INTEGER;
BEGIN
GAL.PKG_COUNTERPARTY.UI_COUNTERPARTY(0, 1,
1, ‘ABN’, ‘ULT P NAME’, 1, ‘USA’, ‘PUB SECURITY’, NULL, 1, ‘Y’, ‘Y’, ‘Y’, 1, ‘N’, 7,
‘GNM’, 1, SYSDATE, ‘SHORT SUM’, 1, ‘Y’,
SYSDATE, SYSDATE, ‘SHORT SUM’, 1, ‘SHORT SUM’, SYSDATE, ‘Y’, ‘V_RSRCH_UNIT_CNTCT’, ‘V_SPNSR_UNIT_CNTCT’,
‘V_CRTS_CNTCT’, ‘V_XTRA_FIELD1′, ‘V_XTRA_FIELD2′, ‘V_XTRA_FIELD3 ‘, ‘V_XTRA_FIELD4 ‘, ‘V_XTRA_FIELD5 ‘, ‘SYSADMN’, SYSDATE,
result_set);
dbms_output.put_line(‘cp id : ‘ || result_set);
END;
————————-Ref Cursor ——————————
DECLARE
type result_set is ref cursor;
BEGIN
SK_CORAL.STAT_CERTIFICATE_PKG.GENERATENONNAICSUSPANCE(’31-OCT-2010′,:result_set);
END;
