eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSM_WLT_VALIDATE_PVT dependencies on WSM_WIP_LOT_TXN_PVT

Line 14: p_wltx_header IN WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,

10: -- ***end data types for LBJ code-remove later when LBJ API is coded
11:
12: -- Inserts the data into the base tables...
13: Procedure insert_txn_data ( p_transaction_id IN NUMBER,
14: p_wltx_header IN WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,
15: p_wltx_starting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,
16: p_wltx_resulting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,
17: x_return_status OUT NOCOPY VARCHAR2,
18: x_msg_count OUT NOCOPY NUMBER,

Line 15: p_wltx_starting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,

11:
12: -- Inserts the data into the base tables...
13: Procedure insert_txn_data ( p_transaction_id IN NUMBER,
14: p_wltx_header IN WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,
15: p_wltx_starting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,
16: p_wltx_resulting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,
17: x_return_status OUT NOCOPY VARCHAR2,
18: x_msg_count OUT NOCOPY NUMBER,
19: x_msg_data OUT NOCOPY VARCHAR2

Line 16: p_wltx_resulting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,

12: -- Inserts the data into the base tables...
13: Procedure insert_txn_data ( p_transaction_id IN NUMBER,
14: p_wltx_header IN WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,
15: p_wltx_starting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,
16: p_wltx_resulting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,
17: x_return_status OUT NOCOPY VARCHAR2,
18: x_msg_count OUT NOCOPY NUMBER,
19: x_msg_data OUT NOCOPY VARCHAR2
20: );

Line 24: Procedure validate_txn_header ( p_wltx_header IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,

20: );
21:
22:
23: -- Validate the txn details passed
24: Procedure validate_txn_header ( p_wltx_header IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,
25: x_return_status OUT NOCOPY VARCHAR2,
26: x_msg_count OUT NOCOPY NUMBER,
27: x_msg_data OUT NOCOPY VARCHAR2
28: );

Line 48: p_starting_job_rec IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_REC_TYPE,

44: Procedure derive_val_st_job_details( p_txn_org_id IN NUMBER,
45: p_txn_type IN NUMBER,
46: -- ST : Added Txn date for bug 4351071
47: p_txn_date IN DATE,
48: p_starting_job_rec IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_REC_TYPE,
49: x_return_status OUT NOCOPY VARCHAR2,
50: x_msg_count OUT NOCOPY NUMBER,
51: x_msg_data OUT NOCOPY VARCHAR2
52: );

Line 58: p_starting_jobs_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,

54: Procedure derive_val_st_job_details( p_txn_org_id IN NUMBER,
55: p_txn_type IN NUMBER,
56: -- ST : Added Txn date for bug 4351071
57: p_txn_date IN DATE,
58: p_starting_jobs_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,
59: p_rep_job_index OUT NOCOPY NUMBER,
60: p_total_avail_quantity OUT NOCOPY NUMBER,
61: p_total_net_quantity OUT NOCOPY NUMBER,
62: x_job_serial_code OUT NOCOPY NUMBER,

Line 71: p_starting_job_rec IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_REC_TYPE,

67:
68: -- Default resulting job details for merge txn --
69: Procedure derive_val_res_job_details( p_txn_type IN NUMBER,
70: p_txn_org_id IN NUMBER,
71: p_starting_job_rec IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_REC_TYPE,
72: p_job_quantity IN NUMBER,
73: p_job_net_quantity IN NUMBER,
74: -- ST : Serial Support : Added the below parameter..
75: p_job_serial_code IN NUMBER,

Line 76: p_resulting_job_rec IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_REC_TYPE,

72: p_job_quantity IN NUMBER,
73: p_job_net_quantity IN NUMBER,
74: -- ST : Serial Support : Added the below parameter..
75: p_job_serial_code IN NUMBER,
76: p_resulting_job_rec IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_REC_TYPE,
77: x_return_status OUT NOCOPY VARCHAR2,
78: x_msg_count OUT NOCOPY NUMBER,
79: x_msg_data OUT NOCOPY VARCHAR2
80: );

Line 86: p_resulting_job_rec IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_REC_TYPE,

82: -- Default resulting job details for bonus txn --
83: Procedure derive_val_res_job_details( p_txn_type IN NUMBER,
84: p_txn_org_id IN NUMBER,
85: p_transaction_date IN DATE,
86: p_resulting_job_rec IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_REC_TYPE,
87: x_return_status OUT NOCOPY VARCHAR2,
88: x_msg_count OUT NOCOPY NUMBER,
89: x_msg_data OUT NOCOPY VARCHAR2
90: );

Line 96: p_starting_job_rec IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_REC_TYPE,

92: -- for non-split non-merge transactions.... --
93: Procedure derive_val_res_job_details( p_txn_type IN NUMBER,
94: p_txn_org_id IN NUMBER,
95: p_transaction_date IN DATE,
96: p_starting_job_rec IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_REC_TYPE,
97: p_resulting_job_rec IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_REC_TYPE,
98: x_return_status OUT NOCOPY VARCHAR2,
99: x_msg_count OUT NOCOPY NUMBER,
100: x_msg_data OUT NOCOPY VARCHAR2

Line 97: p_resulting_job_rec IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_REC_TYPE,

93: Procedure derive_val_res_job_details( p_txn_type IN NUMBER,
94: p_txn_org_id IN NUMBER,
95: p_transaction_date IN DATE,
96: p_starting_job_rec IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_REC_TYPE,
97: p_resulting_job_rec IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_REC_TYPE,
98: x_return_status OUT NOCOPY VARCHAR2,
99: x_msg_count OUT NOCOPY NUMBER,
100: x_msg_data OUT NOCOPY VARCHAR2
101: );

Line 107: p_starting_job_rec IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_REC_TYPE,

103:
104: -- Default resulting job details from the starting job for appropriate fields depending on txn ( overloaded for split) --
105: Procedure derive_val_res_job_details( p_txn_type IN NUMBER,
106: p_txn_org_id IN NUMBER,
107: p_starting_job_rec IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_REC_TYPE,
108: p_resulting_jobs_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,
109: x_return_status OUT NOCOPY VARCHAR2,
110: x_msg_count OUT NOCOPY NUMBER,
111: x_msg_data OUT NOCOPY VARCHAR2

Line 108: p_resulting_jobs_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,

104: -- Default resulting job details from the starting job for appropriate fields depending on txn ( overloaded for split) --
105: Procedure derive_val_res_job_details( p_txn_type IN NUMBER,
106: p_txn_org_id IN NUMBER,
107: p_starting_job_rec IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_REC_TYPE,
108: p_resulting_jobs_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,
109: x_return_status OUT NOCOPY VARCHAR2,
110: x_msg_count OUT NOCOPY NUMBER,
111: x_msg_data OUT NOCOPY VARCHAR2
112: );