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

Line 711: , last_updated_by = arp_standard.profile.user_id

707: FORALL I IN 1..ASSET_ID_LIST.COUNT
708: UPDATE OKL_ASSETS_B SET
709: INSTALL_SITE_ID = NEW_IS_ID_LIST(I)
710: , LAST_UPDATE_DATE = SYSDATE
711: , last_updated_by = arp_standard.profile.user_id
712: , last_update_login = arp_standard.profile.last_update_login
713: WHERE ID = ASSET_ID_LIST(I);
714:
715: x_return_status := l_return_status;

Line 712: , last_update_login = arp_standard.profile.last_update_login

708: UPDATE OKL_ASSETS_B SET
709: INSTALL_SITE_ID = NEW_IS_ID_LIST(I)
710: , LAST_UPDATE_DATE = SYSDATE
711: , last_updated_by = arp_standard.profile.user_id
712: , last_update_login = arp_standard.profile.last_update_login
713: WHERE ID = ASSET_ID_LIST(I);
714:
715: x_return_status := l_return_status;
716:

Line 817: , IPYB.last_updated_by = arp_standard.profile.user_id

813: UPDATE OKL_INS_POLICIES_ALL_B IPYB
814: SET IPYB.ISU_ID = p_to_fk_id
815: , IPYB.object_version_number = IPYB.object_version_number + 1
816: , IPYB.last_update_date = SYSDATE
817: , IPYB.last_updated_by = arp_standard.profile.user_id
818: , IPYB.last_update_login = arp_standard.profile.last_update_login
819: WHERE IPYB.ISU_ID = p_from_fk_id
820: AND IPY_TYPE = 'THIRD_PARTY_POLICY';
821:

Line 818: , IPYB.last_update_login = arp_standard.profile.last_update_login

814: SET IPYB.ISU_ID = p_to_fk_id
815: , IPYB.object_version_number = IPYB.object_version_number + 1
816: , IPYB.last_update_date = SYSDATE
817: , IPYB.last_updated_by = arp_standard.profile.user_id
818: , IPYB.last_update_login = arp_standard.profile.last_update_login
819: WHERE IPYB.ISU_ID = p_from_fk_id
820: AND IPY_TYPE = 'THIRD_PARTY_POLICY';
821:
822: x_to_id := p_from_id;

Line 903: , IPYB.last_updated_by = arp_standard.profile.user_id

899: UPDATE OKL_INS_POLICIES_ALL_B IPYB
900: SET IPYB.AGENCY_SITE_ID = p_to_fk_id
901: , IPYB.object_version_number = IPYB.object_version_number + 1
902: , IPYB.last_update_date = SYSDATE
903: , IPYB.last_updated_by = arp_standard.profile.user_id
904: , IPYB.last_update_login = arp_standard.profile.last_update_login
905: WHERE IPYB.AGENCY_SITE_ID = p_from_fk_id
906: AND IPY_TYPE = 'THIRD_PARTY_POLICY';
907:

Line 904: , IPYB.last_update_login = arp_standard.profile.last_update_login

900: SET IPYB.AGENCY_SITE_ID = p_to_fk_id
901: , IPYB.object_version_number = IPYB.object_version_number + 1
902: , IPYB.last_update_date = SYSDATE
903: , IPYB.last_updated_by = arp_standard.profile.user_id
904: , IPYB.last_update_login = arp_standard.profile.last_update_login
905: WHERE IPYB.AGENCY_SITE_ID = p_from_fk_id
906: AND IPY_TYPE = 'THIRD_PARTY_POLICY';
907:
908: l_count := sql%rowcount;

Line 988: , IPYB.last_updated_by = arp_standard.profile.user_id

984: UPDATE OKL_INS_POLICIES_ALL_B IPYB
985: SET IPYB.INT_ID = p_to_fk_id
986: , IPYB.object_version_number = IPYB.object_version_number + 1
987: , IPYB.last_update_date = SYSDATE
988: , IPYB.last_updated_by = arp_standard.profile.user_id
989: , IPYB.last_update_login = arp_standard.profile.last_update_login
990: WHERE IPYB.INT_ID = p_from_fk_id
991: AND IPY_TYPE = 'THIRD_PARTY_POLICY';
992:

Line 989: , IPYB.last_update_login = arp_standard.profile.last_update_login

985: SET IPYB.INT_ID = p_to_fk_id
986: , IPYB.object_version_number = IPYB.object_version_number + 1
987: , IPYB.last_update_date = SYSDATE
988: , IPYB.last_updated_by = arp_standard.profile.user_id
989: , IPYB.last_update_login = arp_standard.profile.last_update_login
990: WHERE IPYB.INT_ID = p_from_fk_id
991: AND IPY_TYPE = 'THIRD_PARTY_POLICY';
992:
993: l_count := sql%rowcount;

Line 1072: , IPYB.last_updated_by = arp_standard.profile.user_id

1068: UPDATE OKL_INS_POLICIES_ALL_B IPYB
1069: SET IPYB.AGENT_SITE_ID = p_to_fk_id
1070: , IPYB.object_version_number = IPYB.object_version_number + 1
1071: , IPYB.last_update_date = SYSDATE
1072: , IPYB.last_updated_by = arp_standard.profile.user_id
1073: , IPYB.last_update_login = arp_standard.profile.last_update_login
1074: WHERE IPYB.AGENT_SITE_ID = p_from_fk_id
1075: AND IPY_TYPE = 'THIRD_PARTY_POLICY';
1076:

Line 1073: , IPYB.last_update_login = arp_standard.profile.last_update_login

1069: SET IPYB.AGENT_SITE_ID = p_to_fk_id
1070: , IPYB.object_version_number = IPYB.object_version_number + 1
1071: , IPYB.last_update_date = SYSDATE
1072: , IPYB.last_updated_by = arp_standard.profile.user_id
1073: , IPYB.last_update_login = arp_standard.profile.last_update_login
1074: WHERE IPYB.AGENT_SITE_ID = p_from_fk_id
1075: AND IPY_TYPE = 'THIRD_PARTY_POLICY';
1076:
1077: l_count := sql%rowcount;

Line 1151: ,opi.last_updated_by = arp_standard.profile.user_id

1147: ,opi.party_name = (select party_name from hz_parties where party_id = p_to_fk_id)
1148: ,opi.party_type = (select party_type from hz_parties where party_id = p_to_fk_id)
1149: ,opi.object_version_number = opi.object_version_number + 1
1150: ,opi.last_update_date = SYSDATE
1151: ,opi.last_updated_by = arp_standard.profile.user_id
1152: ,opi.last_update_login = arp_standard.profile.last_update_login
1153: WHERE opi.party_ID = p_from_fk_id ;
1154:
1155: l_count := sql%rowcount;

Line 1152: ,opi.last_update_login = arp_standard.profile.last_update_login

1148: ,opi.party_type = (select party_type from hz_parties where party_id = p_to_fk_id)
1149: ,opi.object_version_number = opi.object_version_number + 1
1150: ,opi.last_update_date = SYSDATE
1151: ,opi.last_updated_by = arp_standard.profile.user_id
1152: ,opi.last_update_login = arp_standard.profile.last_update_login
1153: WHERE opi.party_ID = p_from_fk_id ;
1154:
1155: l_count := sql%rowcount;
1156: arp_message.set_name('AR','AR_ROWS_UPDATED');

Line 1233: RAB.last_updated_by = arp_standard.profile.user_id,

1229: UPDATE OKL_RELOCATE_ASTS_ALL_B RAB
1230: SET RAB.PAC_ID = p_to_fk_id,
1231: RAB.object_version_number = RAB.object_version_number + 1,
1232: RAB.last_update_date = SYSDATE,
1233: RAB.last_updated_by = arp_standard.profile.user_id,
1234: RAB.last_update_login = arp_standard.profile.last_update_login
1235: WHERE RAB.PAC_ID = p_from_fk_id ;
1236: l_count := sql%rowcount;
1237: ARP_MESSAGE.set_name('AR','AR_ROWS_UPDATED');

Line 1234: RAB.last_update_login = arp_standard.profile.last_update_login

1230: SET RAB.PAC_ID = p_to_fk_id,
1231: RAB.object_version_number = RAB.object_version_number + 1,
1232: RAB.last_update_date = SYSDATE,
1233: RAB.last_updated_by = arp_standard.profile.user_id,
1234: RAB.last_update_login = arp_standard.profile.last_update_login
1235: WHERE RAB.PAC_ID = p_from_fk_id ;
1236: l_count := sql%rowcount;
1237: ARP_MESSAGE.set_name('AR','AR_ROWS_UPDATED');
1238: ARP_MESSAGE.set_token('NUM_ROWS',to_char(l_count));

