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

Line 421: , last_updated_by = arp_standard.profile.user_id

417: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
418: UPDATE PN_LEASES yt SET
419: CUSTOMER_ID = NUM_COL1_NEW_LIST(I)
420: , LAST_UPDATE_DATE = SYSDATE
421: , last_updated_by = arp_standard.profile.user_id
422: , last_update_login= arp_standard.profile.last_update_login
423: WHERE LEASE_ID=PRIMARY_KEY_ID_LIST(I);
424:
425: l_count := l_count + MERGE_HEADER_ID_LIST.COUNT;

Line 422: , last_update_login= arp_standard.profile.last_update_login

418: UPDATE PN_LEASES yt SET
419: CUSTOMER_ID = NUM_COL1_NEW_LIST(I)
420: , LAST_UPDATE_DATE = SYSDATE
421: , last_updated_by = arp_standard.profile.user_id
422: , last_update_login= arp_standard.profile.last_update_login
423: WHERE LEASE_ID=PRIMARY_KEY_ID_LIST(I);
424:
425: l_count := l_count + MERGE_HEADER_ID_LIST.COUNT;
426:

Line 591: , last_updated_by = arp_standard.profile.user_id

587: UPDATE PN_TENANCIES yt SET
588: CUSTOMER_ID = NUM_COL1_NEW_LIST(I)
589: , CUSTOMER_SITE_USE_ID= NUM_COL2_NEW_LIST(I)
590: , LAST_UPDATE_DATE = SYSDATE
591: , last_updated_by = arp_standard.profile.user_id
592: , last_update_login = arp_standard.profile.last_update_login
593: WHERE TENANCY_ID=PRIMARY_KEY_ID_LIST(I);
594:
595: l_count := l_count + MERGE_HEADER_ID_LIST.COUNT;

Line 592: , last_update_login = arp_standard.profile.last_update_login

588: CUSTOMER_ID = NUM_COL1_NEW_LIST(I)
589: , CUSTOMER_SITE_USE_ID= NUM_COL2_NEW_LIST(I)
590: , LAST_UPDATE_DATE = SYSDATE
591: , last_updated_by = arp_standard.profile.user_id
592: , last_update_login = arp_standard.profile.last_update_login
593: WHERE TENANCY_ID=PRIMARY_KEY_ID_LIST(I);
594:
595: l_count := l_count + MERGE_HEADER_ID_LIST.COUNT;
596:

Line 762: , last_updated_by = arp_standard.profile.user_id

758: UPDATE PN_TENANCIES_HISTORY yt SET
759: CUSTOMER_ID = NUM_COL1_NEW_LIST(I)
760: , CUSTOMER_SITE_USE_ID= NUM_COL2_NEW_LIST(I)
761: , LAST_UPDATE_DATE = SYSDATE
762: , last_updated_by = arp_standard.profile.user_id
763: , last_update_login = arp_standard.profile.last_update_login
764: WHERE TENANCY_HISTORY_ID = PRIMARY_KEY_ID_LIST(I);
765:
766: l_count := l_count + MERGE_HEADER_ID_LIST.COUNT;

Line 763: , last_update_login = arp_standard.profile.last_update_login

759: CUSTOMER_ID = NUM_COL1_NEW_LIST(I)
760: , CUSTOMER_SITE_USE_ID= NUM_COL2_NEW_LIST(I)
761: , LAST_UPDATE_DATE = SYSDATE
762: , last_updated_by = arp_standard.profile.user_id
763: , last_update_login = arp_standard.profile.last_update_login
764: WHERE TENANCY_HISTORY_ID = PRIMARY_KEY_ID_LIST(I);
765:
766: l_count := l_count + MERGE_HEADER_ID_LIST.COUNT;
767:

Line 947: , last_updated_by = arp_standard.profile.user_id

943: CUSTOMER_ID = NUM_COL1_NEW_LIST(I)
944: , CUSTOMER_SITE_USE_ID= NUM_COL2_NEW_LIST(I)
945: , CUST_SHIP_SITE_ID = NUM_COL3_NEW_LIST(I)
946: , LAST_UPDATE_DATE = SYSDATE
947: , last_updated_by = arp_standard.profile.user_id
948: , last_update_login = arp_standard.profile.last_update_login
949: WHERE TERM_TEMPLATE_ID = PRIMARY_KEY_ID_LIST(I);
950:
951: l_count := l_count + MERGE_HEADER_ID_LIST.COUNT;

Line 948: , last_update_login = arp_standard.profile.last_update_login

