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.WSMPJUPD dependencies on WSM_JOB_SECONDARY_QUANTITIES

Line 39: type t_wsm_job_sec_qty_tbl is table of wsm_job_secondary_quantities%rowtype index by binary_integer;

35: type t_number is table of number index by binary_integer;
36: type t_job_name_tbl is table of number index by wip_entities.wip_entity_name%type;
37:
38: -- MES secondary qty changes
39: type t_wsm_job_sec_qty_tbl is table of wsm_job_secondary_quantities%rowtype index by binary_integer;
40: type t_wsm_sj_sec_qty_tbl is table of wsm_sj_secondary_quantities%rowtype index by binary_integer;
41: type t_wsm_rj_sec_qty_tbl is table of wsm_rj_secondary_quantities%rowtype index by binary_integer;
42: type t_wsm_op_sec_qty_tbl is table of wsm_op_secondary_quantities%rowtype index by binary_integer;
43:

Line 45: type t_cur_qty_tbl is table of wsm_job_secondary_quantities.current_quantity%type index by binary_integer;

41: type t_wsm_rj_sec_qty_tbl is table of wsm_rj_secondary_quantities%rowtype index by binary_integer;
42: type t_wsm_op_sec_qty_tbl is table of wsm_op_secondary_quantities%rowtype index by binary_integer;
43:
44: type t_we_id_tbl is table of wip_entities.wip_entity_id%type index by binary_integer;
45: type t_cur_qty_tbl is table of wsm_job_secondary_quantities.current_quantity%type index by binary_integer;
46: type t_cur_uom_tbl is table of wsm_job_secondary_quantities.uom_code%type index by binary_integer;
47: -- End MES secondary qty changes
48:
49: -- MES copy tables changes

Line 46: type t_cur_uom_tbl is table of wsm_job_secondary_quantities.uom_code%type index by binary_integer;

42: type t_wsm_op_sec_qty_tbl is table of wsm_op_secondary_quantities%rowtype index by binary_integer;
43:
44: type t_we_id_tbl is table of wip_entities.wip_entity_id%type index by binary_integer;
45: type t_cur_qty_tbl is table of wsm_job_secondary_quantities.current_quantity%type index by binary_integer;
46: type t_cur_uom_tbl is table of wsm_job_secondary_quantities.uom_code%type index by binary_integer;
47: -- End MES secondary qty changes
48:
49: -- MES copy tables changes
50: type t_wsm_op_reason_codes_tbl is table of wsm_op_reason_codes%rowtype index by binary_integer;

Line 157: -- 1. Query wsm_job_secondary_quantities table to get the SJ data into l_job_qty_tbl

153:
154: l_stmt_num := 10;
155: --*****************************Insert SJ sec qty info into history table**************************
156: -- First store SJ sec qty info in wsm_sj_secondary_quantities.The following steps followed for this:
157: -- 1. Query wsm_job_secondary_quantities table to get the SJ data into l_job_qty_tbl
158: -- 2. Now use this to populate fields in l_wsm_sj_sec_qty_tbl having rowtype same as wsm_sj_secondary_quantities
159: -- in order to do bulk insert later on
160: -- 3. Bulk insert in wsm_sj_secondary_quantities
161:

Line 168: -- Query wsm_job_secondary_quantities table to get the SJ data into l_job_qty_tbl

164: while l_counter is not null loop
165: --store SJ WE_ids in a local table for later use
166: l_sj_we_id_tbl(l_counter) := p_wltx_starting_jobs_tbl(l_counter).wip_entity_id;
167:
168: -- Query wsm_job_secondary_quantities table to get the SJ data into l_job_qty_tbl
169: select *
170: bulk collect into l_job_qty_tbl
171: from wsm_job_secondary_quantities
172: where wip_entity_id = p_wltx_starting_jobs_tbl(l_counter).wip_entity_id

Line 171: from wsm_job_secondary_quantities

