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,
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
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:
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: --
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,
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,
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',
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),
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,
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
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
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
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,
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
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:
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: --
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,
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
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:
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: --
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,
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
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;
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: --
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,
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
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;
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: --
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
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)
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
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;
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,
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
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);
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:
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,
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
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;
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: --
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
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
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: ;
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;
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
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
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: ;
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;
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
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
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: ;
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;