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.WSH_CUST_MERGE dependencies on ARP_STANDARD

Line 1410: last_updated_by = arp_standard.profile.user_id,

1406: deliver_to_location_id = decode( deliver_to_location_id,
1407: G_FROM_LOCATION_ID, G_TO_LOCATION_ID,
1408: deliver_to_location_id ),
1409: last_update_date = SYSDATE,
1410: last_updated_by = arp_standard.profile.user_id,
1411: last_update_login = arp_standard.profile.last_update_login,
1412: request_id = p_req_id,
1413: program_application_id = arp_standard.profile.program_application_id ,
1414: program_id = arp_standard.profile.program_id,

Line 1411: last_update_login = arp_standard.profile.last_update_login,

1407: G_FROM_LOCATION_ID, G_TO_LOCATION_ID,
1408: deliver_to_location_id ),
1409: last_update_date = SYSDATE,
1410: last_updated_by = arp_standard.profile.user_id,
1411: last_update_login = arp_standard.profile.last_update_login,
1412: request_id = p_req_id,
1413: program_application_id = arp_standard.profile.program_application_id ,
1414: program_id = arp_standard.profile.program_id,
1415: program_update_date = SYSDATE

Line 1413: program_application_id = arp_standard.profile.program_application_id ,

1409: last_update_date = SYSDATE,
1410: last_updated_by = arp_standard.profile.user_id,
1411: last_update_login = arp_standard.profile.last_update_login,
1412: request_id = p_req_id,
1413: program_application_id = arp_standard.profile.program_application_id ,
1414: program_id = arp_standard.profile.program_id,
1415: program_update_date = SYSDATE
1416: WHERE Wdd.Rowid = l_deliveryDetailRowidTab(updCnt);
1417:

Line 1414: program_id = arp_standard.profile.program_id,

1410: last_updated_by = arp_standard.profile.user_id,
1411: last_update_login = arp_standard.profile.last_update_login,
1412: request_id = p_req_id,
1413: program_application_id = arp_standard.profile.program_application_id ,
1414: program_id = arp_standard.profile.program_id,
1415: program_update_date = SYSDATE
1416: WHERE Wdd.Rowid = l_deliveryDetailRowidTab(updCnt);
1417:
1418: --

Line 1597: last_updated_by = arp_standard.profile.user_id,

1593: ultimate_dropoff_location_id = decode(ultimate_dropoff_location_id,
1594: G_FROM_LOCATION_ID, G_TO_LOCATION_ID,
1595: ultimate_dropoff_location_id ),
1596: last_update_date = SYSDATE,
1597: last_updated_by = arp_standard.profile.user_id,
1598: last_update_login = arp_standard.profile.last_update_login,
1599: request_id = p_req_id,
1600: program_application_id = arp_standard.profile.program_application_id ,
1601: program_id = arp_standard.profile.program_id,

Line 1598: last_update_login = arp_standard.profile.last_update_login,

1594: G_FROM_LOCATION_ID, G_TO_LOCATION_ID,
1595: ultimate_dropoff_location_id ),
1596: last_update_date = SYSDATE,
1597: last_updated_by = arp_standard.profile.user_id,
1598: last_update_login = arp_standard.profile.last_update_login,
1599: request_id = p_req_id,
1600: program_application_id = arp_standard.profile.program_application_id ,
1601: program_id = arp_standard.profile.program_id,
1602: program_update_date = SYSDATE,

Line 1600: program_application_id = arp_standard.profile.program_application_id ,

