DBA Data[Home] [Help]

APPS.CSI_ACCT_MERGE_PKG dependencies on STANDARD

Line 1604: last_updated_by = arp_standard.profile.user_id ,

1600: SET CUSTOMER_ID = NUM_COL1_NEW_LIST(I) ,
1601: BILL_TO_SITE_USE_ID = NUM_COL2_NEW_LIST(I) ,
1602: SHIP_TO_SITE_USE_ID = NUM_COL3_NEW_LIST(I) ,
1603: LAST_UPDATE_DATE = SYSDATE ,
1604: last_updated_by = arp_standard.profile.user_id ,
1605: last_update_login = arp_standard.profile.last_update_login ,
1606: REQUEST_ID = req_id ,
1607: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id ,
1608: PROGRAM_ID = arp_standard.profile.program_id ,

Line 1605: last_update_login = arp_standard.profile.last_update_login ,

1601: BILL_TO_SITE_USE_ID = NUM_COL2_NEW_LIST(I) ,
1602: SHIP_TO_SITE_USE_ID = NUM_COL3_NEW_LIST(I) ,
1603: LAST_UPDATE_DATE = SYSDATE ,
1604: last_updated_by = arp_standard.profile.user_id ,
1605: last_update_login = arp_standard.profile.last_update_login ,
1606: REQUEST_ID = req_id ,
1607: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id ,
1608: PROGRAM_ID = arp_standard.profile.program_id ,
1609: PROGRAM_UPDATE_DATE = SYSDATE

Line 1607: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id ,

1603: LAST_UPDATE_DATE = SYSDATE ,
1604: last_updated_by = arp_standard.profile.user_id ,
1605: last_update_login = arp_standard.profile.last_update_login ,
1606: REQUEST_ID = req_id ,
1607: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id ,
1608: PROGRAM_ID = arp_standard.profile.program_id ,
1609: PROGRAM_UPDATE_DATE = SYSDATE
1610: WHERE SYSTEM_ID = PRIMARY_KEY_ID_LIST(I);
1611:

Line 1608: PROGRAM_ID = arp_standard.profile.program_id ,