Line 1312: RAB.last_updated_by = arp_standard.profile.user_id,

1308: UPDATE OKL_RELOCATE_ASTS_ALL_B RAB
1309: SET RAB.IST_ID = p_to_fk_id,
1310: RAB.object_version_number = RAB.object_version_number + 1,
1311: RAB.last_update_date = SYSDATE,
1312: RAB.last_updated_by = arp_standard.profile.user_id,
1313: RAB.last_update_login = arp_standard.profile.last_update_login
1314: WHERE RAB.IST_ID = p_from_fk_id ;
1315: l_count := sql%rowcount;
1316: ARP_MESSAGE.set_name('AR','AR_ROWS_UPDATED');

Line 1313: RAB.last_update_login = arp_standard.profile.last_update_login

1309: SET RAB.IST_ID = p_to_fk_id,
1310: RAB.object_version_number = RAB.object_version_number + 1,
1311: RAB.last_update_date = SYSDATE,
1312: RAB.last_updated_by = arp_standard.profile.user_id,
1313: RAB.last_update_login = arp_standard.profile.last_update_login
1314: WHERE RAB.IST_ID = p_from_fk_id ;
1315: l_count := sql%rowcount;
1316: ARP_MESSAGE.set_name('AR','AR_ROWS_UPDATED');
1317: ARP_MESSAGE.set_token('NUM_ROWS',to_char(l_count));

Line 1478: , iti.last_updated_by = arp_standard.profile.user_id

1474: UPDATE okl_txl_itm_insts iti
1475: SET iti.object_id1_old = p_to_fk_id
1476: , iti.object_version_number = iti.object_version_number + 1
1477: , iti.last_update_date = SYSDATE
1478: , iti.last_updated_by = arp_standard.profile.user_id
1479: , iti.last_update_login = arp_standard.profile.last_update_login
1480: WHERE iti.object_id1_old = p_from_fk_id
1481: AND JTOT_OBJECT_CODE_OLD = 'OKX_PARTSITE';
1482:

Line 1479: , iti.last_update_login = arp_standard.profile.last_update_login

1475: SET iti.object_id1_old = p_to_fk_id
1476: , iti.object_version_number = iti.object_version_number + 1
1477: , iti.last_update_date = SYSDATE
1478: , iti.last_updated_by = arp_standard.profile.user_id
1479: , iti.last_update_login = arp_standard.profile.last_update_login
1480: WHERE iti.object_id1_old = p_from_fk_id
1481: AND JTOT_OBJECT_CODE_OLD = 'OKX_PARTSITE';
1482:
1483: l_count := sql%rowcount;

Line 1573: , TAB.last_updated_by = arp_standard.profile.user_id

1569: UPDATE OKL_TXL_ITM_INSTS TAB
1570: SET TAB.object_id1_new = p_to_fk_id
1571: , TAB.object_version_number = TAB.object_version_number + 1
1572: , TAB.last_update_date = SYSDATE
1573: , TAB.last_updated_by = arp_standard.profile.user_id
1574: , TAB.last_update_login = arp_standard.profile.last_update_login
1575: WHERE TAB.object_id1_new = p_from_fk_id
1576: AND JTOT_OBJECT_CODE_NEW = 'OKX_PARTSITE';
1577: END IF;

Line 1574: , TAB.last_update_login = arp_standard.profile.last_update_login

1570: SET TAB.object_id1_new = p_to_fk_id
1571: , TAB.object_version_number = TAB.object_version_number + 1
1572: , TAB.last_update_date = SYSDATE
1573: , TAB.last_updated_by = arp_standard.profile.user_id
1574: , TAB.last_update_login = arp_standard.profile.last_update_login
1575: WHERE TAB.object_id1_new = p_from_fk_id
1576: AND JTOT_OBJECT_CODE_NEW = 'OKX_PARTSITE';
1577: END IF;
1578: l_count := sql%rowcount;

Line 1701: ,TAB.last_updated_by = arp_standard.profile.user_id

1697: UPDATE OKL_ASSETS_B TAB
1698: SET TAB.INSTALL_SITE_ID = p_to_fk_id
1699: ,TAB.object_version_number = TAB.object_version_number + 1
1700: ,TAB.last_update_date = SYSDATE
1701: ,TAB.last_updated_by = arp_standard.profile.user_id
1702: ,TAB.last_update_login = arp_standard.profile.last_update_login
1703: WHERE TAB.INSTALL_SITE_ID = p_from_fk_id ;
1704:
1705: l_count := sql%rowcount;

Line 1702: ,TAB.last_update_login = arp_standard.profile.last_update_login

1698: SET TAB.INSTALL_SITE_ID = p_to_fk_id
1699: ,TAB.object_version_number = TAB.object_version_number + 1
1700: ,TAB.last_update_date = SYSDATE
1701: ,TAB.last_updated_by = arp_standard.profile.user_id
1702: ,TAB.last_update_login = arp_standard.profile.last_update_login
1703: WHERE TAB.INSTALL_SITE_ID = p_from_fk_id ;
1704:
1705: l_count := sql%rowcount;
1706: arp_message.set_name('AR','AR_ROWS_UPDATED');

Line 1800: , TAB.last_updated_by = arp_standard.profile.user_id

1796: UPDATE OKL_LEASE_APPS_ALL_B TAB
1797: SET TAB.PROSPECT_ID = p_to_fk_id
1798: , TAB.object_version_number = TAB.object_version_number + 1
1799: , TAB.last_update_date = SYSDATE
1800: , TAB.last_updated_by = arp_standard.profile.user_id
1801: , TAB.last_update_login = arp_standard.profile.last_update_login
1802: WHERE TAB.PROSPECT_ID = p_from_fk_id;
1803: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES'
1804: THEN

Line 1801: , TAB.last_update_login = arp_standard.profile.last_update_login

1797: SET TAB.PROSPECT_ID = p_to_fk_id
1798: , TAB.object_version_number = TAB.object_version_number + 1
1799: , TAB.last_update_date = SYSDATE
1800: , TAB.last_updated_by = arp_standard.profile.user_id
1801: , TAB.last_update_login = arp_standard.profile.last_update_login
1802: WHERE TAB.PROSPECT_ID = p_from_fk_id;
1803: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES'
1804: THEN
1805: --updating the OKL_LEASE_APPS_ALL_B table for column references PROSPECT_ADDRESS_ID

Line 1810: , TAB.last_updated_by = arp_standard.profile.user_id

1806: UPDATE OKL_LEASE_APPS_ALL_B TAB
1807: SET TAB.PROSPECT_ADDRESS_ID = p_to_fk_id
1808: , TAB.object_version_number = TAB.object_version_number + 1
1809: , TAB.last_update_date = SYSDATE
1810: , TAB.last_updated_by = arp_standard.profile.user_id
1811: , TAB.last_update_login = arp_standard.profile.last_update_login
1812: WHERE TAB.PROSPECT_ADDRESS_ID = p_from_fk_id ;
1813: END IF;
1814: l_count := sql%rowcount;

Line 1811: , TAB.last_update_login = arp_standard.profile.last_update_login

1807: SET TAB.PROSPECT_ADDRESS_ID = p_to_fk_id
1808: , TAB.object_version_number = TAB.object_version_number + 1
1809: , TAB.last_update_date = SYSDATE
1810: , TAB.last_updated_by = arp_standard.profile.user_id
1811: , TAB.last_update_login = arp_standard.profile.last_update_login
1812: WHERE TAB.PROSPECT_ADDRESS_ID = p_from_fk_id ;
1813: END IF;
1814: l_count := sql%rowcount;
1815: arp_message.set_name('AR','AR_ROWS_UPDATED');

Line 1908: , TAB.last_updated_by = arp_standard.profile.user_id

1904: UPDATE OKL_LEASE_OPPS_ALL_B TAB
1905: SET TAB.PROSPECT_ID = p_to_fk_id
1906: , TAB.object_version_number = TAB.object_version_number + 1
1907: , TAB.last_update_date = SYSDATE
1908: , TAB.last_updated_by = arp_standard.profile.user_id
1909: , TAB.last_update_login = arp_standard.profile.last_update_login
1910: WHERE TAB.PROSPECT_ID = p_from_fk_id ;
1911: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES'
1912: THEN