1596: last_update_date = SYSDATE,
1597: last_updated_by = arp_standard.profile.user_id,
1598: last_update_login = arp_standard.profile.last_update_login,
1599: request_id = p_req_id,
1600: program_application_id = arp_standard.profile.program_application_id ,
1601: program_id = arp_standard.profile.program_id,
1602: program_update_date = SYSDATE,
1603: -- OTM R12 : update delivery
1604: TMS_INTERFACE_FLAG = decode(l_tms_update(updCnt), 'Y',

Line 1601: program_id = arp_standard.profile.program_id,

1597: last_updated_by = arp_standard.profile.user_id,
1598: last_update_login = arp_standard.profile.last_update_login,
1599: request_id = p_req_id,
1600: program_application_id = arp_standard.profile.program_application_id ,
1601: program_id = arp_standard.profile.program_id,
1602: program_update_date = SYSDATE,
1603: -- OTM R12 : update delivery
1604: TMS_INTERFACE_FLAG = decode(l_tms_update(updCnt), 'Y',
1605: l_tms_interface_flag(updCnt),

Line 2073: last_updated_by = arp_standard.profile.user_id,

2069:
2070: UPDATE WSH_TRIP_STOPS Wts
2071: SET stop_location_id = G_TO_LOCATION_ID,
2072: last_update_date = SYSDATE,
2073: last_updated_by = arp_standard.profile.user_id,
2074: last_update_login = arp_standard.profile.last_update_login,
2075: request_id = p_req_id,
2076: program_application_id = arp_standard.profile.program_application_id ,
2077: program_id = arp_standard.profile.program_id,

Line 2074: last_update_login = arp_standard.profile.last_update_login,

2070: UPDATE WSH_TRIP_STOPS Wts
2071: SET stop_location_id = G_TO_LOCATION_ID,
2072: last_update_date = SYSDATE,
2073: last_updated_by = arp_standard.profile.user_id,
2074: last_update_login = arp_standard.profile.last_update_login,
2075: request_id = p_req_id,
2076: program_application_id = arp_standard.profile.program_application_id ,
2077: program_id = arp_standard.profile.program_id,
2078: program_update_date = SYSDATE

Line 2076: program_application_id = arp_standard.profile.program_application_id ,

2072: last_update_date = SYSDATE,
2073: last_updated_by = arp_standard.profile.user_id,
2074: last_update_login = arp_standard.profile.last_update_login,
2075: request_id = p_req_id,
2076: program_application_id = arp_standard.profile.program_application_id ,
2077: program_id = arp_standard.profile.program_id,
2078: program_update_date = SYSDATE
2079: WHERE Wts.Stop_Id in (
2080: SELECT Column2

Line 2077: program_id = arp_standard.profile.program_id,

2073: last_updated_by = arp_standard.profile.user_id,
2074: last_update_login = arp_standard.profile.last_update_login,
2075: request_id = p_req_id,
2076: program_application_id = arp_standard.profile.program_application_id ,
2077: program_id = arp_standard.profile.program_id,
2078: program_update_date = SYSDATE
2079: WHERE Wts.Stop_Id in (
2080: SELECT Column2
2081: FROM WSH_TMP

Line 2312: last_updated_by = arp_standard.profile.user_id,

2308: ultimate_dropoff_location_id = decode(ultimate_dropoff_location_id,
2309: G_FROM_LOCATION_ID, G_TO_LOCATION_ID,
2310: ultimate_dropoff_location_id ),
2311: last_update_date = SYSDATE,
2312: last_updated_by = arp_standard.profile.user_id,
2313: last_update_login = arp_standard.profile.last_update_login,
2314: request_id = p_req_id,
2315: program_application_id = arp_standard.profile.program_application_id ,
2316: program_id = arp_standard.profile.program_id,

Line 2313: last_update_login = arp_standard.profile.last_update_login,

2309: G_FROM_LOCATION_ID, G_TO_LOCATION_ID,
2310: ultimate_dropoff_location_id ),
2311: last_update_date = SYSDATE,
2312: last_updated_by = arp_standard.profile.user_id,
2313: last_update_login = arp_standard.profile.last_update_login,
2314: request_id = p_req_id,
2315: program_application_id = arp_standard.profile.program_application_id ,
2316: program_id = arp_standard.profile.program_id,
2317: program_update_date = SYSDATE

Line 2315: program_application_id = arp_standard.profile.program_application_id ,

2311: last_update_date = SYSDATE,
2312: last_updated_by = arp_standard.profile.user_id,
2313: last_update_login = arp_standard.profile.last_update_login,
2314: request_id = p_req_id,
2315: program_application_id = arp_standard.profile.program_application_id ,
2316: program_id = arp_standard.profile.program_id,
2317: program_update_date = SYSDATE
2318: WHERE Rowid = l_deliveryRowidTab(updCnt);
2319:

Line 2316: program_id = arp_standard.profile.program_id,

2312: last_updated_by = arp_standard.profile.user_id,
2313: last_update_login = arp_standard.profile.last_update_login,
2314: request_id = p_req_id,
2315: program_application_id = arp_standard.profile.program_application_id ,
2316: program_id = arp_standard.profile.program_id,
2317: program_update_date = SYSDATE
2318: WHERE Rowid = l_deliveryRowidTab(updCnt);
2319:
2320: --

Line 2375: last_updated_by = arp_standard.profile.user_id,

2371: ultimate_dropoff_location_id = decode(ultimate_dropoff_location_id,
2372: G_FROM_LOCATION_ID, G_TO_LOCATION_ID,
2373: ultimate_dropoff_location_id ),
2374: last_update_date = SYSDATE,
2375: last_updated_by = arp_standard.profile.user_id,
2376: last_update_login = arp_standard.profile.last_update_login,
2377: request_id = p_req_id,
2378: program_application_id = arp_standard.profile.program_application_id ,
2379: program_id = arp_standard.profile.program_id,

Line 2376: last_update_login = arp_standard.profile.last_update_login,

2372: G_FROM_LOCATION_ID, G_TO_LOCATION_ID,
2373: ultimate_dropoff_location_id ),
2374: last_update_date = SYSDATE,
2375: last_updated_by = arp_standard.profile.user_id,
2376: last_update_login = arp_standard.profile.last_update_login,
2377: request_id = p_req_id,
2378: program_application_id = arp_standard.profile.program_application_id ,
2379: program_id = arp_standard.profile.program_id,
2380: program_update_date = SYSDATE

Line 2378: program_application_id = arp_standard.profile.program_application_id ,

2374: last_update_date = SYSDATE,
2375: last_updated_by = arp_standard.profile.user_id,
2376: last_update_login = arp_standard.profile.last_update_login,
2377: request_id = p_req_id,
2378: program_application_id = arp_standard.profile.program_application_id ,
2379: program_id = arp_standard.profile.program_id,
2380: program_update_date = SYSDATE
2381: WHERE Rowid = l_deliveryRowidTab(updCnt);
2382:

Line 2379: program_id = arp_standard.profile.program_id,

2375: last_updated_by = arp_standard.profile.user_id,
2376: last_update_login = arp_standard.profile.last_update_login,
2377: request_id = p_req_id,
2378: program_application_id = arp_standard.profile.program_application_id ,
2379: program_id = arp_standard.profile.program_id,
2380: program_update_date = SYSDATE
2381: WHERE Rowid = l_deliveryRowidTab(updCnt);
2382:
2383: --

Line 2414: last_updated_by = arp_standard.profile.user_id,

2410: deliver_to_location_id = decode( deliver_to_location_id,
2411: G_FROM_LOCATION_ID, G_TO_LOCATION_ID,
2412: deliver_to_location_id ),
2413: last_update_date = SYSDATE,
2414: last_updated_by = arp_standard.profile.user_id,
2415: last_update_login = arp_standard.profile.last_update_login,
2416: request_id = p_req_id,
2417: program_application_id = arp_standard.profile.program_application_id ,
2418: program_id = arp_standard.profile.program_id,

Line 2415: last_update_login = arp_standard.profile.last_update_login,

2411: G_FROM_LOCATION_ID, G_TO_LOCATION_ID,
2412: deliver_to_location_id ),
2413: last_update_date = SYSDATE,
2414: last_updated_by = arp_standard.profile.user_id,
2415: last_update_login = arp_standard.profile.last_update_login,
2416: request_id = p_req_id,
2417: program_application_id = arp_standard.profile.program_application_id ,
2418: program_id = arp_standard.profile.program_id,
2419: program_update_date = SYSDATE

Line 2417: program_application_id = arp_standard.profile.program_application_id ,

2413: last_update_date = SYSDATE,
2414: last_updated_by = arp_standard.profile.user_id,
2415: last_update_login = arp_standard.profile.last_update_login,
2416: request_id = p_req_id,
2417: program_application_id = arp_standard.profile.program_application_id ,
2418: program_id = arp_standard.profile.program_id,
2419: program_update_date = SYSDATE
2420: WHERE Wdd.Rowid = l_deliveryDetailRowidTab(updCnt);
2421: END IF;

Line 2418: program_id = arp_standard.profile.program_id,

2414: last_updated_by = arp_standard.profile.user_id,
2415: last_update_login = arp_standard.profile.last_update_login,
2416: request_id = p_req_id,
2417: program_application_id = arp_standard.profile.program_application_id ,
2418: program_id = arp_standard.profile.program_id,
2419: program_update_date = SYSDATE
2420: WHERE Wdd.Rowid = l_deliveryDetailRowidTab(updCnt);
2421: END IF;
2422: --

Line 2624: last_updated_by = arp_standard.profile.user_id,

2620: G_FROM_LOCATION_ID, G_TO_LOCATION_ID,
2621: deliver_to_location_id ),
2622: deliver_to_location_id ),
2623: last_update_date = SYSDATE,
2624: last_updated_by = arp_standard.profile.user_id,
2625: last_update_login = arp_standard.profile.last_update_login,
2626: request_id = p_req_id,
2627: program_application_id = arp_standard.profile.program_application_id ,
2628: program_id = arp_standard.profile.program_id,

Line 2625: last_update_login = arp_standard.profile.last_update_login,

2621: deliver_to_location_id ),
2622: deliver_to_location_id ),
2623: last_update_date = SYSDATE,
2624: last_updated_by = arp_standard.profile.user_id,
2625: last_update_login = arp_standard.profile.last_update_login,
2626: request_id = p_req_id,
2627: program_application_id = arp_standard.profile.program_application_id ,
2628: program_id = arp_standard.profile.program_id,
2629: program_update_date = SYSDATE

Line 2627: program_application_id = arp_standard.profile.program_application_id ,

2623: last_update_date = SYSDATE,
2624: last_updated_by = arp_standard.profile.user_id,
2625: last_update_login = arp_standard.profile.last_update_login,
2626: request_id = p_req_id,
2627: program_application_id = arp_standard.profile.program_application_id ,
2628: program_id = arp_standard.profile.program_id,
2629: program_update_date = SYSDATE
2630: WHERE Wdd.Rowid = l_deliveryDetailRowidTab(bulkCnt);
2631: END IF;

Line 2628: program_id = arp_standard.profile.program_id,

2624: last_updated_by = arp_standard.profile.user_id,
2625: last_update_login = arp_standard.profile.last_update_login,
2626: request_id = p_req_id,
2627: program_application_id = arp_standard.profile.program_application_id ,
2628: program_id = arp_standard.profile.program_id,
2629: program_update_date = SYSDATE
2630: WHERE Wdd.Rowid = l_deliveryDetailRowidTab(bulkCnt);
2631: END IF;
2632: --