1604: last_updated_by = arp_standard.profile.user_id ,
1605: last_update_login = arp_standard.profile.last_update_login ,
1606: REQUEST_ID = req_id ,
1607: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id ,
1608: PROGRAM_ID = arp_standard.profile.program_id ,
1609: PROGRAM_UPDATE_DATE = SYSDATE
1610: WHERE SYSTEM_ID = PRIMARY_KEY_ID_LIST(I);
1611:
1612: /*------

Line 1696: arp_standard.profile.user_id ,

1692: sysdate ,
1693: v_transaction_type_id ,
1694: req_id ,
1695: set_num ,
1696: arp_standard.profile.user_id ,
1697: sysdate ,
1698: arp_standard.profile.user_id ,
1699: sysdate ,
1700: arp_standard.profile.last_update_login ,

Line 1698: arp_standard.profile.user_id ,

1694: req_id ,
1695: set_num ,
1696: arp_standard.profile.user_id ,
1697: sysdate ,
1698: arp_standard.profile.user_id ,
1699: sysdate ,
1700: arp_standard.profile.last_update_login ,
1701: 1
1702: );

Line 1700: arp_standard.profile.last_update_login ,

1696: arp_standard.profile.user_id ,
1697: sysdate ,
1698: arp_standard.profile.user_id ,
1699: sysdate ,
1700: arp_standard.profile.last_update_login ,
1701: 1
1702: );
1703:
1704: v_transaction_exists := 'Y';

Line 1782: arp_standard.profile.user_id ,

1778: NUM_COL2_NEW_LIST(I) ,
1779: NUM_COL3_ORIG_LIST(I) ,
1780: NUM_COL3_NEW_LIST(I) ,
1781: 'N',
1782: arp_standard.profile.user_id ,
1783: sysdate ,
1784: arp_standard.profile.user_id ,
1785: sysdate ,
1786: arp_standard.profile.last_update_login ,

Line 1784: arp_standard.profile.user_id ,

1780: NUM_COL3_NEW_LIST(I) ,
1781: 'N',
1782: arp_standard.profile.user_id ,
1783: sysdate ,
1784: arp_standard.profile.user_id ,
1785: sysdate ,
1786: arp_standard.profile.last_update_login ,
1787: 1
1788: );

Line 1786: arp_standard.profile.last_update_login ,

1782: arp_standard.profile.user_id ,
1783: sysdate ,
1784: arp_standard.profile.user_id ,
1785: sysdate ,
1786: arp_standard.profile.last_update_login ,
1787: 1
1788: );
1789: write_to_cr_log( 'CSI : inserted system history record ' );
1790: END; -- } Insert systems history

Line 1975: last_updated_by = arp_standard.profile.user_id ,

1971: SET ACCOUNT_ID = NUM_COL1_NEW_LIST(I) ,
1972: BILL_TO_ADDRESS_ID = NUM_COL2_NEW_LIST(I) ,
1973: SHIP_TO_ADDRESS_ID = NUM_COL3_NEW_LIST(I) ,
1974: LAST_UPDATE_DATE = SYSDATE ,
1975: last_updated_by = arp_standard.profile.user_id ,
1976: last_update_login = arp_standard.profile.last_update_login ,
1977: REQUEST_ID = req_id ,
1978: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id ,
1979: PROGRAM_ID = arp_standard.profile.program_id ,

Line 1976: last_update_login = arp_standard.profile.last_update_login ,

1972: BILL_TO_ADDRESS_ID = NUM_COL2_NEW_LIST(I) ,
1973: SHIP_TO_ADDRESS_ID = NUM_COL3_NEW_LIST(I) ,
1974: LAST_UPDATE_DATE = SYSDATE ,
1975: last_updated_by = arp_standard.profile.user_id ,
1976: last_update_login = arp_standard.profile.last_update_login ,
1977: REQUEST_ID = req_id ,
1978: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id ,
1979: PROGRAM_ID = arp_standard.profile.program_id ,
1980: PROGRAM_UPDATE_DATE = SYSDATE

Line 1978: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id ,

1974: LAST_UPDATE_DATE = SYSDATE ,
1975: last_updated_by = arp_standard.profile.user_id ,
1976: last_update_login = arp_standard.profile.last_update_login ,
1977: REQUEST_ID = req_id ,
1978: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id ,
1979: PROGRAM_ID = arp_standard.profile.program_id ,
1980: PROGRAM_UPDATE_DATE = SYSDATE
1981: WHERE TXN_ACCOUNT_DETAIL_ID = PRIMARY_KEY_ID_LIST(I);
1982:

Line 1979: PROGRAM_ID = arp_standard.profile.program_id ,

1975: last_updated_by = arp_standard.profile.user_id ,
1976: last_update_login = arp_standard.profile.last_update_login ,
1977: REQUEST_ID = req_id ,
1978: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id ,
1979: PROGRAM_ID = arp_standard.profile.program_id ,
1980: PROGRAM_UPDATE_DATE = SYSDATE
1981: WHERE TXN_ACCOUNT_DETAIL_ID = PRIMARY_KEY_ID_LIST(I);
1982:
1983: l_count := l_count + SQL%ROWCOUNT;

Line 2173: last_updated_by = arp_standard.profile.user_id ,

2169: BILL_TO_SITE_USE_ID = NUM_COL2_NEW_LIST(I) ,
2170: SHIP_TO_SITE_USE_ID = NUM_COL3_NEW_LIST(I) ,
2171: INSTALL_SITE_USE_ID = NUM_COL4_NEW_LIST(I) ,
2172: LAST_UPDATE_DATE = SYSDATE ,
2173: last_updated_by = arp_standard.profile.user_id ,
2174: last_update_login = arp_standard.profile.last_update_login ,
2175: REQUEST_ID = req_id ,
2176: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id ,
2177: PROGRAM_ID = arp_standard.profile.program_id ,

Line 2174: last_update_login = arp_standard.profile.last_update_login ,

2170: SHIP_TO_SITE_USE_ID = NUM_COL3_NEW_LIST(I) ,
2171: INSTALL_SITE_USE_ID = NUM_COL4_NEW_LIST(I) ,
2172: LAST_UPDATE_DATE = SYSDATE ,
2173: last_updated_by = arp_standard.profile.user_id ,
2174: last_update_login = arp_standard.profile.last_update_login ,
2175: REQUEST_ID = req_id ,
2176: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id ,
2177: PROGRAM_ID = arp_standard.profile.program_id ,
2178: PROGRAM_UPDATE_DATE = SYSDATE

Line 2176: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id ,

2172: LAST_UPDATE_DATE = SYSDATE ,
2173: last_updated_by = arp_standard.profile.user_id ,
2174: last_update_login = arp_standard.profile.last_update_login ,
2175: REQUEST_ID = req_id ,
2176: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id ,
2177: PROGRAM_ID = arp_standard.profile.program_id ,
2178: PROGRAM_UPDATE_DATE = SYSDATE
2179: WHERE TRANSACTION_SYSTEM_ID = PRIMARY_KEY_ID_LIST(I);
2180:

Line 2177: PROGRAM_ID = arp_standard.profile.program_id ,

2173: last_updated_by = arp_standard.profile.user_id ,
2174: last_update_login = arp_standard.profile.last_update_login ,
2175: REQUEST_ID = req_id ,
2176: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id ,
2177: PROGRAM_ID = arp_standard.profile.program_id ,
2178: PROGRAM_UPDATE_DATE = SYSDATE
2179: WHERE TRANSACTION_SYSTEM_ID = PRIMARY_KEY_ID_LIST(I);
2180:
2181: l_count := l_count + SQL%ROWCOUNT;