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 1073: DELETE WSM_COPY_OP_NETWORKS

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

Line 1628: INSERT into WSM_COPY_OP_NETWORKS

1624: -- null values in the table because of the deletion
1625: -- in the previous statement.
1626: --forall l_index in v_job_nw.first..v_job_nw.last
1627: forall l_index in INDICES OF v_job_nw
1628: INSERT into WSM_COPY_OP_NETWORKS
1629: values v_job_nw(l_index);
1630:
1631: --This is not needed when called from wlt code
1632: l_counter := t_eff_opseqid_pos(l_start_op_seq_id);

Line 2441: FROM WSM_COPY_OP_NETWORKS

2437:
2438: BEGIN
2439: SELECT 1
2440: INTO l_op_seq_one_exists_in_ntwk
2441: FROM WSM_COPY_OP_NETWORKS
2442: WHERE routing_sequence_id = p_common_rtg_seq_id
2443: AND wip_entity_id = p_wip_entity_id -- Added for performance improvement
2444: AND 1 in (from_op_seq_num, to_op_seq_num);
2445: EXCEPTION

Line 3928: DELETE WSM_COPY_OP_NETWORKS

3924: -- The following deletes will be needed, in case the API is to be made public
3925: --OPTII-PERF:Following deletes are not needed as this will be called for
3926: --only new jobs.
3927: /*
3928: DELETE WSM_COPY_OP_NETWORKS
3929: WHERE wip_entity_id = p_new_wip_entity_id;
3930:
3931: DELETE WSM_COPY_OPERATIONS
3932: WHERE wip_entity_id = p_new_wip_entity_id;

Line 3951: INSERT into WSM_COPY_OP_NETWORKS

3947: WHERE wip_entity_id = p_new_wip_entity_id;
3948:
3949: -- ***** Make a copy of the Network for the job ***** --
3950: l_stmt_num := 20;
3951: INSERT into WSM_COPY_OP_NETWORKS
3952: (WIP_ENTITY_ID,
3953: FROM_OP_SEQ_NUM,
3954: TO_OP_SEQ_NUM,
3955: FROM_OP_SEQ_ID,

Line 4024: FROM WSM_COPY_OP_NETWORKS

4020: ATTRIBUTE13,
4021: ATTRIBUTE14,
4022: ATTRIBUTE15,
4023: ORIGINAL_SYSTEM_REFERENCE
4024: FROM WSM_COPY_OP_NETWORKS
4025: WHERE wip_entity_id = p_rep_wip_entity_id;
4026:
4027:
4028:

Line 5072: DELETE WSM_COPY_OP_NETWORKS

5068: -- Delete COPY tables --
5069: DELETE WSM_COPY_OPERATIONS
5070: WHERE wip_entity_id = v_job_wip_entity_id(l_counter);
5071:
5072: DELETE WSM_COPY_OP_NETWORKS
5073: WHERE wip_entity_id = v_job_wip_entity_id(l_counter);
5074:
5075: DELETE WSM_COPY_OP_RESOURCES
5076: WHERE wip_entity_id = v_job_wip_entity_id(l_counter);