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 729: Procedure validate_txn_header ( p_wltx_header IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,

725: END wip_entity;
726:
727: -- Validate the txn header details passed
728: -- Validate organization, transaction date
729: Procedure validate_txn_header ( p_wltx_header IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,
730: x_return_status OUT NOCOPY VARCHAR2,
731: x_msg_count OUT NOCOPY NUMBER,
732: x_msg_data OUT NOCOPY VARCHAR2
733: ) IS

Line 1241: p_starting_job_rec IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_REC_TYPE,

1237: Procedure derive_val_st_job_details( p_txn_org_id IN NUMBER,
1238: p_txn_type IN NUMBER,
1239: -- ST : Added Txn date for bug 4351071
1240: p_txn_date IN DATE,
1241: p_starting_job_rec IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_REC_TYPE,
1242: x_return_status OUT NOCOPY VARCHAR2,
1243: x_msg_count OUT NOCOPY NUMBER,
1244: x_msg_data OUT NOCOPY VARCHAR2
1245: ) IS

Line 1862: p_starting_jobs_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,

1858: Procedure derive_val_st_job_details( p_txn_org_id IN NUMBER,
1859: p_txn_type IN NUMBER,
1860: -- ST : Added Txn date for bug 4351071
1861: p_txn_date IN DATE,
1862: p_starting_jobs_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,
1863: p_rep_job_index OUT NOCOPY NUMBER,
1864: p_total_avail_quantity OUT NOCOPY NUMBER,
1865: p_total_net_quantity OUT NOCOPY NUMBER,
1866: -- Added For serial...

Line 1931: p_msg_text => 'Calling WSM_WIP_LOT_TXN_PVT.derive_val_st_job_details ',

1927:
1928: if( g_log_level_statement >= l_log_level ) then
1929: l_msg_tokens.delete;
1930: WSM_log_PVT.logMessage(p_module_name => l_module,
1931: p_msg_text => 'Calling WSM_WIP_LOT_TXN_PVT.derive_val_st_job_details ',
1932: p_stmt_num => l_stmt_num,
1933: p_msg_tokens => l_msg_tokens,
1934: p_fnd_log_level => g_log_level_statement,
1935: p_run_log_level => l_log_level

Line 1959: p_msg_text => 'WSM_WIP_LOT_TXN_PVT.derive_val_st_job_details returned failure' ,

1955: if( g_log_level_statement >= l_log_level ) then
1956:
1957: l_msg_tokens.delete;
1958: WSM_log_PVT.logMessage(p_module_name => l_module ,
1959: p_msg_text => 'WSM_WIP_LOT_TXN_PVT.derive_val_st_job_details returned failure' ,
1960: p_stmt_num => l_stmt_num ,
1961: p_msg_tokens => l_msg_tokens,
1962: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1963: p_fnd_log_level => G_LOG_LEVEL_ERROR ,

Line 2236: p_starting_job_rec IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_REC_TYPE,

2232: -- Default resulting job details from the starting job for appropriate fields depending on txn and also validate the appropriate fields
2233: Procedure derive_val_res_job_details( p_txn_type IN NUMBER,
2234: p_txn_org_id IN NUMBER,
2235: p_transaction_date IN DATE,
2236: p_starting_job_rec IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_REC_TYPE,
2237: p_resulting_job_rec IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_REC_TYPE,
2238: x_return_status OUT NOCOPY VARCHAR2,
2239: x_msg_count OUT NOCOPY NUMBER,
2240: x_msg_data OUT NOCOPY VARCHAR2

Line 2237: p_resulting_job_rec IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_REC_TYPE,

2233: Procedure derive_val_res_job_details( p_txn_type IN NUMBER,
2234: p_txn_org_id IN NUMBER,
2235: p_transaction_date IN DATE,
2236: p_starting_job_rec IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_REC_TYPE,
2237: p_resulting_job_rec IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_REC_TYPE,
2238: x_return_status OUT NOCOPY VARCHAR2,
2239: x_msg_count OUT NOCOPY NUMBER,
2240: x_msg_data OUT NOCOPY VARCHAR2
2241: ) IS

Line 3690: p_starting_job_rec IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_REC_TYPE,

3686:
3687: -- Default resulting job details for merge txn --
3688: Procedure derive_val_res_job_details( p_txn_type IN NUMBER,
3689: p_txn_org_id IN NUMBER,
3690: p_starting_job_rec IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_REC_TYPE,
3691: p_job_quantity IN NUMBER,
3692: p_job_net_quantity IN NUMBER,
3693: -- ST : Serial Support : Added the below parameter..
3694: p_job_serial_code IN NUMBER,

Line 3695: p_resulting_job_rec IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_REC_TYPE,

3691: p_job_quantity IN NUMBER,
3692: p_job_net_quantity IN NUMBER,
3693: -- ST : Serial Support : Added the below parameter..
3694: p_job_serial_code IN NUMBER,
3695: p_resulting_job_rec IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_REC_TYPE,
3696: x_return_status OUT NOCOPY VARCHAR2,
3697: x_msg_count OUT NOCOPY NUMBER,
3698: x_msg_data OUT NOCOPY VARCHAR2
3699: ) is

Line 4010: p_starting_job_rec IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_REC_TYPE,

4006:
4007: -- Default resulting job details from the starting job for appropriate fields depending on txn ( overloaded for split) --
4008: Procedure derive_val_res_job_details( p_txn_type IN NUMBER,
4009: p_txn_org_id IN NUMBER,
4010: p_starting_job_rec IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_REC_TYPE,
4011: p_resulting_jobs_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,
4012: x_return_status OUT NOCOPY VARCHAR2,
4013: x_msg_count OUT NOCOPY NUMBER,
4014: x_msg_data OUT NOCOPY VARCHAR2

Line 4011: p_resulting_jobs_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,

4007: -- Default resulting job details from the starting job for appropriate fields depending on txn ( overloaded for split) --
4008: Procedure derive_val_res_job_details( p_txn_type IN NUMBER,
4009: p_txn_org_id IN NUMBER,
4010: p_starting_job_rec IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_REC_TYPE,
4011: p_resulting_jobs_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,
4012: x_return_status OUT NOCOPY VARCHAR2,
4013: x_msg_count OUT NOCOPY NUMBER,
4014: x_msg_data OUT NOCOPY VARCHAR2
4015: ) is

Line 4984: p_resulting_job_rec IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_REC_TYPE,

4980: -- Default resulting job details for bonus txn
4981: PROCEDURE derive_val_res_job_details( p_txn_type IN NUMBER,
4982: p_txn_org_id IN NUMBER,
4983: p_transaction_date IN DATE,
4984: p_resulting_job_rec IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_REC_TYPE,
4985: x_return_status OUT NOCOPY VARCHAR2,
4986: x_msg_count OUT NOCOPY NUMBER ,
4987: x_msg_data OUT NOCOPY VARCHAR2
4988: )

Line 7365: p_wltx_header IN WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,

7361: end derive_val_primary_item;
7362:
7363: -- Inserts the data into the base tables...
7364: Procedure insert_txn_data (p_transaction_id IN NUMBER,
7365: p_wltx_header IN WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,
7366: p_wltx_starting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,
7367: p_wltx_resulting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,
7368: x_return_status OUT NOCOPY VARCHAR2,
7369: x_msg_count OUT NOCOPY NUMBER,

Line 7366: p_wltx_starting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,

7362:
7363: -- Inserts the data into the base tables...
7364: Procedure insert_txn_data (p_transaction_id IN NUMBER,
7365: p_wltx_header IN WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,
7366: p_wltx_starting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,
7367: p_wltx_resulting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,
7368: x_return_status OUT NOCOPY VARCHAR2,
7369: x_msg_count OUT NOCOPY NUMBER,
7370: x_msg_data OUT NOCOPY VARCHAR2

Line 7367: p_wltx_resulting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,

7363: -- Inserts the data into the base tables...
7364: Procedure insert_txn_data (p_transaction_id IN NUMBER,
7365: p_wltx_header IN WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,
7366: p_wltx_starting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,
7367: p_wltx_resulting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,
7368: x_return_status OUT NOCOPY VARCHAR2,
7369: x_msg_count OUT NOCOPY NUMBER,
7370: x_msg_data OUT NOCOPY VARCHAR2
7371: ) IS

Line 7388: l_starting_job_rec WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_REC_TYPE;

7384: -- Loop Variable --
7385: l_counter NUMBER := 0;
7386:
7387: -- Starting and resulting jobs records
7388: l_starting_job_rec WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_REC_TYPE;
7389: l_resulting_job_rec WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_REC_TYPE;
7390:
7391:
7392: BEGIN

Line 7389: l_resulting_job_rec WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_REC_TYPE;

7385: l_counter NUMBER := 0;
7386:
7387: -- Starting and resulting jobs records
7388: l_starting_job_rec WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_REC_TYPE;
7389: l_resulting_job_rec WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_REC_TYPE;
7390:
7391:
7392: BEGIN
7393: -- Have a starting point