DBA Data[Home] [Help]

APPS.WSMPLOAD dependencies on WSMPCNST

Line 1106: IF l_txn_header_rec.transaction_type_id IN (WSMPCNST.SPLIT,WSMPCNST.UPDATE_QUANTITY) AND

1102:
1103: SAVEPOINT s_process_one_wlt;
1104:
1105: -- ST : Serial Support Project ---
1106: IF l_txn_header_rec.transaction_type_id IN (WSMPCNST.SPLIT,WSMPCNST.UPDATE_QUANTITY) AND
1107: l_starting_jobs_tbl.count = 1
1108: THEN
1109:
1110: if( g_log_level_statement >= l_log_level ) then

Line 1201: IF l_txn_header_rec.transaction_type_id = WSMPCNST.BONUS THEN

1197:
1198: -- ST : Fix for bug 5233265 --
1199: -- Store the information required beforehand..
1200: -- Wip entity Name can be updated... (but the original wip entity name needed for Lot attributes code) --
1201: IF l_txn_header_rec.transaction_type_id = WSMPCNST.BONUS THEN
1202: l_st_lot_number := NULL;
1203: l_st_inv_item_id := NULL;
1204: ELSE
1205: l_stmt_num := 63;

Line 1206: IF l_txn_header_rec.transaction_type_id = WSMPCNST.MERGE THEN

1202: l_st_lot_number := NULL;
1203: l_st_inv_item_id := NULL;
1204: ELSE
1205: l_stmt_num := 63;
1206: IF l_txn_header_rec.transaction_type_id = WSMPCNST.MERGE THEN
1207: l_st_lot_number := l_starting_jobs_tbl(l_rep_job_index).wip_entity_name;
1208: l_st_inv_item_id := l_starting_jobs_tbl(l_rep_job_index).primary_item_id;
1209: ELSE
1210: l_rep_job_index := l_starting_jobs_tbl.first;

Line 1335: -- IF l_txn_header_rec.transaction_type_id = WSMPCNST.BONUS THEN

1331: l_txn_status_tbl(l_txn_counter) := wip_constants.completed;
1332: l_txn_header_tbl(l_txn_counter) := l_wsm_wtxn_hdr_tbl(l_txn_counter).header_id;
1333:
1334: -- ST : Commenting out the below code for bug 5233265
1335: -- IF l_txn_header_rec.transaction_type_id = WSMPCNST.BONUS THEN
1336: -- l_st_lot_number := NULL;
1337: -- l_st_inv_item_id := NULL;
1338: -- ELSE
1339: -- IF l_txn_header_rec.transaction_type_id = WSMPCNST.MERGE THEN

Line 1339: -- IF l_txn_header_rec.transaction_type_id = WSMPCNST.MERGE THEN

1335: -- IF l_txn_header_rec.transaction_type_id = WSMPCNST.BONUS THEN
1336: -- l_st_lot_number := NULL;
1337: -- l_st_inv_item_id := NULL;
1338: -- ELSE
1339: -- IF l_txn_header_rec.transaction_type_id = WSMPCNST.MERGE THEN
1340: -- l_st_lot_number := l_starting_jobs_tbl(l_rep_job_index).wip_entity_name;
1341: -- l_st_inv_item_id := l_starting_jobs_tbl(l_rep_job_index).primary_item_id;
1342: -- ELSE
1343: -- l_rep_job_index := l_starting_jobs_tbl.first;