eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_CCMIGRATE_PVT dependencies on IBY_CC_SECURITY_PUB

Line 476: and sec.sec_segment_id = IBY_CC_SECURITY_PUB.get_segment_id(oksline.cc_no)

472: and IV.bill_to_site_use_id = PAYER.ACCT_SITE_USE_ID(+)
473: ---and IV.authoring_org_id = PAYER.ORG_ID(+)
474: and 'OPERATING_UNIT' = PAYER.ORG_TYPE(+)
475: and 'CUSTOMER_PAYMENT' = PAYER.PAYMENT_FUNCTION(+)
476: and sec.sec_segment_id = IBY_CC_SECURITY_PUB.get_segment_id(oksline.cc_no)
477: and sec.CC_ISSUER_RANGE_ID = RANGE.CC_ISSUER_RANGE_ID (+)
478: and oksline.id BETWEEN p_id_low AND p_id_high;
479:
480: -- Cursor that queries all transactions needed to be migrated with encryption disable

Line 548: IF (iby_cc_security_pub.encryption_enabled()) THEN

544: --open the cursor and migrate the stuff
545:
546: l_user_id := NVL(fnd_global.user_id, -1);
547:
548: IF (iby_cc_security_pub.encryption_enabled()) THEN
549: -- security enabled
550: OPEN oksline_cur_sec;
551: Else
552: OPEN oksline_cur;

Line 556: IF (iby_cc_security_pub.encryption_enabled()) THEN

552: OPEN oksline_cur;
553: End if;
554:
555: LOOP
556: IF (iby_cc_security_pub.encryption_enabled()) THEN
557: FETCH oksline_cur_sec BULK COLLECT INTO
558: oksline_id, oksline_major_version, c_cc_number, c_cc_code, c_cc_exp_date,
559: okcline_id, okchdr_id, c_customer_id, c_cust_account_id,
560: c_cust_site_use_id, c_org_id, c_trxn_entity_id, c_cc_id, c_ext_payer_id,

Line 764: IF (iby_cc_security_pub.encryption_enabled()) THEN

760: c_cc_masked_num.delete;
761:
762: END LOOP;
763:
764: IF (iby_cc_security_pub.encryption_enabled()) THEN
765: CLOSE oksline_cur_sec;
766: ELSE
767: CLOSE oksline_cur;
768: End if;

Line 866: and sec.sec_segment_id = IBY_CC_SECURITY_PUB.get_segment_id(oksline.cc_no)

862: and IV.bill_to_site_use_id = PAYER.ACCT_SITE_USE_ID(+)
863: ---and IV.authoring_org_id = PAYER.ORG_ID(+)
864: and 'OPERATING_UNIT' = PAYER.ORG_TYPE(+)
865: and 'CUSTOMER_PAYMENT' = PAYER.PAYMENT_FUNCTION(+)
866: and sec.sec_segment_id = IBY_CC_SECURITY_PUB.get_segment_id(oksline.cc_no)
867: and sec.CC_ISSUER_RANGE_ID = RANGE.CC_ISSUER_RANGE_ID (+)
868: and oksline.id BETWEEN p_id_low AND p_id_high;
869:
870: -- Cursor that queries all transactions needed to be migrated with encryption disable

Line 937: IF (iby_cc_security_pub.encryption_enabled()) THEN

933: --open the cursor and migrate the stuff
934:
935: l_user_id := NVL(fnd_global.user_id, -1);
936:
937: IF (iby_cc_security_pub.encryption_enabled()) THEN
938: -- security enabled
939: OPEN oksline_cur_sec;
940: Else
941: OPEN oksline_cur;

Line 945: IF (iby_cc_security_pub.encryption_enabled()) THEN

941: OPEN oksline_cur;
942: End if;
943:
944: LOOP
945: IF (iby_cc_security_pub.encryption_enabled()) THEN
946: FETCH oksline_cur_sec BULK COLLECT INTO
947: oksline_id, c_cc_number, c_cc_code, c_cc_exp_date,
948: okcline_id, okchdr_id, c_customer_id, c_cust_account_id,
949: c_cust_site_use_id, c_org_id, c_trxn_entity_id, c_cc_id, c_ext_payer_id,

Line 1152: IF (iby_cc_security_pub.encryption_enabled()) THEN

1148: c_cc_masked_num.delete;
1149:
1150: END LOOP;
1151:
1152: IF (iby_cc_security_pub.encryption_enabled()) THEN
1153: CLOSE oksline_cur_sec;
1154: ELSE
1155: CLOSE oksline_cur;
1156: End if;