Line 1909: , TAB.last_update_login = arp_standard.profile.last_update_login

1905: SET TAB.PROSPECT_ID = p_to_fk_id
1906: , TAB.object_version_number = TAB.object_version_number + 1
1907: , TAB.last_update_date = SYSDATE
1908: , TAB.last_updated_by = arp_standard.profile.user_id
1909: , TAB.last_update_login = arp_standard.profile.last_update_login
1910: WHERE TAB.PROSPECT_ID = p_from_fk_id ;
1911: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES'
1912: THEN
1913: --updating the OKL_LEASE_OPPS_ALL_B table for column references PROSPECT_ADDRESS_ID

Line 1918: , TAB.last_updated_by = arp_standard.profile.user_id

1914: UPDATE OKL_LEASE_OPPS_ALL_B TAB
1915: SET TAB.PROSPECT_ADDRESS_ID = p_to_fk_id
1916: , TAB.object_version_number = TAB.object_version_number + 1
1917: , TAB.last_update_date = SYSDATE
1918: , TAB.last_updated_by = arp_standard.profile.user_id
1919: , TAB.last_update_login = arp_standard.profile.last_update_login
1920: WHERE TAB.PROSPECT_ADDRESS_ID = p_from_fk_id ;
1921: ELSIF p_parent_entity_name = 'HZ_PARTY_SITE_USES'
1922: THEN

Line 1919: , TAB.last_update_login = arp_standard.profile.last_update_login

1915: SET TAB.PROSPECT_ADDRESS_ID = p_to_fk_id
1916: , TAB.object_version_number = TAB.object_version_number + 1
1917: , TAB.last_update_date = SYSDATE
1918: , TAB.last_updated_by = arp_standard.profile.user_id
1919: , TAB.last_update_login = arp_standard.profile.last_update_login
1920: WHERE TAB.PROSPECT_ADDRESS_ID = p_from_fk_id ;
1921: ELSIF p_parent_entity_name = 'HZ_PARTY_SITE_USES'
1922: THEN
1923: --updating the OKL_LEASE_OPPS_ALL_B table for column references INSTALL_SITE_ID

Line 1928: , TAB.last_updated_by = arp_standard.profile.user_id

1924: UPDATE OKL_LEASE_OPPS_ALL_B TAB
1925: SET TAB.INSTALL_SITE_ID = p_to_fk_id
1926: , TAB.object_version_number = TAB.object_version_number + 1
1927: , TAB.last_update_date = SYSDATE
1928: , TAB.last_updated_by = arp_standard.profile.user_id
1929: , TAB.last_update_login = arp_standard.profile.last_update_login
1930: WHERE TAB.INSTALL_SITE_ID = p_from_fk_id ;
1931: END IF;
1932:

Line 1929: , TAB.last_update_login = arp_standard.profile.last_update_login

1925: SET TAB.INSTALL_SITE_ID = p_to_fk_id
1926: , TAB.object_version_number = TAB.object_version_number + 1
1927: , TAB.last_update_date = SYSDATE
1928: , TAB.last_updated_by = arp_standard.profile.user_id
1929: , TAB.last_update_login = arp_standard.profile.last_update_login
1930: WHERE TAB.INSTALL_SITE_ID = p_from_fk_id ;
1931: END IF;
1932:
1933: l_count := sql%rowcount;

Line 2027: , TAB.last_updated_by = arp_standard.profile.user_id

2023: UPDATE OKL_LEASE_OPPS_ALL_B TAB
2024: SET TAB.USAGE_LOCATION_ID = p_to_fk_id
2025: , TAB.object_version_number = TAB.object_version_number + 1
2026: , TAB.last_update_date = SYSDATE
2027: , TAB.last_updated_by = arp_standard.profile.user_id
2028: , TAB.last_update_login = arp_standard.profile.last_update_login
2029: WHERE TAB.USAGE_LOCATION_ID = p_from_fk_id ;
2030: END IF;
2031:

Line 2028: , TAB.last_update_login = arp_standard.profile.last_update_login

2024: SET TAB.USAGE_LOCATION_ID = p_to_fk_id
2025: , TAB.object_version_number = TAB.object_version_number + 1
2026: , TAB.last_update_date = SYSDATE
2027: , TAB.last_updated_by = arp_standard.profile.user_id
2028: , TAB.last_update_login = arp_standard.profile.last_update_login
2029: WHERE TAB.USAGE_LOCATION_ID = p_from_fk_id ;
2030: END IF;
2031:
2032: l_count := sql%rowcount;

Line 2124: , TAB.last_updated_by = arp_standard.profile.user_id

2120: UPDATE OKL_TAX_SOURCES TAB
2121: SET TAB.BILL_TO_PARTY_ID = p_to_fk_id
2122: , TAB.object_version_number = TAB.object_version_number + 1
2123: , TAB.last_update_date = SYSDATE
2124: , TAB.last_updated_by = arp_standard.profile.user_id
2125: , TAB.last_update_login = arp_standard.profile.last_update_login
2126: WHERE TAB.BILL_TO_PARTY_ID = p_from_fk_id ;
2127: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES'
2128: THEN

Line 2125: , TAB.last_update_login = arp_standard.profile.last_update_login

2121: SET TAB.BILL_TO_PARTY_ID = p_to_fk_id
2122: , TAB.object_version_number = TAB.object_version_number + 1
2123: , TAB.last_update_date = SYSDATE
2124: , TAB.last_updated_by = arp_standard.profile.user_id
2125: , TAB.last_update_login = arp_standard.profile.last_update_login
2126: WHERE TAB.BILL_TO_PARTY_ID = p_from_fk_id ;
2127: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES'
2128: THEN
2129: --updating the OKL_TAX_SOURCES table for column references BILL_TO_PARTY_SITE_ID

Line 2134: , TAB.last_updated_by = arp_standard.profile.user_id

2130: UPDATE OKL_TAX_SOURCES TAB
2131: SET TAB.BILL_TO_PARTY_SITE_ID = p_to_fk_id
2132: , TAB.object_version_number = TAB.object_version_number + 1
2133: , TAB.last_update_date = SYSDATE
2134: , TAB.last_updated_by = arp_standard.profile.user_id
2135: , TAB.last_update_login = arp_standard.profile.last_update_login
2136: WHERE TAB.BILL_TO_PARTY_SITE_ID = p_from_fk_id ;
2137: END IF;
2138:

Line 2135: , TAB.last_update_login = arp_standard.profile.last_update_login

2131: SET TAB.BILL_TO_PARTY_SITE_ID = p_to_fk_id
2132: , TAB.object_version_number = TAB.object_version_number + 1
2133: , TAB.last_update_date = SYSDATE
2134: , TAB.last_updated_by = arp_standard.profile.user_id
2135: , TAB.last_update_login = arp_standard.profile.last_update_login
2136: WHERE TAB.BILL_TO_PARTY_SITE_ID = p_from_fk_id ;
2137: END IF;
2138:
2139: l_count := sql%rowcount;

Line 2233: , TAB.last_updated_by = arp_standard.profile.user_id

2229: UPDATE OKL_TAX_SOURCES TAB
2230: SET TAB.SHIP_TO_PARTY_ID = p_to_fk_id
2231: , TAB.object_version_number = TAB.object_version_number + 1
2232: , TAB.last_update_date = SYSDATE
2233: , TAB.last_updated_by = arp_standard.profile.user_id
2234: , TAB.last_update_login = arp_standard.profile.last_update_login
2235: WHERE TAB.SHIP_TO_PARTY_ID = p_from_fk_id ;
2236: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES'
2237: THEN

Line 2234: , TAB.last_update_login = arp_standard.profile.last_update_login

2230: SET TAB.SHIP_TO_PARTY_ID = p_to_fk_id
2231: , TAB.object_version_number = TAB.object_version_number + 1
2232: , TAB.last_update_date = SYSDATE
2233: , TAB.last_updated_by = arp_standard.profile.user_id
2234: , TAB.last_update_login = arp_standard.profile.last_update_login
2235: WHERE TAB.SHIP_TO_PARTY_ID = p_from_fk_id ;
2236: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES'
2237: THEN
2238: --updating the OKL_TAX_SOURCES table for column references SHIP_TO_PARTY_SITE_ID

Line 2243: , TAB.last_updated_by = arp_standard.profile.user_id

