DBA Data[Home] [Help]

APPS.CSI_ACCT_MERGE_PKG dependencies on STANDARD

Line 1636: last_updated_by = arp_standard.profile.user_id ,

1632: SET CUSTOMER_ID = NUM_COL1_NEW_LIST(I) ,
1633: BILL_TO_SITE_USE_ID = NUM_COL2_NEW_LIST(I) ,
1634: SHIP_TO_SITE_USE_ID = NUM_COL3_NEW_LIST(I) ,
1635: LAST_UPDATE_DATE = SYSDATE ,
1636: last_updated_by = arp_standard.profile.user_id ,
1637: last_update_login = arp_standard.profile.last_update_login ,
1638: REQUEST_ID = req_id ,
1639: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id ,
1640: PROGRAM_ID = arp_standard.profile.program_id ,

Line 1637: last_update_login = arp_standard.profile.last_update_login ,

1633: BILL_TO_SITE_USE_ID = NUM_COL2_NEW_LIST(I) ,
1634: SHIP_TO_SITE_USE_ID = NUM_COL3_NEW_LIST(I) ,
1635: LAST_UPDATE_DATE = SYSDATE ,
1636: last_updated_by = arp_standard.profile.user_id ,
1637: last_update_login = arp_standard.profile.last_update_login ,
1638: REQUEST_ID = req_id ,
1639: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id ,
1640: PROGRAM_ID = arp_standard.profile.program_id ,
1641: PROGRAM_UPDATE_DATE = SYSDATE

Line 1639: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id ,

1635: LAST_UPDATE_DATE = SYSDATE ,
1636: last_updated_by = arp_standard.profile.user_id ,
1637: last_update_login = arp_standard.profile.last_update_login ,
1638: REQUEST_ID = req_id ,
1639: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id ,
1640: PROGRAM_ID = arp_standard.profile.program_id ,
1641: PROGRAM_UPDATE_DATE = SYSDATE
1642: WHERE SYSTEM_ID = PRIMARY_KEY_ID_LIST(I);
1643:

Line 1640: PROGRAM_ID = arp_standard.profile.program_id ,