Line 1258: and sec.sec_segment_id = IBY_CC_SECURITY_PUB.get_segment_id(okshdr.cc_no)

1254: and IV.bill_to_site_use_id = PAYER.ACCT_SITE_USE_ID(+)
1255: ---and IV.authoring_org_id = PAYER.ORG_ID(+)
1256: and 'OPERATING_UNIT' = PAYER.ORG_TYPE(+)
1257: and 'CUSTOMER_PAYMENT' = PAYER.PAYMENT_FUNCTION(+)
1258: and sec.sec_segment_id = IBY_CC_SECURITY_PUB.get_segment_id(okshdr.cc_no)
1259: and sec.CC_ISSUER_RANGE_ID = RANGE.CC_ISSUER_RANGE_ID (+)
1260: and okshdr.id BETWEEN p_id_low AND p_id_high;
1261:
1262: -- Cursor that queries all transactions needed to be migrated with encryption disable

Line 1332: IF (iby_cc_security_pub.encryption_enabled()) THEN

1328: --open the cursor and migrate the stuff
1329:
1330: l_user_id := NVL(fnd_global.user_id, -1);
1331:
1332: IF (iby_cc_security_pub.encryption_enabled()) THEN
1333: -- security enabled
1334: OPEN okshdr_cur_sec;
1335: Else
1336: OPEN okshdr_cur;

Line 1340: IF (iby_cc_security_pub.encryption_enabled()) THEN

1336: OPEN okshdr_cur;
1337: End if;
1338:
1339: LOOP
1340: IF (iby_cc_security_pub.encryption_enabled()) THEN
1341: FETCH okshdr_cur_sec BULK COLLECT INTO
1342: okshdr_id, oksline_major_version, c_cc_number, c_cc_code, c_cc_exp_date,
1343: okchdr_id, c_customer_id, c_cust_account_id,
1344: c_cust_site_use_id, c_org_id, c_trxn_entity_id, c_cc_id, c_ext_payer_id,

Line 1548: IF (iby_cc_security_pub.encryption_enabled()) THEN

1544: c_cc_masked_num.delete;
1545:
1546: END LOOP;
1547:
1548: IF (iby_cc_security_pub.encryption_enabled()) THEN
1549: CLOSE okshdr_cur_sec;
1550: ELSE
1551: CLOSE okshdr_cur;
1552: End if;

Line 1652: and sec.sec_segment_id = IBY_CC_SECURITY_PUB.get_segment_id(okshdr.cc_no)

1648: and IV.bill_to_site_use_id = PAYER.ACCT_SITE_USE_ID(+)
1649: ---and IV.authoring_org_id = PAYER.ORG_ID(+)
1650: and 'OPERATING_UNIT' = PAYER.ORG_TYPE(+)
1651: and 'CUSTOMER_PAYMENT' = PAYER.PAYMENT_FUNCTION(+)
1652: and sec.sec_segment_id = IBY_CC_SECURITY_PUB.get_segment_id(okshdr.cc_no)
1653: and sec.CC_ISSUER_RANGE_ID = RANGE.CC_ISSUER_RANGE_ID (+)
1654: and okshdr.id BETWEEN p_id_low AND p_id_high;
1655:
1656: -- Cursor that queries all transactions needed to be migrated with encryption disable

Line 1724: IF (iby_cc_security_pub.encryption_enabled()) THEN

1720: --open the cursor and migrate the stuff
1721:
1722: l_user_id := NVL(fnd_global.user_id, -1);
1723:
1724: IF (iby_cc_security_pub.encryption_enabled()) THEN
1725: -- security enabled
1726: OPEN okshdr_cur_sec;
1727: Else
1728: OPEN okshdr_cur;

Line 1732: IF (iby_cc_security_pub.encryption_enabled()) THEN

1728: OPEN okshdr_cur;
1729: End if;
1730:
1731: LOOP
1732: IF (iby_cc_security_pub.encryption_enabled()) THEN
1733: FETCH okshdr_cur_sec BULK COLLECT INTO
1734: okshdr_id, c_cc_number, c_cc_code, c_cc_exp_date,
1735: okchdr_id, c_customer_id, c_cust_account_id,
1736: c_cust_site_use_id, c_org_id, c_trxn_entity_id, c_cc_id, c_ext_payer_id,

Line 1939: IF (iby_cc_security_pub.encryption_enabled()) THEN

1935: c_cc_masked_num.delete;
1936:
1937: END LOOP;
1938:
1939: IF (iby_cc_security_pub.encryption_enabled()) THEN
1940: CLOSE okshdr_cur_sec;
1941: ELSE
1942: CLOSE okshdr_cur;
1943: End if;