2239: UPDATE OKL_TAX_SOURCES TAB
2240: SET TAB.SHIP_TO_PARTY_SITE_ID = p_to_fk_id
2241: , TAB.object_version_number = TAB.object_version_number + 1
2242: , TAB.last_update_date = SYSDATE
2243: , TAB.last_updated_by = arp_standard.profile.user_id
2244: , TAB.last_update_login = arp_standard.profile.last_update_login
2245: WHERE TAB.SHIP_TO_PARTY_SITE_ID = p_from_fk_id ;
2246: END IF;
2247:

Line 2244: , TAB.last_update_login = arp_standard.profile.last_update_login

2240: SET TAB.SHIP_TO_PARTY_SITE_ID = p_to_fk_id
2241: , TAB.object_version_number = TAB.object_version_number + 1
2242: , TAB.last_update_date = SYSDATE
2243: , TAB.last_updated_by = arp_standard.profile.user_id
2244: , TAB.last_update_login = arp_standard.profile.last_update_login
2245: WHERE TAB.SHIP_TO_PARTY_SITE_ID = p_from_fk_id ;
2246: END IF;
2247:
2248: l_count := sql%rowcount;

Line 2343: , TAB.last_updated_by = arp_standard.profile.user_id

2339: UPDATE OKL_TAX_SOURCES_T TAB
2340: SET TAB.BILL_TO_PARTY_ID = p_to_fk_id
2341: , TAB.object_version_number = TAB.object_version_number + 1
2342: , TAB.last_update_date = SYSDATE
2343: , TAB.last_updated_by = arp_standard.profile.user_id
2344: , TAB.last_update_login = arp_standard.profile.last_update_login
2345: WHERE TAB.BILL_TO_PARTY_ID = p_from_fk_id ;
2346: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES'
2347: THEN

Line 2344: , TAB.last_update_login = arp_standard.profile.last_update_login

2340: SET TAB.BILL_TO_PARTY_ID = p_to_fk_id
2341: , TAB.object_version_number = TAB.object_version_number + 1
2342: , TAB.last_update_date = SYSDATE
2343: , TAB.last_updated_by = arp_standard.profile.user_id
2344: , TAB.last_update_login = arp_standard.profile.last_update_login
2345: WHERE TAB.BILL_TO_PARTY_ID = p_from_fk_id ;
2346: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES'
2347: THEN
2348: --updating the OKL_TAX_SOURCES_T table for column references BILL_TO_PARTY_SITE_ID

Line 2353: , TAB.last_updated_by = arp_standard.profile.user_id

2349: UPDATE OKL_TAX_SOURCES_T TAB
2350: SET TAB.BILL_TO_PARTY_SITE_ID = p_to_fk_id
2351: , TAB.object_version_number = TAB.object_version_number + 1
2352: , TAB.last_update_date = SYSDATE
2353: , TAB.last_updated_by = arp_standard.profile.user_id
2354: , TAB.last_update_login = arp_standard.profile.last_update_login
2355: WHERE TAB.BILL_TO_PARTY_SITE_ID = p_from_fk_id ;
2356: END IF;
2357:

Line 2354: , TAB.last_update_login = arp_standard.profile.last_update_login

2350: SET TAB.BILL_TO_PARTY_SITE_ID = p_to_fk_id
2351: , TAB.object_version_number = TAB.object_version_number + 1
2352: , TAB.last_update_date = SYSDATE
2353: , TAB.last_updated_by = arp_standard.profile.user_id
2354: , TAB.last_update_login = arp_standard.profile.last_update_login
2355: WHERE TAB.BILL_TO_PARTY_SITE_ID = p_from_fk_id ;
2356: END IF;
2357:
2358: l_count := sql%rowcount;

Line 2452: , TAB.last_updated_by = arp_standard.profile.user_id

2448: UPDATE OKL_TAX_SOURCES_T TAB
2449: SET TAB.SHIP_TO_PARTY_ID = p_to_fk_id
2450: , TAB.object_version_number = TAB.object_version_number + 1
2451: , TAB.last_update_date = SYSDATE
2452: , TAB.last_updated_by = arp_standard.profile.user_id
2453: , TAB.last_update_login = arp_standard.profile.last_update_login
2454: WHERE TAB.SHIP_TO_PARTY_ID = p_from_fk_id ;
2455: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES'
2456: THEN

Line 2453: , TAB.last_update_login = arp_standard.profile.last_update_login

2449: SET TAB.SHIP_TO_PARTY_ID = p_to_fk_id
2450: , TAB.object_version_number = TAB.object_version_number + 1
2451: , TAB.last_update_date = SYSDATE
2452: , TAB.last_updated_by = arp_standard.profile.user_id
2453: , TAB.last_update_login = arp_standard.profile.last_update_login
2454: WHERE TAB.SHIP_TO_PARTY_ID = p_from_fk_id ;
2455: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES'
2456: THEN
2457: --updating the OKL_TAX_SOURCES_T table for column references SHIP_TO_PARTY_SITE_ID

Line 2462: , TAB.last_updated_by = arp_standard.profile.user_id

2458: UPDATE OKL_TAX_SOURCES_T TAB
2459: SET TAB.SHIP_TO_PARTY_SITE_ID = p_to_fk_id
2460: , TAB.object_version_number = TAB.object_version_number + 1
2461: , TAB.last_update_date = SYSDATE
2462: , TAB.last_updated_by = arp_standard.profile.user_id
2463: , TAB.last_update_login = arp_standard.profile.last_update_login
2464: WHERE TAB.SHIP_TO_PARTY_SITE_ID = p_from_fk_id;
2465: END IF;
2466:

Line 2463: , TAB.last_update_login = arp_standard.profile.last_update_login

2459: SET TAB.SHIP_TO_PARTY_SITE_ID = p_to_fk_id
2460: , TAB.object_version_number = TAB.object_version_number + 1
2461: , TAB.last_update_date = SYSDATE
2462: , TAB.last_updated_by = arp_standard.profile.user_id
2463: , TAB.last_update_login = arp_standard.profile.last_update_login
2464: WHERE TAB.SHIP_TO_PARTY_SITE_ID = p_from_fk_id;
2465: END IF;
2466:
2467: l_count := sql%rowcount;

Line 2560: ,TAB.last_updated_by = arp_standard.profile.user_id

2556: UPDATE OKL_TRX_CONTRACTS_ALL TAB
2557: SET TAB.PARTY_REL_ID2_NEW = p_to_fk_id
2558: ,TAB.object_version_number = TAB.object_version_number + 1
2559: ,TAB.last_update_date = SYSDATE
2560: ,TAB.last_updated_by = arp_standard.profile.user_id
2561: ,TAB.last_update_login = arp_standard.profile.last_update_login
2562: WHERE TAB.PARTY_REL_ID2_NEW = to_char(p_from_fk_id); -- MGAAP 7263041
2563: --rkuttiya added for 12.1.1 multi gaap project
2564: --AND TAB.REPRESENTATION_TYPE = 'PRIMARY' ;

Line 2561: ,TAB.last_update_login = arp_standard.profile.last_update_login

2557: SET TAB.PARTY_REL_ID2_NEW = p_to_fk_id
2558: ,TAB.object_version_number = TAB.object_version_number + 1
2559: ,TAB.last_update_date = SYSDATE
2560: ,TAB.last_updated_by = arp_standard.profile.user_id
2561: ,TAB.last_update_login = arp_standard.profile.last_update_login
2562: WHERE TAB.PARTY_REL_ID2_NEW = to_char(p_from_fk_id); -- MGAAP 7263041
2563: --rkuttiya added for 12.1.1 multi gaap project
2564: --AND TAB.REPRESENTATION_TYPE = 'PRIMARY' ;
2565: --

Line 2658: ,TAB.last_updated_by = arp_standard.profile.user_id

2654: UPDATE OKL_QUOTE_PARTIES TAB
2655: SET TAB.PARTY_OBJECT1_ID1 = p_to_fk_id
2656: ,TAB.object_version_number = TAB.object_version_number + 1
2657: ,TAB.last_update_date = SYSDATE
2658: ,TAB.last_updated_by = arp_standard.profile.user_id
2659: ,TAB.last_update_login = arp_standard.profile.last_update_login
2660: WHERE TAB.PARTY_OBJECT1_ID1 = to_char(p_from_fk_id)
2661: AND PARTY_JTOT_OBJECT1_CODE = 'OKX_PARTY';
2662:

Line 2659: ,TAB.last_update_login = arp_standard.profile.last_update_login

