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,
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,
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
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: );
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: /* =================================================================================
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
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: ================================================================================*/
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,
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,
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,
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
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: );
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: /* ================================================================================
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
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,
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,
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
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: );
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:
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:
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: /* ==============================================================================