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.OZF_ACCOUNT_MERGE_PKG dependencies on STANDARD

Line 144: , last_updated_by=arp_standard.profile.user_id

140: cust_account_id=NUM_COL1_NEW_LIST(I)
141: ,bill_to_site_use_id=NUM_COL2_NEW_LIST(I)
142: ,site_use_id=NUM_COL3_NEW_LIST(I)
143: , LAST_UPDATE_DATE=SYSDATE
144: , last_updated_by=arp_standard.profile.user_id
145: , last_update_login=arp_standard.profile.last_update_login
146: WHERE account_allocation_id=PRIMARY_KEY_ID1_LIST(I)
147: ;
148: l_count := l_count + SQL%ROWCOUNT;

Line 145: , last_update_login=arp_standard.profile.last_update_login

141: ,bill_to_site_use_id=NUM_COL2_NEW_LIST(I)
142: ,site_use_id=NUM_COL3_NEW_LIST(I)
143: , LAST_UPDATE_DATE=SYSDATE
144: , last_updated_by=arp_standard.profile.user_id
145: , last_update_login=arp_standard.profile.last_update_login
146: WHERE account_allocation_id=PRIMARY_KEY_ID1_LIST(I)
147: ;
148: l_count := l_count + SQL%ROWCOUNT;
149: IF l_last_fetch THEN

Line 283: , last_updated_by=arp_standard.profile.user_id

279: UPDATE ozf_claim_lines yt SET
280: related_cust_account_id=NUM_COL1_NEW_LIST(I)
281: ,buy_group_cust_account_id=NUM_COL2_NEW_LIST(I)
282: , LAST_UPDATE_DATE=SYSDATE
283: , last_updated_by=arp_standard.profile.user_id
284: , last_update_login=arp_standard.profile.last_update_login
285: , REQUEST_ID=req_id
286: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
287: , PROGRAM_ID=arp_standard.profile.program_id

Line 284: , last_update_login=arp_standard.profile.last_update_login

280: related_cust_account_id=NUM_COL1_NEW_LIST(I)
281: ,buy_group_cust_account_id=NUM_COL2_NEW_LIST(I)
282: , LAST_UPDATE_DATE=SYSDATE
283: , last_updated_by=arp_standard.profile.user_id
284: , last_update_login=arp_standard.profile.last_update_login
285: , REQUEST_ID=req_id
286: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
287: , PROGRAM_ID=arp_standard.profile.program_id
288: , PROGRAM_UPDATE_DATE=SYSDATE

Line 286: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

282: , LAST_UPDATE_DATE=SYSDATE
283: , last_updated_by=arp_standard.profile.user_id
284: , last_update_login=arp_standard.profile.last_update_login
285: , REQUEST_ID=req_id
286: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
287: , PROGRAM_ID=arp_standard.profile.program_id
288: , PROGRAM_UPDATE_DATE=SYSDATE
289: WHERE claim_line_id=PRIMARY_KEY_ID1_LIST(I)
290: ;

Line 287: , PROGRAM_ID=arp_standard.profile.program_id

283: , last_updated_by=arp_standard.profile.user_id
284: , last_update_login=arp_standard.profile.last_update_login
285: , REQUEST_ID=req_id
286: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
287: , PROGRAM_ID=arp_standard.profile.program_id
288: , PROGRAM_UPDATE_DATE=SYSDATE
289: WHERE claim_line_id=PRIMARY_KEY_ID1_LIST(I)
290: ;
291: l_count := l_count + SQL%ROWCOUNT;

Line 427: , last_updated_by=arp_standard.profile.user_id

423: UPDATE ozf_claim_lines_hist yt SET
424: related_cust_account_id=NUM_COL1_NEW_LIST(I)
425: ,buy_group_cust_account_id=NUM_COL2_NEW_LIST(I)
426: , LAST_UPDATE_DATE=SYSDATE
427: , last_updated_by=arp_standard.profile.user_id
428: , last_update_login=arp_standard.profile.last_update_login
429: , REQUEST_ID=req_id
430: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
431: , PROGRAM_ID=arp_standard.profile.program_id

Line 428: , last_update_login=arp_standard.profile.last_update_login

424: related_cust_account_id=NUM_COL1_NEW_LIST(I)
425: ,buy_group_cust_account_id=NUM_COL2_NEW_LIST(I)
426: , LAST_UPDATE_DATE=SYSDATE
427: , last_updated_by=arp_standard.profile.user_id
428: , last_update_login=arp_standard.profile.last_update_login
429: , REQUEST_ID=req_id
430: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
431: , PROGRAM_ID=arp_standard.profile.program_id
432: , PROGRAM_UPDATE_DATE=SYSDATE

