APPS.QA_SOLUTION_DISPOSITION_PKG dependencies on WIP_DISCRETE_JOBS

Line 187: -- This would avoid a full table scan on wip_discrete_jobs and

183: AND we.wip_entity_id = wjsi.wip_entity_id;
184: */
185:
186: -- Bug 3641781. Modified the sql to include primary_item_id.
187: -- This would avoid a full table scan on wip_discrete_jobs and
188: -- make the sql pick up the NON-UNIQUE index WIP_DISCRETE_JOBS_N1
189: -- (on primary_item_id). kabalakr
190:
191: CURSOR wip_job(l_src_code VARCHAR2, l_pri_item_id NUMBER) IS

Line 188: -- make the sql pick up the NON-UNIQUE index WIP_DISCRETE_JOBS_N1

184: */
185:
186: -- Bug 3641781. Modified the sql to include primary_item_id.
187: -- This would avoid a full table scan on wip_discrete_jobs and
188: -- make the sql pick up the NON-UNIQUE index WIP_DISCRETE_JOBS_N1
189: -- (on primary_item_id). kabalakr
190:
191: CURSOR wip_job(l_src_code VARCHAR2, l_pri_item_id NUMBER) IS
192: SELECT wip_entity_id

Line 193: FROM wip_discrete_jobs

189: -- (on primary_item_id). kabalakr
190:
191: CURSOR wip_job(l_src_code VARCHAR2, l_pri_item_id NUMBER) IS
192: SELECT wip_entity_id
193: FROM wip_discrete_jobs
194: WHERE primary_item_id = l_pri_item_id
195: AND source_code = l_src_code;
196:
197: BEGIN

Line 327: -- wip_discrete_jobs table using the source_code. kabalakr

323: ELSIF (substr(l_devstatus,1,6) = 'NORMAL') THEN
324:
325: -- Bug 3019869. We had passed the source_code concatenated
326: -- with the group_id. Hence fetching the wip_entity_id from
327: -- wip_discrete_jobs table using the source_code. kabalakr
328:
329: l_source_code := 'QA ACTION: REWORK'||to_char(l_group_id);
330:
331: -- Bug 3641781. Pass the item_id also to the cursor sql. kabalakr.

Line 347: X_to_entity_name => 'WIP_DISCRETE_JOBS',

343: X_from_entity_name => 'QA_RESULTS',
344: X_from_pk1_value => to_char(p_occurrence),
345: X_from_pk2_value => to_char(p_collection_id),
346: X_from_pk3_value => to_char(l_plan_id),
347: X_to_entity_name => 'WIP_DISCRETE_JOBS',
348: X_to_pk1_value => to_char(l_job_id),
349: X_to_pk2_value => to_char(l_organization_id));
350:
351: ELSE

Line 2826: -- Bug 2714880 : Derive the STATUS_TYPE of the Job from WIP_DISCRETE_JOBS. This

2822: --
2823: -- Bug 2656461 : Code added to support copying of attachments to the
2824: -- WIP_DISCRETE_OPERATIONS entity, once the Action is successful.
2825: --
2826: -- Bug 2714880 : Derive the STATUS_TYPE of the Job from WIP_DISCRETE_JOBS. This
2827: -- value is needed when importing Operations and resources in the
2828: -- internal functions REWORK_OP_ADD_OP_INT() and
2829: -- REWORK_OP_ADD_RES_INT().
2830: --

Line 2932: FROM wip_discrete_jobs

2928: -- Bug 2714880. Added the cursor below to fetch the status of the job.
2929:
2930: CURSOR job_status IS
2931: SELECT status_type
2932: FROM wip_discrete_jobs
2933: WHERE wip_entity_id = l_wip_entity_id;
2934:
2935:
2936: BEGIN