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 STANDARD

Line 1407: last_updated_by = arp_standard.profile.user_id,

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

Line 1408: last_update_login = arp_standard.profile.last_update_login,

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

Line 1410: program_application_id = arp_standard.profile.program_application_id ,

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

Line 1411: program_id = arp_standard.profile.program_id,

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

Line 1594: last_updated_by = arp_standard.profile.user_id,

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

Line 1595: last_update_login = arp_standard.profile.last_update_login,

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

Line 1597: program_application_id = arp_standard.profile.program_application_id ,

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

Line 1598: program_id = arp_standard.profile.program_id,

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

Line 2070: last_updated_by = arp_standard.profile.user_id,

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

Line 2071: last_update_login = arp_standard.profile.last_update_login,

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

Line 2073: program_application_id = arp_standard.profile.program_application_id ,

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

Line 2074: program_id = arp_standard.profile.program_id,

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

Line 2309: last_updated_by = arp_standard.profile.user_id,

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

Line 2310: last_update_login = arp_standard.profile.last_update_login,

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

Line 2312: program_application_id = arp_standard.profile.program_application_id ,

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

Line 2313: program_id = arp_standard.profile.program_id,

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

Line 2372: last_updated_by = arp_standard.profile.user_id,

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

Line 2373: last_update_login = arp_standard.profile.last_update_login,

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

Line 2375: program_application_id = arp_standard.profile.program_application_id ,

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

Line 2376: program_id = arp_standard.profile.program_id,

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

Line 2411: last_updated_by = arp_standard.profile.user_id,

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

Line 2412: last_update_login = arp_standard.profile.last_update_login,

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

Line 2414: program_application_id = arp_standard.profile.program_application_id ,

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

Line 2415: program_id = arp_standard.profile.program_id,

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

Line 2621: last_updated_by = arp_standard.profile.user_id,

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

Line 2622: last_update_login = arp_standard.profile.last_update_login,

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

Line 2624: program_application_id = arp_standard.profile.program_application_id ,

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

Line 2625: program_id = arp_standard.profile.program_id,

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

Line 2687: last_updated_by = arp_standard.profile.user_id,

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

Line 2688: last_update_login = arp_standard.profile.last_update_login,

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

Line 2689: program_application_id = arp_standard.profile.program_application_id,

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

Line 2690: program_id = arp_standard.profile.program_id,

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

Line 3091: last_updated_by = arp_standard.profile.user_id,

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

Line 3092: last_update_login = arp_standard.profile.last_update_login,

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

Line 3094: program_application_id = arp_standard.profile.program_application_id ,

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

Line 3095: program_id = arp_standard.profile.program_id,

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

Line 3155: last_updated_by = arp_standard.profile.user_id,

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

Line 3156: last_update_login = arp_standard.profile.last_update_login,

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

Line 3158: program_application_id = arp_standard.profile.program_application_id ,

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

Line 3159: program_id = arp_standard.profile.program_id,

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

Line 3411: , last_updated_by=arp_standard.profile.user_id

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

Line 3412: , last_update_login=arp_standard.profile.last_update_login

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

Line 3414: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

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

Line 3415: , PROGRAM_ID=arp_standard.profile.program_id

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

Line 3562: , last_updated_by=arp_standard.profile.user_id

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

Line 3563: , last_update_login=arp_standard.profile.last_update_login

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

Line 3565: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

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

Line 3566: , PROGRAM_ID=arp_standard.profile.program_id

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

Line 3704: , last_updated_by=arp_standard.profile.user_id

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

Line 3705: , last_update_login=arp_standard.profile.last_update_login

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

Line 3707: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

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

Line 3708: , PROGRAM_ID=arp_standard.profile.program_id

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