1636: last_updated_by = arp_standard.profile.user_id ,
1637: last_update_login = arp_standard.profile.last_update_login ,
1638: REQUEST_ID = req_id ,
1639: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id ,
1640: PROGRAM_ID = arp_standard.profile.program_id ,
1641: PROGRAM_UPDATE_DATE = SYSDATE
1642: WHERE SYSTEM_ID = PRIMARY_KEY_ID_LIST(I);
1643:
1644: /*------

Line 1728: arp_standard.profile.user_id ,

1724: sysdate ,
1725: v_transaction_type_id ,
1726: req_id ,
1727: set_num ,
1728: arp_standard.profile.user_id ,
1729: sysdate ,
1730: arp_standard.profile.user_id ,
1731: sysdate ,
1732: arp_standard.profile.last_update_login ,

Line 1730: arp_standard.profile.user_id ,

1726: req_id ,
1727: set_num ,
1728: arp_standard.profile.user_id ,
1729: sysdate ,
1730: arp_standard.profile.user_id ,
1731: sysdate ,
1732: arp_standard.profile.last_update_login ,
1733: 1
1734: );

Line 1732: arp_standard.profile.last_update_login ,

1728: arp_standard.profile.user_id ,
1729: sysdate ,
1730: arp_standard.profile.user_id ,
1731: sysdate ,
1732: arp_standard.profile.last_update_login ,
1733: 1
1734: );
1735:
1736: v_transaction_exists := 'Y';

Line 1814: arp_standard.profile.user_id ,

1810: NUM_COL2_NEW_LIST(I) ,
1811: NUM_COL3_ORIG_LIST(I) ,
1812: NUM_COL3_NEW_LIST(I) ,
1813: 'N',
1814: arp_standard.profile.user_id ,
1815: sysdate ,
1816: arp_standard.profile.user_id ,
1817: sysdate ,
1818: arp_standard.profile.last_update_login ,

Line 1816: arp_standard.profile.user_id ,

1812: NUM_COL3_NEW_LIST(I) ,
1813: 'N',
1814: arp_standard.profile.user_id ,
1815: sysdate ,
1816: arp_standard.profile.user_id ,
1817: sysdate ,
1818: arp_standard.profile.last_update_login ,
1819: 1
1820: );

Line 1818: arp_standard.profile.last_update_login ,

1814: arp_standard.profile.user_id ,
1815: sysdate ,
1816: arp_standard.profile.user_id ,
1817: sysdate ,
1818: arp_standard.profile.last_update_login ,
1819: 1
1820: );
1821: write_to_cr_log( 'CSI : inserted system history record ' );
1822: END; -- } Insert systems history

Line 2007: last_updated_by = arp_standard.profile.user_id ,

2003: SET ACCOUNT_ID = NUM_COL1_NEW_LIST(I) ,
2004: BILL_TO_ADDRESS_ID = NUM_COL2_NEW_LIST(I) ,
2005: SHIP_TO_ADDRESS_ID = NUM_COL3_NEW_LIST(I) ,
2006: LAST_UPDATE_DATE = SYSDATE ,
2007: last_updated_by = arp_standard.profile.user_id ,
2008: last_update_login = arp_standard.profile.last_update_login ,
2009: REQUEST_ID = req_id ,
2010: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id ,
2011: PROGRAM_ID = arp_standard.profile.program_id ,

Line 2008: last_update_login = arp_standard.profile.last_update_login ,

2004: BILL_TO_ADDRESS_ID = NUM_COL2_NEW_LIST(I) ,
2005: SHIP_TO_ADDRESS_ID = NUM_COL3_NEW_LIST(I) ,
2006: LAST_UPDATE_DATE = SYSDATE ,
2007: last_updated_by = arp_standard.profile.user_id ,
2008: last_update_login = arp_standard.profile.last_update_login ,
2009: REQUEST_ID = req_id ,
2010: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id ,
2011: PROGRAM_ID = arp_standard.profile.program_id ,
2012: PROGRAM_UPDATE_DATE = SYSDATE

Line 2010: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id ,

2006: LAST_UPDATE_DATE = SYSDATE ,
2007: last_updated_by = arp_standard.profile.user_id ,
2008: last_update_login = arp_standard.profile.last_update_login ,
2009: REQUEST_ID = req_id ,
2010: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id ,
2011: PROGRAM_ID = arp_standard.profile.program_id ,
2012: PROGRAM_UPDATE_DATE = SYSDATE
2013: WHERE TXN_ACCOUNT_DETAIL_ID = PRIMARY_KEY_ID_LIST(I);
2014:

Line 2011: PROGRAM_ID = arp_standard.profile.program_id ,

2007: last_updated_by = arp_standard.profile.user_id ,
2008: last_update_login = arp_standard.profile.last_update_login ,
2009: REQUEST_ID = req_id ,
2010: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id ,
2011: PROGRAM_ID = arp_standard.profile.program_id ,
2012: PROGRAM_UPDATE_DATE = SYSDATE
2013: WHERE TXN_ACCOUNT_DETAIL_ID = PRIMARY_KEY_ID_LIST(I);
2014:
2015: l_count := l_count + SQL%ROWCOUNT;

Line 2205: last_updated_by = arp_standard.profile.user_id ,

2201: BILL_TO_SITE_USE_ID = NUM_COL2_NEW_LIST(I) ,
2202: SHIP_TO_SITE_USE_ID = NUM_COL3_NEW_LIST(I) ,
2203: INSTALL_SITE_USE_ID = NUM_COL4_NEW_LIST(I) ,
2204: LAST_UPDATE_DATE = SYSDATE ,
2205: last_updated_by = arp_standard.profile.user_id ,
2206: last_update_login = arp_standard.profile.last_update_login ,
2207: REQUEST_ID = req_id ,
2208: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id ,
2209: PROGRAM_ID = arp_standard.profile.program_id ,

Line 2206: last_update_login = arp_standard.profile.last_update_login ,

2202: SHIP_TO_SITE_USE_ID = NUM_COL3_NEW_LIST(I) ,
2203: INSTALL_SITE_USE_ID = NUM_COL4_NEW_LIST(I) ,
2204: LAST_UPDATE_DATE = SYSDATE ,
2205: last_updated_by = arp_standard.profile.user_id ,
2206: last_update_login = arp_standard.profile.last_update_login ,
2207: REQUEST_ID = req_id ,
2208: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id ,
2209: PROGRAM_ID = arp_standard.profile.program_id ,
2210: PROGRAM_UPDATE_DATE = SYSDATE

Line 2208: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id ,

2204: LAST_UPDATE_DATE = SYSDATE ,
2205: last_updated_by = arp_standard.profile.user_id ,
2206: last_update_login = arp_standard.profile.last_update_login ,
2207: REQUEST_ID = req_id ,
2208: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id ,
2209: PROGRAM_ID = arp_standard.profile.program_id ,
2210: PROGRAM_UPDATE_DATE = SYSDATE
2211: WHERE TRANSACTION_SYSTEM_ID = PRIMARY_KEY_ID_LIST(I);
2212:

Line 2209: PROGRAM_ID = arp_standard.profile.program_id ,

2205: last_updated_by = arp_standard.profile.user_id ,
2206: last_update_login = arp_standard.profile.last_update_login ,
2207: REQUEST_ID = req_id ,
2208: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id ,
2209: PROGRAM_ID = arp_standard.profile.program_id ,
2210: PROGRAM_UPDATE_DATE = SYSDATE
2211: WHERE TRANSACTION_SYSTEM_ID = PRIMARY_KEY_ID_LIST(I);
2212:
2213: l_count := l_count + SQL%ROWCOUNT;