APPS.WSMPJUPD dependencies on WSM_SJ_SECONDARY_QUANTITIES

Line 40: type t_wsm_sj_sec_qty_tbl is table of wsm_sj_secondary_quantities%rowtype 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:
44: type t_we_id_tbl is table of wip_entities.wip_entity_id%type index by binary_integer;

Line 156: -- First store SJ sec qty info in wsm_sj_secondary_quantities.The following steps followed for this:

152: l_job_qty_tbl.delete;
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

Line 158: -- 2. Now use this to populate fields in l_wsm_sj_sec_qty_tbl having rowtype same as wsm_sj_secondary_quantities

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:
162: l_counter := p_wltx_starting_jobs_tbl.first;

Line 160: -- 3. Bulk insert in wsm_sj_secondary_quantities

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:
162: l_counter := p_wltx_starting_jobs_tbl.first;
163: l_sj_tbl_counter := 1;
164: while l_counter is not null loop

Line 210: -- bulk insert in wsm_sj_secondary_quantities

206:
207: l_counter := p_wltx_starting_jobs_tbl.next(l_counter);
208: end loop;
209:
210: -- bulk insert in wsm_sj_secondary_quantities
211: if l_wsm_sj_sec_qty_tbl.count > 0 then
212: forall i in indices of l_wsm_sj_sec_qty_tbl
213: insert into wsm_sj_secondary_quantities
214: values l_wsm_sj_sec_qty_tbl(i);

Line 213: insert into wsm_sj_secondary_quantities

209:
210: -- bulk insert in wsm_sj_secondary_quantities
211: if l_wsm_sj_sec_qty_tbl.count > 0 then
212: forall i in indices of l_wsm_sj_sec_qty_tbl
213: insert into wsm_sj_secondary_quantities
214: values l_wsm_sj_sec_qty_tbl(i);
215: end if;
216: if( g_log_level_statement >= l_log_level ) then
217: l_msg_tokens.delete;