1: PACKAGE IGC_CC_MC_HEADERS_PKG AUTHID CURRENT_USER as
2: /* $Header: IGCCMCHS.pls 120.3.12000000.1 2007/08/20 12:13:05 mbremkum ship $ */
3:
4:
5:
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_HEADERS.CC_Header_Id%TYPE,
21: p_Set_Of_Books_Id IGC_CC_MC_HEADERS.Set_Of_Books_Id%TYPE,
22: p_Conversion_Type IGC_CC_MC_HEADERS.Conversion_Type%TYPE,
23: p_Conversion_Date IGC_CC_MC_HEADERS.Conversion_Date%TYPE,
24: p_Conversion_Rate IGC_CC_MC_HEADERS.Conversion_Rate%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_HEADERS.CC_Header_Id%TYPE,
21: p_Set_Of_Books_Id IGC_CC_MC_HEADERS.Set_Of_Books_Id%TYPE,
22: p_Conversion_Type IGC_CC_MC_HEADERS.Conversion_Type%TYPE,
23: p_Conversion_Date IGC_CC_MC_HEADERS.Conversion_Date%TYPE,
24: p_Conversion_Rate IGC_CC_MC_HEADERS.Conversion_Rate%TYPE
25: );
18: X_msg_data OUT NOCOPY VARCHAR2,
19: p_Rowid IN OUT NOCOPY VARCHAR2,
20: p_CC_Header_Id IGC_CC_MC_HEADERS.CC_Header_Id%TYPE,
21: p_Set_Of_Books_Id IGC_CC_MC_HEADERS.Set_Of_Books_Id%TYPE,
22: p_Conversion_Type IGC_CC_MC_HEADERS.Conversion_Type%TYPE,
23: p_Conversion_Date IGC_CC_MC_HEADERS.Conversion_Date%TYPE,
24: p_Conversion_Rate IGC_CC_MC_HEADERS.Conversion_Rate%TYPE
25: );
26: /* =================================================================================
19: p_Rowid IN OUT NOCOPY VARCHAR2,
20: p_CC_Header_Id IGC_CC_MC_HEADERS.CC_Header_Id%TYPE,
21: p_Set_Of_Books_Id IGC_CC_MC_HEADERS.Set_Of_Books_Id%TYPE,
22: p_Conversion_Type IGC_CC_MC_HEADERS.Conversion_Type%TYPE,
23: p_Conversion_Date IGC_CC_MC_HEADERS.Conversion_Date%TYPE,
24: p_Conversion_Rate IGC_CC_MC_HEADERS.Conversion_Rate%TYPE
25: );
26: /* =================================================================================
27: PROCEDURE Lock_Row
20: p_CC_Header_Id IGC_CC_MC_HEADERS.CC_Header_Id%TYPE,
21: p_Set_Of_Books_Id IGC_CC_MC_HEADERS.Set_Of_Books_Id%TYPE,
22: p_Conversion_Type IGC_CC_MC_HEADERS.Conversion_Type%TYPE,
23: p_Conversion_Date IGC_CC_MC_HEADERS.Conversion_Date%TYPE,
24: p_Conversion_Rate IGC_CC_MC_HEADERS.Conversion_Rate%TYPE
25: );
26: /* =================================================================================
27: PROCEDURE Lock_Row
28: ================================================================================*/
34: X_return_status OUT NOCOPY VARCHAR2,
35: X_msg_count OUT NOCOPY NUMBER,
36: X_msg_data OUT NOCOPY VARCHAR2,
37: p_Rowid IN OUT NOCOPY VARCHAR2,
38: p_CC_Header_Id IGC_CC_MC_HEADERS.CC_Header_Id%TYPE,
39: p_Set_Of_Books_Id IGC_CC_MC_HEADERS.Set_Of_Books_Id%TYPE,
40: p_Conversion_Type IGC_CC_MC_HEADERS.Conversion_Type%TYPE,
41: p_Conversion_Date IGC_CC_MC_HEADERS.Conversion_Date%TYPE,
42: p_Conversion_Rate IGC_CC_MC_HEADERS.Conversion_Rate%TYPE,
35: X_msg_count OUT NOCOPY NUMBER,
36: X_msg_data OUT NOCOPY VARCHAR2,
37: p_Rowid IN OUT NOCOPY VARCHAR2,
38: p_CC_Header_Id IGC_CC_MC_HEADERS.CC_Header_Id%TYPE,
39: p_Set_Of_Books_Id IGC_CC_MC_HEADERS.Set_Of_Books_Id%TYPE,
40: p_Conversion_Type IGC_CC_MC_HEADERS.Conversion_Type%TYPE,
41: p_Conversion_Date IGC_CC_MC_HEADERS.Conversion_Date%TYPE,
42: p_Conversion_Rate IGC_CC_MC_HEADERS.Conversion_Rate%TYPE,
43: X_row_locked OUT NOCOPY VARCHAR2
36: X_msg_data OUT NOCOPY VARCHAR2,
37: p_Rowid IN OUT NOCOPY VARCHAR2,
38: p_CC_Header_Id IGC_CC_MC_HEADERS.CC_Header_Id%TYPE,
39: p_Set_Of_Books_Id IGC_CC_MC_HEADERS.Set_Of_Books_Id%TYPE,
40: p_Conversion_Type IGC_CC_MC_HEADERS.Conversion_Type%TYPE,
41: p_Conversion_Date IGC_CC_MC_HEADERS.Conversion_Date%TYPE,
42: p_Conversion_Rate IGC_CC_MC_HEADERS.Conversion_Rate%TYPE,
43: X_row_locked OUT NOCOPY VARCHAR2
44: );
37: p_Rowid IN OUT NOCOPY VARCHAR2,
38: p_CC_Header_Id IGC_CC_MC_HEADERS.CC_Header_Id%TYPE,
39: p_Set_Of_Books_Id IGC_CC_MC_HEADERS.Set_Of_Books_Id%TYPE,
40: p_Conversion_Type IGC_CC_MC_HEADERS.Conversion_Type%TYPE,
41: p_Conversion_Date IGC_CC_MC_HEADERS.Conversion_Date%TYPE,
42: p_Conversion_Rate IGC_CC_MC_HEADERS.Conversion_Rate%TYPE,
43: X_row_locked OUT NOCOPY VARCHAR2
44: );
45: /* ================================================================================
38: p_CC_Header_Id IGC_CC_MC_HEADERS.CC_Header_Id%TYPE,
39: p_Set_Of_Books_Id IGC_CC_MC_HEADERS.Set_Of_Books_Id%TYPE,
40: p_Conversion_Type IGC_CC_MC_HEADERS.Conversion_Type%TYPE,
41: p_Conversion_Date IGC_CC_MC_HEADERS.Conversion_Date%TYPE,
42: p_Conversion_Rate IGC_CC_MC_HEADERS.Conversion_Rate%TYPE,
43: X_row_locked OUT NOCOPY VARCHAR2
44: );
45: /* ================================================================================
46: PROCEDURE Update_Row
53: X_return_status OUT NOCOPY VARCHAR2,
54: X_msg_count OUT NOCOPY NUMBER,
55: X_msg_data OUT NOCOPY VARCHAR2,
56: p_Rowid IN OUT NOCOPY VARCHAR2,
57: p_CC_Header_Id IGC_CC_MC_HEADERS.CC_Header_Id%TYPE,
58: p_Set_Of_Books_Id IGC_CC_MC_HEADERS.Set_Of_Books_Id%TYPE,
59: p_Conversion_Type IGC_CC_MC_HEADERS.Conversion_Type%TYPE,
60: p_Conversion_Date IGC_CC_MC_HEADERS.Conversion_Date%TYPE,
61: p_Conversion_Rate IGC_CC_MC_HEADERS.Conversion_Rate%TYPE
54: X_msg_count OUT NOCOPY NUMBER,
55: X_msg_data OUT NOCOPY VARCHAR2,
56: p_Rowid IN OUT NOCOPY VARCHAR2,
57: p_CC_Header_Id IGC_CC_MC_HEADERS.CC_Header_Id%TYPE,
58: p_Set_Of_Books_Id IGC_CC_MC_HEADERS.Set_Of_Books_Id%TYPE,
59: p_Conversion_Type IGC_CC_MC_HEADERS.Conversion_Type%TYPE,
60: p_Conversion_Date IGC_CC_MC_HEADERS.Conversion_Date%TYPE,
61: p_Conversion_Rate IGC_CC_MC_HEADERS.Conversion_Rate%TYPE
62: );
55: X_msg_data OUT NOCOPY VARCHAR2,
56: p_Rowid IN OUT NOCOPY VARCHAR2,
57: p_CC_Header_Id IGC_CC_MC_HEADERS.CC_Header_Id%TYPE,
58: p_Set_Of_Books_Id IGC_CC_MC_HEADERS.Set_Of_Books_Id%TYPE,
59: p_Conversion_Type IGC_CC_MC_HEADERS.Conversion_Type%TYPE,
60: p_Conversion_Date IGC_CC_MC_HEADERS.Conversion_Date%TYPE,
61: p_Conversion_Rate IGC_CC_MC_HEADERS.Conversion_Rate%TYPE
62: );
63:
56: p_Rowid IN OUT NOCOPY VARCHAR2,
57: p_CC_Header_Id IGC_CC_MC_HEADERS.CC_Header_Id%TYPE,
58: p_Set_Of_Books_Id IGC_CC_MC_HEADERS.Set_Of_Books_Id%TYPE,
59: p_Conversion_Type IGC_CC_MC_HEADERS.Conversion_Type%TYPE,
60: p_Conversion_Date IGC_CC_MC_HEADERS.Conversion_Date%TYPE,
61: p_Conversion_Rate IGC_CC_MC_HEADERS.Conversion_Rate%TYPE
62: );
63:
64:
57: p_CC_Header_Id IGC_CC_MC_HEADERS.CC_Header_Id%TYPE,
58: p_Set_Of_Books_Id IGC_CC_MC_HEADERS.Set_Of_Books_Id%TYPE,
59: p_Conversion_Type IGC_CC_MC_HEADERS.Conversion_Type%TYPE,
60: p_Conversion_Date IGC_CC_MC_HEADERS.Conversion_Date%TYPE,
61: p_Conversion_Rate IGC_CC_MC_HEADERS.Conversion_Rate%TYPE
62: );
63:
64:
65: /* ==============================================================================
75: X_msg_data OUT NOCOPY VARCHAR2,
76: p_Rowid IN OUT NOCOPY VARCHAR2
77: );
78:
79: END IGC_CC_MC_HEADERS_PKG;