Line 2690: last_updated_by = arp_standard.profile.user_id,

2686: FORALL unassignCnt IN l_deliveryAssgRowidTab.FIRST..l_deliveryAssgRowidTab.LAST
2687: UPDATE WSH_DELIVERY_ASSIGNMENTS
2688: SET parent_delivery_detail_id = null,
2689: last_update_date = SYSDATE,
2690: last_updated_by = arp_standard.profile.user_id,
2691: last_update_login = arp_standard.profile.last_update_login,
2692: program_application_id = arp_standard.profile.program_application_id,
2693: program_id = arp_standard.profile.program_id,
2694: program_update_date = SYSDATE

Line 2691: last_update_login = arp_standard.profile.last_update_login,

2687: UPDATE WSH_DELIVERY_ASSIGNMENTS
2688: SET parent_delivery_detail_id = null,
2689: last_update_date = SYSDATE,
2690: last_updated_by = arp_standard.profile.user_id,
2691: last_update_login = arp_standard.profile.last_update_login,
2692: program_application_id = arp_standard.profile.program_application_id,
2693: program_id = arp_standard.profile.program_id,
2694: program_update_date = SYSDATE
2695: WHERE rowid = l_deliveryAssgRowidTab(unassignCnt)

Line 2692: program_application_id = arp_standard.profile.program_application_id,