Line 430: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

426: , LAST_UPDATE_DATE=SYSDATE
427: , last_updated_by=arp_standard.profile.user_id
428: , last_update_login=arp_standard.profile.last_update_login
429: , REQUEST_ID=req_id
430: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
431: , PROGRAM_ID=arp_standard.profile.program_id
432: , PROGRAM_UPDATE_DATE=SYSDATE
433: WHERE claim_line_history_id=PRIMARY_KEY_ID1_LIST(I)
434: ;

Line 431: , PROGRAM_ID=arp_standard.profile.program_id

427: , last_updated_by=arp_standard.profile.user_id
428: , last_update_login=arp_standard.profile.last_update_login
429: , REQUEST_ID=req_id
430: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
431: , PROGRAM_ID=arp_standard.profile.program_id
432: , PROGRAM_UPDATE_DATE=SYSDATE
433: WHERE claim_line_history_id=PRIMARY_KEY_ID1_LIST(I)
434: ;
435: l_count := l_count + SQL%ROWCOUNT;

Line 631: , last_updated_by=arp_standard.profile.user_id

627: ,cust_shipto_acct_site_id=NUM_COL4_NEW_LIST(I)
628: ,related_cust_account_id=NUM_COL5_NEW_LIST(I)
629: ,related_site_use_id=NUM_COL6_NEW_LIST(I)
630: , LAST_UPDATE_DATE=SYSDATE
631: , last_updated_by=arp_standard.profile.user_id
632: , last_update_login=arp_standard.profile.last_update_login
633: , REQUEST_ID=req_id
634: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
635: , PROGRAM_ID=arp_standard.profile.program_id

Line 632: , last_update_login=arp_standard.profile.last_update_login

628: ,related_cust_account_id=NUM_COL5_NEW_LIST(I)
629: ,related_site_use_id=NUM_COL6_NEW_LIST(I)
630: , LAST_UPDATE_DATE=SYSDATE
631: , last_updated_by=arp_standard.profile.user_id
632: , last_update_login=arp_standard.profile.last_update_login
633: , REQUEST_ID=req_id
634: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
635: , PROGRAM_ID=arp_standard.profile.program_id
636: , PROGRAM_UPDATE_DATE=SYSDATE

Line 634: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

630: , LAST_UPDATE_DATE=SYSDATE
631: , last_updated_by=arp_standard.profile.user_id
632: , last_update_login=arp_standard.profile.last_update_login
633: , REQUEST_ID=req_id
634: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
635: , PROGRAM_ID=arp_standard.profile.program_id
636: , PROGRAM_UPDATE_DATE=SYSDATE
637: WHERE claim_id=PRIMARY_KEY_ID1_LIST(I)
638: ;

Line 635: , PROGRAM_ID=arp_standard.profile.program_id

631: , last_updated_by=arp_standard.profile.user_id
632: , last_update_login=arp_standard.profile.last_update_login
633: , REQUEST_ID=req_id
634: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
635: , PROGRAM_ID=arp_standard.profile.program_id
636: , PROGRAM_UPDATE_DATE=SYSDATE
637: WHERE claim_id=PRIMARY_KEY_ID1_LIST(I)
638: ;
639: l_count := l_count + SQL%ROWCOUNT;

Line 835: , last_updated_by=arp_standard.profile.user_id

831: ,cust_shipto_acct_site_id=NUM_COL4_NEW_LIST(I)
832: ,related_cust_account_id=NUM_COL5_NEW_LIST(I)
833: ,related_site_use_id=NUM_COL6_NEW_LIST(I)
834: , LAST_UPDATE_DATE=SYSDATE
835: , last_updated_by=arp_standard.profile.user_id
836: , last_update_login=arp_standard.profile.last_update_login
837: , REQUEST_ID=req_id
838: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
839: , PROGRAM_ID=arp_standard.profile.program_id

Line 836: , last_update_login=arp_standard.profile.last_update_login

832: ,related_cust_account_id=NUM_COL5_NEW_LIST(I)
833: ,related_site_use_id=NUM_COL6_NEW_LIST(I)
834: , LAST_UPDATE_DATE=SYSDATE
835: , last_updated_by=arp_standard.profile.user_id
836: , last_update_login=arp_standard.profile.last_update_login
837: , REQUEST_ID=req_id
838: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
839: , PROGRAM_ID=arp_standard.profile.program_id
840: , PROGRAM_UPDATE_DATE=SYSDATE

Line 838: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

