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.WMS_TASK_DISPATCH_GEN dependencies on WMS_REPLENISHMENT_PVT

Line 11: g_ordered_psr wms_replenishment_pvt.psrTabTyp;

7: g_pkg_name CONSTANT VARCHAR2(30) := 'WMS_Task_Dispatch_Gen';
8: g_pkg_version CONSTANT VARCHAR2(100) := '$Header: WMSTASKB.pls 120.18.12010000.2 2008/08/22 10:57:04 satishku ship $';
9:
10: --Replenishment Project --6681109
11: g_ordered_psr wms_replenishment_pvt.psrTabTyp;
12:
13: PROCEDURE call_workflow(
14: p_rsn_id IN NUMBER
15: , p_calling_program IN VARCHAR2

Line 10819: wms_replenishment_pvt.GET_SORT_INVOICE_VALUE(WDD.SOURCE_HEADER_ID,

10815: 'Standard',
10816: 10,
10817: NULL),
10818: 'INVOICE_VALUE',
10819: wms_replenishment_pvt.GET_SORT_INVOICE_VALUE(WDD.SOURCE_HEADER_ID,
10820: L_INVOICE_VALUE_SORT),
10821: 'SCHEDULE_DATE',
10822: DECODE(L_SCHEDULE_DATE_SORT,
10823: 'ASC',

Line 10833: wms_replenishment_pvt.GET_SORT_TRIP_STOP_DATE(wdd.delivery_detail_id,

10829: 'DD-MM-YYYY HH24:MI:SS') -
10830: WDD.DATE_SCHEDULED),
10831: null),
10832: 'TRIP_STOP_DATE',
10833: wms_replenishment_pvt.GET_SORT_TRIP_STOP_DATE(wdd.delivery_detail_id,
10834: L_TRIP_STOP_DATE_SORT),
10835: NULL))) as sort_attribute1,
10836:
10837: -- get for sort_attribute2

Line 10857: wms_replenishment_pvt.GET_SORT_INVOICE_VALUE(WDD.SOURCE_HEADER_ID,

10853: 'Standard',
10854: 10,
10855: NULL),
10856: 'INVOICE_VALUE',
10857: wms_replenishment_pvt.GET_SORT_INVOICE_VALUE(WDD.SOURCE_HEADER_ID,
10858: L_INVOICE_VALUE_SORT),
10859: 'SCHEDULE_DATE',
10860: DECODE(L_SCHEDULE_DATE_SORT,
10861: 'ASC',

Line 10871: wms_replenishment_pvt.GET_SORT_TRIP_STOP_DATE(wdd.delivery_detail_id,

10867: 'DD-MM-YYYY HH24:MI:SS') -
10868: WDD.DATE_SCHEDULED),
10869: null),
10870: 'TRIP_STOP_DATE',
10871: wms_replenishment_pvt.GET_SORT_TRIP_STOP_DATE(wdd.delivery_detail_id,
10872: L_TRIP_STOP_DATE_SORT),
10873: NULL))) as sort_attribute2,
10874:
10875: -- get for sort_attribute3

Line 10895: wms_replenishment_pvt.GET_SORT_INVOICE_VALUE(WDD.SOURCE_HEADER_ID,

10891: 'Standard',
10892: 10,
10893: NULL),
10894: 'INVOICE_VALUE',
10895: wms_replenishment_pvt.GET_SORT_INVOICE_VALUE(WDD.SOURCE_HEADER_ID,
10896: L_INVOICE_VALUE_SORT),
10897: 'SCHEDULE_DATE',
10898: DECODE(L_SCHEDULE_DATE_SORT,
10899: 'ASC',

Line 10909: wms_replenishment_pvt.GET_SORT_TRIP_STOP_DATE(wdd.delivery_detail_id,

10905: 'DD-MM-YYYY HH24:MI:SS') -
10906: WDD.DATE_SCHEDULED),
10907: null),
10908: 'TRIP_STOP_DATE',
10909: wms_replenishment_pvt.GET_SORT_TRIP_STOP_DATE(wdd.delivery_detail_id,
10910: L_TRIP_STOP_DATE_SORT),
10911: NULL))) as sort_attribute3,
10912:
10913: -- get for sort_attribute4

Line 10933: wms_replenishment_pvt.GET_SORT_INVOICE_VALUE(WDD.SOURCE_HEADER_ID,

10929: 'Standard',
10930: 10,
10931: NULL),
10932: 'INVOICE_VALUE',
10933: wms_replenishment_pvt.GET_SORT_INVOICE_VALUE(WDD.SOURCE_HEADER_ID,
10934: L_INVOICE_VALUE_SORT),
10935: 'SCHEDULE_DATE',
10936: DECODE(L_SCHEDULE_DATE_SORT,
10937: 'ASC',

Line 10947: wms_replenishment_pvt.GET_SORT_TRIP_STOP_DATE(wdd.delivery_detail_id,

10943: 'DD-MM-YYYY HH24:MI:SS') -
10944: WDD.DATE_SCHEDULED),
10945: null),
10946: 'TRIP_STOP_DATE',
10947: wms_replenishment_pvt.GET_SORT_TRIP_STOP_DATE(wdd.delivery_detail_id,
10948: L_TRIP_STOP_DATE_SORT),
10949: NULL))) as sort_attribute4,
10950:
10951: -- get for sort_attribute5

