DBA Data[Home] [Help]

APPS.IGC_CC_MC_HEADER_HST_PKG dependencies on IGC_CC_MC_HEADER_HISTORY

Line 20: p_CC_Header_Id IGC_CC_MC_HEADER_HISTORY.CC_Header_Id%TYPE,

16: X_return_status OUT NOCOPY VARCHAR2,
17: X_msg_count OUT NOCOPY NUMBER,
18: X_msg_data OUT NOCOPY VARCHAR2,
19: p_Rowid IN OUT NOCOPY VARCHAR2,
20: p_CC_Header_Id IGC_CC_MC_HEADER_HISTORY.CC_Header_Id%TYPE,
21: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
22: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
23: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
24: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,

Line 21: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,

17: X_msg_count OUT NOCOPY NUMBER,
18: X_msg_data OUT NOCOPY VARCHAR2,
19: p_Rowid IN OUT NOCOPY VARCHAR2,
20: p_CC_Header_Id IGC_CC_MC_HEADER_HISTORY.CC_Header_Id%TYPE,
21: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
22: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
23: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
24: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
25: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,

Line 22: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,

18: X_msg_data OUT NOCOPY VARCHAR2,
19: p_Rowid IN OUT NOCOPY VARCHAR2,
20: p_CC_Header_Id IGC_CC_MC_HEADER_HISTORY.CC_Header_Id%TYPE,
21: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
22: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
23: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
24: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
25: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,
26: p_Conversion_Rate IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE

Line 23: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,

19: p_Rowid IN OUT NOCOPY VARCHAR2,
20: p_CC_Header_Id IGC_CC_MC_HEADER_HISTORY.CC_Header_Id%TYPE,
21: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
22: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
23: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
24: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
25: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,
26: p_Conversion_Rate IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE
27: );

Line 24: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,

20: p_CC_Header_Id IGC_CC_MC_HEADER_HISTORY.CC_Header_Id%TYPE,
21: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
22: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
23: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
24: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
25: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,
26: p_Conversion_Rate IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE
27: );
28: /* =================================================================================

Line 25: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,

21: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
22: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
23: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
24: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
25: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,
26: p_Conversion_Rate IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE
27: );
28: /* =================================================================================
29: PROCEDURE Lock_Row

Line 26: p_Conversion_Rate IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE

22: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
23: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
24: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
25: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,
26: p_Conversion_Rate IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE
27: );
28: /* =================================================================================
29: PROCEDURE Lock_Row
30: ================================================================================*/

Line 40: p_CC_Header_Id IGC_CC_MC_HEADER_HISTORY.CC_Header_Id%TYPE,

36: X_return_status OUT NOCOPY VARCHAR2,
37: X_msg_count OUT NOCOPY NUMBER,
38: X_msg_data OUT NOCOPY VARCHAR2,
39: p_Rowid IN OUT NOCOPY VARCHAR2,
40: p_CC_Header_Id IGC_CC_MC_HEADER_HISTORY.CC_Header_Id%TYPE,
41: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
42: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
43: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
44: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,

Line 41: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,

37: X_msg_count OUT NOCOPY NUMBER,
38: X_msg_data OUT NOCOPY VARCHAR2,
39: p_Rowid IN OUT NOCOPY VARCHAR2,
40: p_CC_Header_Id IGC_CC_MC_HEADER_HISTORY.CC_Header_Id%TYPE,
41: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
42: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
43: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
44: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
45: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,

Line 42: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,

38: X_msg_data OUT NOCOPY VARCHAR2,
39: p_Rowid IN OUT NOCOPY VARCHAR2,
40: p_CC_Header_Id IGC_CC_MC_HEADER_HISTORY.CC_Header_Id%TYPE,
41: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
42: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
43: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
44: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
45: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,
46: p_Conversion_Rate IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE,

Line 43: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,

39: p_Rowid IN OUT NOCOPY VARCHAR2,
40: p_CC_Header_Id IGC_CC_MC_HEADER_HISTORY.CC_Header_Id%TYPE,
41: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
42: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
43: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
44: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
45: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,
46: p_Conversion_Rate IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE,
47: X_row_locked OUT NOCOPY VARCHAR2

Line 44: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,

40: p_CC_Header_Id IGC_CC_MC_HEADER_HISTORY.CC_Header_Id%TYPE,
41: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
42: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
43: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
44: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
45: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,
46: p_Conversion_Rate IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE,
47: X_row_locked OUT NOCOPY VARCHAR2
48: );

Line 45: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,

41: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
42: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
43: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
44: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
45: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,
46: p_Conversion_Rate IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE,
47: X_row_locked OUT NOCOPY VARCHAR2
48: );
49: /* ================================================================================

Line 46: p_Conversion_Rate IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE,

42: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
43: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
44: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
45: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,
46: p_Conversion_Rate IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE,
47: X_row_locked OUT NOCOPY VARCHAR2
48: );
49: /* ================================================================================
50: PROCEDURE Update_Row

Line 61: p_CC_Header_Id IGC_CC_MC_HEADER_HISTORY.CC_Header_Id%TYPE,

57: X_return_status OUT NOCOPY VARCHAR2,
58: X_msg_count OUT NOCOPY NUMBER,
59: X_msg_data OUT NOCOPY VARCHAR2,
60: p_Rowid IN OUT NOCOPY VARCHAR2,
61: p_CC_Header_Id IGC_CC_MC_HEADER_HISTORY.CC_Header_Id%TYPE,
62: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
63: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
64: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
65: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,

Line 62: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,

58: X_msg_count OUT NOCOPY NUMBER,
59: X_msg_data OUT NOCOPY VARCHAR2,
60: p_Rowid IN OUT NOCOPY VARCHAR2,
61: p_CC_Header_Id IGC_CC_MC_HEADER_HISTORY.CC_Header_Id%TYPE,
62: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
63: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
64: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
65: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
66: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,

Line 63: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,

59: X_msg_data OUT NOCOPY VARCHAR2,
60: p_Rowid IN OUT NOCOPY VARCHAR2,
61: p_CC_Header_Id IGC_CC_MC_HEADER_HISTORY.CC_Header_Id%TYPE,
62: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
63: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
64: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
65: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
66: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,
67: p_Conversion_Rate IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE

Line 64: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,

60: p_Rowid IN OUT NOCOPY VARCHAR2,
61: p_CC_Header_Id IGC_CC_MC_HEADER_HISTORY.CC_Header_Id%TYPE,
62: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
63: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
64: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
65: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
66: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,
67: p_Conversion_Rate IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE
68: );

Line 65: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,

61: p_CC_Header_Id IGC_CC_MC_HEADER_HISTORY.CC_Header_Id%TYPE,
62: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
63: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
64: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
65: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
66: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,
67: p_Conversion_Rate IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE
68: );
69:

Line 66: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,

62: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
63: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
64: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
65: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
66: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,
67: p_Conversion_Rate IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE
68: );
69:
70:

Line 67: p_Conversion_Rate IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE

63: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
64: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
65: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
66: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,
67: p_Conversion_Rate IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE
68: );
69:
70:
71: /* ==============================================================================