2655: SET TAB.PARTY_OBJECT1_ID1 = p_to_fk_id
2656: ,TAB.object_version_number = TAB.object_version_number + 1
2657: ,TAB.last_update_date = SYSDATE
2658: ,TAB.last_updated_by = arp_standard.profile.user_id
2659: ,TAB.last_update_login = arp_standard.profile.last_update_login
2660: WHERE TAB.PARTY_OBJECT1_ID1 = to_char(p_from_fk_id)
2661: AND PARTY_JTOT_OBJECT1_CODE = 'OKX_PARTY';
2662:
2663: l_count := sql%rowcount;

Line 2754: ,TAB.last_updated_by = arp_standard.profile.user_id

2750: UPDATE OKL_QUOTE_PARTIES TAB
2751: SET TAB.CONTACT_OBJECT1_ID1 = p_to_fk_id
2752: ,TAB.object_version_number = TAB.object_version_number + 1
2753: ,TAB.last_update_date = SYSDATE
2754: ,TAB.last_updated_by = arp_standard.profile.user_id
2755: ,TAB.last_update_login = arp_standard.profile.last_update_login
2756: WHERE TAB.CONTACT_OBJECT1_ID1 = to_char(p_from_fk_id)
2757: AND CONTACT_JTOT_OBJECT1_CODE = 'OKX_PARTY';
2758:

Line 2755: ,TAB.last_update_login = arp_standard.profile.last_update_login

2751: SET TAB.CONTACT_OBJECT1_ID1 = p_to_fk_id
2752: ,TAB.object_version_number = TAB.object_version_number + 1
2753: ,TAB.last_update_date = SYSDATE
2754: ,TAB.last_updated_by = arp_standard.profile.user_id
2755: ,TAB.last_update_login = arp_standard.profile.last_update_login
2756: WHERE TAB.CONTACT_OBJECT1_ID1 = to_char(p_from_fk_id)
2757: AND CONTACT_JTOT_OBJECT1_CODE = 'OKX_PARTY';
2758:
2759: l_count := sql%rowcount;

Line 2849: ,TAB.last_updated_by = arp_standard.profile.user_id

2845:
2846: UPDATE OKL_TERMNT_INTF_PTY TAB
2847: SET TAB.PARTY_OBJECT_ID1 = p_to_fk_id
2848: ,TAB.last_update_date = SYSDATE
2849: ,TAB.last_updated_by = arp_standard.profile.user_id
2850: ,TAB.last_update_login = arp_standard.profile.last_update_login
2851: WHERE TAB.PARTY_OBJECT_ID1 = to_char(p_from_fk_id)
2852: AND PARTY_OBJECT_CODE = 'OKX_PARTY';
2853:

Line 2850: ,TAB.last_update_login = arp_standard.profile.last_update_login

2846: UPDATE OKL_TERMNT_INTF_PTY TAB
2847: SET TAB.PARTY_OBJECT_ID1 = p_to_fk_id
2848: ,TAB.last_update_date = SYSDATE
2849: ,TAB.last_updated_by = arp_standard.profile.user_id
2850: ,TAB.last_update_login = arp_standard.profile.last_update_login
2851: WHERE TAB.PARTY_OBJECT_ID1 = to_char(p_from_fk_id)
2852: AND PARTY_OBJECT_CODE = 'OKX_PARTY';
2853:
2854: l_count := sql%rowcount;

Line 3366: , TAB.last_updated_by = arp_standard.profile.user_id

3362: UPDATE OKC_K_PARTY_ROLES_B TAB
3363: SET TAB.OBJECT1_ID1 = p_to_fk_id
3364: , TAB.object_version_number = TAB.object_version_number + 1
3365: , TAB.last_update_date = SYSDATE
3366: , TAB.last_updated_by = arp_standard.profile.user_id
3367: , TAB.last_update_login = arp_standard.profile.last_update_login
3368: WHERE TAB.OBJECT1_ID1 = TO_CHAR(p_from_fk_id)
3369: AND JTOT_OBJECT1_CODE = 'OKL_PARTYSITE'
3370: AND DNZ_CHR_ID IN (SELECT ID FROM OKL_K_HEADERS);

Line 3367: , TAB.last_update_login = arp_standard.profile.last_update_login

3363: SET TAB.OBJECT1_ID1 = p_to_fk_id
3364: , TAB.object_version_number = TAB.object_version_number + 1
3365: , TAB.last_update_date = SYSDATE
3366: , TAB.last_updated_by = arp_standard.profile.user_id
3367: , TAB.last_update_login = arp_standard.profile.last_update_login
3368: WHERE TAB.OBJECT1_ID1 = TO_CHAR(p_from_fk_id)
3369: AND JTOT_OBJECT1_CODE = 'OKL_PARTYSITE'
3370: AND DNZ_CHR_ID IN (SELECT ID FROM OKL_K_HEADERS);
3371: END IF;

Line 3875: , last_updated_by=arp_standard.profile.user_id

3871: , PROSPECT_ADDRESS_ID = PROSPECT_ADDRESS_ID_LIST(I)
3872: , INSTALL_SITE_ID = IS_ID_LIST(I)
3873: , USAGE_LOCATION_ID = UL_ID_LIST(I)
3874: , LAST_UPDATE_DATE=SYSDATE
3875: , last_updated_by=arp_standard.profile.user_id
3876: , last_update_login=arp_standard.profile.last_update_login
3877: WHERE ID=PRIMARY_KEY_ID_LIST(I);
3878:
3879: l_count := l_count + SQL%ROWCOUNT;

Line 3876: , last_update_login=arp_standard.profile.last_update_login

3872: , INSTALL_SITE_ID = IS_ID_LIST(I)
3873: , USAGE_LOCATION_ID = UL_ID_LIST(I)
3874: , LAST_UPDATE_DATE=SYSDATE
3875: , last_updated_by=arp_standard.profile.user_id
3876: , last_update_login=arp_standard.profile.last_update_login
3877: WHERE ID=PRIMARY_KEY_ID_LIST(I);
3878:
3879: l_count := l_count + SQL%ROWCOUNT;
3880: IF l_last_fetch THEN

Line 4194: , last_updated_by=arp_standard.profile.user_id

4190: CUST_ACCT_ID=NUM_COL1_NEW_LIST(I)
4191: , PROSPECT_ID = PROSPECT_ID_LIST(I)
4192: , PROSPECT_ADDRESS_ID = PROSPECT_ADDRESS_ID_LIST(I)
4193: , LAST_UPDATE_DATE=SYSDATE
4194: , last_updated_by=arp_standard.profile.user_id
4195: , last_update_login=arp_standard.profile.last_update_login
4196: WHERE ID=PRIMARY_KEY_ID_LIST(I);
4197:
4198: l_count := l_count + SQL%ROWCOUNT;

Line 4195: , last_update_login=arp_standard.profile.last_update_login

4191: , PROSPECT_ID = PROSPECT_ID_LIST(I)
4192: , PROSPECT_ADDRESS_ID = PROSPECT_ADDRESS_ID_LIST(I)
4193: , LAST_UPDATE_DATE=SYSDATE
4194: , last_updated_by=arp_standard.profile.user_id
4195: , last_update_login=arp_standard.profile.last_update_login
4196: WHERE ID=PRIMARY_KEY_ID_LIST(I);
4197:
4198: l_count := l_count + SQL%ROWCOUNT;
4199: IF l_last_fetch THEN

Line 4370: , last_updated_by=arp_standard.profile.user_id

4366: UPDATE OKL_EXT_SELL_INVS_B yt SET
4367: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
4368: ,CUSTOMER_ADDRESS_ID=NUM_COL2_NEW_LIST(I)
4369: , LAST_UPDATE_DATE=SYSDATE
4370: , last_updated_by=arp_standard.profile.user_id
4371: , last_update_login=arp_standard.profile.last_update_login
4372: , REQUEST_ID=req_id
4373: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
4374: , PROGRAM_ID=arp_standard.profile.program_id

Line 4371: , last_update_login=arp_standard.profile.last_update_login

4367: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
4368: ,CUSTOMER_ADDRESS_ID=NUM_COL2_NEW_LIST(I)
4369: , LAST_UPDATE_DATE=SYSDATE
4370: , last_updated_by=arp_standard.profile.user_id
4371: , last_update_login=arp_standard.profile.last_update_login
4372: , REQUEST_ID=req_id
4373: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
4374: , PROGRAM_ID=arp_standard.profile.program_id
4375: , PROGRAM_UPDATE_DATE=SYSDATE

Line 4373: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

4369: , LAST_UPDATE_DATE=SYSDATE
4370: , last_updated_by=arp_standard.profile.user_id
4371: , last_update_login=arp_standard.profile.last_update_login
4372: , REQUEST_ID=req_id
4373: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
4374: , PROGRAM_ID=arp_standard.profile.program_id
4375: , PROGRAM_UPDATE_DATE=SYSDATE
4376: WHERE ID=PRIMARY_KEY_ID_LIST(I);
4377:

Line 4374: , PROGRAM_ID=arp_standard.profile.program_id

4370: , last_updated_by=arp_standard.profile.user_id
4371: , last_update_login=arp_standard.profile.last_update_login
4372: , REQUEST_ID=req_id
4373: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
4374: , PROGRAM_ID=arp_standard.profile.program_id
4375: , PROGRAM_UPDATE_DATE=SYSDATE
4376: WHERE ID=PRIMARY_KEY_ID_LIST(I);
4377:
4378: l_count := l_count + SQL%ROWCOUNT;

Line 4635: , last_updated_by=arp_standard.profile.user_id

4631: , SHIP_TO_PARTY_ID = ST_PAR_ID_NEW_LIST(I)
4632: , SHIP_TO_PARTY_SITE_ID = ST_PAR_SITE_ID_NEW_LIST(I)
4633: , SHIP_TO_LOCATION_ID = ST_LOC_ID_NEW_LIST(I)
4634: , LAST_UPDATE_DATE=SYSDATE
4635: , last_updated_by=arp_standard.profile.user_id
4636: , last_update_login=arp_standard.profile.last_update_login
4637: , REQUEST_ID=req_id
4638: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
4639: , PROGRAM_ID=arp_standard.profile.program_id

Line 4636: , last_update_login=arp_standard.profile.last_update_login

4632: , SHIP_TO_PARTY_SITE_ID = ST_PAR_SITE_ID_NEW_LIST(I)
4633: , SHIP_TO_LOCATION_ID = ST_LOC_ID_NEW_LIST(I)
4634: , LAST_UPDATE_DATE=SYSDATE
4635: , last_updated_by=arp_standard.profile.user_id
4636: , last_update_login=arp_standard.profile.last_update_login
4637: , REQUEST_ID=req_id
4638: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
4639: , PROGRAM_ID=arp_standard.profile.program_id
4640: , PROGRAM_UPDATE_DATE=SYSDATE

Line 4638: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

4634: , LAST_UPDATE_DATE=SYSDATE
4635: , last_updated_by=arp_standard.profile.user_id
4636: , last_update_login=arp_standard.profile.last_update_login
4637: , REQUEST_ID=req_id
4638: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
4639: , PROGRAM_ID=arp_standard.profile.program_id
4640: , PROGRAM_UPDATE_DATE=SYSDATE
4641: WHERE ID=PRIMARY_KEY_ID_LIST(I);
4642:

Line 4639: , PROGRAM_ID=arp_standard.profile.program_id

4635: , last_updated_by=arp_standard.profile.user_id
4636: , last_update_login=arp_standard.profile.last_update_login
4637: , REQUEST_ID=req_id
4638: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
4639: , PROGRAM_ID=arp_standard.profile.program_id
4640: , PROGRAM_UPDATE_DATE=SYSDATE
4641: WHERE ID=PRIMARY_KEY_ID_LIST(I);
4642:
4643: l_count := l_count + SQL%ROWCOUNT;

Line 4912: , last_updated_by=arp_standard.profile.user_id

4908: , SHIP_TO_PARTY_ID = ST_PAR_ID_NEW_LIST(I)
4909: , SHIP_TO_PARTY_SITE_ID = ST_PAR_SITE_ID_NEW_LIST(I)
4910: , SHIP_TO_LOCATION_ID = ST_LOC_ID_NEW_LIST(I)
4911: , LAST_UPDATE_DATE=SYSDATE
4912: , last_updated_by=arp_standard.profile.user_id
4913: , last_update_login=arp_standard.profile.last_update_login
4914: , REQUEST_ID=req_id
4915: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
4916: , PROGRAM_ID=arp_standard.profile.program_id

Line 4913: , last_update_login=arp_standard.profile.last_update_login

4909: , SHIP_TO_PARTY_SITE_ID = ST_PAR_SITE_ID_NEW_LIST(I)
4910: , SHIP_TO_LOCATION_ID = ST_LOC_ID_NEW_LIST(I)
4911: , LAST_UPDATE_DATE=SYSDATE
4912: , last_updated_by=arp_standard.profile.user_id
4913: , last_update_login=arp_standard.profile.last_update_login
4914: , REQUEST_ID=req_id
4915: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
4916: , PROGRAM_ID=arp_standard.profile.program_id
4917: , PROGRAM_UPDATE_DATE=SYSDATE

Line 4915: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

4911: , LAST_UPDATE_DATE=SYSDATE
4912: , last_updated_by=arp_standard.profile.user_id
4913: , last_update_login=arp_standard.profile.last_update_login
4914: , REQUEST_ID=req_id
4915: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
4916: , PROGRAM_ID=arp_standard.profile.program_id
4917: , PROGRAM_UPDATE_DATE=SYSDATE
4918: WHERE ID=PRIMARY_KEY_ID_LIST(I);
4919:

Line 4916: , PROGRAM_ID=arp_standard.profile.program_id

4912: , last_updated_by=arp_standard.profile.user_id
4913: , last_update_login=arp_standard.profile.last_update_login
4914: , REQUEST_ID=req_id
4915: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
4916: , PROGRAM_ID=arp_standard.profile.program_id
4917: , PROGRAM_UPDATE_DATE=SYSDATE
4918: WHERE ID=PRIMARY_KEY_ID_LIST(I);
4919:
4920: l_count := l_count + SQL%ROWCOUNT;

Line 5066: , last_updated_by=arp_standard.profile.user_id

5062: UPDATE OKL_TRX_AR_INVOICES_B yt SET
5063: IBT_ID=NUM_COL1_NEW_LIST(I)
5064: ,IXX_ID=NUM_COL2_NEW_LIST(I)
5065: , LAST_UPDATE_DATE=SYSDATE
5066: , last_updated_by=arp_standard.profile.user_id
5067: , last_update_login=arp_standard.profile.last_update_login
5068: , REQUEST_ID=req_id
5069: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
5070: , PROGRAM_ID=arp_standard.profile.program_id

Line 5067: , last_update_login=arp_standard.profile.last_update_login

5063: IBT_ID=NUM_COL1_NEW_LIST(I)
5064: ,IXX_ID=NUM_COL2_NEW_LIST(I)
5065: , LAST_UPDATE_DATE=SYSDATE
5066: , last_updated_by=arp_standard.profile.user_id
5067: , last_update_login=arp_standard.profile.last_update_login
5068: , REQUEST_ID=req_id
5069: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
5070: , PROGRAM_ID=arp_standard.profile.program_id
5071: , PROGRAM_UPDATE_DATE=SYSDATE

Line 5069: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

5065: , LAST_UPDATE_DATE=SYSDATE
5066: , last_updated_by=arp_standard.profile.user_id
5067: , last_update_login=arp_standard.profile.last_update_login
5068: , REQUEST_ID=req_id
5069: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
5070: , PROGRAM_ID=arp_standard.profile.program_id
5071: , PROGRAM_UPDATE_DATE=SYSDATE
5072: WHERE ID=PRIMARY_KEY_ID_LIST(I);
5073:

Line 5070: , PROGRAM_ID=arp_standard.profile.program_id

5066: , last_updated_by=arp_standard.profile.user_id
5067: , last_update_login=arp_standard.profile.last_update_login
5068: , REQUEST_ID=req_id
5069: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
5070: , PROGRAM_ID=arp_standard.profile.program_id
5071: , PROGRAM_UPDATE_DATE=SYSDATE
5072: WHERE ID=PRIMARY_KEY_ID_LIST(I);
5073:
5074: l_count := l_count + SQL%ROWCOUNT;

Line 5193: , last_updated_by=arp_standard.profile.user_id

5189: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
5190: UPDATE OKL_TXL_RCPT_APPS_B yt SET
5191: ILE_ID=NUM_COL1_NEW_LIST(I)
5192: , LAST_UPDATE_DATE=SYSDATE
5193: , last_updated_by=arp_standard.profile.user_id
5194: , last_update_login=arp_standard.profile.last_update_login
5195: , REQUEST_ID=req_id
5196: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
5197: , PROGRAM_ID=arp_standard.profile.program_id