167:
168: -- Query wsm_job_secondary_quantities table to get the SJ data into l_job_qty_tbl
169: select *
170: bulk collect into l_job_qty_tbl
171: from wsm_job_secondary_quantities
172: where wip_entity_id = p_wltx_starting_jobs_tbl(l_counter).wip_entity_id
173: and currently_active= 1;
174:
175: if( g_log_level_statement >= l_log_level ) then

Line 234: -- bulk insert data into wsm_op_secondary_quantities by reading from wsm_job_secondary_quantities

230: ----- Handle Secondary qty information passed for Split,Merge,Upd Assy and Update Qty transaction-------------------------------------
231: IF p_wltx_header.transaction_type_id in (WSMPCNST.SPLIT,WSMPCNST.MERGE,WSMPCNST.UPDATE_ASSEMBLY,WSMPCNST.UPDATE_QUANTITY) then
232:
233: -- For all the new resulting jobs (non-SpUA jobs)
234: -- bulk insert data into wsm_op_secondary_quantities by reading from wsm_job_secondary_quantities
235: --Assumes that the wsm_job_secondary_quantities is already populated in lbj build_header_info proc
236: IF p_wltx_header.transaction_type_id in (WSMPCNST.SPLIT,WSMPCNST.MERGE) then
237: l_op_tbl_counter := 1;
238:

Line 235: --Assumes that the wsm_job_secondary_quantities is already populated in lbj build_header_info proc

231: IF p_wltx_header.transaction_type_id in (WSMPCNST.SPLIT,WSMPCNST.MERGE,WSMPCNST.UPDATE_ASSEMBLY,WSMPCNST.UPDATE_QUANTITY) then
232:
233: -- For all the new resulting jobs (non-SpUA jobs)
234: -- bulk insert data into wsm_op_secondary_quantities by reading from wsm_job_secondary_quantities
235: --Assumes that the wsm_job_secondary_quantities is already populated in lbj build_header_info proc
236: IF p_wltx_header.transaction_type_id in (WSMPCNST.SPLIT,WSMPCNST.MERGE) then
237: l_op_tbl_counter := 1;
238:
239: l_stmt_num := 50;

Line 256: from wsm_job_secondary_quantities

252: THEN
253: select *
254: bulk collect
255: into l_job_qty_tbl
256: from wsm_job_secondary_quantities
257: where wip_entity_id = p_wltx_resulting_jobs_tbl(l_counter).wip_entity_id
258: and currently_active = 1;
259:
260: -- now populate the local pl/sql table with rowtype same as wsm_op_secondary_quantities

Line 334: update wsm_job_secondary_quantities