2688: SET parent_delivery_detail_id = null,
2689: last_update_date = SYSDATE,
2690: last_updated_by = arp_standard.profile.user_id,
2691: last_update_login = arp_standard.profile.last_update_login,
2692: program_application_id = arp_standard.profile.program_application_id,
2693: program_id = arp_standard.profile.program_id,
2694: program_update_date = SYSDATE
2695: WHERE rowid = l_deliveryAssgRowidTab(unassignCnt)
2696: AND Parent_Delivery_Detail_Id IS NOT NULL

Line 2693: program_id = arp_standard.profile.program_id,

2689: last_update_date = SYSDATE,
2690: last_updated_by = arp_standard.profile.user_id,
2691: last_update_login = arp_standard.profile.last_update_login,
2692: program_application_id = arp_standard.profile.program_application_id,
2693: program_id = arp_standard.profile.program_id,
2694: program_update_date = SYSDATE
2695: WHERE rowid = l_deliveryAssgRowidTab(unassignCnt)
2696: AND Parent_Delivery_Detail_Id IS NOT NULL
2697: AND Delivery_Id IS NULL;

Line 3094: last_updated_by = arp_standard.profile.user_id,

3090: deliver_to_site_use_id = decode( nvl(deliver_to_site_use_id, ship_to_site_use_id),
3091: G_FROM_CUST_SITE_ID, G_TO_CUST_SITE_ID,
3092: deliver_to_site_use_id ),
3093: last_update_date = SYSDATE,
3094: last_updated_by = arp_standard.profile.user_id,
3095: last_update_login = arp_standard.profile.last_update_login,
3096: request_id = req_id,
3097: program_application_id = arp_standard.profile.program_application_id ,
3098: program_id = arp_standard.profile.program_id,

Line 3095: last_update_login = arp_standard.profile.last_update_login,

3091: G_FROM_CUST_SITE_ID, G_TO_CUST_SITE_ID,
3092: deliver_to_site_use_id ),
3093: last_update_date = SYSDATE,
3094: last_updated_by = arp_standard.profile.user_id,
3095: last_update_login = arp_standard.profile.last_update_login,
3096: request_id = req_id,
3097: program_application_id = arp_standard.profile.program_application_id ,
3098: program_id = arp_standard.profile.program_id,
3099: program_update_date = SYSDATE

Line 3097: program_application_id = arp_standard.profile.program_application_id ,

3093: last_update_date = SYSDATE,
3094: last_updated_by = arp_standard.profile.user_id,
3095: last_update_login = arp_standard.profile.last_update_login,
3096: request_id = req_id,
3097: program_application_id = arp_standard.profile.program_application_id ,
3098: program_id = arp_standard.profile.program_id,
3099: program_update_date = SYSDATE
3100: WHERE Wdd.Container_Flag = 'Y'
3101: AND Wdd.Rowid = l_deliveryDetailRowidTab(bulkCnt);

Line 3098: program_id = arp_standard.profile.program_id,

3094: last_updated_by = arp_standard.profile.user_id,
3095: last_update_login = arp_standard.profile.last_update_login,
3096: request_id = req_id,
3097: program_application_id = arp_standard.profile.program_application_id ,
3098: program_id = arp_standard.profile.program_id,
3099: program_update_date = SYSDATE
3100: WHERE Wdd.Container_Flag = 'Y'
3101: AND Wdd.Rowid = l_deliveryDetailRowidTab(bulkCnt);
3102:

Line 3158: last_updated_by = arp_standard.profile.user_id,

3154: deliver_to_site_use_id = decode( nvl(deliver_to_site_use_id, ship_to_site_use_id),
3155: G_FROM_CUST_SITE_ID, G_TO_CUST_SITE_ID,
3156: deliver_to_site_use_id ),
3157: last_update_date = SYSDATE,
3158: last_updated_by = arp_standard.profile.user_id,
3159: last_update_login = arp_standard.profile.last_update_login,
3160: request_id = req_id,
3161: program_application_id = arp_standard.profile.program_application_id ,
3162: program_id = arp_standard.profile.program_id,

Line 3159: last_update_login = arp_standard.profile.last_update_login,

