APPS.WSM_JOBCOPIES_PVT dependencies on WSM_COPY_OP_NETWORKS

Line 433: type t_job_nw is table of WSM_COPY_OP_NETWORKS%rowtype index by binary_integer;

429:
430:
431:
432: type t_job_ops is table of WSM_COPY_OPERATIONS%rowtype index by binary_integer;
433: type t_job_nw is table of WSM_COPY_OP_NETWORKS%rowtype index by binary_integer;
434:
435:
436: v_job_ops t_job_ops;
437: v_job_nw t_job_nw;

Line 1074: DELETE WSM_COPY_OP_NETWORKS

1070:
1071: DELETE WSM_COPY_OPERATIONS
1072: WHERE wip_entity_id = p_wip_entity_id;
1073:
1074: DELETE WSM_COPY_OP_NETWORKS
1075: WHERE wip_entity_id = p_wip_entity_id;
1076:
1077: DELETE WSM_COPY_OP_RESOURCES
1078: WHERE wip_entity_id = p_wip_entity_id;

Line 1787: INSERT into WSM_COPY_OP_NETWORKS

1783: -- null values in the table because of the deletion
1784: -- in the previous statement.
1785: --forall l_index in v_job_nw.first..v_job_nw.last
1786: forall l_index in INDICES OF v_job_nw
1787: INSERT into WSM_COPY_OP_NETWORKS
1788: (WIP_ENTITY_ID,
1789: FROM_OP_SEQ_NUM,
1790: TO_OP_SEQ_NUM,
1791: FROM_OP_SEQ_ID,

Line 2673: FROM WSM_COPY_OP_NETWORKS

2669:
2670: BEGIN
2671: SELECT 1
2672: INTO l_op_seq_one_exists_in_ntwk
2673: FROM WSM_COPY_OP_NETWORKS
2674: WHERE routing_sequence_id = p_common_rtg_seq_id
2675: AND wip_entity_id = p_wip_entity_id -- Added for performance improvement
2676: AND 1 in (from_op_seq_num, to_op_seq_num);
2677: EXCEPTION

Line 4159: DELETE WSM_COPY_OP_NETWORKS

4155: -- The following deletes will be needed, in case the API is to be made public
4156: --OPTII-PERF:Following deletes are not needed as this will be called for
4157: --only new jobs.
4158: /*
4159: DELETE WSM_COPY_OP_NETWORKS
4160: WHERE wip_entity_id = p_new_wip_entity_id;
4161:
4162: DELETE WSM_COPY_OPERATIONS
4163: WHERE wip_entity_id = p_new_wip_entity_id;

Line 4182: INSERT into WSM_COPY_OP_NETWORKS

4178: WHERE wip_entity_id = p_new_wip_entity_id;
4179:
4180: -- ***** Make a copy of the Network for the job ***** --
4181: l_stmt_num := 20;
4182: INSERT into WSM_COPY_OP_NETWORKS
4183: (WIP_ENTITY_ID,
4184: FROM_OP_SEQ_NUM,
4185: TO_OP_SEQ_NUM,
4186: FROM_OP_SEQ_ID,

Line 4255: FROM WSM_COPY_OP_NETWORKS

4251: ATTRIBUTE13,
4252: ATTRIBUTE14,
4253: ATTRIBUTE15,
4254: ORIGINAL_SYSTEM_REFERENCE
4255: FROM WSM_COPY_OP_NETWORKS
4256: WHERE wip_entity_id = p_rep_wip_entity_id;
4257:
4258:
4259:

Line 5303: DELETE WSM_COPY_OP_NETWORKS

5299: -- Delete COPY tables --
5300: DELETE WSM_COPY_OPERATIONS
5301: WHERE wip_entity_id = v_job_wip_entity_id(l_counter);
5302:
5303: DELETE WSM_COPY_OP_NETWORKS
5304: WHERE wip_entity_id = v_job_wip_entity_id(l_counter);
5305:
5306: DELETE WSM_COPY_OP_RESOURCES
5307: WHERE wip_entity_id = v_job_wip_entity_id(l_counter);