944: , CUSTOMER_SITE_USE_ID= NUM_COL2_NEW_LIST(I)
945: , CUST_SHIP_SITE_ID = NUM_COL3_NEW_LIST(I)
946: , LAST_UPDATE_DATE = SYSDATE
947: , last_updated_by = arp_standard.profile.user_id
948: , last_update_login = arp_standard.profile.last_update_login
949: WHERE TERM_TEMPLATE_ID = PRIMARY_KEY_ID_LIST(I);
950:
951: l_count := l_count + MERGE_HEADER_ID_LIST.COUNT;
952:

Line 1134: , last_updated_by = arp_standard.profile.user_id

1130: CUSTOMER_ID = NUM_COL1_NEW_LIST(I)
1131: , CUSTOMER_SITE_USE_ID= NUM_COL2_NEW_LIST(I)
1132: , CUST_SHIP_SITE_ID = NUM_COL3_NEW_LIST(I)
1133: , LAST_UPDATE_DATE = SYSDATE
1134: , last_updated_by = arp_standard.profile.user_id
1135: , last_update_login = arp_standard.profile.last_update_login
1136: WHERE PAYMENT_TERM_ID=PRIMARY_KEY_ID_LIST(I);
1137:
1138: l_count := l_count + MERGE_HEADER_ID_LIST.COUNT;

Line 1135: , last_update_login = arp_standard.profile.last_update_login

1131: , CUSTOMER_SITE_USE_ID= NUM_COL2_NEW_LIST(I)
1132: , CUST_SHIP_SITE_ID = NUM_COL3_NEW_LIST(I)
1133: , LAST_UPDATE_DATE = SYSDATE
1134: , last_updated_by = arp_standard.profile.user_id
1135: , last_update_login = arp_standard.profile.last_update_login
1136: WHERE PAYMENT_TERM_ID=PRIMARY_KEY_ID_LIST(I);
1137:
1138: l_count := l_count + MERGE_HEADER_ID_LIST.COUNT;
1139:

Line 1320: , last_updated_by=arp_standard.profile.user_id

1316: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
1317: , CUSTOMER_SITE_USE_ID=NUM_COL2_NEW_LIST(I)
1318: , CUST_SHIP_SITE_ID=NUM_COL3_NEW_LIST(I)
1319: , LAST_UPDATE_DATE=SYSDATE
1320: , last_updated_by=arp_standard.profile.user_id
1321: , last_update_login=arp_standard.profile.last_update_login
1322: WHERE PAYMENT_ITEM_ID=PRIMARY_KEY_ID_LIST(I);
1323:
1324: l_count := l_count + MERGE_HEADER_ID_LIST.COUNT;

Line 1321: , last_update_login=arp_standard.profile.last_update_login

1317: , CUSTOMER_SITE_USE_ID=NUM_COL2_NEW_LIST(I)
1318: , CUST_SHIP_SITE_ID=NUM_COL3_NEW_LIST(I)
1319: , LAST_UPDATE_DATE=SYSDATE
1320: , last_updated_by=arp_standard.profile.user_id
1321: , last_update_login=arp_standard.profile.last_update_login
1322: WHERE PAYMENT_ITEM_ID=PRIMARY_KEY_ID_LIST(I);
1323:
1324: l_count := l_count + MERGE_HEADER_ID_LIST.COUNT;
1325:

Line 1487: , last_updated_by=arp_standard.profile.user_id

1483: UPDATE PN_REC_AGREEMENTS yt SET
1484: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
1485: , CUST_SITE_ID=NUM_COL2_NEW_LIST(I)
1486: , LAST_UPDATE_DATE=SYSDATE
1487: , last_updated_by=arp_standard.profile.user_id
1488: , last_update_login=arp_standard.profile.last_update_login
1489: WHERE REC_AGREEMENT_ID=PRIMARY_KEY_ID_LIST(I);
1490:
1491: l_count := l_count + MERGE_HEADER_ID_LIST.COUNT;

Line 1488: , last_update_login=arp_standard.profile.last_update_login

1484: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
1485: , CUST_SITE_ID=NUM_COL2_NEW_LIST(I)
1486: , LAST_UPDATE_DATE=SYSDATE
1487: , last_updated_by=arp_standard.profile.user_id
1488: , last_update_login=arp_standard.profile.last_update_login
1489: WHERE REC_AGREEMENT_ID=PRIMARY_KEY_ID_LIST(I);
1490:
1491: l_count := l_count + MERGE_HEADER_ID_LIST.COUNT;
1492:

Line 1640: , last_updated_by=arp_standard.profile.user_id

