APPS.CSD_MIGRATE_FROM_115X_PKG6 dependencies on CSD_TASKS

Line 6: /* procedure name: CSD_TASKS_MIG6 */

2: /* $Header: csdmig6b.pls 120.8 2012/03/09 20:07:43 swai ship $ */
3: AS
4:
5: /*-------------------------------------------------------------------------------*/
6: /* procedure name: CSD_TASKS_MIG6 */
7: /* description : procedure for migrating Task data */
8: /* from 11.5.10 to R12 */
9: /* purpose : Create Repair Task record in CSD_TASKS */
10: /*-------------------------------------------------------------------------------*/

Line 9: /* purpose : Create Repair Task record in CSD_TASKS */

5: /*-------------------------------------------------------------------------------*/
6: /* procedure name: CSD_TASKS_MIG6 */
7: /* description : procedure for migrating Task data */
8: /* from 11.5.10 to R12 */
9: /* purpose : Create Repair Task record in CSD_TASKS */
10: /*-------------------------------------------------------------------------------*/
11:
12: PROCEDURE csd_task_mig6(p_slab_number IN NUMBER DEFAULT 1)
13: IS

Line 30: and not exists( select 'x' from csd_tasks

26: where jtf_tasks_vl.source_object_id = csd_repairs.repair_line_id
27: and source_object_type_code='DR'
28: and repair_line_id between p_start_repair_line_id
29: and p_end_repair_line_id
30: and not exists( select 'x' from csd_tasks
31: where csd_tasks.task_id = jtf_tasks_vl.task_id
32: and csd_tasks.repair_line_id = csd_repairs.repair_line_id);*/
33:
34: BEGIN

Line 31: where csd_tasks.task_id = jtf_tasks_vl.task_id

27: and source_object_type_code='DR'
28: and repair_line_id between p_start_repair_line_id
29: and p_end_repair_line_id
30: and not exists( select 'x' from csd_tasks
31: where csd_tasks.task_id = jtf_tasks_vl.task_id
32: and csd_tasks.repair_line_id = csd_repairs.repair_line_id);*/
33:
34: BEGIN
35: -- Get the Slab Number for the table

Line 32: and csd_tasks.repair_line_id = csd_repairs.repair_line_id);*/

28: and repair_line_id between p_start_repair_line_id
29: and p_end_repair_line_id
30: and not exists( select 'x' from csd_tasks
31: where csd_tasks.task_id = jtf_tasks_vl.task_id
32: and csd_tasks.repair_line_id = csd_repairs.repair_line_id);*/
33:
34: BEGIN
35: -- Get the Slab Number for the table
36:

Line 53: insert into CSD_TASKS (

49:
50: END;
51:
52: -- Migration code for creating Repair Tasks
53: insert into CSD_TASKS (
54: REPAIR_TASK_ID,
55: TASK_ID,
56: REPAIR_LINE_ID,
57: APPLICABLE_QA_PLANS,

Line 65: CSD.csd_tasks_s.nextval,

61: LAST_UPDATED_BY,
62: LAST_UPDATE_DATE,
63: LAST_UPDATE_LOGIN
64: ) select
65: CSD.csd_tasks_s.nextval,
66: jtf_tasks_vl.task_id,
67: csd_repairs.repair_line_id,
68: 'N',
69: 1,

Line 80: and not exists( select 'x' from csd_tasks

76: CSD_REPAIRS
77: where jtf_tasks_vl.source_object_id = csd_repairs.repair_line_id
78: and source_object_type_code='DR'
79: and repair_line_id between v_min and v_max
80: and not exists( select 'x' from csd_tasks
81: where csd_tasks.task_id = jtf_tasks_vl.task_id
82: and csd_tasks.repair_line_id = csd_repairs.repair_line_id);
83:
84:

Line 81: where csd_tasks.task_id = jtf_tasks_vl.task_id

77: where jtf_tasks_vl.source_object_id = csd_repairs.repair_line_id
78: and source_object_type_code='DR'
79: and repair_line_id between v_min and v_max
80: and not exists( select 'x' from csd_tasks
81: where csd_tasks.task_id = jtf_tasks_vl.task_id
82: and csd_tasks.repair_line_id = csd_repairs.repair_line_id);
83:
84:
85: COMMIT;

Line 82: and csd_tasks.repair_line_id = csd_repairs.repair_line_id);

78: and source_object_type_code='DR'
79: and repair_line_id between v_min and v_max
80: and not exists( select 'x' from csd_tasks
81: where csd_tasks.task_id = jtf_tasks_vl.task_id
82: and csd_tasks.repair_line_id = csd_repairs.repair_line_id);
83:
84:
85: COMMIT;
86: