1: PACKAGE BODY IGC_CC_HEADER_HISTORY_PKG as
2: /* $Header: IGCCHDHB.pls 120.3.12000000.3 2007/10/19 07:07:39 smannava ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IGC_CC_HEADER_HISTORY_PKG';
5: g_debug_flag VARCHAR2(1) := 'N' ;
1: PACKAGE BODY IGC_CC_HEADER_HISTORY_PKG as
2: /* $Header: IGCCHDHB.pls 120.3.12000000.3 2007/10/19 07:07:39 smannava ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IGC_CC_HEADER_HISTORY_PKG';
5: g_debug_flag VARCHAR2(1) := 'N' ;
6:
7:
8: /* ================================================================================
17: X_return_status OUT NOCOPY VARCHAR2,
18: X_msg_count OUT NOCOPY NUMBER,
19: X_msg_data OUT NOCOPY VARCHAR2,
20: p_Rowid IN OUT NOCOPY VARCHAR2,
21: p_CC_Header_Id IGC_CC_HEADER_HISTORY.CC_Header_Id%TYPE,
22: p_Org_id IGC_CC_HEADER_HISTORY.Org_id%TYPE,
23: p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
24: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
25: p_CC_Ref_Num IGC_CC_HEADER_HISTORY.CC_Ref_Num%TYPE,
18: X_msg_count OUT NOCOPY NUMBER,
19: X_msg_data OUT NOCOPY VARCHAR2,
20: p_Rowid IN OUT NOCOPY VARCHAR2,
21: p_CC_Header_Id IGC_CC_HEADER_HISTORY.CC_Header_Id%TYPE,
22: p_Org_id IGC_CC_HEADER_HISTORY.Org_id%TYPE,
23: p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
24: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
25: p_CC_Ref_Num IGC_CC_HEADER_HISTORY.CC_Ref_Num%TYPE,
26: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
19: X_msg_data OUT NOCOPY VARCHAR2,
20: p_Rowid IN OUT NOCOPY VARCHAR2,
21: p_CC_Header_Id IGC_CC_HEADER_HISTORY.CC_Header_Id%TYPE,
22: p_Org_id IGC_CC_HEADER_HISTORY.Org_id%TYPE,
23: p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
24: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
25: p_CC_Ref_Num IGC_CC_HEADER_HISTORY.CC_Ref_Num%TYPE,
26: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
27: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
20: p_Rowid IN OUT NOCOPY VARCHAR2,
21: p_CC_Header_Id IGC_CC_HEADER_HISTORY.CC_Header_Id%TYPE,
22: p_Org_id IGC_CC_HEADER_HISTORY.Org_id%TYPE,
23: p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
24: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
25: p_CC_Ref_Num IGC_CC_HEADER_HISTORY.CC_Ref_Num%TYPE,
26: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
27: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
28: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
21: p_CC_Header_Id IGC_CC_HEADER_HISTORY.CC_Header_Id%TYPE,
22: p_Org_id IGC_CC_HEADER_HISTORY.Org_id%TYPE,
23: p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
24: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
25: p_CC_Ref_Num IGC_CC_HEADER_HISTORY.CC_Ref_Num%TYPE,
26: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
27: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
28: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
29: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
22: p_Org_id IGC_CC_HEADER_HISTORY.Org_id%TYPE,
23: p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
24: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
25: p_CC_Ref_Num IGC_CC_HEADER_HISTORY.CC_Ref_Num%TYPE,
26: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
27: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
28: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
29: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
30: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
23: p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
24: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
25: p_CC_Ref_Num IGC_CC_HEADER_HISTORY.CC_Ref_Num%TYPE,
26: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
27: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
28: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
29: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
30: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
31: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
24: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
25: p_CC_Ref_Num IGC_CC_HEADER_HISTORY.CC_Ref_Num%TYPE,
26: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
27: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
28: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
29: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
30: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
31: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
32: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
25: p_CC_Ref_Num IGC_CC_HEADER_HISTORY.CC_Ref_Num%TYPE,
26: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
27: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
28: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
29: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
30: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
31: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
32: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
33: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
26: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
27: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
28: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
29: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
30: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
31: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
32: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
33: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
34: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
27: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
28: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
29: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
30: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
31: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
32: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
33: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
34: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
35: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
28: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
29: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
30: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
31: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
32: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
33: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
34: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
35: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
36: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
29: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
30: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
31: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
32: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
33: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
34: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
35: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
36: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
37: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
30: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
31: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
32: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
33: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
34: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
35: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
36: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
37: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
38: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
31: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
32: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
33: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
34: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
35: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
36: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
37: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
38: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
39: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
32: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
33: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
34: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
35: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
36: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
37: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
38: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
39: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
40: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
33: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
34: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
35: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
36: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
37: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
38: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
39: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
40: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
41: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
34: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
35: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
36: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
37: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
38: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
39: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
40: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
41: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
42: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
35: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
36: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
37: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
38: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
39: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
40: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
41: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
42: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
43: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
36: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
37: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
38: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
39: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
40: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
41: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
42: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
43: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
44: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
37: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
38: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
39: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
40: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
41: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
42: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
43: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
44: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
45: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
38: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
39: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
40: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
41: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
42: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
43: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
44: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
45: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
46: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
39: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
40: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
41: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
42: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
43: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
44: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
45: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
46: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
47: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
40: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
41: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
42: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
43: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
44: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
45: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
46: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
47: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
48: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
41: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
42: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
43: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
44: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
45: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
46: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
47: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
48: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
49: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
42: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
43: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
44: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
45: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
46: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
47: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
48: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
49: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
50: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
43: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
44: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
45: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
46: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
47: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
48: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
49: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
50: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
51: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
44: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
45: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
46: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
47: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
48: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
49: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
50: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
51: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
52: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
45: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
46: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
47: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
48: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
49: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
50: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
51: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
52: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
53: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
46: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
47: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
48: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
49: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
50: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
51: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
52: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
53: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
54: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
47: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
48: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
49: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
50: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
51: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
52: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
53: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
54: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
55: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
48: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
49: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
50: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
51: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
52: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
53: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
54: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
55: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
56: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
49: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
50: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
51: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
52: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
53: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
54: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
55: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
56: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
57: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
50: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
51: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
52: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
53: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
54: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
55: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
56: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
57: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
58: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
51: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
52: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
53: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
54: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
55: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
56: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
57: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
58: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
59: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
53: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
54: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
55: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
56: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
57: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
58: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
59: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
60: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
61: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
54: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
55: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
56: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
57: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
58: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
59: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
60: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
61: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
62: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
55: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
56: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
57: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
58: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
59: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
60: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
61: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
62: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
63: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
56: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
57: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
58: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
59: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
60: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
61: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
62: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
63: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
64: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
57: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
58: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
59: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
60: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
61: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
62: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
63: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
64: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
65: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
58: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
59: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
60: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
61: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
62: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
63: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
64: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
65: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
66: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
59: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
60: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
61: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
62: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
63: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
64: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
65: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
66: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
67: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
60: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
61: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
62: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
63: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
64: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
65: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
66: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
67: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
68: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
61: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
62: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
63: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
64: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
65: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
66: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
67: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
68: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
69: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
62: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
63: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
64: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
65: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
66: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
67: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
68: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
69: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
70: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
63: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
64: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
65: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
66: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
67: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
68: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
69: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
70: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
71: p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPe,
64: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
65: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
66: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
67: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
68: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
69: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
70: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
71: p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPe,
72: p_Context IGC_CC_HEADER_HISTORY.Context%TYPE,
65: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
66: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
67: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
68: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
69: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
70: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
71: p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPe,
72: p_Context IGC_CC_HEADER_HISTORY.Context%TYPE,
73: p_CC_Guarantee_Flag IGC_CC_HEADER_HISTORY.CC_Guarantee_Flag%TYPE,
66: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
67: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
68: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
69: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
70: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
71: p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPe,
72: p_Context IGC_CC_HEADER_HISTORY.Context%TYPE,
73: p_CC_Guarantee_Flag IGC_CC_HEADER_HISTORY.CC_Guarantee_Flag%TYPE,
74: G_FLAG IN OUT NOCOPY VARCHAR2
67: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
68: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
69: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
70: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
71: p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPe,
72: p_Context IGC_CC_HEADER_HISTORY.Context%TYPE,
73: p_CC_Guarantee_Flag IGC_CC_HEADER_HISTORY.CC_Guarantee_Flag%TYPE,
74: G_FLAG IN OUT NOCOPY VARCHAR2
75: ) IS
68: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
69: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
70: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
71: p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPe,
72: p_Context IGC_CC_HEADER_HISTORY.Context%TYPE,
73: p_CC_Guarantee_Flag IGC_CC_HEADER_HISTORY.CC_Guarantee_Flag%TYPE,
74: G_FLAG IN OUT NOCOPY VARCHAR2
75: ) IS
76:
69: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
70: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
71: p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPe,
72: p_Context IGC_CC_HEADER_HISTORY.Context%TYPE,
73: p_CC_Guarantee_Flag IGC_CC_HEADER_HISTORY.CC_Guarantee_Flag%TYPE,
74: G_FLAG IN OUT NOCOPY VARCHAR2
75: ) IS
76:
77: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
84: l_return_status VARCHAR2(1);
85:
86: CURSOR C_header_hst_rowid IS
87: SELECT Rowid
88: FROM IGC_CC_HEADER_HISTORY
89: WHERE CC_Header_id = p_CC_Header_id
90: AND CC_Version_Num = P_CC_Version_Num ;
91:
92: CURSOR c_igc_app_id IS
120: -- -----------------------------------------------------------------
121: -- Insert the CC Header History record as requested.
122: -- -----------------------------------------------------------------
123: INSERT
124: INTO IGC_CC_HEADER_HISTORY
125: (CC_Header_Id,
126: Parent_Header_Id,
127: Org_Id,
128: CC_Type,
390: X_return_status OUT NOCOPY VARCHAR2,
391: X_msg_count OUT NOCOPY NUMBER,
392: X_msg_data OUT NOCOPY VARCHAR2,
393: p_Rowid IN OUT NOCOPY VARCHAR2,
394: p_CC_Header_Id IGC_CC_HEADER_HISTORY.CC_Header_Id%TYPE,
395: p_Org_id IGC_CC_HEADER_HISTORY.Org_id%TYPE,
396: p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
397: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
398: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
391: X_msg_count OUT NOCOPY NUMBER,
392: X_msg_data OUT NOCOPY VARCHAR2,
393: p_Rowid IN OUT NOCOPY VARCHAR2,
394: p_CC_Header_Id IGC_CC_HEADER_HISTORY.CC_Header_Id%TYPE,
395: p_Org_id IGC_CC_HEADER_HISTORY.Org_id%TYPE,
396: p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
397: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
398: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
399: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
392: X_msg_data OUT NOCOPY VARCHAR2,
393: p_Rowid IN OUT NOCOPY VARCHAR2,
394: p_CC_Header_Id IGC_CC_HEADER_HISTORY.CC_Header_Id%TYPE,
395: p_Org_id IGC_CC_HEADER_HISTORY.Org_id%TYPE,
396: p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
397: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
398: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
399: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
400: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
393: p_Rowid IN OUT NOCOPY VARCHAR2,
394: p_CC_Header_Id IGC_CC_HEADER_HISTORY.CC_Header_Id%TYPE,
395: p_Org_id IGC_CC_HEADER_HISTORY.Org_id%TYPE,
396: p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
397: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
398: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
399: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
400: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
401: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
394: p_CC_Header_Id IGC_CC_HEADER_HISTORY.CC_Header_Id%TYPE,
395: p_Org_id IGC_CC_HEADER_HISTORY.Org_id%TYPE,
396: p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
397: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
398: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
399: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
400: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
401: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
402: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
395: p_Org_id IGC_CC_HEADER_HISTORY.Org_id%TYPE,
396: p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
397: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
398: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
399: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
400: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
401: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
402: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
403: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
396: p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
397: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
398: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
399: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
400: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
401: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
402: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
403: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
404: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
397: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
398: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
399: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
400: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
401: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
402: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
403: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
404: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
405: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
398: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
399: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
400: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
401: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
402: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
403: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
404: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
405: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
406: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
399: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
400: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
401: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
402: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
403: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
404: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
405: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
406: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
407: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
400: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
401: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
402: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
403: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
404: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
405: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
406: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
407: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
408: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
401: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
402: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
403: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
404: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
405: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
406: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
407: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
408: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
409: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
402: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
403: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
404: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
405: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
406: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
407: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
408: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
409: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
410: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
403: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
404: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
405: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
406: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
407: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
408: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
409: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
410: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
411: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
404: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
405: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
406: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
407: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
408: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
409: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
410: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
411: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
412: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
405: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
406: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
407: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
408: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
409: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
410: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
411: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
412: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
413: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
406: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
407: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
408: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
409: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
410: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
411: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
412: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
413: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
414: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
407: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
408: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
409: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
410: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
411: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
412: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
413: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
414: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
415: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
408: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
409: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
410: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
411: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
412: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
413: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
414: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
415: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
416: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
409: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
410: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
411: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
412: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
413: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
414: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
415: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
416: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
417: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
410: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
411: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
412: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
413: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
414: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
415: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
416: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
417: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
418: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
411: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
412: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
413: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
414: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
415: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
416: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
417: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
418: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
419: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
412: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
413: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
414: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
415: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
416: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
417: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
418: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
419: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
420: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
413: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
414: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
415: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
416: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
417: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
418: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
419: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
420: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
421: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
414: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
415: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
416: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
417: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
418: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
419: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
420: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
421: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
422: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
415: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
416: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
417: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
418: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
419: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
420: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
421: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
422: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
423: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
416: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
417: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
418: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
419: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
420: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
421: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
422: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
423: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
424: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
417: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
418: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
419: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
420: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
421: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
422: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
423: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
424: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
425: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
418: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
419: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
420: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
421: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
422: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
423: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
424: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
425: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
426: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
419: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
420: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
421: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
422: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
423: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
424: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
425: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
426: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
427: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
420: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
421: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
422: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
423: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
424: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
425: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
426: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
427: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
428: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
421: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
422: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
423: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
424: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
425: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
426: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
427: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
428: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
429: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
422: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
423: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
424: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
425: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
426: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
427: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
428: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
429: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
430: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
423: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
424: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
425: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
426: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
427: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
428: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
429: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
430: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
431: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
425: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
426: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
427: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
428: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
429: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
430: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
431: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
432: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
433: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
426: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
427: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
428: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
429: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
430: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
431: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
432: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
433: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
434: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
427: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
428: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
429: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
430: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
431: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
432: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
433: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
434: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
435: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
428: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
429: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
430: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
431: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
432: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
433: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
434: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
435: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
436: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
429: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
430: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
431: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
432: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
433: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
434: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
435: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
436: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
437: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
430: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
431: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
432: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
433: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
434: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
435: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
436: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
437: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
438: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
431: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
432: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
433: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
434: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
435: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
436: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
437: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
438: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
439: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
432: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
433: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
434: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
435: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
436: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
437: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
438: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
439: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
440: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
433: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
434: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
435: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
436: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
437: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
438: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
439: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
440: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
441: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
434: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
435: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
436: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
437: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
438: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
439: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
440: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
441: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
442: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
435: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
436: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
437: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
438: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
439: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
440: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
441: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
442: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
443: p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPe,
436: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
437: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
438: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
439: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
440: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
441: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
442: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
443: p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPe,
444: p_Context IGC_CC_HEADER_HISTORY.Context%TYPE,
437: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
438: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
439: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
440: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
441: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
442: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
443: p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPe,
444: p_Context IGC_CC_HEADER_HISTORY.Context%TYPE,
445: p_CC_Guarantee_Flag IGC_CC_HEADER_HISTORY.CC_Guarantee_Flag%TYPE,
438: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
439: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
440: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
441: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
442: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
443: p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPe,
444: p_Context IGC_CC_HEADER_HISTORY.Context%TYPE,
445: p_CC_Guarantee_Flag IGC_CC_HEADER_HISTORY.CC_Guarantee_Flag%TYPE,
446: G_FLAG IN OUT NOCOPY VARCHAR2
439: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
440: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
441: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
442: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
443: p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPe,
444: p_Context IGC_CC_HEADER_HISTORY.Context%TYPE,
445: p_CC_Guarantee_Flag IGC_CC_HEADER_HISTORY.CC_Guarantee_Flag%TYPE,
446: G_FLAG IN OUT NOCOPY VARCHAR2
447: ) IS
440: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
441: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
442: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
443: p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPe,
444: p_Context IGC_CC_HEADER_HISTORY.Context%TYPE,
445: p_CC_Guarantee_Flag IGC_CC_HEADER_HISTORY.CC_Guarantee_Flag%TYPE,
446: G_FLAG IN OUT NOCOPY VARCHAR2
447: ) IS
448:
441: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
442: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
443: p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPe,
444: p_Context IGC_CC_HEADER_HISTORY.Context%TYPE,
445: p_CC_Guarantee_Flag IGC_CC_HEADER_HISTORY.CC_Guarantee_Flag%TYPE,
446: G_FLAG IN OUT NOCOPY VARCHAR2
447: ) IS
448:
449: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
456: l_return_status VARCHAR2(1);
457:
458: CURSOR C_header_hst_rowid IS
459: SELECT Rowid
460: FROM IGC_CC_HEADER_HISTORY
461: WHERE CC_Header_id = p_CC_Header_id
462: AND CC_Version_Num = P_CC_Version_Num ;
463:
464: CURSOR c_igc_app_id IS
492: -- -----------------------------------------------------------------
493: -- Insert the CC Header History record as requested.
494: -- -----------------------------------------------------------------
495: INSERT
496: INTO IGC_CC_HEADER_HISTORY
497: (CC_Header_Id,
498: Parent_Header_Id,
499: Org_Id,
500: CC_Type,
760: X_return_status OUT NOCOPY VARCHAR2,
761: X_msg_count OUT NOCOPY NUMBER,
762: X_msg_data OUT NOCOPY VARCHAR2,
763: p_Rowid IN OUT NOCOPY VARCHAR2,
764: p_CC_Header_Id IGC_CC_HEADER_HISTORY.CC_Header_Id%TYPE,
765: p_Org_id IGC_CC_HEADER_HISTORY.Org_id%TYPE,
766: p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
767: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
768: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
761: X_msg_count OUT NOCOPY NUMBER,
762: X_msg_data OUT NOCOPY VARCHAR2,
763: p_Rowid IN OUT NOCOPY VARCHAR2,
764: p_CC_Header_Id IGC_CC_HEADER_HISTORY.CC_Header_Id%TYPE,
765: p_Org_id IGC_CC_HEADER_HISTORY.Org_id%TYPE,
766: p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
767: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
768: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
769: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
762: X_msg_data OUT NOCOPY VARCHAR2,
763: p_Rowid IN OUT NOCOPY VARCHAR2,
764: p_CC_Header_Id IGC_CC_HEADER_HISTORY.CC_Header_Id%TYPE,
765: p_Org_id IGC_CC_HEADER_HISTORY.Org_id%TYPE,
766: p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
767: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
768: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
769: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
770: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
763: p_Rowid IN OUT NOCOPY VARCHAR2,
764: p_CC_Header_Id IGC_CC_HEADER_HISTORY.CC_Header_Id%TYPE,
765: p_Org_id IGC_CC_HEADER_HISTORY.Org_id%TYPE,
766: p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
767: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
768: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
769: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
770: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
771: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
764: p_CC_Header_Id IGC_CC_HEADER_HISTORY.CC_Header_Id%TYPE,
765: p_Org_id IGC_CC_HEADER_HISTORY.Org_id%TYPE,
766: p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
767: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
768: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
769: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
770: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
771: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
772: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
765: p_Org_id IGC_CC_HEADER_HISTORY.Org_id%TYPE,
766: p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
767: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
768: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
769: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
770: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
771: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
772: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
773: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
766: p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
767: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
768: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
769: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
770: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
771: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
772: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
773: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
774: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
767: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
768: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
769: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
770: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
771: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
772: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
773: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
774: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
775: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
768: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
769: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
770: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
771: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
772: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
773: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
774: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
775: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
776: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
769: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
770: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
771: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
772: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
773: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
774: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
775: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
776: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
777: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
770: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
771: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
772: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
773: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
774: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
775: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
776: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
777: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
778: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
771: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
772: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
773: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
774: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
775: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
776: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
777: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
778: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
779: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
772: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
773: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
774: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
775: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
776: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
777: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
778: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
779: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
780: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
773: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
774: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
775: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
776: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
777: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
778: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
779: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
780: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
781: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
774: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
775: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
776: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
777: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
778: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
779: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
780: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
781: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
782: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
775: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
776: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
777: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
778: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
779: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
780: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
781: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
782: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
783: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
776: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
777: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
778: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
779: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
780: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
781: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
782: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
783: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
784: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
777: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
778: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
779: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
780: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
781: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
782: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
783: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
784: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
785: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
778: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
779: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
780: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
781: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
782: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
783: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
784: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
785: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
786: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
779: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
780: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
781: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
782: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
783: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
784: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
785: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
786: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
787: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
780: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
781: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
782: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
783: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
784: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
785: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
786: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
787: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
788: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
781: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
782: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
783: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
784: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
785: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
786: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
787: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
788: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
789: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
782: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
783: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
784: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
785: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
786: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
787: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
788: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
789: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
790: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
783: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
784: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
785: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
786: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
787: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
788: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
789: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
790: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
791: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
784: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
785: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
786: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
787: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
788: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
789: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
790: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
791: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
792: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
785: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
786: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
787: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
788: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
789: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
790: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
791: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
792: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
793: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
786: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
787: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
788: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
789: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
790: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
791: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
792: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
793: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
794: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
787: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
788: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
789: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
790: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
791: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
792: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
793: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
794: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
795: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
788: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
789: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
790: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
791: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
792: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
793: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
794: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
795: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
796: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
789: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
790: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
791: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
792: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
793: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
794: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
795: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
796: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
797: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
790: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
791: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
792: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
793: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
794: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
795: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
796: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
797: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
798: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
791: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
792: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
793: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
794: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
795: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
796: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
797: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
798: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
799: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
792: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
793: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
794: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
795: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
796: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
797: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
798: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
799: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
800: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
793: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
794: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
795: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
796: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
797: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
798: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
799: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
800: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
801: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
795: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
796: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
797: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
798: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
799: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
800: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
801: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
802: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
803: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
796: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
797: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
798: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
799: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
800: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
801: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
802: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
803: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
804: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
797: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
798: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
799: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
800: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
801: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
802: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
803: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
804: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
805: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
798: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
799: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
800: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
801: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
802: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
803: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
804: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
805: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
806: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
799: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
800: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
801: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
802: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
803: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
804: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
805: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
806: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
807: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
800: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
801: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
802: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
803: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
804: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
805: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
806: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
807: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
808: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
801: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
802: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
803: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
804: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
805: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
806: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
807: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
808: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
809: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
802: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
803: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
804: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
805: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
806: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
807: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
808: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
809: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
810: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
803: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
804: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
805: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
806: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
807: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
808: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
809: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
810: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
811: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
804: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
805: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
806: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
807: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
808: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
809: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
810: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
811: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
812: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
805: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
806: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
807: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
808: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
809: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
810: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
811: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
812: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
813: p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPE,
806: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
807: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
808: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
809: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
810: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
811: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
812: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
813: p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPE,
814: p_Context IGC_CC_HEADER_HISTORY.Context%TYPE,
807: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
808: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
809: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
810: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
811: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
812: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
813: p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPE,
814: p_Context IGC_CC_HEADER_HISTORY.Context%TYPE,
815: p_CC_Guarantee_Flag IGC_CC_HEADER_HISTORY.CC_Guarantee_Flag%TYPE,
808: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
809: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
810: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
811: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
812: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
813: p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPE,
814: p_Context IGC_CC_HEADER_HISTORY.Context%TYPE,
815: p_CC_Guarantee_Flag IGC_CC_HEADER_HISTORY.CC_Guarantee_Flag%TYPE,
816: X_row_locked OUT NOCOPY VARCHAR2,
809: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
810: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
811: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
812: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
813: p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPE,
814: p_Context IGC_CC_HEADER_HISTORY.Context%TYPE,
815: p_CC_Guarantee_Flag IGC_CC_HEADER_HISTORY.CC_Guarantee_Flag%TYPE,
816: X_row_locked OUT NOCOPY VARCHAR2,
817: G_FLAG IN OUT NOCOPY VARCHAR2
810: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
811: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
812: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
813: p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPE,
814: p_Context IGC_CC_HEADER_HISTORY.Context%TYPE,
815: p_CC_Guarantee_Flag IGC_CC_HEADER_HISTORY.CC_Guarantee_Flag%TYPE,
816: X_row_locked OUT NOCOPY VARCHAR2,
817: G_FLAG IN OUT NOCOPY VARCHAR2
818: ) IS
811: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
812: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
813: p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPE,
814: p_Context IGC_CC_HEADER_HISTORY.Context%TYPE,
815: p_CC_Guarantee_Flag IGC_CC_HEADER_HISTORY.CC_Guarantee_Flag%TYPE,
816: X_row_locked OUT NOCOPY VARCHAR2,
817: G_FLAG IN OUT NOCOPY VARCHAR2
818: ) IS
819:
822: Counter NUMBER;
823:
824: CURSOR C IS
825: SELECT *
826: FROM IGC_CC_HEADER_HISTORY
827: WHERE rowid = p_Rowid
828: FOR UPDATE of CC_Header_Id NOWAIT;
829:
830: Recinfo C%ROWTYPE;
1066: X_return_status OUT NOCOPY VARCHAR2,
1067: X_msg_count OUT NOCOPY NUMBER,
1068: X_msg_data OUT NOCOPY VARCHAR2,
1069: p_Rowid IN OUT NOCOPY VARCHAR2,
1070: p_CC_Header_Id IGC_CC_HEADER_HISTORY.CC_Header_Id%TYPE,
1071: p_Org_id IGC_CC_HEADER_HISTORY.Org_id%TYPE,
1072: p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
1073: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
1074: p_CC_Ref_Num IGC_CC_HEADER_HISTORY.CC_Ref_Num%TYPE,
1067: X_msg_count OUT NOCOPY NUMBER,
1068: X_msg_data OUT NOCOPY VARCHAR2,
1069: p_Rowid IN OUT NOCOPY VARCHAR2,
1070: p_CC_Header_Id IGC_CC_HEADER_HISTORY.CC_Header_Id%TYPE,
1071: p_Org_id IGC_CC_HEADER_HISTORY.Org_id%TYPE,
1072: p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
1073: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
1074: p_CC_Ref_Num IGC_CC_HEADER_HISTORY.CC_Ref_Num%TYPE,
1075: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
1068: X_msg_data OUT NOCOPY VARCHAR2,
1069: p_Rowid IN OUT NOCOPY VARCHAR2,
1070: p_CC_Header_Id IGC_CC_HEADER_HISTORY.CC_Header_Id%TYPE,
1071: p_Org_id IGC_CC_HEADER_HISTORY.Org_id%TYPE,
1072: p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
1073: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
1074: p_CC_Ref_Num IGC_CC_HEADER_HISTORY.CC_Ref_Num%TYPE,
1075: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
1076: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
1069: p_Rowid IN OUT NOCOPY VARCHAR2,
1070: p_CC_Header_Id IGC_CC_HEADER_HISTORY.CC_Header_Id%TYPE,
1071: p_Org_id IGC_CC_HEADER_HISTORY.Org_id%TYPE,
1072: p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
1073: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
1074: p_CC_Ref_Num IGC_CC_HEADER_HISTORY.CC_Ref_Num%TYPE,
1075: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
1076: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
1077: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
1070: p_CC_Header_Id IGC_CC_HEADER_HISTORY.CC_Header_Id%TYPE,
1071: p_Org_id IGC_CC_HEADER_HISTORY.Org_id%TYPE,
1072: p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
1073: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
1074: p_CC_Ref_Num IGC_CC_HEADER_HISTORY.CC_Ref_Num%TYPE,
1075: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
1076: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
1077: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
1078: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
1071: p_Org_id IGC_CC_HEADER_HISTORY.Org_id%TYPE,
1072: p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
1073: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
1074: p_CC_Ref_Num IGC_CC_HEADER_HISTORY.CC_Ref_Num%TYPE,
1075: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
1076: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
1077: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
1078: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
1079: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
1072: p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
1073: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
1074: p_CC_Ref_Num IGC_CC_HEADER_HISTORY.CC_Ref_Num%TYPE,
1075: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
1076: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
1077: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
1078: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
1079: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
1080: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
1073: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
1074: p_CC_Ref_Num IGC_CC_HEADER_HISTORY.CC_Ref_Num%TYPE,
1075: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
1076: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
1077: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
1078: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
1079: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
1080: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
1081: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
1074: p_CC_Ref_Num IGC_CC_HEADER_HISTORY.CC_Ref_Num%TYPE,
1075: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
1076: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
1077: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
1078: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
1079: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
1080: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
1081: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
1082: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
1075: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
1076: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
1077: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
1078: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
1079: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
1080: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
1081: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
1082: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
1083: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
1076: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
1077: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
1078: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
1079: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
1080: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
1081: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
1082: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
1083: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
1084: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
1077: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
1078: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
1079: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
1080: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
1081: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
1082: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
1083: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
1084: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
1085: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
1078: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
1079: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
1080: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
1081: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
1082: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
1083: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
1084: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
1085: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
1086: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
1079: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
1080: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
1081: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
1082: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
1083: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
1084: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
1085: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
1086: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
1087: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
1080: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
1081: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
1082: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
1083: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
1084: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
1085: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
1086: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
1087: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
1088: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
1081: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
1082: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
1083: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
1084: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
1085: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
1086: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
1087: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
1088: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
1089: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
1082: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
1083: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
1084: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
1085: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
1086: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
1087: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
1088: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
1089: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
1090: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
1083: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
1084: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
1085: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
1086: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
1087: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
1088: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
1089: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
1090: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
1091: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
1084: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
1085: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
1086: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
1087: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
1088: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
1089: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
1090: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
1091: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
1092: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
1085: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
1086: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
1087: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
1088: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
1089: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
1090: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
1091: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
1092: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
1093: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
1086: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
1087: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
1088: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
1089: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
1090: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
1091: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
1092: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
1093: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
1094: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
1087: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
1088: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
1089: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
1090: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
1091: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
1092: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
1093: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
1094: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
1095: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
1088: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
1089: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
1090: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
1091: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
1092: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
1093: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
1094: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
1095: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
1096: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
1089: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
1090: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
1091: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
1092: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
1093: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
1094: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
1095: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
1096: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
1097: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
1090: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
1091: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
1092: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
1093: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
1094: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
1095: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
1096: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
1097: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
1098: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
1091: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
1092: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
1093: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
1094: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
1095: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
1096: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
1097: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
1098: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
1099: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
1092: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
1093: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
1094: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
1095: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
1096: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
1097: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
1098: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
1099: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
1100: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
1093: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
1094: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
1095: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
1096: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
1097: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
1098: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
1099: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
1100: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
1101: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
1094: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
1095: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
1096: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
1097: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
1098: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
1099: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
1100: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
1101: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
1102: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
1095: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
1096: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
1097: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
1098: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
1099: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
1100: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
1101: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
1102: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
1103: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
1096: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
1097: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
1098: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
1099: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
1100: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
1101: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
1102: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
1103: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
1104: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
1097: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
1098: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
1099: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
1100: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
1101: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
1102: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
1103: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
1104: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
1105: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
1098: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
1099: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
1100: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
1101: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
1102: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
1103: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
1104: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
1105: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
1106: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
1099: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
1100: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
1101: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
1102: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
1103: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
1104: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
1105: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
1106: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
1107: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
1100: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
1101: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
1102: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
1103: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
1104: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
1105: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
1106: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
1107: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
1108: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
1102: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
1103: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
1104: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
1105: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
1106: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
1107: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
1108: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
1109: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
1110: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
1103: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
1104: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
1105: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
1106: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
1107: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
1108: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
1109: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
1110: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
1111: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
1104: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
1105: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
1106: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
1107: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
1108: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
1109: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
1110: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
1111: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
1112: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
1105: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
1106: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
1107: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
1108: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
1109: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
1110: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
1111: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
1112: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
1113: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
1106: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
1107: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
1108: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
1109: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
1110: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
1111: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
1112: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
1113: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
1114: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
1107: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
1108: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
1109: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
1110: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
1111: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
1112: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
1113: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
1114: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
1115: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
1108: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
1109: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
1110: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
1111: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
1112: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
1113: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
1114: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
1115: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
1116: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
1109: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
1110: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
1111: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
1112: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
1113: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
1114: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
1115: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
1116: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
1117: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
1110: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
1111: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
1112: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
1113: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
1114: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
1115: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
1116: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
1117: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
1118: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
1111: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
1112: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
1113: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
1114: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
1115: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
1116: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
1117: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
1118: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
1119: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
1112: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
1113: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
1114: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
1115: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
1116: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
1117: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
1118: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
1119: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
1120: p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPE,
1113: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
1114: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
1115: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
1116: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
1117: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
1118: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
1119: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
1120: p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPE,
1121: p_Context IGC_CC_HEADER_HISTORY.Context%TYPE,
1114: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
1115: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
1116: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
1117: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
1118: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
1119: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
1120: p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPE,
1121: p_Context IGC_CC_HEADER_HISTORY.Context%TYPE,
1122: p_CC_Guarantee_Flag IGC_CC_HEADER_HISTORY.CC_Guarantee_Flag%TYPE,
1115: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
1116: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
1117: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
1118: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
1119: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
1120: p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPE,
1121: p_Context IGC_CC_HEADER_HISTORY.Context%TYPE,
1122: p_CC_Guarantee_Flag IGC_CC_HEADER_HISTORY.CC_Guarantee_Flag%TYPE,
1123: G_FLAG IN OUT NOCOPY VARCHAR2
1116: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
1117: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
1118: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
1119: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
1120: p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPE,
1121: p_Context IGC_CC_HEADER_HISTORY.Context%TYPE,
1122: p_CC_Guarantee_Flag IGC_CC_HEADER_HISTORY.CC_Guarantee_Flag%TYPE,
1123: G_FLAG IN OUT NOCOPY VARCHAR2
1124: ) IS
1117: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
1118: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
1119: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
1120: p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPE,
1121: p_Context IGC_CC_HEADER_HISTORY.Context%TYPE,
1122: p_CC_Guarantee_Flag IGC_CC_HEADER_HISTORY.CC_Guarantee_Flag%TYPE,
1123: G_FLAG IN OUT NOCOPY VARCHAR2
1124: ) IS
1125:
1118: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
1119: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
1120: p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPE,
1121: p_Context IGC_CC_HEADER_HISTORY.Context%TYPE,
1122: p_CC_Guarantee_Flag IGC_CC_HEADER_HISTORY.CC_Guarantee_Flag%TYPE,
1123: G_FLAG IN OUT NOCOPY VARCHAR2
1124: ) IS
1125:
1126: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
1144: END IF;
1145:
1146: X_return_status := FND_API.G_RET_STS_SUCCESS ;
1147:
1148: UPDATE IGC_CC_HEADER_HISTORY
1149: SET CC_Header_Id = p_CC_Header_Id,
1150: Parent_Header_Id = p_Parent_Header_Id,
1151: Org_Id = p_Org_id,
1152: CC_Type = p_CC_Type,
1256: X_return_status OUT NOCOPY VARCHAR2,
1257: X_msg_count OUT NOCOPY NUMBER,
1258: X_msg_data OUT NOCOPY VARCHAR2,
1259: p_Rowid IN OUT NOCOPY VARCHAR2,
1260: p_CC_Header_Id IGC_CC_HEADER_HISTORY.CC_Header_Id%TYPE,
1261: p_Org_id IGC_CC_HEADER_HISTORY.Org_id%TYPE,
1262: p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
1263: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
1264: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
1257: X_msg_count OUT NOCOPY NUMBER,
1258: X_msg_data OUT NOCOPY VARCHAR2,
1259: p_Rowid IN OUT NOCOPY VARCHAR2,
1260: p_CC_Header_Id IGC_CC_HEADER_HISTORY.CC_Header_Id%TYPE,
1261: p_Org_id IGC_CC_HEADER_HISTORY.Org_id%TYPE,
1262: p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
1263: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
1264: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
1265: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
1258: X_msg_data OUT NOCOPY VARCHAR2,
1259: p_Rowid IN OUT NOCOPY VARCHAR2,
1260: p_CC_Header_Id IGC_CC_HEADER_HISTORY.CC_Header_Id%TYPE,
1261: p_Org_id IGC_CC_HEADER_HISTORY.Org_id%TYPE,
1262: p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
1263: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
1264: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
1265: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
1266: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
1259: p_Rowid IN OUT NOCOPY VARCHAR2,
1260: p_CC_Header_Id IGC_CC_HEADER_HISTORY.CC_Header_Id%TYPE,
1261: p_Org_id IGC_CC_HEADER_HISTORY.Org_id%TYPE,
1262: p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
1263: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
1264: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
1265: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
1266: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
1267: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
1260: p_CC_Header_Id IGC_CC_HEADER_HISTORY.CC_Header_Id%TYPE,
1261: p_Org_id IGC_CC_HEADER_HISTORY.Org_id%TYPE,
1262: p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
1263: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
1264: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
1265: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
1266: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
1267: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
1268: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
1261: p_Org_id IGC_CC_HEADER_HISTORY.Org_id%TYPE,
1262: p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
1263: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
1264: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
1265: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
1266: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
1267: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
1268: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
1269: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
1262: p_CC_Type IGC_CC_HEADER_HISTORY.CC_Type%TYPE,
1263: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
1264: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
1265: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
1266: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
1267: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
1268: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
1269: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
1270: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
1263: p_CC_Num IGC_CC_HEADER_HISTORY.CC_Num%TYPE,
1264: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
1265: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
1266: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
1267: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
1268: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
1269: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
1270: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
1271: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
1264: p_CC_Version_num IGC_CC_HEADER_HISTORY.CC_Version_Num%TYPE,
1265: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
1266: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
1267: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
1268: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
1269: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
1270: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
1271: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
1272: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
1265: p_CC_Version_Action IGC_CC_HEADER_HISTORY.CC_Version_Action%TYPE,
1266: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
1267: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
1268: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
1269: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
1270: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
1271: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
1272: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
1273: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
1266: p_CC_State IGC_CC_HEADER_HISTORY.CC_State%TYPE,
1267: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
1268: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
1269: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
1270: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
1271: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
1272: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
1273: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
1274: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
1267: p_Parent_Header_Id IGC_CC_HEADER_HISTORY.Parent_Header_Id%TYPE,
1268: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
1269: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
1270: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
1271: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
1272: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
1273: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
1274: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
1275: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
1268: p_CC_ctrl_status IGC_CC_HEADER_HISTORY.CC_ctrl_status%TYPE,
1269: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
1270: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
1271: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
1272: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
1273: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
1274: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
1275: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
1276: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
1269: p_CC_Encmbrnc_Status IGC_CC_HEADER_HISTORY.CC_Encmbrnc_Status%TYPE,
1270: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
1271: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
1272: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
1273: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
1274: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
1275: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
1276: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
1277: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
1270: p_CC_Apprvl_Status IGC_CC_HEADER_HISTORY.CC_Apprvl_Status%TYPE,
1271: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
1272: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
1273: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
1274: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
1275: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
1276: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
1277: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
1278: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
1271: p_Vendor_Id IGC_CC_HEADER_HISTORY.Vendor_Id%TYPE,
1272: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
1273: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
1274: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
1275: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
1276: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
1277: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
1278: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
1279: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
1272: p_Vendor_Site_Id IGC_CC_HEADER_HISTORY.Vendor_Site_Id%TYPE,
1273: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
1274: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
1275: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
1276: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
1277: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
1278: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
1279: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
1280: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
1273: p_Vendor_Contact_Id IGC_CC_HEADER_HISTORY.Vendor_Contact_Id%TYPE,
1274: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
1275: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
1276: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
1277: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
1278: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
1279: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
1280: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
1281: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
1274: p_Term_Id IGC_CC_HEADER_HISTORY.Term_Id%TYPE,
1275: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
1276: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
1277: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
1278: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
1279: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
1280: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
1281: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
1282: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
1275: p_Location_Id IGC_CC_HEADER_HISTORY.Location_Id%TYPE,
1276: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
1277: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
1278: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
1279: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
1280: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
1281: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
1282: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
1283: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
1276: p_Set_Of_Books_Id IGC_CC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
1277: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
1278: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
1279: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
1280: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
1281: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
1282: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
1283: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
1284: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
1277: p_CC_Acct_Date IGC_CC_HEADER_HISTORY.CC_Acct_Date%TYPE,
1278: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
1279: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
1280: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
1281: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
1282: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
1283: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
1284: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
1285: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
1278: p_CC_Desc IGC_CC_HEADER_HISTORY.CC_Desc%TYPE,
1279: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
1280: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
1281: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
1282: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
1283: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
1284: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
1285: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
1286: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
1279: p_CC_Start_Date IGC_CC_HEADER_HISTORY.CC_Start_Date%TYPE,
1280: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
1281: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
1282: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
1283: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
1284: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
1285: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
1286: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
1287: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
1280: p_CC_End_Date IGC_CC_HEADER_HISTORY.CC_End_Date%TYPE,
1281: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
1282: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
1283: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
1284: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
1285: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
1286: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
1287: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
1288: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
1281: p_CC_Owner_User_Id IGC_CC_HEADER_HISTORY.CC_Owner_User_Id%TYPE,
1282: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
1283: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
1284: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
1285: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
1286: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
1287: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
1288: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
1289: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
1282: p_CC_Preparer_User_Id IGC_CC_HEADER_HISTORY.CC_Preparer_User_Id%TYPE,
1283: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
1284: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
1285: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
1286: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
1287: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
1288: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
1289: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
1290: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
1283: p_Currency_Code IGC_CC_HEADER_HISTORY.Currency_Code%TYPE,
1284: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
1285: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
1286: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
1287: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
1288: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
1289: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
1290: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
1291: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
1284: p_Conversion_Type IGC_CC_HEADER_HISTORY.Conversion_Type%TYPE,
1285: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
1286: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
1287: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
1288: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
1289: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
1290: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
1291: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
1292: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
1285: p_Conversion_Date IGC_CC_HEADER_HISTORY.Conversion_Date%TYPE,
1286: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
1287: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
1288: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
1289: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
1290: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
1291: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
1292: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
1293: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
1286: p_Conversion_Rate IGC_CC_HEADER_HISTORY.Conversion_Rate%TYPE,
1287: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
1288: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
1289: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
1290: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
1291: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
1292: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
1293: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
1294: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
1287: p_Last_Update_Date IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
1288: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
1289: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
1290: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
1291: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
1292: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
1293: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
1294: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
1295: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
1288: p_Last_Updated_By IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
1289: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
1290: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
1291: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
1292: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
1293: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
1294: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
1295: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
1296: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
1289: p_Last_Update_Login IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
1290: p_Created_By IGC_CC_HEADER_HISTORY.Created_By%TYPE,
1291: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
1292: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
1293: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
1294: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
1295: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
1296: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
1297: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
1291: p_Creation_Date IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
1292: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
1293: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
1294: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
1295: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
1296: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
1297: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
1298: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
1299: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
1292: p_Wf_Item_Type IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
1293: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
1294: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
1295: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
1296: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
1297: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
1298: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
1299: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
1300: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
1293: p_Wf_Item_Key IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
1294: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
1295: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
1296: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
1297: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
1298: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
1299: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
1300: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
1301: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
1294: p_CC_Current_User_Id IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
1295: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
1296: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
1297: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
1298: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
1299: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
1300: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
1301: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
1302: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
1295: p_Attribute1 IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
1296: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
1297: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
1298: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
1299: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
1300: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
1301: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
1302: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
1303: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
1296: p_Attribute2 IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
1297: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
1298: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
1299: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
1300: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
1301: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
1302: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
1303: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
1304: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
1297: p_Attribute3 IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
1298: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
1299: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
1300: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
1301: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
1302: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
1303: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
1304: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
1305: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
1298: p_Attribute4 IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
1299: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
1300: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
1301: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
1302: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
1303: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
1304: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
1305: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
1306: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
1299: p_Attribute5 IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
1300: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
1301: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
1302: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
1303: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
1304: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
1305: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
1306: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
1307: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
1300: p_Attribute6 IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
1301: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
1302: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
1303: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
1304: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
1305: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
1306: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
1307: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
1308: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
1301: p_Attribute7 IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
1302: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
1303: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
1304: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
1305: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
1306: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
1307: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
1308: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
1309: p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPE,
1302: p_Attribute8 IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
1303: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
1304: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
1305: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
1306: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
1307: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
1308: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
1309: p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPE,
1310: p_Context IGC_CC_HEADER_HISTORY.Context%TYPE,
1303: p_Attribute9 IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
1304: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
1305: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
1306: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
1307: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
1308: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
1309: p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPE,
1310: p_Context IGC_CC_HEADER_HISTORY.Context%TYPE,
1311: p_CC_Guarantee_Flag IGC_CC_HEADER_HISTORY.CC_Guarantee_Flag%TYPE,
1304: p_Attribute10 IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
1305: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
1306: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
1307: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
1308: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
1309: p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPE,
1310: p_Context IGC_CC_HEADER_HISTORY.Context%TYPE,
1311: p_CC_Guarantee_Flag IGC_CC_HEADER_HISTORY.CC_Guarantee_Flag%TYPE,
1312: G_FLAG IN OUT NOCOPY VARCHAR2
1305: p_Attribute11 IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
1306: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
1307: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
1308: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
1309: p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPE,
1310: p_Context IGC_CC_HEADER_HISTORY.Context%TYPE,
1311: p_CC_Guarantee_Flag IGC_CC_HEADER_HISTORY.CC_Guarantee_Flag%TYPE,
1312: G_FLAG IN OUT NOCOPY VARCHAR2
1313: ) IS
1306: p_Attribute12 IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
1307: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
1308: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
1309: p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPE,
1310: p_Context IGC_CC_HEADER_HISTORY.Context%TYPE,
1311: p_CC_Guarantee_Flag IGC_CC_HEADER_HISTORY.CC_Guarantee_Flag%TYPE,
1312: G_FLAG IN OUT NOCOPY VARCHAR2
1313: ) IS
1314:
1307: p_Attribute13 IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
1308: p_Attribute14 IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
1309: p_Attribute15 IGC_CC_HEADER_HISTORY.Attribute15%TYPE,
1310: p_Context IGC_CC_HEADER_HISTORY.Context%TYPE,
1311: p_CC_Guarantee_Flag IGC_CC_HEADER_HISTORY.CC_Guarantee_Flag%TYPE,
1312: G_FLAG IN OUT NOCOPY VARCHAR2
1313: ) IS
1314:
1315: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
1334: END IF;
1335:
1336: X_return_status := FND_API.G_RET_STS_SUCCESS ;
1337:
1338: UPDATE IGC_CC_HEADER_HISTORY
1339: SET CC_Header_Id = p_CC_Header_Id,
1340: Parent_Header_Id = p_Parent_Header_Id,
1341: Org_Id = p_Org_id,
1342: CC_Type = p_CC_Type,
1473:
1474: X_return_status := FND_API.G_RET_STS_SUCCESS ;
1475:
1476: DELETE
1477: FROM IGC_CC_HEADER_HISTORY
1478: WHERE rowid = p_Rowid;
1479:
1480: IF (SQL%NOTFOUND) THEN
1481: Raise NO_DATA_FOUND;
1520: END Delete_Row;
1521:
1522:
1523:
1524: END IGC_CC_HEADER_HISTORY_PKG;