834: , LAST_UPDATE_DATE=SYSDATE
835: , last_updated_by=arp_standard.profile.user_id
836: , last_update_login=arp_standard.profile.last_update_login
837: , REQUEST_ID=req_id
838: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
839: , PROGRAM_ID=arp_standard.profile.program_id
840: , PROGRAM_UPDATE_DATE=SYSDATE
841: WHERE claim_history_id=PRIMARY_KEY_ID1_LIST(I)
842: ;

Line 839: , PROGRAM_ID=arp_standard.profile.program_id

835: , last_updated_by=arp_standard.profile.user_id
836: , last_update_login=arp_standard.profile.last_update_login
837: , REQUEST_ID=req_id
838: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
839: , PROGRAM_ID=arp_standard.profile.program_id
840: , PROGRAM_UPDATE_DATE=SYSDATE
841: WHERE claim_history_id=PRIMARY_KEY_ID1_LIST(I)
842: ;
843: l_count := l_count + SQL%ROWCOUNT;

Line 964: , last_updated_by=arp_standard.profile.user_id

960: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
961: UPDATE ozf_code_conversions yt SET
962: cust_account_id=NUM_COL1_NEW_LIST(I)
963: , LAST_UPDATE_DATE=SYSDATE
964: , last_updated_by=arp_standard.profile.user_id
965: , last_update_login=arp_standard.profile.last_update_login
966: WHERE code_conversion_id=PRIMARY_KEY_ID1_LIST(I)
967: ;
968: l_count := l_count + SQL%ROWCOUNT;

Line 965: , last_update_login=arp_standard.profile.last_update_login

961: UPDATE ozf_code_conversions yt SET
962: cust_account_id=NUM_COL1_NEW_LIST(I)
963: , LAST_UPDATE_DATE=SYSDATE
964: , last_updated_by=arp_standard.profile.user_id
965: , last_update_login=arp_standard.profile.last_update_login
966: WHERE code_conversion_id=PRIMARY_KEY_ID1_LIST(I)
967: ;
968: l_count := l_count + SQL%ROWCOUNT;
969: IF l_last_fetch THEN

Line 1119: , last_updated_by=arp_standard.profile.user_id

1115: cust_account_id=NUM_COL1_NEW_LIST(I)
1116: ,bill_to_site_use_id=NUM_COL2_NEW_LIST(I)
1117: ,ship_to_site_use_id=NUM_COL3_NEW_LIST(I)
1118: , LAST_UPDATE_DATE=SYSDATE
1119: , last_updated_by=arp_standard.profile.user_id
1120: , last_update_login=arp_standard.profile.last_update_login
1121: WHERE cust_daily_fact_id=PRIMARY_KEY_ID1_LIST(I)
1122: ;
1123: l_count := l_count + SQL%ROWCOUNT;

Line 1120: , last_update_login=arp_standard.profile.last_update_login

1116: ,bill_to_site_use_id=NUM_COL2_NEW_LIST(I)
1117: ,ship_to_site_use_id=NUM_COL3_NEW_LIST(I)
1118: , LAST_UPDATE_DATE=SYSDATE
1119: , last_updated_by=arp_standard.profile.user_id
1120: , last_update_login=arp_standard.profile.last_update_login
1121: WHERE cust_daily_fact_id=PRIMARY_KEY_ID1_LIST(I)
1122: ;
1123: l_count := l_count + SQL%ROWCOUNT;
1124: IF l_last_fetch THEN

Line 1258: , last_updated_by=arp_standard.profile.user_id

1254: UPDATE ozf_funds_utilized_all_b yt SET
1255: cust_account_id=NUM_COL1_NEW_LIST(I)
1256: ,billto_cust_account_id=NUM_COL2_NEW_LIST(I)
1257: , LAST_UPDATE_DATE=SYSDATE
1258: , last_updated_by=arp_standard.profile.user_id
1259: , last_update_login=arp_standard.profile.last_update_login
1260: , REQUEST_ID=req_id
1261: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
1262: , PROGRAM_ID=arp_standard.profile.program_id

Line 1259: , last_update_login=arp_standard.profile.last_update_login

1255: cust_account_id=NUM_COL1_NEW_LIST(I)
1256: ,billto_cust_account_id=NUM_COL2_NEW_LIST(I)
1257: , LAST_UPDATE_DATE=SYSDATE
1258: , last_updated_by=arp_standard.profile.user_id
1259: , last_update_login=arp_standard.profile.last_update_login
1260: , REQUEST_ID=req_id
1261: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
1262: , PROGRAM_ID=arp_standard.profile.program_id
1263: , PROGRAM_UPDATE_DATE=SYSDATE

Line 1261: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