Line 10971: wms_replenishment_pvt.GET_SORT_INVOICE_VALUE(WDD.SOURCE_HEADER_ID,

10967: 'Standard',
10968: 10,
10969: null),
10970: 'INVOICE_VALUE',
10971: wms_replenishment_pvt.GET_SORT_INVOICE_VALUE(WDD.SOURCE_HEADER_ID,
10972: L_INVOICE_VALUE_SORT),
10973: 'SCHEDULE_DATE',
10974: DECODE(L_SCHEDULE_DATE_SORT,
10975: 'ASC',

Line 10985: wms_replenishment_pvt.GET_SORT_TRIP_STOP_DATE(wdd.delivery_detail_id,

10981: 'DD-MM-YYYY HH24:MI:SS') -
10982: WDD.DATE_SCHEDULED),
10983: null),
10984: 'TRIP_STOP_DATE',
10985: wms_replenishment_pvt.GET_SORT_TRIP_STOP_DATE(wdd.delivery_detail_id,
10986: L_TRIP_STOP_DATE_SORT),
10987: NULL))) as sort_attribute5
10988:
10989: FROM

Line 11858: wms_replenishment_pvt.update_wdd_repl_status

11854:
11855: -- CALL SHIPPING API TO MARK THESE DELIVERY DETAILS AS 'RC' based on
11856: --l_delivery_detail_id
11857:
11858: wms_replenishment_pvt.update_wdd_repl_status
11859: (p_deliv_detail_id => l_delivery_detail_id
11860: , p_repl_status => 'C' -- for completed status
11861: , x_return_status => l_return_status
11862: );

Line 11889: -- the wms_replenishment_pvt.update_delivery_detail() API that insert the newly created

11885:
11886: -- Split the original deamand line
11887: -- the newly created demand line will have qty =(L_DEMAND_PRI_QTY - L_REMAINING_MMTT_QTY)
11888: -- WITH original 'RR" status . The shipping API with 'SPLIT-LINE' action in turn calls
11889: -- the wms_replenishment_pvt.update_delivery_detail() API that insert the newly created
11890: -- record with RR status in the WRD table AND updates the qty to l_remaining_mmtt_qty
11891: -- for the old delivery_detail record in the WRD table
11892:
11893: -- So after calling for the split-line action, I need to call shipping

Line 11935: -- wms_replenishment_pvt.update_delivery_detail() internally.

11931:
11932: -- At this point the new delivery is already inserted in the WRD table.
11933: -- AND the qty for original delivery has been updated
11934: -- TO l_remaining_mmtt_qty IN WRD as above api calls
11935: -- wms_replenishment_pvt.update_delivery_detail() internally.
11936: -- SO JUST MARK original delivery replenishment_status RC
11937: -- and then delete the original record from the WRD table
11938:
11939: wms_replenishment_pvt.update_wdd_repl_status

Line 11939: wms_replenishment_pvt.update_wdd_repl_status

11935: -- wms_replenishment_pvt.update_delivery_detail() internally.
11936: -- SO JUST MARK original delivery replenishment_status RC
11937: -- and then delete the original record from the WRD table
11938:
11939: wms_replenishment_pvt.update_wdd_repl_status
11940: (p_deliv_detail_id => l_delivery_detail_id
11941: , p_repl_status => 'C' -- for completed status
11942: , x_return_status => l_return_status
11943: );

Line 12042: wms_replenishment_pvt.init_rules

12038: -- Get the Order By Clause based on Pick Release Rule
12039: --initialize gloabl variables
12040: -- delete old value
12041: g_ordered_psr.DELETE;
12042: wms_replenishment_pvt.init_rules
12043: (p_pick_seq_rule_id => l_release_sequence_rule_id,
12044: x_order_id_sort => l_ORDER_ID_SORT,
12045: x_INVOICE_VALUE_SORT => l_INVOICE_VALUE_SORT,
12046: x_SCHEDULE_DATE_SORT => l_SCHEDULE_DATE_SORT,

Line 12080: wms_replenishment_pvt.update_wdd_repl_status

12076: IF (l_debug = 1) THEN
12077: mydebug('MO Qty >= Demand Qty; Mark demand as RC ');
12078: END IF;
12079:
12080: wms_replenishment_pvt.update_wdd_repl_status
12081: (p_deliv_detail_id => l_delivery_detail_id
12082: , p_repl_status => 'C' -- for completed status
12083: , x_return_status => l_return_status
12084: );

Line 12107: -- the wms_replenishment_pvt.update_delivery_detail()

12103:
12104: -- Split the original deamand line
12105: -- the newly created demand line will have qty =(L_DEMAND_PRI_QTY - L_REMAINING_MMTT_QTY) WITH
12106: -- original status . The shipping API with 'SPLIT-LINE' action in turn calls
12107: -- the wms_replenishment_pvt.update_delivery_detail()
12108: -- API but in this case since original
12109: -- delivery_detial was NOT tracked in the WRD table
12110: -- to start with, nothing happens there. In shipping,
12111: -- we have a new split WDD though

Line 12153: -- wms_replenishment_pvt.update_delivery_detail() internally.

12149:
12150: -- At this point the new delivery is already inserted in the WRD table.
12151: -- AND the qty for original delivery has been updated
12152: -- TO l_remaining_mmtt_qty IN WRD as above api calls
12153: -- wms_replenishment_pvt.update_delivery_detail() internally.
12154: -- SO JUST MARK original delviery replenishment_status RC
12155: -- and then delete the original record from the WRD table
12156:
12157: wms_replenishment_pvt.update_wdd_repl_status

Line 12157: wms_replenishment_pvt.update_wdd_repl_status

12153: -- wms_replenishment_pvt.update_delivery_detail() internally.
12154: -- SO JUST MARK original delviery replenishment_status RC
12155: -- and then delete the original record from the WRD table
12156:
12157: wms_replenishment_pvt.update_wdd_repl_status
12158: (p_deliv_detail_id => l_delivery_detail_id
12159: , p_repl_status => 'C' -- for completed status
12160: , x_return_status => l_return_status
12161: );