Line 5194: , last_update_login=arp_standard.profile.last_update_login

5190: UPDATE OKL_TXL_RCPT_APPS_B yt SET
5191: ILE_ID=NUM_COL1_NEW_LIST(I)
5192: , LAST_UPDATE_DATE=SYSDATE
5193: , last_updated_by=arp_standard.profile.user_id
5194: , last_update_login=arp_standard.profile.last_update_login
5195: , REQUEST_ID=req_id
5196: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
5197: , PROGRAM_ID=arp_standard.profile.program_id
5198: , PROGRAM_UPDATE_DATE=SYSDATE

Line 5196: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

5192: , LAST_UPDATE_DATE=SYSDATE
5193: , last_updated_by=arp_standard.profile.user_id
5194: , last_update_login=arp_standard.profile.last_update_login
5195: , REQUEST_ID=req_id
5196: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
5197: , PROGRAM_ID=arp_standard.profile.program_id
5198: , PROGRAM_UPDATE_DATE=SYSDATE
5199: WHERE ID=PRIMARY_KEY_ID_LIST(I);
5200:

Line 5197: , PROGRAM_ID=arp_standard.profile.program_id

5193: , last_updated_by=arp_standard.profile.user_id
5194: , last_update_login=arp_standard.profile.last_update_login
5195: , REQUEST_ID=req_id
5196: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
5197: , PROGRAM_ID=arp_standard.profile.program_id
5198: , PROGRAM_UPDATE_DATE=SYSDATE
5199: WHERE ID=PRIMARY_KEY_ID_LIST(I);
5200:
5201: l_count := l_count + SQL%ROWCOUNT;

Line 5335: , last_updated_by=arp_standard.profile.user_id

5331: UPDATE OKL_CNSLD_AR_HDRS_B yt SET
5332: IXX_ID=NUM_COL1_NEW_LIST(I)
5333: ,IBT_ID=NUM_COL2_NEW_LIST(I)
5334: , LAST_UPDATE_DATE=SYSDATE
5335: , last_updated_by=arp_standard.profile.user_id
5336: , last_update_login=arp_standard.profile.last_update_login
5337: , REQUEST_ID=req_id
5338: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
5339: , PROGRAM_ID=arp_standard.profile.program_id

Line 5336: , last_update_login=arp_standard.profile.last_update_login

5332: IXX_ID=NUM_COL1_NEW_LIST(I)
5333: ,IBT_ID=NUM_COL2_NEW_LIST(I)
5334: , LAST_UPDATE_DATE=SYSDATE
5335: , last_updated_by=arp_standard.profile.user_id
5336: , last_update_login=arp_standard.profile.last_update_login
5337: , REQUEST_ID=req_id
5338: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
5339: , PROGRAM_ID=arp_standard.profile.program_id
5340: , PROGRAM_UPDATE_DATE=SYSDATE

Line 5338: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

5334: , LAST_UPDATE_DATE=SYSDATE
5335: , last_updated_by=arp_standard.profile.user_id
5336: , last_update_login=arp_standard.profile.last_update_login
5337: , REQUEST_ID=req_id
5338: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
5339: , PROGRAM_ID=arp_standard.profile.program_id
5340: , PROGRAM_UPDATE_DATE=SYSDATE
5341: WHERE ID=PRIMARY_KEY_ID_LIST(I);
5342:

Line 5339: , PROGRAM_ID=arp_standard.profile.program_id

5335: , last_updated_by=arp_standard.profile.user_id
5336: , last_update_login=arp_standard.profile.last_update_login
5337: , REQUEST_ID=req_id
5338: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
5339: , PROGRAM_ID=arp_standard.profile.program_id
5340: , PROGRAM_UPDATE_DATE=SYSDATE
5341: WHERE ID=PRIMARY_KEY_ID_LIST(I);
5342:
5343: l_count := l_count + SQL%ROWCOUNT;

Line 5462: , last_updated_by=arp_standard.profile.user_id

5458: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
5459: UPDATE OKL_CNTR_LVLNG_GRPS_B yt SET
5460: ICA_ID=NUM_COL1_NEW_LIST(I)
5461: , LAST_UPDATE_DATE=SYSDATE
5462: , last_updated_by=arp_standard.profile.user_id
5463: , last_update_login=arp_standard.profile.last_update_login
5464: WHERE ID=PRIMARY_KEY_ID_LIST(I);
5465:
5466: l_count := l_count + SQL%ROWCOUNT;

Line 5463: , last_update_login=arp_standard.profile.last_update_login

5459: UPDATE OKL_CNTR_LVLNG_GRPS_B yt SET
5460: ICA_ID=NUM_COL1_NEW_LIST(I)
5461: , LAST_UPDATE_DATE=SYSDATE
5462: , last_updated_by=arp_standard.profile.user_id
5463: , last_update_login=arp_standard.profile.last_update_login
5464: WHERE ID=PRIMARY_KEY_ID_LIST(I);
5465:
5466: l_count := l_count + SQL%ROWCOUNT;
5467: IF l_last_fetch THEN

Line 5581: , last_updated_by=arp_standard.profile.user_id

5577: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
5578: UPDATE OKL_ACCT_SOURCES yt SET
5579: REC_SITE_USES_PK=NUM_COL1_NEW_LIST(I)
5580: , LAST_UPDATE_DATE=SYSDATE
5581: , last_updated_by=arp_standard.profile.user_id
5582: , last_update_login=arp_standard.profile.last_update_login
5583: , REQUEST_ID=req_id
5584: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
5585: , PROGRAM_ID=arp_standard.profile.program_id

Line 5582: , last_update_login=arp_standard.profile.last_update_login

5578: UPDATE OKL_ACCT_SOURCES yt SET
5579: REC_SITE_USES_PK=NUM_COL1_NEW_LIST(I)
5580: , LAST_UPDATE_DATE=SYSDATE
5581: , last_updated_by=arp_standard.profile.user_id
5582: , last_update_login=arp_standard.profile.last_update_login
5583: , REQUEST_ID=req_id
5584: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
5585: , PROGRAM_ID=arp_standard.profile.program_id
5586: , PROGRAM_UPDATE_DATE=SYSDATE

Line 5584: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

5580: , LAST_UPDATE_DATE=SYSDATE
5581: , last_updated_by=arp_standard.profile.user_id
5582: , last_update_login=arp_standard.profile.last_update_login
5583: , REQUEST_ID=req_id
5584: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
5585: , PROGRAM_ID=arp_standard.profile.program_id
5586: , PROGRAM_UPDATE_DATE=SYSDATE
5587: WHERE ID=PRIMARY_KEY_ID_LIST(I)
5588: ;

Line 5585: , PROGRAM_ID=arp_standard.profile.program_id

5581: , last_updated_by=arp_standard.profile.user_id
5582: , last_update_login=arp_standard.profile.last_update_login
5583: , REQUEST_ID=req_id
5584: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
5585: , PROGRAM_ID=arp_standard.profile.program_id
5586: , PROGRAM_UPDATE_DATE=SYSDATE
5587: WHERE ID=PRIMARY_KEY_ID_LIST(I)
5588: ;
5589: l_count := l_count + SQL%ROWCOUNT;

Line 5704: , last_updated_by=arp_standard.profile.user_id

5700: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
5701: UPDATE OKL_SUPP_INVOICE_DTLS yt SET
5702: SHIPPING_ADDRESS_ID1=NUM_COL1_NEW_LIST(I)
5703: , LAST_UPDATE_DATE=SYSDATE
5704: , last_updated_by=arp_standard.profile.user_id
5705: , last_update_login=arp_standard.profile.last_update_login
5706: --NISINHA Bug#6655434 removed extra attributes
5707: WHERE ID=PRIMARY_KEY_ID_LIST(I)
5708: ;

Line 5705: , last_update_login=arp_standard.profile.last_update_login

5701: UPDATE OKL_SUPP_INVOICE_DTLS yt SET
5702: SHIPPING_ADDRESS_ID1=NUM_COL1_NEW_LIST(I)
5703: , LAST_UPDATE_DATE=SYSDATE
5704: , last_updated_by=arp_standard.profile.user_id
5705: , last_update_login=arp_standard.profile.last_update_login
5706: --NISINHA Bug#6655434 removed extra attributes
5707: WHERE ID=PRIMARY_KEY_ID_LIST(I)
5708: ;
5709: l_count := l_count + SQL%ROWCOUNT;

