1 PACKAGE WSMPJUPD AUTHID CURRENT_USER AS
2 /* $Header: WSMJUPDS.pls 120.3.12000000.1 2007/01/12 05:35:46 appldev ship $ */
3
4 g_debug VARCHAR2(1);
5 g_osp_exists NUMBER := 0;
6 g_copy_mode NUMBER := NULL; -- Added for APS-WLT
7 -- 0=> no copies,
8 -- 1=> copies after each transaction,
9 -- 2=> copies at end (for interface only)
10 -- Will remain NULL if JUPD is called through the form
11
12
13
14 PROCEDURE PROCESS_LOTS (p_copy_qa IN VARCHAR2,
15 p_txn_org_id IN NUMBER,
16 p_rep_job_index IN NUMBER,
17 p_wltx_header IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,
18 p_wltx_starting_jobs_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,
19 p_wltx_resulting_jobs_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,
20 p_secondary_qty_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WSM_JOB_SECONDARY_QTY_TBL_TYPE ,
21 -- p_txn_id OUT NOCOPY NUMBER, /* i dont think this is needed,,,, */
22 x_return_status OUT NOCOPY VARCHAR2,
23 x_msg_count OUT NOCOPY NUMBER,
24 x_error_msg OUT NOCOPY VARCHAR2
25 );
26
27
28 PROCEDURE CREATE_COPIES_OR_SET_COPY_DATA (p_txn_id IN NUMBER,
29 p_txn_type_id IN NUMBER,
30 p_copy_mode IN NUMBER,
31 p_rep_sj_index IN NUMBER,
32 p_sj_as_rj_index IN NUMBER,
33 p_wltx_starting_jobs_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,
34 p_wltx_resulting_jobs_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,
35 x_err_code OUT NOCOPY NUMBER,
36 x_err_buf OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER);
38
39 PROCEDURE GET_JOB_CURR_OP_INFO(p_wip_entity_id IN NUMBER,
40 p_op_seq_num OUT NOCOPY NUMBER,
41 p_op_seq_id OUT NOCOPY NUMBER,
42 p_std_op_id OUT NOCOPY NUMBER,
43 p_intra_op OUT NOCOPY NUMBER,
44 p_dept_id OUT NOCOPY NUMBER,
45 p_op_qty OUT NOCOPY NUMBER,
46 p_op_start_date OUT NOCOPY DATE,
47 p_op_completion_date OUT NOCOPY DATE,
48 x_err_code OUT NOCOPY NUMBER,
49 x_err_buf OUT NOCOPY VARCHAR2,
50 x_msg_count OUT NOCOPY NUMBER);
51
52 END WSMPJUPD;