1636: FORALL I IN 1..MERGE_HEADER_ID_LIST.COUNT
1637: UPDATE PN_REC_ARCL_DTLLN yt SET
1638: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
1639: , LAST_UPDATE_DATE=SYSDATE
1640: , last_updated_by=arp_standard.profile.user_id
1641: , last_update_login=arp_standard.profile.last_update_login
1642: WHERE AREA_CLASS_DTL_ID=PRIMARY_KEY_ID_LIST(I);
1643:
1644: l_count := l_count + MERGE_HEADER_ID_LIST.COUNT;

Line 1641: , last_update_login=arp_standard.profile.last_update_login

1637: UPDATE PN_REC_ARCL_DTLLN yt SET
1638: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
1639: , LAST_UPDATE_DATE=SYSDATE
1640: , last_updated_by=arp_standard.profile.user_id
1641: , last_update_login=arp_standard.profile.last_update_login
1642: WHERE AREA_CLASS_DTL_ID=PRIMARY_KEY_ID_LIST(I);
1643:
1644: l_count := l_count + MERGE_HEADER_ID_LIST.COUNT;
1645: IF l_last_fetch THEN

Line 1791: , last_updated_by=arp_standard.profile.user_id

1787: FORALL I IN 1..MERGE_HEADER_ID_LIST.COUNT
1788: UPDATE PN_REC_EXPCL_DTLLN yt SET
1789: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
1790: , LAST_UPDATE_DATE=SYSDATE
1791: , last_updated_by=arp_standard.profile.user_id
1792: , last_update_login=arp_standard.profile.last_update_login
1793: WHERE EXPENSE_CLASS_LINE_ID=PRIMARY_KEY_ID_LIST(I);
1794:
1795: l_count := l_count + MERGE_HEADER_ID_LIST.COUNT;

Line 1792: , last_update_login=arp_standard.profile.last_update_login

1788: UPDATE PN_REC_EXPCL_DTLLN yt SET
1789: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
1790: , LAST_UPDATE_DATE=SYSDATE
1791: , last_updated_by=arp_standard.profile.user_id
1792: , last_update_login=arp_standard.profile.last_update_login
1793: WHERE EXPENSE_CLASS_LINE_ID=PRIMARY_KEY_ID_LIST(I);
1794:
1795: l_count := l_count + MERGE_HEADER_ID_LIST.COUNT;
1796: IF l_last_fetch THEN

Line 1940: , last_updated_by=arp_standard.profile.user_id

1936: FORALL I IN 1..MERGE_HEADER_ID_LIST.COUNT
1937: UPDATE PN_REC_PERIOD_LINES yt SET
1938: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
1939: , LAST_UPDATE_DATE=SYSDATE
1940: , last_updated_by=arp_standard.profile.user_id
1941: , last_update_login=arp_standard.profile.last_update_login
1942: WHERE REC_PERIOD_LINES_ID=PRIMARY_KEY_ID_LIST(I);
1943:
1944: l_count := l_count + MERGE_HEADER_ID_LIST.COUNT;

Line 1941: , last_update_login=arp_standard.profile.last_update_login

1937: UPDATE PN_REC_PERIOD_LINES yt SET
1938: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
1939: , LAST_UPDATE_DATE=SYSDATE
1940: , last_updated_by=arp_standard.profile.user_id
1941: , last_update_login=arp_standard.profile.last_update_login
1942: WHERE REC_PERIOD_LINES_ID=PRIMARY_KEY_ID_LIST(I);
1943:
1944: l_count := l_count + MERGE_HEADER_ID_LIST.COUNT;
1945: IF l_last_fetch THEN

Line 2109: ,last_updated_by=arp_standard.profile.user_id

2105: UPDATE PN_SPACE_ASSIGN_CUST yt SET
2106: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
2107: ,SITE_USE_ID=NUM_COL2_NEW_LIST(I)
2108: ,LAST_UPDATE_DATE=SYSDATE
2109: ,last_updated_by=arp_standard.profile.user_id
2110: ,last_update_login=arp_standard.profile.last_update_login
2111: WHERE cust_space_assign_id=PRIMARY_KEY_ID_LIST(I);
2112:
2113: l_count := l_count + MERGE_HEADER_ID_LIST.COUNT;

Line 2110: ,last_update_login=arp_standard.profile.last_update_login

2106: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
2107: ,SITE_USE_ID=NUM_COL2_NEW_LIST(I)
2108: ,LAST_UPDATE_DATE=SYSDATE
2109: ,last_updated_by=arp_standard.profile.user_id
2110: ,last_update_login=arp_standard.profile.last_update_login
2111: WHERE cust_space_assign_id=PRIMARY_KEY_ID_LIST(I);
2112:
2113: l_count := l_count + MERGE_HEADER_ID_LIST.COUNT;
2114: