35: TYPE trans_rec_typ IS RECORD
36: ( trans_type NUMBER(2)
37: , item_no ic_item_mst.item_no%TYPE
38: , journal_no ic_jrnl_mst.journal_no%TYPE
39: , from_whse_code ic_tran_cmp.whse_code%TYPE
40: , to_whse_code ic_tran_cmp.whse_code%TYPE DEFAULT NULL
41: , item_um ic_item_mst.item_um%TYPE DEFAULT NULL
42: , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL
43: , lot_no ic_lots_mst.lot_no%TYPE DEFAULT NULL
36: ( trans_type NUMBER(2)
37: , item_no ic_item_mst.item_no%TYPE
38: , journal_no ic_jrnl_mst.journal_no%TYPE
39: , from_whse_code ic_tran_cmp.whse_code%TYPE
40: , to_whse_code ic_tran_cmp.whse_code%TYPE DEFAULT NULL
41: , item_um ic_item_mst.item_um%TYPE DEFAULT NULL
42: , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL
43: , lot_no ic_lots_mst.lot_no%TYPE DEFAULT NULL
44: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL
41: , item_um ic_item_mst.item_um%TYPE DEFAULT NULL
42: , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL
43: , lot_no ic_lots_mst.lot_no%TYPE DEFAULT NULL
44: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL
45: , from_location ic_tran_cmp.location%TYPE DEFAULT NULL
46: , to_location ic_tran_cmp.location%TYPE DEFAULT NULL
47: , trans_qty ic_tran_cmp.trans_qty%TYPE DEFAULT 0
48: , trans_qty2 ic_tran_cmp.trans_qty2%TYPE DEFAULT 0
49: , qc_grade ic_tran_cmp.qc_grade%TYPE DEFAULT NULL
42: , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL
43: , lot_no ic_lots_mst.lot_no%TYPE DEFAULT NULL
44: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL
45: , from_location ic_tran_cmp.location%TYPE DEFAULT NULL
46: , to_location ic_tran_cmp.location%TYPE DEFAULT NULL
47: , trans_qty ic_tran_cmp.trans_qty%TYPE DEFAULT 0
48: , trans_qty2 ic_tran_cmp.trans_qty2%TYPE DEFAULT 0
49: , qc_grade ic_tran_cmp.qc_grade%TYPE DEFAULT NULL
50: , lot_status ic_tran_cmp.lot_status%TYPE DEFAULT NULL
43: , lot_no ic_lots_mst.lot_no%TYPE DEFAULT NULL
44: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL
45: , from_location ic_tran_cmp.location%TYPE DEFAULT NULL
46: , to_location ic_tran_cmp.location%TYPE DEFAULT NULL
47: , trans_qty ic_tran_cmp.trans_qty%TYPE DEFAULT 0
48: , trans_qty2 ic_tran_cmp.trans_qty2%TYPE DEFAULT 0
49: , qc_grade ic_tran_cmp.qc_grade%TYPE DEFAULT NULL
50: , lot_status ic_tran_cmp.lot_status%TYPE DEFAULT NULL
51: , co_code ic_tran_cmp.co_code%TYPE
44: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL
45: , from_location ic_tran_cmp.location%TYPE DEFAULT NULL
46: , to_location ic_tran_cmp.location%TYPE DEFAULT NULL
47: , trans_qty ic_tran_cmp.trans_qty%TYPE DEFAULT 0
48: , trans_qty2 ic_tran_cmp.trans_qty2%TYPE DEFAULT 0
49: , qc_grade ic_tran_cmp.qc_grade%TYPE DEFAULT NULL
50: , lot_status ic_tran_cmp.lot_status%TYPE DEFAULT NULL
51: , co_code ic_tran_cmp.co_code%TYPE
52: , orgn_code ic_tran_cmp.orgn_code%TYPE
45: , from_location ic_tran_cmp.location%TYPE DEFAULT NULL
46: , to_location ic_tran_cmp.location%TYPE DEFAULT NULL
47: , trans_qty ic_tran_cmp.trans_qty%TYPE DEFAULT 0
48: , trans_qty2 ic_tran_cmp.trans_qty2%TYPE DEFAULT 0
49: , qc_grade ic_tran_cmp.qc_grade%TYPE DEFAULT NULL
50: , lot_status ic_tran_cmp.lot_status%TYPE DEFAULT NULL
51: , co_code ic_tran_cmp.co_code%TYPE
52: , orgn_code ic_tran_cmp.orgn_code%TYPE
53: , trans_date ic_tran_cmp.trans_date%TYPE DEFAULT SYSDATE
46: , to_location ic_tran_cmp.location%TYPE DEFAULT NULL
47: , trans_qty ic_tran_cmp.trans_qty%TYPE DEFAULT 0
48: , trans_qty2 ic_tran_cmp.trans_qty2%TYPE DEFAULT 0
49: , qc_grade ic_tran_cmp.qc_grade%TYPE DEFAULT NULL
50: , lot_status ic_tran_cmp.lot_status%TYPE DEFAULT NULL
51: , co_code ic_tran_cmp.co_code%TYPE
52: , orgn_code ic_tran_cmp.orgn_code%TYPE
53: , trans_date ic_tran_cmp.trans_date%TYPE DEFAULT SYSDATE
54: , reason_code ic_tran_cmp.reason_code%TYPE
47: , trans_qty ic_tran_cmp.trans_qty%TYPE DEFAULT 0
48: , trans_qty2 ic_tran_cmp.trans_qty2%TYPE DEFAULT 0
49: , qc_grade ic_tran_cmp.qc_grade%TYPE DEFAULT NULL
50: , lot_status ic_tran_cmp.lot_status%TYPE DEFAULT NULL
51: , co_code ic_tran_cmp.co_code%TYPE
52: , orgn_code ic_tran_cmp.orgn_code%TYPE
53: , trans_date ic_tran_cmp.trans_date%TYPE DEFAULT SYSDATE
54: , reason_code ic_tran_cmp.reason_code%TYPE
55: , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'
48: , trans_qty2 ic_tran_cmp.trans_qty2%TYPE DEFAULT 0
49: , qc_grade ic_tran_cmp.qc_grade%TYPE DEFAULT NULL
50: , lot_status ic_tran_cmp.lot_status%TYPE DEFAULT NULL
51: , co_code ic_tran_cmp.co_code%TYPE
52: , orgn_code ic_tran_cmp.orgn_code%TYPE
53: , trans_date ic_tran_cmp.trans_date%TYPE DEFAULT SYSDATE
54: , reason_code ic_tran_cmp.reason_code%TYPE
55: , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'
56: );
49: , qc_grade ic_tran_cmp.qc_grade%TYPE DEFAULT NULL
50: , lot_status ic_tran_cmp.lot_status%TYPE DEFAULT NULL
51: , co_code ic_tran_cmp.co_code%TYPE
52: , orgn_code ic_tran_cmp.orgn_code%TYPE
53: , trans_date ic_tran_cmp.trans_date%TYPE DEFAULT SYSDATE
54: , reason_code ic_tran_cmp.reason_code%TYPE
55: , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'
56: );
57: --
50: , lot_status ic_tran_cmp.lot_status%TYPE DEFAULT NULL
51: , co_code ic_tran_cmp.co_code%TYPE
52: , orgn_code ic_tran_cmp.orgn_code%TYPE
53: , trans_date ic_tran_cmp.trans_date%TYPE DEFAULT SYSDATE
54: , reason_code ic_tran_cmp.reason_code%TYPE
55: , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'
56: );
57: --
58: PROCEDURE Inventory_Posting