1257: , LAST_UPDATE_DATE=SYSDATE
1258: , last_updated_by=arp_standard.profile.user_id
1259: , last_update_login=arp_standard.profile.last_update_login
1260: , REQUEST_ID=req_id
1261: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
1262: , PROGRAM_ID=arp_standard.profile.program_id
1263: , PROGRAM_UPDATE_DATE=SYSDATE
1264: WHERE utilization_id=PRIMARY_KEY_ID1_LIST(I)
1265: ;

Line 1262: , PROGRAM_ID=arp_standard.profile.program_id

1258: , last_updated_by=arp_standard.profile.user_id
1259: , last_update_login=arp_standard.profile.last_update_login
1260: , REQUEST_ID=req_id
1261: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
1262: , PROGRAM_ID=arp_standard.profile.program_id
1263: , PROGRAM_UPDATE_DATE=SYSDATE
1264: WHERE utilization_id=PRIMARY_KEY_ID1_LIST(I)
1265: ;
1266: l_count := l_count + SQL%ROWCOUNT;

Line 1412: , last_updated_by=arp_standard.profile.user_id

1408: UPDATE ozf_activity_customers yt SET
1409: cust_account_id=NUM_COL1_NEW_LIST(I)
1410: ,site_use_id=NUM_COL2_NEW_LIST(I)
1411: , LAST_UPDATE_DATE=SYSDATE
1412: , last_updated_by=arp_standard.profile.user_id
1413: , last_update_login=arp_standard.profile.last_update_login
1414: WHERE object_class=PRIMARY_KEY1_LIST(I)
1415: AND object_id=PRIMARY_KEY2_LIST(I)
1416: ;

Line 1413: , last_update_login=arp_standard.profile.last_update_login

1409: cust_account_id=NUM_COL1_NEW_LIST(I)
1410: ,site_use_id=NUM_COL2_NEW_LIST(I)
1411: , LAST_UPDATE_DATE=SYSDATE
1412: , last_updated_by=arp_standard.profile.user_id
1413: , last_update_login=arp_standard.profile.last_update_login
1414: WHERE object_class=PRIMARY_KEY1_LIST(I)
1415: AND object_id=PRIMARY_KEY2_LIST(I)
1416: ;
1417: l_count := l_count + SQL%ROWCOUNT;

Line 1539: , last_updated_by=arp_standard.profile.user_id

1535: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1536: UPDATE ozf_offers yt SET
1537: beneficiary_account_id=NUM_COL1_NEW_LIST(I)
1538: , LAST_UPDATE_DATE=SYSDATE
1539: , last_updated_by=arp_standard.profile.user_id
1540: , last_update_login=arp_standard.profile.last_update_login
1541: WHERE qp_list_header_id=PRIMARY_KEY_ID1_LIST(I)
1542: ;
1543: l_count := l_count + SQL%ROWCOUNT;

Line 1540: , last_update_login=arp_standard.profile.last_update_login

1536: UPDATE ozf_offers yt SET
1537: beneficiary_account_id=NUM_COL1_NEW_LIST(I)
1538: , LAST_UPDATE_DATE=SYSDATE
1539: , last_updated_by=arp_standard.profile.user_id
1540: , last_update_login=arp_standard.profile.last_update_login
1541: WHERE qp_list_header_id=PRIMARY_KEY_ID1_LIST(I)
1542: ;
1543: l_count := l_count + SQL%ROWCOUNT;
1544: IF l_last_fetch THEN

Line 1694: , last_updated_by=arp_standard.profile.user_id

1690: reseller_site_use_id=NUM_COL1_NEW_LIST(I)
1691: ,end_cust_site_use_id=NUM_COL2_NEW_LIST(I)
1692: ,partner_site_use_id=NUM_COL3_NEW_LIST(I)
1693: , LAST_UPDATE_DATE=SYSDATE
1694: , last_updated_by=arp_standard.profile.user_id
1695: , last_update_login=arp_standard.profile.last_update_login
1696: , REQUEST_ID=req_id
1697: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
1698: , PROGRAM_ID=arp_standard.profile.program_id

Line 1695: , last_update_login=arp_standard.profile.last_update_login

1691: ,end_cust_site_use_id=NUM_COL2_NEW_LIST(I)
1692: ,partner_site_use_id=NUM_COL3_NEW_LIST(I)
1693: , LAST_UPDATE_DATE=SYSDATE
1694: , last_updated_by=arp_standard.profile.user_id
1695: , last_update_login=arp_standard.profile.last_update_login
1696: , REQUEST_ID=req_id
1697: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
1698: , PROGRAM_ID=arp_standard.profile.program_id
1699: , PROGRAM_UPDATE_DATE=SYSDATE

