30: -- Notes
31: --
32: -- API specific parameters to be presented in SQL RECORD format
33: TYPE cmp_tran_typ IS RECORD
34: ( item_id IC_TRAN_CMP.item_id%TYPE
35: , line_id IC_TRAN_CMP.line_id%TYPE
36: , trans_id IC_TRAN_CMP.trans_id%TYPE
37: , co_code IC_TRAN_CMP.co_code%TYPE
38: , orgn_code IC_TRAN_CMP.orgn_code%TYPE
31: --
32: -- API specific parameters to be presented in SQL RECORD format
33: TYPE cmp_tran_typ IS RECORD
34: ( item_id IC_TRAN_CMP.item_id%TYPE
35: , line_id IC_TRAN_CMP.line_id%TYPE
36: , trans_id IC_TRAN_CMP.trans_id%TYPE
37: , co_code IC_TRAN_CMP.co_code%TYPE
38: , orgn_code IC_TRAN_CMP.orgn_code%TYPE
39: , whse_code IC_TRAN_CMP.whse_code%TYPE
32: -- API specific parameters to be presented in SQL RECORD format
33: TYPE cmp_tran_typ IS RECORD
34: ( item_id IC_TRAN_CMP.item_id%TYPE
35: , line_id IC_TRAN_CMP.line_id%TYPE
36: , trans_id IC_TRAN_CMP.trans_id%TYPE
37: , co_code IC_TRAN_CMP.co_code%TYPE
38: , orgn_code IC_TRAN_CMP.orgn_code%TYPE
39: , whse_code IC_TRAN_CMP.whse_code%TYPE
40: , lot_id IC_TRAN_CMP.lot_id%TYPE
33: TYPE cmp_tran_typ IS RECORD
34: ( item_id IC_TRAN_CMP.item_id%TYPE
35: , line_id IC_TRAN_CMP.line_id%TYPE
36: , trans_id IC_TRAN_CMP.trans_id%TYPE
37: , co_code IC_TRAN_CMP.co_code%TYPE
38: , orgn_code IC_TRAN_CMP.orgn_code%TYPE
39: , whse_code IC_TRAN_CMP.whse_code%TYPE
40: , lot_id IC_TRAN_CMP.lot_id%TYPE
41: , location IC_TRAN_CMP.location%TYPE
34: ( item_id IC_TRAN_CMP.item_id%TYPE
35: , line_id IC_TRAN_CMP.line_id%TYPE
36: , trans_id IC_TRAN_CMP.trans_id%TYPE
37: , co_code IC_TRAN_CMP.co_code%TYPE
38: , orgn_code IC_TRAN_CMP.orgn_code%TYPE
39: , whse_code IC_TRAN_CMP.whse_code%TYPE
40: , lot_id IC_TRAN_CMP.lot_id%TYPE
41: , location IC_TRAN_CMP.location%TYPE
42: , doc_id IC_TRAN_CMP.doc_id%TYPE
35: , line_id IC_TRAN_CMP.line_id%TYPE
36: , trans_id IC_TRAN_CMP.trans_id%TYPE
37: , co_code IC_TRAN_CMP.co_code%TYPE
38: , orgn_code IC_TRAN_CMP.orgn_code%TYPE
39: , whse_code IC_TRAN_CMP.whse_code%TYPE
40: , lot_id IC_TRAN_CMP.lot_id%TYPE
41: , location IC_TRAN_CMP.location%TYPE
42: , doc_id IC_TRAN_CMP.doc_id%TYPE
43: , doc_type IC_TRAN_CMP.doc_type%TYPE
36: , trans_id IC_TRAN_CMP.trans_id%TYPE
37: , co_code IC_TRAN_CMP.co_code%TYPE
38: , orgn_code IC_TRAN_CMP.orgn_code%TYPE
39: , whse_code IC_TRAN_CMP.whse_code%TYPE
40: , lot_id IC_TRAN_CMP.lot_id%TYPE
41: , location IC_TRAN_CMP.location%TYPE
42: , doc_id IC_TRAN_CMP.doc_id%TYPE
43: , doc_type IC_TRAN_CMP.doc_type%TYPE
44: , doc_line IC_TRAN_CMP.doc_line%TYPE
37: , co_code IC_TRAN_CMP.co_code%TYPE
38: , orgn_code IC_TRAN_CMP.orgn_code%TYPE
39: , whse_code IC_TRAN_CMP.whse_code%TYPE
40: , lot_id IC_TRAN_CMP.lot_id%TYPE
41: , location IC_TRAN_CMP.location%TYPE
42: , doc_id IC_TRAN_CMP.doc_id%TYPE
43: , doc_type IC_TRAN_CMP.doc_type%TYPE
44: , doc_line IC_TRAN_CMP.doc_line%TYPE
45: , line_type IC_TRAN_CMP.line_type%TYPE
38: , orgn_code IC_TRAN_CMP.orgn_code%TYPE
39: , whse_code IC_TRAN_CMP.whse_code%TYPE
40: , lot_id IC_TRAN_CMP.lot_id%TYPE
41: , location IC_TRAN_CMP.location%TYPE
42: , doc_id IC_TRAN_CMP.doc_id%TYPE
43: , doc_type IC_TRAN_CMP.doc_type%TYPE
44: , doc_line IC_TRAN_CMP.doc_line%TYPE
45: , line_type IC_TRAN_CMP.line_type%TYPE
46: , reason_code IC_TRAN_CMP.reason_code%TYPE
39: , whse_code IC_TRAN_CMP.whse_code%TYPE
40: , lot_id IC_TRAN_CMP.lot_id%TYPE
41: , location IC_TRAN_CMP.location%TYPE
42: , doc_id IC_TRAN_CMP.doc_id%TYPE
43: , doc_type IC_TRAN_CMP.doc_type%TYPE
44: , doc_line IC_TRAN_CMP.doc_line%TYPE
45: , line_type IC_TRAN_CMP.line_type%TYPE
46: , reason_code IC_TRAN_CMP.reason_code%TYPE
47: , creation_date IC_TRAN_CMP.creation_date%TYPE
40: , lot_id IC_TRAN_CMP.lot_id%TYPE
41: , location IC_TRAN_CMP.location%TYPE
42: , doc_id IC_TRAN_CMP.doc_id%TYPE
43: , doc_type IC_TRAN_CMP.doc_type%TYPE
44: , doc_line IC_TRAN_CMP.doc_line%TYPE
45: , line_type IC_TRAN_CMP.line_type%TYPE
46: , reason_code IC_TRAN_CMP.reason_code%TYPE
47: , creation_date IC_TRAN_CMP.creation_date%TYPE
48: , trans_date IC_TRAN_CMP.trans_date%TYPE
41: , location IC_TRAN_CMP.location%TYPE
42: , doc_id IC_TRAN_CMP.doc_id%TYPE
43: , doc_type IC_TRAN_CMP.doc_type%TYPE
44: , doc_line IC_TRAN_CMP.doc_line%TYPE
45: , line_type IC_TRAN_CMP.line_type%TYPE
46: , reason_code IC_TRAN_CMP.reason_code%TYPE
47: , creation_date IC_TRAN_CMP.creation_date%TYPE
48: , trans_date IC_TRAN_CMP.trans_date%TYPE
49: , trans_qty IC_TRAN_CMP.trans_qty%TYPE
42: , doc_id IC_TRAN_CMP.doc_id%TYPE
43: , doc_type IC_TRAN_CMP.doc_type%TYPE
44: , doc_line IC_TRAN_CMP.doc_line%TYPE
45: , line_type IC_TRAN_CMP.line_type%TYPE
46: , reason_code IC_TRAN_CMP.reason_code%TYPE
47: , creation_date IC_TRAN_CMP.creation_date%TYPE
48: , trans_date IC_TRAN_CMP.trans_date%TYPE
49: , trans_qty IC_TRAN_CMP.trans_qty%TYPE
50: , trans_qty2 IC_TRAN_CMP.trans_qty2%TYPE
43: , doc_type IC_TRAN_CMP.doc_type%TYPE
44: , doc_line IC_TRAN_CMP.doc_line%TYPE
45: , line_type IC_TRAN_CMP.line_type%TYPE
46: , reason_code IC_TRAN_CMP.reason_code%TYPE
47: , creation_date IC_TRAN_CMP.creation_date%TYPE
48: , trans_date IC_TRAN_CMP.trans_date%TYPE
49: , trans_qty IC_TRAN_CMP.trans_qty%TYPE
50: , trans_qty2 IC_TRAN_CMP.trans_qty2%TYPE
51: , qc_grade IC_TRAN_CMP.qc_grade%TYPE
44: , doc_line IC_TRAN_CMP.doc_line%TYPE
45: , line_type IC_TRAN_CMP.line_type%TYPE
46: , reason_code IC_TRAN_CMP.reason_code%TYPE
47: , creation_date IC_TRAN_CMP.creation_date%TYPE
48: , trans_date IC_TRAN_CMP.trans_date%TYPE
49: , trans_qty IC_TRAN_CMP.trans_qty%TYPE
50: , trans_qty2 IC_TRAN_CMP.trans_qty2%TYPE
51: , qc_grade IC_TRAN_CMP.qc_grade%TYPE
52: , lot_status IC_TRAN_CMP.lot_status%TYPE
45: , line_type IC_TRAN_CMP.line_type%TYPE
46: , reason_code IC_TRAN_CMP.reason_code%TYPE
47: , creation_date IC_TRAN_CMP.creation_date%TYPE
48: , trans_date IC_TRAN_CMP.trans_date%TYPE
49: , trans_qty IC_TRAN_CMP.trans_qty%TYPE
50: , trans_qty2 IC_TRAN_CMP.trans_qty2%TYPE
51: , qc_grade IC_TRAN_CMP.qc_grade%TYPE
52: , lot_status IC_TRAN_CMP.lot_status%TYPE
53: , trans_stat IC_TRAN_CMP.trans_stat%TYPE
46: , reason_code IC_TRAN_CMP.reason_code%TYPE
47: , creation_date IC_TRAN_CMP.creation_date%TYPE
48: , trans_date IC_TRAN_CMP.trans_date%TYPE
49: , trans_qty IC_TRAN_CMP.trans_qty%TYPE
50: , trans_qty2 IC_TRAN_CMP.trans_qty2%TYPE
51: , qc_grade IC_TRAN_CMP.qc_grade%TYPE
52: , lot_status IC_TRAN_CMP.lot_status%TYPE
53: , trans_stat IC_TRAN_CMP.trans_stat%TYPE
54: , trans_um IC_TRAN_CMP.trans_um%TYPE
47: , creation_date IC_TRAN_CMP.creation_date%TYPE
48: , trans_date IC_TRAN_CMP.trans_date%TYPE
49: , trans_qty IC_TRAN_CMP.trans_qty%TYPE
50: , trans_qty2 IC_TRAN_CMP.trans_qty2%TYPE
51: , qc_grade IC_TRAN_CMP.qc_grade%TYPE
52: , lot_status IC_TRAN_CMP.lot_status%TYPE
53: , trans_stat IC_TRAN_CMP.trans_stat%TYPE
54: , trans_um IC_TRAN_CMP.trans_um%TYPE
55: , trans_um2 IC_TRAN_CMP.trans_um2%TYPE
48: , trans_date IC_TRAN_CMP.trans_date%TYPE
49: , trans_qty IC_TRAN_CMP.trans_qty%TYPE
50: , trans_qty2 IC_TRAN_CMP.trans_qty2%TYPE
51: , qc_grade IC_TRAN_CMP.qc_grade%TYPE
52: , lot_status IC_TRAN_CMP.lot_status%TYPE
53: , trans_stat IC_TRAN_CMP.trans_stat%TYPE
54: , trans_um IC_TRAN_CMP.trans_um%TYPE
55: , trans_um2 IC_TRAN_CMP.trans_um2%TYPE
56: , user_id FND_USER.user_id%TYPE
49: , trans_qty IC_TRAN_CMP.trans_qty%TYPE
50: , trans_qty2 IC_TRAN_CMP.trans_qty2%TYPE
51: , qc_grade IC_TRAN_CMP.qc_grade%TYPE
52: , lot_status IC_TRAN_CMP.lot_status%TYPE
53: , trans_stat IC_TRAN_CMP.trans_stat%TYPE
54: , trans_um IC_TRAN_CMP.trans_um%TYPE
55: , trans_um2 IC_TRAN_CMP.trans_um2%TYPE
56: , user_id FND_USER.user_id%TYPE
57: , gl_posted_ind IC_TRAN_CMP.gl_posted_ind%TYPE
50: , trans_qty2 IC_TRAN_CMP.trans_qty2%TYPE
51: , qc_grade IC_TRAN_CMP.qc_grade%TYPE
52: , lot_status IC_TRAN_CMP.lot_status%TYPE
53: , trans_stat IC_TRAN_CMP.trans_stat%TYPE
54: , trans_um IC_TRAN_CMP.trans_um%TYPE
55: , trans_um2 IC_TRAN_CMP.trans_um2%TYPE
56: , user_id FND_USER.user_id%TYPE
57: , gl_posted_ind IC_TRAN_CMP.gl_posted_ind%TYPE
58: , event_id IC_TRAN_CMP.event_id%TYPE
51: , qc_grade IC_TRAN_CMP.qc_grade%TYPE
52: , lot_status IC_TRAN_CMP.lot_status%TYPE
53: , trans_stat IC_TRAN_CMP.trans_stat%TYPE
54: , trans_um IC_TRAN_CMP.trans_um%TYPE
55: , trans_um2 IC_TRAN_CMP.trans_um2%TYPE
56: , user_id FND_USER.user_id%TYPE
57: , gl_posted_ind IC_TRAN_CMP.gl_posted_ind%TYPE
58: , event_id IC_TRAN_CMP.event_id%TYPE
59: , text_code IC_TRAN_CMP.text_code%TYPE
53: , trans_stat IC_TRAN_CMP.trans_stat%TYPE
54: , trans_um IC_TRAN_CMP.trans_um%TYPE
55: , trans_um2 IC_TRAN_CMP.trans_um2%TYPE
56: , user_id FND_USER.user_id%TYPE
57: , gl_posted_ind IC_TRAN_CMP.gl_posted_ind%TYPE
58: , event_id IC_TRAN_CMP.event_id%TYPE
59: , text_code IC_TRAN_CMP.text_code%TYPE
60: );
61: --
54: , trans_um IC_TRAN_CMP.trans_um%TYPE
55: , trans_um2 IC_TRAN_CMP.trans_um2%TYPE
56: , user_id FND_USER.user_id%TYPE
57: , gl_posted_ind IC_TRAN_CMP.gl_posted_ind%TYPE
58: , event_id IC_TRAN_CMP.event_id%TYPE
59: , text_code IC_TRAN_CMP.text_code%TYPE
60: );
61: --
62: FUNCTION Update_Quantity_Transaction
55: , trans_um2 IC_TRAN_CMP.trans_um2%TYPE
56: , user_id FND_USER.user_id%TYPE
57: , gl_posted_ind IC_TRAN_CMP.gl_posted_ind%TYPE
58: , event_id IC_TRAN_CMP.event_id%TYPE
59: , text_code IC_TRAN_CMP.text_code%TYPE
60: );
61: --
62: FUNCTION Update_Quantity_Transaction
63: ( p_cmp_tran_rec IN cmp_tran_typ
78: ( p_cmp_tran_rec IN cmp_tran_typ
79: )
80: RETURN BOOLEAN;
81: --
82: FUNCTION Insert_ic_tran_cmp
83: ( p_cmp_tran_rec IN cmp_tran_typ
84: )
85: RETURN BOOLEAN;
86: --