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.WSMPJUPD dependencies on WSM_WIP_LOT_TXN_PVT

Line 56: Procedure process_mes_info ( p_secondary_qty_tbl IN WSM_WIP_LOT_TXN_PVT.WSM_JOB_SECONDARY_QTY_TBL_TYPE,

52: type t_wsm_copy_requirement_ops_tbl is table of wsm_copy_requirement_ops%rowtype index by binary_integer;
53: -- End MES copy tables changes
54:
55: -- start...
56: Procedure process_mes_info ( p_secondary_qty_tbl IN WSM_WIP_LOT_TXN_PVT.WSM_JOB_SECONDARY_QTY_TBL_TYPE,
57: p_wltx_header IN WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,
58: p_wltx_starting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,
59: p_wltx_resulting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,
60: p_sj_also_rj_index IN NUMBER,

Line 57: p_wltx_header IN WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,

53: -- End MES copy tables changes
54:
55: -- start...
56: Procedure process_mes_info ( p_secondary_qty_tbl IN WSM_WIP_LOT_TXN_PVT.WSM_JOB_SECONDARY_QTY_TBL_TYPE,
57: p_wltx_header IN WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,
58: p_wltx_starting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,
59: p_wltx_resulting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,
60: p_sj_also_rj_index IN NUMBER,
61: p_rep_job_index IN NUMBER,

Line 58: p_wltx_starting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,

54:
55: -- start...
56: Procedure process_mes_info ( p_secondary_qty_tbl IN WSM_WIP_LOT_TXN_PVT.WSM_JOB_SECONDARY_QTY_TBL_TYPE,
57: p_wltx_header IN WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,
58: p_wltx_starting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,
59: p_wltx_resulting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,
60: p_sj_also_rj_index IN NUMBER,
61: p_rep_job_index IN NUMBER,
62: x_return_status OUT NOCOPY VARCHAR2,

Line 59: p_wltx_resulting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,

55: -- start...
56: Procedure process_mes_info ( p_secondary_qty_tbl IN WSM_WIP_LOT_TXN_PVT.WSM_JOB_SECONDARY_QTY_TBL_TYPE,
57: p_wltx_header IN WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,
58: p_wltx_starting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,
59: p_wltx_resulting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,
60: p_sj_also_rj_index IN NUMBER,
61: p_rep_job_index IN NUMBER,
62: x_return_status OUT NOCOPY VARCHAR2,
63: x_msg_count OUT NOCOPY NUMBER,

Line 72: -- l_sj_rj_sec_qty_tbl WSM_WIP_LOT_TXN_PVT.wsm_job_secondary_qty_tbl_type;

68: l_sj_rj_wip_entity_id NUMBER ;
69: l_sj_rj_wip_entity_name VARCHAR2(2000) ;
70: l_sj_rj_inventory_item_id NUMBER ;
71:
72: -- l_sj_rj_sec_qty_tbl WSM_WIP_LOT_TXN_PVT.wsm_job_secondary_qty_tbl_type;
73:
74: l_sj_we_id_tbl t_we_id_tbl ;
75: l_sj_rj_sec_qty_exists NUMBER;
76:

Line 758: PROCEDURE copy_wsm_op_reason_codes ( p_wltx_header IN WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,

754: END;
755:
756: /************** Commenting out due to few discrepancies in the code...
757: Reason code information is handled if the process_mes_info
758: PROCEDURE copy_wsm_op_reason_codes ( p_wltx_header IN WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,
759: p_wltx_starting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,
760: p_wltx_resulting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,
761: p_rep_job_index IN NUMBER,
762: p_sj_also_rj_index IN NUMBER,

Line 759: p_wltx_starting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,

755:
756: /************** Commenting out due to few discrepancies in the code...
757: Reason code information is handled if the process_mes_info
758: PROCEDURE copy_wsm_op_reason_codes ( p_wltx_header IN WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,
759: p_wltx_starting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,
760: p_wltx_resulting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,
761: p_rep_job_index IN NUMBER,
762: p_sj_also_rj_index IN NUMBER,
763: x_return_status OUT NOCOPY VARCHAR2,

Line 760: p_wltx_resulting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,

756: /************** Commenting out due to few discrepancies in the code...
757: Reason code information is handled if the process_mes_info
758: PROCEDURE copy_wsm_op_reason_codes ( p_wltx_header IN WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,
759: p_wltx_starting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,
760: p_wltx_resulting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,
761: p_rep_job_index IN NUMBER,
762: p_sj_also_rj_index IN NUMBER,
763: x_return_status OUT NOCOPY VARCHAR2,
764: x_msg_count OUT NOCOPY NUMBER,

Line 939: PROCEDURE copy_wsm_substitute_components ( p_wltx_header IN WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,

935: );
936: END ;
937: *************************************************************/
938: /*** Commenting out : Descoped..
939: PROCEDURE copy_wsm_substitute_components ( p_wltx_header IN WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,
940: p_wltx_starting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,
941: p_wltx_resulting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,
942: p_rep_job_index IN NUMBER,
943: x_return_status OUT NOCOPY VARCHAR2,

Line 940: p_wltx_starting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,

936: END ;
937: *************************************************************/
938: /*** Commenting out : Descoped..
939: PROCEDURE copy_wsm_substitute_components ( p_wltx_header IN WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,
940: p_wltx_starting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,
941: p_wltx_resulting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,
942: p_rep_job_index IN NUMBER,
943: x_return_status OUT NOCOPY VARCHAR2,
944: x_msg_count OUT NOCOPY NUMBER,

Line 941: p_wltx_resulting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,

937: *************************************************************/
938: /*** Commenting out : Descoped..
939: PROCEDURE copy_wsm_substitute_components ( p_wltx_header IN WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,
940: p_wltx_starting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,
941: p_wltx_resulting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,
942: p_rep_job_index IN NUMBER,
943: x_return_status OUT NOCOPY VARCHAR2,
944: x_msg_count OUT NOCOPY NUMBER,
945: x_error_msg OUT NOCOPY VARCHAR2)

Line 2956: p_rj_job_rec IN WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_REC_TYPE,

2952:
2953: PROCEDURE CHANGE_ROUTING (p_txn_id IN NUMBER,
2954: p_wip_entity_id IN NUMBER,
2955: p_org_id IN NUMBER,
2956: p_rj_job_rec IN WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_REC_TYPE,
2957: p_new_op_added OUT NOCOPY NUMBER,
2958: x_err_code OUT NOCOPY NUMBER,
2959: x_err_buf OUT NOCOPY VARCHAR2)
2960: IS

Line 3448: p_rj_job_rec IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_REC_TYPE,

3444: p_po_creation_time IN NUMBER, --osp
3445: p_request_id IN NUMBER, --osp
3446: p_sj_compl_subinventory IN VARCHAR2,
3447: p_sj_compl_locator_id IN NUMBER,
3448: p_rj_job_rec IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_REC_TYPE,
3449: x_err_code OUT NOCOPY NUMBER,
3450: x_err_buf OUT NOCOPY VARCHAR2,
3451: x_msg_count OUT NOCOPY NUMBER)
3452:

Line 3992: p_wltx_starting_jobs_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,

3988: p_txn_type_id IN NUMBER,
3989: p_copy_mode IN NUMBER,
3990: p_rep_sj_index IN NUMBER,
3991: p_sj_as_rj_index IN NUMBER,
3992: p_wltx_starting_jobs_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,
3993: p_wltx_resulting_jobs_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,
3994: x_err_code OUT NOCOPY NUMBER,
3995: x_err_buf OUT NOCOPY VARCHAR2,
3996: x_msg_count OUT NOCOPY NUMBER)

Line 3993: p_wltx_resulting_jobs_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,

3989: p_copy_mode IN NUMBER,
3990: p_rep_sj_index IN NUMBER,
3991: p_sj_as_rj_index IN NUMBER,
3992: p_wltx_starting_jobs_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,
3993: p_wltx_resulting_jobs_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,
3994: x_err_code OUT NOCOPY NUMBER,
3995: x_err_buf OUT NOCOPY VARCHAR2,
3996: x_msg_count OUT NOCOPY NUMBER)
3997: IS

Line 4766: p_wltx_header IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,

4762:
4763: PROCEDURE PROCESS_LOTS (p_copy_qa IN VARCHAR2,
4764: p_txn_org_id IN NUMBER,
4765: p_rep_job_index IN NUMBER,
4766: p_wltx_header IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,
4767: p_wltx_starting_jobs_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,
4768: p_wltx_resulting_jobs_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,
4769: p_secondary_qty_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WSM_JOB_SECONDARY_QTY_TBL_TYPE ,
4770: -- p_txn_id OUT NOCOPY NUMBER, /* i dont think this is needed,,,, */

Line 4767: p_wltx_starting_jobs_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,

4763: PROCEDURE PROCESS_LOTS (p_copy_qa IN VARCHAR2,
4764: p_txn_org_id IN NUMBER,
4765: p_rep_job_index IN NUMBER,
4766: p_wltx_header IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,
4767: p_wltx_starting_jobs_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,
4768: p_wltx_resulting_jobs_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,
4769: p_secondary_qty_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WSM_JOB_SECONDARY_QTY_TBL_TYPE ,
4770: -- p_txn_id OUT NOCOPY NUMBER, /* i dont think this is needed,,,, */
4771: x_return_status OUT NOCOPY VARCHAR2,

Line 4768: p_wltx_resulting_jobs_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,

4764: p_txn_org_id IN NUMBER,
4765: p_rep_job_index IN NUMBER,
4766: p_wltx_header IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,
4767: p_wltx_starting_jobs_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,
4768: p_wltx_resulting_jobs_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,
4769: p_secondary_qty_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WSM_JOB_SECONDARY_QTY_TBL_TYPE ,
4770: -- p_txn_id OUT NOCOPY NUMBER, /* i dont think this is needed,,,, */
4771: x_return_status OUT NOCOPY VARCHAR2,
4772: x_msg_count OUT NOCOPY NUMBER,

Line 4769: p_secondary_qty_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WSM_JOB_SECONDARY_QTY_TBL_TYPE ,

4765: p_rep_job_index IN NUMBER,
4766: p_wltx_header IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,
4767: p_wltx_starting_jobs_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,
4768: p_wltx_resulting_jobs_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,
4769: p_secondary_qty_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WSM_JOB_SECONDARY_QTY_TBL_TYPE ,
4770: -- p_txn_id OUT NOCOPY NUMBER, /* i dont think this is needed,,,, */
4771: x_return_status OUT NOCOPY VARCHAR2,
4772: x_msg_count OUT NOCOPY NUMBER,
4773: x_error_msg OUT NOCOPY VARCHAR2

Line 4856: WSM_WIP_LOT_TXN_PVT.Log_transaction_data ( p_txn_header_rec => p_wltx_header ,

4852: x_return_status := g_ret_success;
4853:
4854: if( g_log_level_statement >= l_log_level ) then
4855: -- Log the transaction data...
4856: WSM_WIP_LOT_TXN_PVT.Log_transaction_data ( p_txn_header_rec => p_wltx_header ,
4857: p_starting_jobs_tbl => p_wltx_starting_jobs_tbl ,
4858: p_resulting_jobs_tbl => p_wltx_resulting_jobs_tbl ,
4859: p_secondary_qty_tbl => p_secondary_qty_tbl ,
4860: x_return_status => x_return_status ,