3155: G_FROM_CUST_SITE_ID, G_TO_CUST_SITE_ID,
3156: deliver_to_site_use_id ),
3157: last_update_date = SYSDATE,
3158: last_updated_by = arp_standard.profile.user_id,
3159: last_update_login = arp_standard.profile.last_update_login,
3160: request_id = req_id,
3161: program_application_id = arp_standard.profile.program_application_id ,
3162: program_id = arp_standard.profile.program_id,
3163: program_update_date = SYSDATE

Line 3161: program_application_id = arp_standard.profile.program_application_id ,

3157: last_update_date = SYSDATE,
3158: last_updated_by = arp_standard.profile.user_id,
3159: last_update_login = arp_standard.profile.last_update_login,
3160: request_id = req_id,
3161: program_application_id = arp_standard.profile.program_application_id ,
3162: program_id = arp_standard.profile.program_id,
3163: program_update_date = SYSDATE
3164: WHERE Wdd.Rowid = l_deliveryDetailRowidTab(bulkCnt);
3165: END IF;

Line 3162: program_id = arp_standard.profile.program_id,

3158: last_updated_by = arp_standard.profile.user_id,
3159: last_update_login = arp_standard.profile.last_update_login,
3160: request_id = req_id,
3161: program_application_id = arp_standard.profile.program_application_id ,
3162: program_id = arp_standard.profile.program_id,
3163: program_update_date = SYSDATE
3164: WHERE Wdd.Rowid = l_deliveryDetailRowidTab(bulkCnt);
3165: END IF;
3166: --

Line 3414: , last_updated_by=arp_standard.profile.user_id

3410: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
3411: UPDATE WSH_PICKING_BATCHES yt SET
3412: customer_id=NUM_COL1_NEW_LIST(I)
3413: , LAST_UPDATE_DATE=SYSDATE
3414: , last_updated_by=arp_standard.profile.user_id
3415: , last_update_login=arp_standard.profile.last_update_login
3416: , REQUEST_ID=req_id
3417: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
3418: , PROGRAM_ID=arp_standard.profile.program_id

Line 3415: , last_update_login=arp_standard.profile.last_update_login

3411: UPDATE WSH_PICKING_BATCHES yt SET
3412: customer_id=NUM_COL1_NEW_LIST(I)
3413: , LAST_UPDATE_DATE=SYSDATE
3414: , last_updated_by=arp_standard.profile.user_id
3415: , last_update_login=arp_standard.profile.last_update_login
3416: , REQUEST_ID=req_id
3417: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
3418: , PROGRAM_ID=arp_standard.profile.program_id
3419: , PROGRAM_UPDATE_DATE=SYSDATE

Line 3417: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

3413: , LAST_UPDATE_DATE=SYSDATE
3414: , last_updated_by=arp_standard.profile.user_id
3415: , last_update_login=arp_standard.profile.last_update_login
3416: , REQUEST_ID=req_id
3417: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
3418: , PROGRAM_ID=arp_standard.profile.program_id
3419: , PROGRAM_UPDATE_DATE=SYSDATE
3420: WHERE BATCH_ID=PRIMARY_KEY_ID_LIST(I)
3421: ;

Line 3418: , PROGRAM_ID=arp_standard.profile.program_id

3414: , last_updated_by=arp_standard.profile.user_id
3415: , last_update_login=arp_standard.profile.last_update_login
3416: , REQUEST_ID=req_id
3417: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
3418: , PROGRAM_ID=arp_standard.profile.program_id
3419: , PROGRAM_UPDATE_DATE=SYSDATE
3420: WHERE BATCH_ID=PRIMARY_KEY_ID_LIST(I)
3421: ;
3422: l_count := l_count + SQL%ROWCOUNT;

Line 3565: , last_updated_by=arp_standard.profile.user_id

3561: UPDATE WSH_CALENDAR_ASSIGNMENTS yt SET
3562: customer_id=NUM_COL1_NEW_LIST(I)
3563: ,customer_site_use_id=NUM_COL2_NEW_LIST(I)
3564: , LAST_UPDATE_DATE=SYSDATE
3565: , last_updated_by=arp_standard.profile.user_id
3566: , last_update_login=arp_standard.profile.last_update_login
3567: , REQUEST_ID=req_id
3568: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
3569: , PROGRAM_ID=arp_standard.profile.program_id