330: (p_wltx_header.transaction_type_id = WSMPCNST.UPDATE_ASSEMBLY)
331: THEN
332: l_stmt_num := 80.1;
333: -- obsolete Old UOMs no longer valid in new assy
334: update wsm_job_secondary_quantities
335: set currently_active =2,
336: current_quantity=null
337: where wip_entity_id = l_sj_rj_wip_entity_id
338: AND uom_code not in (select uom_code

Line 357: update wsm_job_secondary_quantities

353: -- ST : Bug fix 5046332 : Added the below update to change the active flag of UOMs
354: -- currently inactive but are present in the new item
355: l_stmt_num := 80.2;
356: -- Enable old UOMs to be valid if present in new assy
357: update wsm_job_secondary_quantities
358: set currently_active = 1,
359: current_quantity= null
360: where wip_entity_id = l_sj_rj_wip_entity_id
361: AND uom_code in (select uom_code

Line 379: insert into wsm_job_secondary_quantities

375: End if;
376: -- ST : Bug fix 5046332 : End --
377:
378: --Insert new UOMs skeletal info into the base table by reading from wsm_secondary_uoms
379: insert into wsm_job_secondary_quantities
380: (wip_entity_id
381: ,organization_id
382: ,uom_code
383: ,start_quantity

Line 413: from wsm_job_secondary_quantities

409: -- where inventory_item_id= p_wltx_starting_jobs_tbl(p_rep_job_index).primary_item_id)
410: -- -- ST : Sec. UOM Fix : Use the starting rep jobs's item id --
411: -- ST : Bug Fix 5046332 : Added the below condition ---
412: and uom_code not in (select uom_code
413: from wsm_job_secondary_quantities
414: where wip_entity_id = l_sj_rj_wip_entity_id)
415: -- ST : Bug Fix 5046332 : End --
416: );
417:

Line 437: -- Update wsm_job_secondary_quantities wjsq

433: -- (p_sj_also_rj_index is not NULL) and
434: -- (l_sj_rj_sec_qty_exists = 0)
435: -- THEN
436: -- -- User hasnt provided secondary qty information...
437: -- Update wsm_job_secondary_quantities wjsq
438: -- set current_quantity = null
439: -- where wjsq.wip_entity_id = l_sj_rj_wip_entity_id
440: -- and currently_active = 1;
441: -- END IF;

Line 446: update wsm_job_secondary_quantities

442:
443: -- Now do the updation for all the resulting jobs...
444: IF p_secondary_qty_tbl.count <> 0 THEN
445: forall i in indices of p_secondary_qty_tbl
446: update wsm_job_secondary_quantities
447: set current_quantity = l_cur_qty_tbl(i)
448: where wip_entity_id = l_wip_entity_id_tbl(i)
449: and uom_code = l_cur_uom_tbl(i);
450: END IF;

Line 471: update wsm_job_secondary_quantities

467: -- In case of Merge and Split,
468: -- then need to set the cur_qty = null and cur_active = N for Starting Jobs not present as a Resulting job
469: IF p_wltx_header.transaction_type_id IN (WSMPCNST.SPLIT,WSMPCNST.MERGE) THEN
470: forall i in indices of l_sj_we_id_tbl
471: update wsm_job_secondary_quantities
472: set currently_active = 2,
473: current_quantity=null
474: where wip_entity_id = l_sj_we_id_tbl(i)
475: and wip_entity_id <> nvl(l_sj_rj_wip_entity_id,0);

Line 574: -- to fill in data from the WSM_JOB_SECONDARY_QUANTITIES into ... WSM_OP_SECONDARY_QUANTITIES

570: -- now handle bonus.Insert skeletal data in both job level and op level tables as for job
571: -- we are calling option 1 code so LBJ proc wont insert elementary sec qty data
572:
573: -- Call the WSMOPRNB procedure for BONUS,UPDATE_ASSEMBLY, SpUA and UPDATE_ROUTING transactions
574: -- to fill in data from the WSM_JOB_SECONDARY_QUANTITIES into ... WSM_OP_SECONDARY_QUANTITIES
575: IF p_wltx_header.transaction_type_id IN (WSMPCNST.BONUS,WSMPCNST.UPDATE_ASSEMBLY,WSMPCNST.UPDATE_ROUTING,WSMPCNST.SPLIT) THEN
576: l_counter := p_wltx_resulting_jobs_tbl.first;
577: while l_counter IS NOT NULL LOOP
578: IF (p_wltx_header.transaction_type_id <> WSMPCNST.SPLIT) OR

Line 584: insert into wsm_job_secondary_quantities

580: THEN
581: l_stmt_num := 130;
582: -- In case of bonus we'll have to create the skeletal data and then invoke the OPRNB code
583: IF p_wltx_header.transaction_type_id = WSMPCNST.BONUS THEN
584: insert into wsm_job_secondary_quantities
585: ( wip_entity_id
586: ,organization_id
587: ,uom_code
588: ,start_quantity

Line 674: from wsm_job_secondary_quantities

670: while l_counter is not null loop
671:
672: select *
673: bulk collect into l_job_qty_tbl
674: from wsm_job_secondary_quantities
675: where wip_entity_id = p_wltx_resulting_jobs_tbl(l_counter).wip_entity_id
676: and currently_active= 1;
677:
678: -- now populate the local pl/sql table