Line 5824: , last_updated_by=arp_standard.profile.user_id

5820: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
5821: UPDATE OKL_SUPP_INVOICE_DTLS_H yt SET
5822: SHIPPING_ADDRESS_ID1=NUM_COL1_NEW_LIST(I)
5823: , LAST_UPDATE_DATE=SYSDATE
5824: , last_updated_by=arp_standard.profile.user_id
5825: , last_update_login=arp_standard.profile.last_update_login
5826: --NISINHA Bug#6655434 removed extra attributes
5827: WHERE ID=PRIMARY_KEY_ID_LIST(I)
5828: ;

Line 5825: , last_update_login=arp_standard.profile.last_update_login

5821: UPDATE OKL_SUPP_INVOICE_DTLS_H yt SET
5822: SHIPPING_ADDRESS_ID1=NUM_COL1_NEW_LIST(I)
5823: , LAST_UPDATE_DATE=SYSDATE
5824: , last_updated_by=arp_standard.profile.user_id
5825: , last_update_login=arp_standard.profile.last_update_login
5826: --NISINHA Bug#6655434 removed extra attributes
5827: WHERE ID=PRIMARY_KEY_ID_LIST(I)
5828: ;
5829: l_count := l_count + SQL%ROWCOUNT;

Line 5921: ,TAB.last_updated_by = arp_standard.profile.user_id

5917: UPDATE OKL_TRX_CONTRACTS_ALL TAB
5918: SET TAB.PARTY_REL_ID1_NEW = p_to_fk_id
5919: ,TAB.object_version_number = TAB.object_version_number + 1
5920: ,TAB.last_update_date = SYSDATE
5921: ,TAB.last_updated_by = arp_standard.profile.user_id
5922: ,TAB.last_update_login = arp_standard.profile.last_update_login
5923: WHERE TAB.PARTY_REL_ID1_NEW = p_from_fk_id; -- MGAAP 7263041
5924: --rkuttiya added for 12.1.1 multigaap project
5925: --AND TAB.REPRESENTATION_TYPE = 'PRIMARY' ;

Line 5922: ,TAB.last_update_login = arp_standard.profile.last_update_login

5918: SET TAB.PARTY_REL_ID1_NEW = p_to_fk_id
5919: ,TAB.object_version_number = TAB.object_version_number + 1
5920: ,TAB.last_update_date = SYSDATE
5921: ,TAB.last_updated_by = arp_standard.profile.user_id
5922: ,TAB.last_update_login = arp_standard.profile.last_update_login
5923: WHERE TAB.PARTY_REL_ID1_NEW = p_from_fk_id; -- MGAAP 7263041
5924: --rkuttiya added for 12.1.1 multigaap project
5925: --AND TAB.REPRESENTATION_TYPE = 'PRIMARY' ;
5926: --

Line 6020: ,TAB.last_updated_by = arp_standard.profile.user_id

6016: UPDATE OKL_TRX_CONTRACTS_ALL TAB
6017: SET TAB.PARTY_REL_ID1_OLD = p_to_fk_id
6018: ,TAB.object_version_number = TAB.object_version_number + 1
6019: ,TAB.last_update_date = SYSDATE
6020: ,TAB.last_updated_by = arp_standard.profile.user_id
6021: ,TAB.last_update_login = arp_standard.profile.last_update_login
6022: WHERE TAB.PARTY_REL_ID1_OLD = p_from_fk_id; -- MGAAP 7263041
6023: --rkuttiya added for 12.1.1 multigaap project
6024: --AND REPRESENTATION_TYPE = 'PRIMARY' ;

Line 6021: ,TAB.last_update_login = arp_standard.profile.last_update_login

6017: SET TAB.PARTY_REL_ID1_OLD = p_to_fk_id
6018: ,TAB.object_version_number = TAB.object_version_number + 1
6019: ,TAB.last_update_date = SYSDATE
6020: ,TAB.last_updated_by = arp_standard.profile.user_id
6021: ,TAB.last_update_login = arp_standard.profile.last_update_login
6022: WHERE TAB.PARTY_REL_ID1_OLD = p_from_fk_id; -- MGAAP 7263041
6023: --rkuttiya added for 12.1.1 multigaap project
6024: --AND REPRESENTATION_TYPE = 'PRIMARY' ;
6025: --

Line 6119: ,TAB.last_updated_by = arp_standard.profile.user_id

6115: UPDATE OKL_TRX_CONTRACTS_ALL TAB
6116: SET TAB.PARTY_REL_ID2_OLD = p_to_fk_id
6117: ,TAB.object_version_number = TAB.object_version_number + 1
6118: ,TAB.last_update_date = SYSDATE
6119: ,TAB.last_updated_by = arp_standard.profile.user_id
6120: ,TAB.last_update_login = arp_standard.profile.last_update_login
6121: WHERE TAB.PARTY_REL_ID2_OLD = to_char(p_from_fk_id); -- MGAAP 7263041
6122: --rkuttiya added for 12.1.1 Multi gaap
6123: --AND REPRESENTATION_TYPE = 'PRIMARY';

Line 6120: ,TAB.last_update_login = arp_standard.profile.last_update_login

6116: SET TAB.PARTY_REL_ID2_OLD = p_to_fk_id
6117: ,TAB.object_version_number = TAB.object_version_number + 1
6118: ,TAB.last_update_date = SYSDATE
6119: ,TAB.last_updated_by = arp_standard.profile.user_id
6120: ,TAB.last_update_login = arp_standard.profile.last_update_login
6121: WHERE TAB.PARTY_REL_ID2_OLD = to_char(p_from_fk_id); -- MGAAP 7263041
6122: --rkuttiya added for 12.1.1 Multi gaap
6123: --AND REPRESENTATION_TYPE = 'PRIMARY';
6124: --

Line 6220: , TAB.last_updated_by = arp_standard.profile.user_id

6216: UPDATE OKC_RULES_B TAB
6217: SET TAB.OBJECT1_ID1 = p_to_fk_id
6218: , TAB.object_version_number = TAB.object_version_number + 1
6219: , TAB.last_update_date = SYSDATE
6220: , TAB.last_updated_by = arp_standard.profile.user_id
6221: , TAB.last_update_login = arp_standard.profile.last_update_login
6222: WHERE TAB.OBJECT1_ID1 = TO_CHAR(p_from_fk_id)
6223: AND JTOT_OBJECT1_CODE = 'OKL_PARTYSITE'
6224: AND DNZ_CHR_ID IN (SELECT ID FROM OKL_K_HEADERS);

Line 6221: , TAB.last_update_login = arp_standard.profile.last_update_login

6217: SET TAB.OBJECT1_ID1 = p_to_fk_id
6218: , TAB.object_version_number = TAB.object_version_number + 1
6219: , TAB.last_update_date = SYSDATE
6220: , TAB.last_updated_by = arp_standard.profile.user_id
6221: , TAB.last_update_login = arp_standard.profile.last_update_login
6222: WHERE TAB.OBJECT1_ID1 = TO_CHAR(p_from_fk_id)
6223: AND JTOT_OBJECT1_CODE = 'OKL_PARTYSITE'
6224: AND DNZ_CHR_ID IN (SELECT ID FROM OKL_K_HEADERS);
6225: END IF;

Line 6377: , last_updated_by=arp_standard.profile.user_id

6373: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
6374: UPDATE OKC_RULES_B yt SET
6375: OBJECT1_ID1=NUM_RUL_OBJ1_NEW_LIST(I)
6376: , LAST_UPDATE_DATE=SYSDATE
6377: , last_updated_by=arp_standard.profile.user_id
6378: , last_update_login=arp_standard.profile.last_update_login
6379: WHERE ID=PRIMARY_KEY_ID_LIST(I);
6380: l_count := l_count + SQL%ROWCOUNT;
6381: IF l_last_fetch THEN

Line 6378: , last_update_login=arp_standard.profile.last_update_login

6374: UPDATE OKC_RULES_B yt SET
6375: OBJECT1_ID1=NUM_RUL_OBJ1_NEW_LIST(I)
6376: , LAST_UPDATE_DATE=SYSDATE
6377: , last_updated_by=arp_standard.profile.user_id
6378: , last_update_login=arp_standard.profile.last_update_login
6379: WHERE ID=PRIMARY_KEY_ID_LIST(I);
6380: l_count := l_count + SQL%ROWCOUNT;
6381: IF l_last_fetch THEN
6382: EXIT;