DBA Data[Home] [Help]

APPS.GMI_CMP_TRAN_PVT dependencies on IC_TRAN_CMP

Line 34: ( item_id IC_TRAN_CMP.item_id%TYPE

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

Line 35: , line_id IC_TRAN_CMP.line_id%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

Line 36: , trans_id IC_TRAN_CMP.trans_id%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

Line 37: , co_code IC_TRAN_CMP.co_code%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

Line 38: , orgn_code IC_TRAN_CMP.orgn_code%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

Line 39: , whse_code IC_TRAN_CMP.whse_code%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

Line 40: , lot_id IC_TRAN_CMP.lot_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
44: , doc_line IC_TRAN_CMP.doc_line%TYPE

Line 41: , location IC_TRAN_CMP.location%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

Line 42: , doc_id IC_TRAN_CMP.doc_id%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

Line 43: , doc_type IC_TRAN_CMP.doc_type%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

Line 44: , doc_line IC_TRAN_CMP.doc_line%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

Line 45: , line_type IC_TRAN_CMP.line_type%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

Line 46: , reason_code IC_TRAN_CMP.reason_code%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

Line 47: , creation_date IC_TRAN_CMP.creation_date%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

Line 48: , trans_date IC_TRAN_CMP.trans_date%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

Line 49: , trans_qty IC_TRAN_CMP.trans_qty%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

Line 50: , trans_qty2 IC_TRAN_CMP.trans_qty2%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

Line 51: , qc_grade IC_TRAN_CMP.qc_grade%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

Line 52: , lot_status IC_TRAN_CMP.lot_status%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

Line 53: , trans_stat IC_TRAN_CMP.trans_stat%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

Line 54: , trans_um IC_TRAN_CMP.trans_um%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

Line 55: , trans_um2 IC_TRAN_CMP.trans_um2%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

Line 57: , gl_posted_ind IC_TRAN_CMP.gl_posted_ind%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: --

Line 58: , event_id IC_TRAN_CMP.event_id%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: --
62: FUNCTION Update_Quantity_Transaction

Line 59: , text_code IC_TRAN_CMP.text_code%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
63: ( p_cmp_tran_rec IN cmp_tran_typ

Line 82: FUNCTION Insert_ic_tran_cmp

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: --