APPS.WSMPLOAD dependencies on WSMPLOAD

Line 1: PACKAGE BODY WSMPLOAD AS

1: PACKAGE BODY WSMPLOAD AS
2: /* $Header: WSMLOADB.pls 120.10.12010000.2 2008/09/02 06:11:44 sisankar ship $ */
3:
4: /* Forward declaration of this PRIVATE PROCEDURE */
5:

Line 125: WHERE wsrj.internal_group_id = WSMPLOAD.G_GROUP_ID

121: wdj.wip_supply_type
122: FROM wsm_lot_based_jobs wlbj,
123: wip_discrete_jobs wdj,
124: wsm_sm_resulting_jobs wsrj
125: WHERE wsrj.internal_group_id = WSMPLOAD.G_GROUP_ID
126: AND wsrj.wip_entity_id = wlbj.wip_entity_id
127: AND wlbj.wip_entity_id = wdj.wip_entity_id
128: AND wdj.status_type = 3 -- Released jobs
129: AND wlbj.internal_copy_type in (1, 2)

Line 141: WHERE wsrj.internal_group_id = WSMPLOAD.G_GROUP_ID

137: decode(wlbj.on_rec_path, 'Y', WIP_CONSTANTS.MIDPOINT_FORWARDS, WIP_CONSTANTS.CURRENT_OP) inf_sch_mode
138: FROM wsm_lot_based_jobs wlbj,
139: wip_discrete_jobs wdj,
140: wsm_sm_resulting_jobs wsrj
141: WHERE wsrj.internal_group_id = WSMPLOAD.G_GROUP_ID
142: AND wsrj.wip_entity_id = wlbj.wip_entity_id
143: AND wlbj.wip_entity_id = wdj.wip_entity_id
144: AND wdj.status_type = 3 -- Released jobs
145: AND wlbj.infinite_schedule = 'Y';

Line 174: l_module VARCHAR2(100) := 'wsm.plsql.WSMPLOAD.algo_create_copies';

170: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
171: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
172:
173: l_stmt_num NUMBER;
174: l_module VARCHAR2(100) := 'wsm.plsql.WSMPLOAD.algo_create_copies';
175: -- Logging variables...
176:
177: begin
178:

Line 190: -- WHERE wsrj.internal_group_id = WSMPLOAD.G_GROUP_ID

186: -- INTO l_temp
187: -- FROM wsm_lot_based_jobs wlbj,
188: -- wip_discrete_jobs wdj,
189: -- wsm_sm_resulting_jobs wsrj
190: -- WHERE wsrj.internal_group_id = WSMPLOAD.G_GROUP_ID
191: -- AND wsrj.wip_entity_id = wlbj.wip_entity_id
192: -- AND wlbj.wip_entity_id = wdj.wip_entity_id
193: -- AND wdj.status_type = 3 -- Released jobs
194: -- AND wlbj.internal_copy_type in (1, 2);

Line 579: l_module VARCHAR2(100) := 'wsm.plsql.WSMPLOAD.load';

575: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
576: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
577:
578: l_stmt_num NUMBER;
579: l_module VARCHAR2(100) := 'wsm.plsql.WSMPLOAD.load';
580: -- Logging variables...
581:
582: l_internal_group_id NUMBER;
583:

Line 673: WSMPLOAD.G_GROUP_ID := l_internal_group_id; -- WLTEnh add

669: l_stmt_num := 10;
670: select wsm_sm_txn_int_group_s.nextval into l_internal_group_id from dual;
671:
672: /* do you need this ... global variable.... */
673: WSMPLOAD.G_GROUP_ID := l_internal_group_id; -- WLTEnh add
674:
675: /* Start the loop here.... */
676: loop
677: l_wsm_wtxn_hdr_tbl.delete;

Line 1823: END WSMPLOAD;

1819: commit;
1820:
1821: END LOAD;
1822:
1823: END WSMPLOAD;