Line 3566: , last_update_login=arp_standard.profile.last_update_login

3562: customer_id=NUM_COL1_NEW_LIST(I)
3563: ,customer_site_use_id=NUM_COL2_NEW_LIST(I)
3564: , LAST_UPDATE_DATE=SYSDATE
3565: , last_updated_by=arp_standard.profile.user_id
3566: , last_update_login=arp_standard.profile.last_update_login
3567: , REQUEST_ID=req_id
3568: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
3569: , PROGRAM_ID=arp_standard.profile.program_id
3570: , PROGRAM_UPDATE_DATE=SYSDATE

Line 3568: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

3564: , LAST_UPDATE_DATE=SYSDATE
3565: , last_updated_by=arp_standard.profile.user_id
3566: , last_update_login=arp_standard.profile.last_update_login
3567: , REQUEST_ID=req_id
3568: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
3569: , PROGRAM_ID=arp_standard.profile.program_id
3570: , PROGRAM_UPDATE_DATE=SYSDATE
3571: WHERE CALENDAR_ASSIGNMENT_ID=PRIMARY_KEY_ID_LIST(I)
3572: ;

Line 3569: , PROGRAM_ID=arp_standard.profile.program_id

3565: , last_updated_by=arp_standard.profile.user_id
3566: , last_update_login=arp_standard.profile.last_update_login
3567: , REQUEST_ID=req_id
3568: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
3569: , PROGRAM_ID=arp_standard.profile.program_id
3570: , PROGRAM_UPDATE_DATE=SYSDATE
3571: WHERE CALENDAR_ASSIGNMENT_ID=PRIMARY_KEY_ID_LIST(I)
3572: ;
3573: l_count := l_count + SQL%ROWCOUNT;

Line 3707: , last_updated_by=arp_standard.profile.user_id

3703: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
3704: UPDATE WSH_PICKING_RULES yt SET
3705: customer_id=NUM_COL1_NEW_LIST(I)
3706: , LAST_UPDATE_DATE=SYSDATE
3707: , last_updated_by=arp_standard.profile.user_id
3708: , last_update_login=arp_standard.profile.last_update_login
3709: , REQUEST_ID=req_id
3710: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
3711: , PROGRAM_ID=arp_standard.profile.program_id

Line 3708: , last_update_login=arp_standard.profile.last_update_login

3704: UPDATE WSH_PICKING_RULES yt SET
3705: customer_id=NUM_COL1_NEW_LIST(I)
3706: , LAST_UPDATE_DATE=SYSDATE
3707: , last_updated_by=arp_standard.profile.user_id
3708: , last_update_login=arp_standard.profile.last_update_login
3709: , REQUEST_ID=req_id
3710: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
3711: , PROGRAM_ID=arp_standard.profile.program_id
3712: , PROGRAM_UPDATE_DATE=SYSDATE

Line 3710: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

3706: , LAST_UPDATE_DATE=SYSDATE
3707: , last_updated_by=arp_standard.profile.user_id
3708: , last_update_login=arp_standard.profile.last_update_login
3709: , REQUEST_ID=req_id
3710: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
3711: , PROGRAM_ID=arp_standard.profile.program_id
3712: , PROGRAM_UPDATE_DATE=SYSDATE
3713: WHERE PICKING_RULE_ID=PRIMARY_KEY_ID_LIST(I)
3714: ;

Line 3711: , PROGRAM_ID=arp_standard.profile.program_id

3707: , last_updated_by=arp_standard.profile.user_id
3708: , last_update_login=arp_standard.profile.last_update_login
3709: , REQUEST_ID=req_id
3710: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
3711: , PROGRAM_ID=arp_standard.profile.program_id
3712: , PROGRAM_UPDATE_DATE=SYSDATE
3713: WHERE PICKING_RULE_ID=PRIMARY_KEY_ID_LIST(I)
3714: ;
3715: l_count := l_count + SQL%ROWCOUNT;