Line 1697: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

1693: , LAST_UPDATE_DATE=SYSDATE
1694: , last_updated_by=arp_standard.profile.user_id
1695: , last_update_login=arp_standard.profile.last_update_login
1696: , REQUEST_ID=req_id
1697: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
1698: , PROGRAM_ID=arp_standard.profile.program_id
1699: , PROGRAM_UPDATE_DATE=SYSDATE
1700: WHERE request_header_id=PRIMARY_KEY_ID1_LIST(I)
1701: ;

Line 1698: , PROGRAM_ID=arp_standard.profile.program_id

1694: , last_updated_by=arp_standard.profile.user_id
1695: , last_update_login=arp_standard.profile.last_update_login
1696: , REQUEST_ID=req_id
1697: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
1698: , PROGRAM_ID=arp_standard.profile.program_id
1699: , PROGRAM_UPDATE_DATE=SYSDATE
1700: WHERE request_header_id=PRIMARY_KEY_ID1_LIST(I)
1701: ;
1702: l_count := l_count + SQL%ROWCOUNT;

Line 1839: , last_updated_by=arp_standard.profile.user_id

1835: UPDATE ozf_retail_price_points yt SET
1836: cust_account_id=NUM_COL1_NEW_LIST(I)
1837: ,site_use_id=NUM_COL2_NEW_LIST(I)
1838: , LAST_UPDATE_DATE=SYSDATE
1839: , last_updated_by=arp_standard.profile.user_id
1840: , last_update_login=arp_standard.profile.last_update_login
1841: WHERE retail_price_point_id=PRIMARY_KEY_ID1_LIST(I)
1842: ;
1843: l_count := l_count + SQL%ROWCOUNT;

Line 1840: , last_update_login=arp_standard.profile.last_update_login

1836: cust_account_id=NUM_COL1_NEW_LIST(I)
1837: ,site_use_id=NUM_COL2_NEW_LIST(I)
1838: , LAST_UPDATE_DATE=SYSDATE
1839: , last_updated_by=arp_standard.profile.user_id
1840: , last_update_login=arp_standard.profile.last_update_login
1841: WHERE retail_price_point_id=PRIMARY_KEY_ID1_LIST(I)
1842: ;
1843: l_count := l_count + SQL%ROWCOUNT;
1844: IF l_last_fetch THEN

Line 1979: , last_updated_by=arp_standard.profile.user_id

1975: UPDATE ozf_cust_trd_prfls yt SET
1976: cust_account_id=NUM_COL1_NEW_LIST(I)
1977: ,cust_acct_site_id=NUM_COL2_NEW_LIST(I)
1978: , LAST_UPDATE_DATE=SYSDATE
1979: , last_updated_by=arp_standard.profile.user_id
1980: , last_update_login=arp_standard.profile.last_update_login
1981: , REQUEST_ID=req_id
1982: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
1983: , PROGRAM_ID=arp_standard.profile.program_id

Line 1980: , last_update_login=arp_standard.profile.last_update_login

1976: cust_account_id=NUM_COL1_NEW_LIST(I)
1977: ,cust_acct_site_id=NUM_COL2_NEW_LIST(I)
1978: , LAST_UPDATE_DATE=SYSDATE
1979: , last_updated_by=arp_standard.profile.user_id
1980: , last_update_login=arp_standard.profile.last_update_login
1981: , REQUEST_ID=req_id
1982: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
1983: , PROGRAM_ID=arp_standard.profile.program_id
1984: , PROGRAM_UPDATE_DATE=SYSDATE

Line 1982: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

1978: , LAST_UPDATE_DATE=SYSDATE
1979: , last_updated_by=arp_standard.profile.user_id
1980: , last_update_login=arp_standard.profile.last_update_login
1981: , REQUEST_ID=req_id
1982: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
1983: , PROGRAM_ID=arp_standard.profile.program_id
1984: , PROGRAM_UPDATE_DATE=SYSDATE
1985: WHERE trade_profile_id=PRIMARY_KEY_ID1_LIST(I)
1986: ;

Line 1983: , PROGRAM_ID=arp_standard.profile.program_id

1979: , last_updated_by=arp_standard.profile.user_id
1980: , last_update_login=arp_standard.profile.last_update_login
1981: , REQUEST_ID=req_id
1982: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
1983: , PROGRAM_ID=arp_standard.profile.program_id
1984: , PROGRAM_UPDATE_DATE=SYSDATE
1985: WHERE trade_profile_id=PRIMARY_KEY_ID1_LIST(I)
1986: ;
1987: l_count := l_count + SQL%ROWCOUNT;