APPS.CSD_DEPOT_UPDATE_PVT dependencies on CSD_REPAIR_JOB_XREF

Line 130: FROM csd_repair_job_xref x

126: WHERE incident_id = p_inc_id;
127:
128: CURSOR get_xref_id (p_rep_grp_id in number) IS
129: SELECT x.repair_job_xref_id, x.group_id, x.object_version_number
130: FROM csd_repair_job_xref x
131: WHERE x.repair_line_id in ( select r.repair_line_id
132: from csd_repairs r
133: where r.repair_group_id = p_rep_grp_id)
134: AND x.wip_entity_id = x.group_id;

Line 170: FROM csd_repair_job_xref crj,

166: csr.repair_number,
167: crj.quantity_completed,
168: crj.quantity,
169: csr.promise_date
170: FROM csd_repair_job_xref crj,
171: csd_repairs csr
172: WHERE repair_group_id = p_rep_group_id
173: AND csr.repair_line_id = crj.repair_line_id
174: AND nvl(crj.quantity_completed,0) < crj.quantity

Line 265: UPDATE csd_repair_job_xref

261: csd_gen_utility_pvt.ADD('In C6 updating xref : '||C6.repair_job_xref_id||' for wip_entity_id');
262: END IF;
263:
264: -- updating xref for wip_entity_id
265: UPDATE csd_repair_job_xref
266: SET wip_entity_id = v_weid
267: WHERE repair_job_xref_id = C6.repair_job_xref_id
268: AND group_id = C6.group_id
269: AND object_version_number = C6.object_version_number;

Line 347: -- Get the original qty completed from csd_repair_job_xref based on the wip_entity_id

343:
344: Raise FND_API.G_EXC_ERROR;
345: END;
346:
347: -- Get the original qty completed from csd_repair_job_xref based on the wip_entity_id
348: SELECT nvl(sum(quantity_completed),0)
349: INTO p_old_complete
350: FROM csd_repair_job_xref
351: WHERE wip_entity_id = C1.wip_entity_id;

Line 350: FROM csd_repair_job_xref

346:
347: -- Get the original qty completed from csd_repair_job_xref based on the wip_entity_id
348: SELECT nvl(sum(quantity_completed),0)
349: INTO p_old_complete
350: FROM csd_repair_job_xref
351: WHERE wip_entity_id = C1.wip_entity_id;
352:
353: -- Get the actual qty completed, (qty completed - old qty completed)
354: p_quantity_completed := nvl(v_quantity_completed,0) - nvl(p_old_complete,0);

Line 366: -- Update csd_repair_job_xref

362: -- Getting all the repair_lines for the repair_group_id
363: FOR C3 in get_repair_lines(C2.repair_group_id,C1.wip_entity_id)
364: LOOP
365:
366: -- Update csd_repair_job_xref
367: update csd_repair_job_xref
368: set quantity_completed = quantity
369: where repair_line_id = C3.repair_line_id;
370:

Line 367: update csd_repair_job_xref

363: FOR C3 in get_repair_lines(C2.repair_group_id,C1.wip_entity_id)
364: LOOP
365:
366: -- Update csd_repair_job_xref
367: update csd_repair_job_xref
368: set quantity_completed = quantity
369: where repair_line_id = C3.repair_line_id;
370:
371: IF (g_debug > 0 ) THEN

Line 372: csd_gen_utility_pvt.add('Updated qty completed in csd_repair_job_xref for :'||C1.wip_entity_id);

368: set quantity_completed = quantity
369: where repair_line_id = C3.repair_line_id;
370:
371: IF (g_debug > 0 ) THEN
372: csd_gen_utility_pvt.add('Updated qty completed in csd_repair_job_xref for :'||C1.wip_entity_id);
373: END IF;
374:
375:
376: -- Update csd_repairs