DBA Data[Home] [Help]

APPS.GMI_OM_ALLOC_API_PUB dependencies on IC_TRAN_PND

Line 16: trans_id IC_TRAN_PND.TRANS_ID%TYPE

12: * @rep:category BUSINESS_ENTITY GMI_OM_ALLOC_API_PUB
13: */
14:
15: TYPE Ic_Tran_Rec_Type IS RECORD (
16: trans_id IC_TRAN_PND.TRANS_ID%TYPE
17: ,line_id IC_TRAN_PND.LINE_ID%TYPE
18: ,lot_id IC_LOTS_MST.LOT_ID%TYPE
19: ,lot_no IC_LOTS_MST.LOT_NO%TYPE
20: ,sublot_no IC_LOTS_MST.SUBLOT_NO%TYPE

Line 17: ,line_id IC_TRAN_PND.LINE_ID%TYPE

13: */
14:
15: TYPE Ic_Tran_Rec_Type IS RECORD (
16: trans_id IC_TRAN_PND.TRANS_ID%TYPE
17: ,line_id IC_TRAN_PND.LINE_ID%TYPE
18: ,lot_id IC_LOTS_MST.LOT_ID%TYPE
19: ,lot_no IC_LOTS_MST.LOT_NO%TYPE
20: ,sublot_no IC_LOTS_MST.SUBLOT_NO%TYPE
21: ,location VARCHAR2(50)

Line 22: ,trans_qty IC_TRAN_PND.TRANS_QTY%TYPE

18: ,lot_id IC_LOTS_MST.LOT_ID%TYPE
19: ,lot_no IC_LOTS_MST.LOT_NO%TYPE
20: ,sublot_no IC_LOTS_MST.SUBLOT_NO%TYPE
21: ,location VARCHAR2(50)
22: ,trans_qty IC_TRAN_PND.TRANS_QTY%TYPE
23: ,trans_qty2 IC_TRAN_PND.TRANS_QTY2%TYPE
24: ,trans_um IC_TRAN_PND.TRANS_UM%TYPE
25: ,reason_code SY_REAS_CDS.REASON_CODE%TYPE
26: ,trans_date DATE

Line 23: ,trans_qty2 IC_TRAN_PND.TRANS_QTY2%TYPE

19: ,lot_no IC_LOTS_MST.LOT_NO%TYPE
20: ,sublot_no IC_LOTS_MST.SUBLOT_NO%TYPE
21: ,location VARCHAR2(50)
22: ,trans_qty IC_TRAN_PND.TRANS_QTY%TYPE
23: ,trans_qty2 IC_TRAN_PND.TRANS_QTY2%TYPE
24: ,trans_um IC_TRAN_PND.TRANS_UM%TYPE
25: ,reason_code SY_REAS_CDS.REASON_CODE%TYPE
26: ,trans_date DATE
27: ,line_detail_id IC_TRAN_PND.LINE_DETAIL_ID%TYPE

Line 24: ,trans_um IC_TRAN_PND.TRANS_UM%TYPE

20: ,sublot_no IC_LOTS_MST.SUBLOT_NO%TYPE
21: ,location VARCHAR2(50)
22: ,trans_qty IC_TRAN_PND.TRANS_QTY%TYPE
23: ,trans_qty2 IC_TRAN_PND.TRANS_QTY2%TYPE
24: ,trans_um IC_TRAN_PND.TRANS_UM%TYPE
25: ,reason_code SY_REAS_CDS.REASON_CODE%TYPE
26: ,trans_date DATE
27: ,line_detail_id IC_TRAN_PND.LINE_DETAIL_ID%TYPE
28: ,action_code VARCHAR2(10));

Line 27: ,line_detail_id IC_TRAN_PND.LINE_DETAIL_ID%TYPE

23: ,trans_qty2 IC_TRAN_PND.TRANS_QTY2%TYPE
24: ,trans_um IC_TRAN_PND.TRANS_UM%TYPE
25: ,reason_code SY_REAS_CDS.REASON_CODE%TYPE
26: ,trans_date DATE
27: ,line_detail_id IC_TRAN_PND.LINE_DETAIL_ID%TYPE
28: ,action_code VARCHAR2(10));
29:
30:
31: /* ========================================================================

Line 43: | COMMENT : Creates,updates or deletes an opm reservation (allocation) in ic_tran_pnd

39: | x_return_status return status
40: |
41: | VERSION : current version 1.0
42: | initial version 1.0
43: | COMMENT : Creates,updates or deletes an opm reservation (allocation) in ic_tran_pnd
44: | table with information specified in p_tran_rec.
45: |
46: | ======================================================================== */
47:

Line 50: * This API creates, updates or deletes an opm allocation in the ic_tran_pnd

46: | ======================================================================== */
47:
48: /*#
49: * Allocate OPM Orders API
50: * This API creates, updates or deletes an opm allocation in the ic_tran_pnd
51: * table with information specified in p_tran_rec.
52: * @param p_api_version Version Number of the API
53: * @param p_init_msg_list Flag for initializing message list (default 'F')
54: * @param p_commit Flag for commiting the data or not (default 'F')