DBA Data[Home] [Help]

APPS.IGC_CC_HEADERS_PKG dependencies on IGC_CC_HEADERS_ALL

Line 90: p_CC_Header_Id IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,

86: X_return_status OUT NOCOPY VARCHAR2,
87: X_msg_count OUT NOCOPY NUMBER,
88: X_msg_data OUT NOCOPY VARCHAR2,
89: p_Rowid IN OUT NOCOPY VARCHAR2,
90: p_CC_Header_Id IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,
91: p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,
92: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
93: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
94: p_CC_Ref_Num IGC_CC_HEADERS_ALL.CC_Ref_Num%TYPE,

Line 91: p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,

87: X_msg_count OUT NOCOPY NUMBER,
88: X_msg_data OUT NOCOPY VARCHAR2,
89: p_Rowid IN OUT NOCOPY VARCHAR2,
90: p_CC_Header_Id IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,
91: p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,
92: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
93: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
94: p_CC_Ref_Num IGC_CC_HEADERS_ALL.CC_Ref_Num%TYPE,
95: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,

Line 92: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,

88: X_msg_data OUT NOCOPY VARCHAR2,
89: p_Rowid IN OUT NOCOPY VARCHAR2,
90: p_CC_Header_Id IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,
91: p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,
92: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
93: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
94: p_CC_Ref_Num IGC_CC_HEADERS_ALL.CC_Ref_Num%TYPE,
95: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
96: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,

Line 93: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,

89: p_Rowid IN OUT NOCOPY VARCHAR2,
90: p_CC_Header_Id IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,
91: p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,
92: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
93: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
94: p_CC_Ref_Num IGC_CC_HEADERS_ALL.CC_Ref_Num%TYPE,
95: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
96: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
97: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,

Line 94: p_CC_Ref_Num IGC_CC_HEADERS_ALL.CC_Ref_Num%TYPE,

90: p_CC_Header_Id IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,
91: p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,
92: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
93: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
94: p_CC_Ref_Num IGC_CC_HEADERS_ALL.CC_Ref_Num%TYPE,
95: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
96: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
97: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
98: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,

Line 95: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,

91: p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,
92: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
93: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
94: p_CC_Ref_Num IGC_CC_HEADERS_ALL.CC_Ref_Num%TYPE,
95: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
96: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
97: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
98: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
99: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,

Line 96: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,

92: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
93: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
94: p_CC_Ref_Num IGC_CC_HEADERS_ALL.CC_Ref_Num%TYPE,
95: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
96: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
97: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
98: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
99: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
100: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,

Line 97: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,

93: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
94: p_CC_Ref_Num IGC_CC_HEADERS_ALL.CC_Ref_Num%TYPE,
95: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
96: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
97: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
98: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
99: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
100: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
101: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,

Line 98: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,

94: p_CC_Ref_Num IGC_CC_HEADERS_ALL.CC_Ref_Num%TYPE,
95: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
96: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
97: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
98: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
99: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
100: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
101: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
102: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,

Line 99: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,

95: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
96: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
97: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
98: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
99: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
100: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
101: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
102: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
103: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,

Line 100: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,

96: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
97: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
98: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
99: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
100: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
101: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
102: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
103: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
104: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,

Line 101: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,

97: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
98: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
99: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
100: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
101: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
102: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
103: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
104: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
105: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,

Line 102: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,

98: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
99: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
100: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
101: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
102: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
103: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
104: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
105: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
106: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,

Line 103: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,

99: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
100: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
101: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
102: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
103: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
104: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
105: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
106: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
107: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,

Line 104: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,

100: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
101: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
102: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
103: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
104: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
105: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
106: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
107: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
108: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,

Line 105: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,

101: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
102: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
103: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
104: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
105: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
106: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
107: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
108: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
109: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,

Line 106: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,

102: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
103: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
104: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
105: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
106: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
107: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
108: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
109: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
110: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,

Line 107: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,

103: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
104: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
105: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
106: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
107: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
108: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
109: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
110: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
111: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,

Line 108: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,

104: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
105: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
106: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
107: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
108: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
109: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
110: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
111: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
112: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,

Line 109: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,

105: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
106: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
107: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
108: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
109: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
110: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
111: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
112: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
113: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,

Line 110: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,

106: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
107: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
108: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
109: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
110: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
111: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
112: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
113: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
114: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,

Line 111: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,

107: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
108: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
109: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
110: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
111: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
112: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
113: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
114: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
115: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,

Line 112: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,

108: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
109: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
110: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
111: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
112: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
113: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
114: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
115: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
116: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,

Line 113: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,

109: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
110: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
111: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
112: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
113: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
114: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
115: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
116: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
117: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,

Line 114: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,

110: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
111: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
112: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
113: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
114: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
115: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
116: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
117: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
118: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,

Line 115: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,

111: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
112: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
113: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
114: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
115: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
116: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
117: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
118: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
119: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,

Line 116: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,

112: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
113: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
114: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
115: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
116: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
117: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
118: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
119: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
120: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,

Line 117: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,

113: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
114: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
115: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
116: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
117: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
118: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
119: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
120: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
121: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,

Line 118: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,

114: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
115: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
116: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
117: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
118: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
119: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
120: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
121: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
122: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,

Line 119: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,

115: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
116: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
117: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
118: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
119: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
120: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
121: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
122: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
123: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,

Line 120: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,

116: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
117: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
118: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
119: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
120: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
121: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
122: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
123: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
124: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,

Line 121: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,

117: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
118: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
119: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
120: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
121: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
122: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
123: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
124: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
125: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,

Line 122: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,

118: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
119: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
120: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
121: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
122: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
123: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
124: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
125: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
126: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,

Line 123: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,

119: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
120: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
121: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
122: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
123: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
124: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
125: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
126: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
127: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,

Line 124: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,

120: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
121: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
122: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
123: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
124: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
125: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
126: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
127: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
128: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,

Line 125: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,

121: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
122: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
123: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
124: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
125: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
126: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
127: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
128: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
129: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,

Line 126: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,

122: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
123: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
124: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
125: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
126: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
127: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
128: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
129: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
130: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,

Line 127: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,

123: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
124: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
125: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
126: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
127: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
128: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
129: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
130: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
131: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,

Line 128: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,

124: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
125: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
126: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
127: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
128: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
129: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
130: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
131: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
132: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,

Line 129: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,

125: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
126: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
127: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
128: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
129: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
130: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
131: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
132: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
133: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,

Line 130: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,

126: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
127: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
128: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
129: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
130: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
131: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
132: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
133: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
134: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,

Line 131: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,

127: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
128: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
129: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
130: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
131: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
132: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
133: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
134: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
135: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,

Line 132: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,

128: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
129: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
130: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
131: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
132: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
133: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
134: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
135: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
136: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,

Line 133: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,

129: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
130: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
131: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
132: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
133: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
134: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
135: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
136: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
137: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,

Line 134: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,

130: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
131: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
132: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
133: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
134: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
135: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
136: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
137: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
138: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,

Line 135: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,

131: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
132: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
133: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
134: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
135: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
136: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
137: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
138: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
139: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPE,

Line 136: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,

132: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
133: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
134: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
135: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
136: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
137: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
138: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
139: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPE,
140: p_Context IGC_CC_HEADERS_ALL.Context%TYPE,

Line 137: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,

133: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
134: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
135: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
136: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
137: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
138: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
139: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPE,
140: p_Context IGC_CC_HEADERS_ALL.Context%TYPE,
141: p_CC_Guarantee_Flag IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,

Line 138: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,

134: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
135: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
136: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
137: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
138: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
139: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPE,
140: p_Context IGC_CC_HEADERS_ALL.Context%TYPE,
141: p_CC_Guarantee_Flag IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,
142: G_FLAG IN OUT NOCOPY VARCHAR2

Line 139: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPE,

135: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
136: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
137: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
138: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
139: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPE,
140: p_Context IGC_CC_HEADERS_ALL.Context%TYPE,
141: p_CC_Guarantee_Flag IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,
142: G_FLAG IN OUT NOCOPY VARCHAR2
143: ) IS

Line 140: p_Context IGC_CC_HEADERS_ALL.Context%TYPE,

136: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
137: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
138: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
139: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPE,
140: p_Context IGC_CC_HEADERS_ALL.Context%TYPE,
141: p_CC_Guarantee_Flag IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,
142: G_FLAG IN OUT NOCOPY VARCHAR2
143: ) IS
144:

Line 141: p_CC_Guarantee_Flag IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,

137: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
138: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
139: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPE,
140: p_Context IGC_CC_HEADERS_ALL.Context%TYPE,
141: p_CC_Guarantee_Flag IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,
142: G_FLAG IN OUT NOCOPY VARCHAR2
143: ) IS
144:
145: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';

Line 156: FROM IGC_CC_HEADERS_ALL

152: -- l_debug VARCHAR2(1);
153:
154: CURSOR c_cc_header_row_id IS
155: SELECT Rowid
156: FROM IGC_CC_HEADERS_ALL
157: WHERE CC_Header_id = p_CC_Header_id;
158:
159: CURSOR c_igc_app_id IS
160: SELECT Application_Id

Line 209: INTO IGC_CC_HEADERS_ALL

205: -- -----------------------------------------------------------------
206: -- Insert the CC Header record as requested.
207: -- -----------------------------------------------------------------
208: INSERT
209: INTO IGC_CC_HEADERS_ALL
210: (CC_Header_Id,
211: Parent_Header_Id,
212: Org_Id,
213: CC_Type,

Line 533: p_CC_Header_Id IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,

529: X_return_status OUT NOCOPY VARCHAR2,
530: X_msg_count OUT NOCOPY NUMBER,
531: X_msg_data OUT NOCOPY VARCHAR2,
532: p_Rowid IN OUT NOCOPY VARCHAR2,
533: p_CC_Header_Id IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,
534: p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,
535: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
536: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
537: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,

Line 534: p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,

530: X_msg_count OUT NOCOPY NUMBER,
531: X_msg_data OUT NOCOPY VARCHAR2,
532: p_Rowid IN OUT NOCOPY VARCHAR2,
533: p_CC_Header_Id IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,
534: p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,
535: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
536: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
537: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
538: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,

Line 535: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,

531: X_msg_data OUT NOCOPY VARCHAR2,
532: p_Rowid IN OUT NOCOPY VARCHAR2,
533: p_CC_Header_Id IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,
534: p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,
535: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
536: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
537: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
538: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
539: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,

Line 536: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,

532: p_Rowid IN OUT NOCOPY VARCHAR2,
533: p_CC_Header_Id IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,
534: p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,
535: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
536: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
537: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
538: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
539: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
540: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,

Line 537: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,

533: p_CC_Header_Id IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,
534: p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,
535: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
536: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
537: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
538: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
539: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
540: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
541: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,

Line 538: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,

534: p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,
535: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
536: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
537: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
538: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
539: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
540: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
541: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
542: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,

Line 539: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,

535: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
536: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
537: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
538: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
539: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
540: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
541: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
542: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
543: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,

Line 540: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,

536: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
537: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
538: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
539: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
540: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
541: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
542: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
543: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
544: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,

Line 541: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,

537: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
538: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
539: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
540: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
541: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
542: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
543: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
544: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
545: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,

Line 542: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,

538: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
539: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
540: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
541: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
542: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
543: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
544: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
545: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
546: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,

Line 543: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,

539: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
540: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
541: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
542: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
543: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
544: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
545: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
546: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
547: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,

Line 544: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,

540: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
541: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
542: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
543: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
544: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
545: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
546: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
547: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
548: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,

Line 545: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,

541: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
542: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
543: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
544: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
545: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
546: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
547: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
548: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
549: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,

Line 546: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,

542: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
543: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
544: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
545: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
546: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
547: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
548: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
549: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
550: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,

Line 547: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,

543: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
544: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
545: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
546: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
547: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
548: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
549: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
550: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
551: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,

Line 548: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,

544: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
545: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
546: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
547: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
548: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
549: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
550: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
551: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
552: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,

Line 549: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,

545: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
546: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
547: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
548: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
549: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
550: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
551: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
552: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
553: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,

Line 550: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,

546: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
547: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
548: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
549: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
550: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
551: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
552: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
553: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
554: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,

Line 551: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,

547: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
548: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
549: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
550: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
551: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
552: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
553: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
554: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
555: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,

Line 552: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,

548: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
549: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
550: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
551: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
552: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
553: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
554: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
555: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
556: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,

Line 553: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,

549: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
550: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
551: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
552: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
553: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
554: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
555: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
556: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
557: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,

Line 554: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,

550: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
551: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
552: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
553: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
554: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
555: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
556: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
557: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
558: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,

Line 555: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,

551: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
552: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
553: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
554: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
555: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
556: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
557: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
558: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
559: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,

Line 556: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,

552: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
553: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
554: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
555: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
556: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
557: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
558: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
559: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
560: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,

Line 557: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,

553: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
554: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
555: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
556: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
557: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
558: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
559: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
560: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
561: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,

Line 558: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,

554: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
555: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
556: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
557: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
558: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
559: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
560: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
561: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
562: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,

Line 559: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,

555: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
556: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
557: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
558: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
559: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
560: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
561: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
562: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
563: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,

Line 560: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,

556: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
557: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
558: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
559: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
560: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
561: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
562: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
563: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
564: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,

Line 561: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,

557: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
558: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
559: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
560: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
561: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
562: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
563: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
564: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
565: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,

Line 562: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,

558: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
559: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
560: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
561: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
562: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
563: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
564: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
565: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
566: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,

Line 563: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,

559: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
560: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
561: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
562: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
563: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
564: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
565: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
566: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
567: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,

Line 564: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,

560: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
561: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
562: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
563: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
564: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
565: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
566: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
567: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
568: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,

Line 565: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,

561: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
562: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
563: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
564: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
565: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
566: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
567: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
568: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
569: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,

Line 566: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,

562: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
563: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
564: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
565: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
566: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
567: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
568: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
569: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
570: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,

Line 567: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,

563: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
564: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
565: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
566: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
567: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
568: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
569: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
570: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
571: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,

Line 568: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,

564: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
565: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
566: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
567: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
568: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
569: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
570: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
571: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
572: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,

Line 569: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,

565: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
566: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
567: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
568: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
569: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
570: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
571: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
572: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
573: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,

Line 570: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,

566: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
567: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
568: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
569: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
570: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
571: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
572: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
573: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
574: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,

Line 571: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,

567: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
568: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
569: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
570: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
571: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
572: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
573: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
574: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
575: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,

Line 572: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,

568: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
569: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
570: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
571: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
572: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
573: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
574: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
575: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
576: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,

Line 573: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,

569: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
570: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
571: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
572: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
573: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
574: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
575: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
576: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
577: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,

Line 574: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,

570: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
571: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
572: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
573: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
574: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
575: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
576: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
577: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
578: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,

Line 575: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,

571: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
572: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
573: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
574: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
575: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
576: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
577: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
578: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
579: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,

Line 576: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,

572: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
573: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
574: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
575: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
576: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
577: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
578: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
579: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
580: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,

Line 577: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,

573: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
574: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
575: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
576: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
577: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
578: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
579: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
580: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
581: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPE,

Line 578: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,

574: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
575: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
576: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
577: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
578: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
579: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
580: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
581: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPE,
582: p_Context IGC_CC_HEADERS_ALL.Context%TYPE,

Line 579: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,

575: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
576: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
577: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
578: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
579: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
580: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
581: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPE,
582: p_Context IGC_CC_HEADERS_ALL.Context%TYPE,
583: p_CC_Guarantee_Flag IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,

Line 580: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,

576: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
577: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
578: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
579: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
580: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
581: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPE,
582: p_Context IGC_CC_HEADERS_ALL.Context%TYPE,
583: p_CC_Guarantee_Flag IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,
584: G_FLAG IN OUT NOCOPY VARCHAR2

Line 581: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPE,

577: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
578: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
579: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
580: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
581: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPE,
582: p_Context IGC_CC_HEADERS_ALL.Context%TYPE,
583: p_CC_Guarantee_Flag IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,
584: G_FLAG IN OUT NOCOPY VARCHAR2
585: ) IS

Line 582: p_Context IGC_CC_HEADERS_ALL.Context%TYPE,

578: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
579: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
580: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
581: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPE,
582: p_Context IGC_CC_HEADERS_ALL.Context%TYPE,
583: p_CC_Guarantee_Flag IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,
584: G_FLAG IN OUT NOCOPY VARCHAR2
585: ) IS
586:

Line 583: p_CC_Guarantee_Flag IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,

579: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
580: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
581: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPE,
582: p_Context IGC_CC_HEADERS_ALL.Context%TYPE,
583: p_CC_Guarantee_Flag IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,
584: G_FLAG IN OUT NOCOPY VARCHAR2
585: ) IS
586:
587: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';

Line 598: FROM IGC_CC_HEADERS_ALL

594: -- l_debug VARCHAR2(1);
595:
596: CURSOR c_cc_header_row_id IS
597: SELECT Rowid
598: FROM IGC_CC_HEADERS_ALL
599: WHERE CC_Header_id = p_CC_Header_id;
600:
601: CURSOR c_igc_app_id IS
602: SELECT Application_Id

Line 651: INTO IGC_CC_HEADERS_ALL

647: -- -----------------------------------------------------------------
648: -- Insert the CC Header record as requested.
649: -- -----------------------------------------------------------------
650: INSERT
651: INTO IGC_CC_HEADERS_ALL
652: (CC_Header_Id,
653: Parent_Header_Id,
654: Org_Id,
655: CC_Type,

Line 973: p_CC_Header_Id IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,

969: X_return_status OUT NOCOPY VARCHAR2,
970: X_msg_count OUT NOCOPY NUMBER,
971: X_msg_data OUT NOCOPY VARCHAR2,
972: p_Rowid IN OUT NOCOPY VARCHAR2,
973: p_CC_Header_Id IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,
974: p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,
975: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
976: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
977: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,

Line 974: p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,

970: X_msg_count OUT NOCOPY NUMBER,
971: X_msg_data OUT NOCOPY VARCHAR2,
972: p_Rowid IN OUT NOCOPY VARCHAR2,
973: p_CC_Header_Id IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,
974: p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,
975: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
976: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
977: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
978: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,

Line 975: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,

971: X_msg_data OUT NOCOPY VARCHAR2,
972: p_Rowid IN OUT NOCOPY VARCHAR2,
973: p_CC_Header_Id IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,
974: p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,
975: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
976: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
977: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
978: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
979: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,

Line 976: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,

972: p_Rowid IN OUT NOCOPY VARCHAR2,
973: p_CC_Header_Id IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,
974: p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,
975: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
976: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
977: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
978: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
979: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
980: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,

Line 977: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,

973: p_CC_Header_Id IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,
974: p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,
975: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
976: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
977: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
978: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
979: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
980: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
981: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,

Line 978: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,

974: p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,
975: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
976: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
977: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
978: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
979: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
980: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
981: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
982: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,

Line 979: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,

975: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
976: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
977: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
978: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
979: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
980: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
981: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
982: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
983: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,

Line 980: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,

976: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
977: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
978: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
979: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
980: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
981: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
982: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
983: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
984: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,

Line 981: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,

977: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
978: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
979: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
980: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
981: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
982: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
983: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
984: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
985: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,

Line 982: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,

978: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
979: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
980: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
981: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
982: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
983: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
984: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
985: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
986: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,

Line 983: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,

979: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
980: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
981: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
982: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
983: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
984: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
985: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
986: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
987: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,

Line 984: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,

980: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
981: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
982: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
983: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
984: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
985: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
986: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
987: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
988: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,

Line 985: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,

981: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
982: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
983: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
984: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
985: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
986: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
987: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
988: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
989: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,

Line 986: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,

982: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
983: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
984: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
985: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
986: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
987: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
988: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
989: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
990: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,

Line 987: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,

983: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
984: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
985: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
986: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
987: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
988: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
989: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
990: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
991: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,

Line 988: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,

984: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
985: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
986: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
987: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
988: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
989: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
990: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
991: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
992: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,

Line 989: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,

985: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
986: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
987: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
988: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
989: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
990: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
991: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
992: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
993: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,

Line 990: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,

986: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
987: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
988: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
989: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
990: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
991: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
992: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
993: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
994: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,

Line 991: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,

987: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
988: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
989: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
990: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
991: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
992: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
993: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
994: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
995: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,

Line 992: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,

988: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
989: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
990: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
991: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
992: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
993: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
994: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
995: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
996: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,

Line 993: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,

989: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
990: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
991: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
992: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
993: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
994: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
995: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
996: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
997: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,

Line 994: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,

990: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
991: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
992: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
993: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
994: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
995: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
996: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
997: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
998: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,

Line 995: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,

991: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
992: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
993: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
994: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
995: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
996: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
997: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
998: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
999: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,

Line 996: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,

992: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
993: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
994: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
995: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
996: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
997: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
998: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
999: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
1000: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,

Line 997: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,

993: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
994: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
995: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
996: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
997: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
998: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
999: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
1000: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
1001: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,

Line 998: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,

994: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
995: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
996: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
997: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
998: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
999: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
1000: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
1001: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
1002: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,

Line 999: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,

995: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
996: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
997: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
998: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
999: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
1000: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
1001: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
1002: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
1003: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,

Line 1000: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,

996: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
997: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
998: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
999: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
1000: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
1001: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
1002: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
1003: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
1004: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,

Line 1001: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,

997: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
998: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
999: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
1000: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
1001: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
1002: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
1003: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
1004: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
1005: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,

Line 1002: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,

998: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
999: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
1000: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
1001: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
1002: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
1003: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
1004: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
1005: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
1006: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,

Line 1003: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,

999: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
1000: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
1001: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
1002: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
1003: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
1004: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
1005: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
1006: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
1007: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,

Line 1004: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,

1000: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
1001: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
1002: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
1003: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
1004: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
1005: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
1006: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
1007: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
1008: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,

Line 1005: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,

1001: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
1002: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
1003: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
1004: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
1005: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
1006: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
1007: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
1008: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
1009: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,

Line 1006: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,

1002: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
1003: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
1004: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
1005: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
1006: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
1007: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
1008: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
1009: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
1010: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,

Line 1007: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,

1003: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
1004: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
1005: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
1006: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
1007: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
1008: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
1009: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
1010: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
1011: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,

Line 1008: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,

1004: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
1005: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
1006: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
1007: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
1008: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
1009: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
1010: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
1011: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
1012: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,

Line 1009: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,

1005: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
1006: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
1007: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
1008: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
1009: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
1010: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
1011: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
1012: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
1013: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,

Line 1010: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,

1006: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
1007: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
1008: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
1009: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
1010: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
1011: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
1012: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
1013: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
1014: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,

Line 1011: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,

1007: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
1008: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
1009: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
1010: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
1011: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
1012: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
1013: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
1014: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
1015: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,

Line 1012: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,

1008: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
1009: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
1010: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
1011: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
1012: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
1013: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
1014: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
1015: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
1016: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,

Line 1013: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,

1009: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
1010: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
1011: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
1012: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
1013: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
1014: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
1015: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
1016: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
1017: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,

Line 1014: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,

1010: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
1011: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
1012: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
1013: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
1014: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
1015: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
1016: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
1017: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
1018: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,

Line 1015: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,

1011: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
1012: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
1013: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
1014: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
1015: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
1016: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
1017: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
1018: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
1019: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,

Line 1016: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,

1012: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
1013: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
1014: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
1015: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
1016: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
1017: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
1018: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
1019: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
1020: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,

Line 1017: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,

1013: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
1014: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
1015: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
1016: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
1017: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
1018: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
1019: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
1020: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
1021: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPE,

Line 1018: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,

1014: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
1015: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
1016: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
1017: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
1018: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
1019: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
1020: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
1021: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPE,
1022: p_Context IGC_CC_HEADERS_ALL.Context%TYPE,

Line 1019: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,

1015: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
1016: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
1017: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
1018: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
1019: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
1020: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
1021: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPE,
1022: p_Context IGC_CC_HEADERS_ALL.Context%TYPE,
1023: p_CC_Guarantee_Flag IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,

Line 1020: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,

1016: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
1017: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
1018: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
1019: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
1020: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
1021: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPE,
1022: p_Context IGC_CC_HEADERS_ALL.Context%TYPE,
1023: p_CC_Guarantee_Flag IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,
1024: X_row_locked OUT NOCOPY VARCHAR2,

Line 1021: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPE,

1017: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
1018: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
1019: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
1020: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
1021: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPE,
1022: p_Context IGC_CC_HEADERS_ALL.Context%TYPE,
1023: p_CC_Guarantee_Flag IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,
1024: X_row_locked OUT NOCOPY VARCHAR2,
1025: G_FLAG IN OUT NOCOPY VARCHAR2

Line 1022: p_Context IGC_CC_HEADERS_ALL.Context%TYPE,

1018: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
1019: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
1020: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
1021: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPE,
1022: p_Context IGC_CC_HEADERS_ALL.Context%TYPE,
1023: p_CC_Guarantee_Flag IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,
1024: X_row_locked OUT NOCOPY VARCHAR2,
1025: G_FLAG IN OUT NOCOPY VARCHAR2
1026: ) IS

Line 1023: p_CC_Guarantee_Flag IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,

1019: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
1020: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
1021: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPE,
1022: p_Context IGC_CC_HEADERS_ALL.Context%TYPE,
1023: p_CC_Guarantee_Flag IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,
1024: X_row_locked OUT NOCOPY VARCHAR2,
1025: G_FLAG IN OUT NOCOPY VARCHAR2
1026: ) IS
1027:

Line 1035: FROM IGC_CC_HEADERS_ALL

1031: -- l_debug VARCHAR2(1);
1032:
1033: CURSOR C IS
1034: SELECT *
1035: FROM IGC_CC_HEADERS_ALL
1036: WHERE rowid = p_Rowid
1037: FOR UPDATE of CC_Header_Id NOWAIT;
1038:
1039: Recinfo C%ROWTYPE;

Line 1349: p_CC_Header_Id IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,

1345: X_return_status OUT NOCOPY VARCHAR2,
1346: X_msg_count OUT NOCOPY NUMBER,
1347: X_msg_data OUT NOCOPY VARCHAR2,
1348: p_Rowid IN OUT NOCOPY VARCHAR2,
1349: p_CC_Header_Id IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,
1350: p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,
1351: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
1352: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
1353: p_CC_Ref_Num IGC_CC_HEADERS_ALL.CC_Ref_Num%TYPE,

Line 1350: p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,

1346: X_msg_count OUT NOCOPY NUMBER,
1347: X_msg_data OUT NOCOPY VARCHAR2,
1348: p_Rowid IN OUT NOCOPY VARCHAR2,
1349: p_CC_Header_Id IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,
1350: p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,
1351: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
1352: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
1353: p_CC_Ref_Num IGC_CC_HEADERS_ALL.CC_Ref_Num%TYPE,
1354: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,

Line 1351: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,

1347: X_msg_data OUT NOCOPY VARCHAR2,
1348: p_Rowid IN OUT NOCOPY VARCHAR2,
1349: p_CC_Header_Id IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,
1350: p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,
1351: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
1352: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
1353: p_CC_Ref_Num IGC_CC_HEADERS_ALL.CC_Ref_Num%TYPE,
1354: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
1355: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,

Line 1352: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,

1348: p_Rowid IN OUT NOCOPY VARCHAR2,
1349: p_CC_Header_Id IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,
1350: p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,
1351: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
1352: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
1353: p_CC_Ref_Num IGC_CC_HEADERS_ALL.CC_Ref_Num%TYPE,
1354: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
1355: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
1356: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,

Line 1353: p_CC_Ref_Num IGC_CC_HEADERS_ALL.CC_Ref_Num%TYPE,

1349: p_CC_Header_Id IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,
1350: p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,
1351: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
1352: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
1353: p_CC_Ref_Num IGC_CC_HEADERS_ALL.CC_Ref_Num%TYPE,
1354: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
1355: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
1356: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
1357: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,

Line 1354: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,

1350: p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,
1351: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
1352: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
1353: p_CC_Ref_Num IGC_CC_HEADERS_ALL.CC_Ref_Num%TYPE,
1354: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
1355: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
1356: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
1357: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
1358: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,

Line 1355: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,

1351: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
1352: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
1353: p_CC_Ref_Num IGC_CC_HEADERS_ALL.CC_Ref_Num%TYPE,
1354: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
1355: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
1356: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
1357: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
1358: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
1359: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,

Line 1356: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,

1352: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
1353: p_CC_Ref_Num IGC_CC_HEADERS_ALL.CC_Ref_Num%TYPE,
1354: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
1355: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
1356: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
1357: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
1358: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
1359: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
1360: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,

Line 1357: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,

1353: p_CC_Ref_Num IGC_CC_HEADERS_ALL.CC_Ref_Num%TYPE,
1354: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
1355: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
1356: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
1357: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
1358: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
1359: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
1360: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
1361: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,

Line 1358: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,

1354: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
1355: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
1356: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
1357: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
1358: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
1359: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
1360: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
1361: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
1362: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,

Line 1359: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,

1355: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
1356: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
1357: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
1358: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
1359: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
1360: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
1361: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
1362: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
1363: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,

Line 1360: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,

1356: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
1357: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
1358: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
1359: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
1360: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
1361: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
1362: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
1363: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
1364: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,

Line 1361: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,

1357: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
1358: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
1359: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
1360: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
1361: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
1362: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
1363: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
1364: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
1365: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,

Line 1362: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,

1358: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
1359: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
1360: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
1361: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
1362: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
1363: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
1364: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
1365: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
1366: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,

Line 1363: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,

1359: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
1360: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
1361: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
1362: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
1363: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
1364: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
1365: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
1366: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
1367: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,

Line 1364: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,

1360: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
1361: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
1362: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
1363: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
1364: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
1365: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
1366: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
1367: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
1368: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,

Line 1365: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,

1361: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
1362: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
1363: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
1364: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
1365: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
1366: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
1367: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
1368: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
1369: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,

Line 1366: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,

1362: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
1363: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
1364: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
1365: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
1366: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
1367: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
1368: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
1369: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
1370: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,

Line 1367: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,

1363: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
1364: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
1365: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
1366: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
1367: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
1368: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
1369: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
1370: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
1371: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,

Line 1368: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,

1364: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
1365: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
1366: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
1367: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
1368: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
1369: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
1370: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
1371: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
1372: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,

Line 1369: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,

1365: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
1366: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
1367: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
1368: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
1369: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
1370: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
1371: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
1372: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
1373: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,

Line 1370: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,

1366: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
1367: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
1368: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
1369: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
1370: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
1371: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
1372: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
1373: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
1374: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,

Line 1371: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,

1367: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
1368: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
1369: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
1370: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
1371: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
1372: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
1373: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
1374: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
1375: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,

Line 1372: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,

1368: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
1369: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
1370: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
1371: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
1372: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
1373: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
1374: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
1375: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
1376: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,

Line 1373: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,

1369: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
1370: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
1371: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
1372: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
1373: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
1374: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
1375: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
1376: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
1377: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,

Line 1374: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,

1370: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
1371: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
1372: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
1373: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
1374: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
1375: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
1376: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
1377: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
1378: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,

Line 1375: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,

1371: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
1372: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
1373: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
1374: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
1375: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
1376: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
1377: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
1378: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
1379: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,

Line 1376: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,

1372: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
1373: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
1374: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
1375: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
1376: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
1377: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
1378: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
1379: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
1380: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,

Line 1377: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,

1373: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
1374: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
1375: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
1376: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
1377: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
1378: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
1379: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
1380: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
1381: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,

Line 1378: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,

1374: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
1375: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
1376: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
1377: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
1378: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
1379: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
1380: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
1381: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
1382: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,

Line 1379: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,

1375: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
1376: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
1377: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
1378: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
1379: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
1380: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
1381: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
1382: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
1383: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,

Line 1380: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,

1376: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
1377: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
1378: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
1379: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
1380: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
1381: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
1382: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
1383: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
1384: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,

Line 1381: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,

1377: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
1378: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
1379: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
1380: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
1381: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
1382: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
1383: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
1384: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
1385: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,

Line 1382: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,

1378: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
1379: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
1380: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
1381: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
1382: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
1383: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
1384: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
1385: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
1386: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,

Line 1383: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,

1379: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
1380: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
1381: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
1382: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
1383: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
1384: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
1385: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
1386: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
1387: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,

Line 1384: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,

1380: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
1381: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
1382: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
1383: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
1384: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
1385: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
1386: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
1387: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
1388: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,

Line 1385: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,

1381: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
1382: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
1383: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
1384: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
1385: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
1386: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
1387: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
1388: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
1389: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,

Line 1386: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,

1382: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
1383: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
1384: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
1385: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
1386: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
1387: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
1388: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
1389: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
1390: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,

Line 1387: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,

1383: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
1384: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
1385: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
1386: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
1387: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
1388: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
1389: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
1390: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
1391: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,

Line 1388: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,

1384: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
1385: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
1386: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
1387: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
1388: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
1389: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
1390: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
1391: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
1392: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,

Line 1389: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,

1385: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
1386: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
1387: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
1388: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
1389: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
1390: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
1391: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
1392: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
1393: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,

Line 1390: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,

1386: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
1387: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
1388: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
1389: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
1390: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
1391: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
1392: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
1393: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
1394: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,

Line 1391: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,

1387: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
1388: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
1389: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
1390: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
1391: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
1392: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
1393: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
1394: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
1395: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,

Line 1392: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,

1388: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
1389: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
1390: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
1391: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
1392: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
1393: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
1394: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
1395: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
1396: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,

Line 1393: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,

1389: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
1390: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
1391: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
1392: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
1393: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
1394: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
1395: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
1396: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
1397: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,

Line 1394: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,

1390: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
1391: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
1392: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
1393: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
1394: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
1395: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
1396: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
1397: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
1398: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPe,

Line 1395: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,

1391: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
1392: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
1393: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
1394: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
1395: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
1396: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
1397: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
1398: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPe,
1399: p_Context IGC_CC_HEADERS_ALL.Context%TYPE,

Line 1396: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,

1392: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
1393: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
1394: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
1395: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
1396: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
1397: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
1398: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPe,
1399: p_Context IGC_CC_HEADERS_ALL.Context%TYPE,
1400: p_CC_Guarantee_Flag IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,

Line 1397: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,

1393: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
1394: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
1395: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
1396: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
1397: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
1398: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPe,
1399: p_Context IGC_CC_HEADERS_ALL.Context%TYPE,
1400: p_CC_Guarantee_Flag IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,
1401: G_FLAG IN OUT NOCOPY VARCHAR2

Line 1398: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPe,

1394: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
1395: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
1396: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
1397: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
1398: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPe,
1399: p_Context IGC_CC_HEADERS_ALL.Context%TYPE,
1400: p_CC_Guarantee_Flag IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,
1401: G_FLAG IN OUT NOCOPY VARCHAR2
1402: ) IS

Line 1399: p_Context IGC_CC_HEADERS_ALL.Context%TYPE,

1395: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
1396: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
1397: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
1398: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPe,
1399: p_Context IGC_CC_HEADERS_ALL.Context%TYPE,
1400: p_CC_Guarantee_Flag IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,
1401: G_FLAG IN OUT NOCOPY VARCHAR2
1402: ) IS
1403:

Line 1400: p_CC_Guarantee_Flag IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,

1396: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
1397: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
1398: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPe,
1399: p_Context IGC_CC_HEADERS_ALL.Context%TYPE,
1400: p_CC_Guarantee_Flag IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,
1401: G_FLAG IN OUT NOCOPY VARCHAR2
1402: ) IS
1403:
1404: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';

Line 1461: UPDATE IGC_CC_HEADERS_ALL

1457:
1458: -- --------------------------------------------------------------------------
1459: -- Update the CC Header Record
1460: -- --------------------------------------------------------------------------
1461: UPDATE IGC_CC_HEADERS_ALL
1462: SET CC_Header_Id = p_CC_Header_Id,
1463: Parent_Header_Id = p_Parent_Header_Id,
1464: Org_Id = p_Org_id,
1465: CC_Type = p_CC_Type,

Line 1713: p_CC_Header_Id IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,

1709: X_return_status OUT NOCOPY VARCHAR2,
1710: X_msg_count OUT NOCOPY NUMBER,
1711: X_msg_data OUT NOCOPY VARCHAR2,
1712: p_Rowid IN OUT NOCOPY VARCHAR2,
1713: p_CC_Header_Id IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,
1714: p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,
1715: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
1716: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
1717: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,

Line 1714: p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,

1710: X_msg_count OUT NOCOPY NUMBER,
1711: X_msg_data OUT NOCOPY VARCHAR2,
1712: p_Rowid IN OUT NOCOPY VARCHAR2,
1713: p_CC_Header_Id IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,
1714: p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,
1715: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
1716: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
1717: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
1718: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,

Line 1715: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,

1711: X_msg_data OUT NOCOPY VARCHAR2,
1712: p_Rowid IN OUT NOCOPY VARCHAR2,
1713: p_CC_Header_Id IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,
1714: p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,
1715: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
1716: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
1717: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
1718: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
1719: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,

Line 1716: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,

1712: p_Rowid IN OUT NOCOPY VARCHAR2,
1713: p_CC_Header_Id IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,
1714: p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,
1715: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
1716: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
1717: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
1718: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
1719: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
1720: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,

Line 1717: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,

1713: p_CC_Header_Id IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,
1714: p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,
1715: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
1716: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
1717: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
1718: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
1719: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
1720: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
1721: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,

Line 1718: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,

1714: p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,
1715: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
1716: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
1717: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
1718: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
1719: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
1720: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
1721: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
1722: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,

Line 1719: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,

1715: p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
1716: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
1717: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
1718: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
1719: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
1720: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
1721: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
1722: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
1723: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,

Line 1720: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,

1716: p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
1717: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
1718: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
1719: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
1720: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
1721: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
1722: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
1723: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
1724: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,

Line 1721: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,

1717: p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
1718: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
1719: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
1720: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
1721: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
1722: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
1723: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
1724: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
1725: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,

Line 1722: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,

1718: p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
1719: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
1720: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
1721: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
1722: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
1723: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
1724: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
1725: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
1726: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,

Line 1723: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,

1719: p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
1720: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
1721: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
1722: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
1723: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
1724: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
1725: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
1726: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
1727: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,

Line 1724: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,

1720: p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
1721: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
1722: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
1723: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
1724: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
1725: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
1726: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
1727: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
1728: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,

Line 1725: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,

1721: p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
1722: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
1723: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
1724: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
1725: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
1726: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
1727: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
1728: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
1729: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,

Line 1726: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,

1722: p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
1723: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
1724: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
1725: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
1726: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
1727: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
1728: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
1729: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
1730: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,

Line 1727: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,

1723: p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
1724: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
1725: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
1726: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
1727: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
1728: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
1729: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
1730: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
1731: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,

Line 1728: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,

1724: p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
1725: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
1726: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
1727: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
1728: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
1729: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
1730: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
1731: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
1732: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,

Line 1729: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,

1725: p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
1726: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
1727: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
1728: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
1729: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
1730: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
1731: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
1732: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
1733: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,

Line 1730: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,

1726: p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
1727: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
1728: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
1729: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
1730: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
1731: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
1732: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
1733: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
1734: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,

Line 1731: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,

1727: p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
1728: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
1729: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
1730: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
1731: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
1732: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
1733: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
1734: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
1735: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,

Line 1732: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,

1728: p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
1729: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
1730: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
1731: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
1732: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
1733: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
1734: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
1735: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
1736: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,

Line 1733: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,

1729: p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
1730: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
1731: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
1732: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
1733: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
1734: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
1735: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
1736: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
1737: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,

Line 1734: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,

1730: p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
1731: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
1732: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
1733: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
1734: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
1735: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
1736: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
1737: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
1738: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,

Line 1735: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,

1731: p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
1732: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
1733: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
1734: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
1735: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
1736: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
1737: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
1738: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
1739: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,

Line 1736: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,

1732: p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
1733: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
1734: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
1735: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
1736: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
1737: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
1738: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
1739: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
1740: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,

Line 1737: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,

1733: p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
1734: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
1735: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
1736: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
1737: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
1738: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
1739: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
1740: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
1741: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,

Line 1738: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,

1734: p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
1735: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
1736: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
1737: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
1738: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
1739: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
1740: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
1741: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
1742: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,

Line 1739: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,

1735: p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
1736: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
1737: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
1738: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
1739: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
1740: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
1741: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
1742: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
1743: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,

Line 1740: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,

1736: p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
1737: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
1738: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
1739: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
1740: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
1741: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
1742: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
1743: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
1744: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,

Line 1741: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,

1737: p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
1738: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
1739: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
1740: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
1741: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
1742: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
1743: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
1744: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
1745: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,

Line 1742: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,

1738: p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
1739: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
1740: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
1741: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
1742: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
1743: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
1744: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
1745: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
1746: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,

Line 1743: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,

1739: p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
1740: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
1741: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
1742: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
1743: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
1744: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
1745: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
1746: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
1747: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,

Line 1744: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,

1740: p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
1741: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
1742: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
1743: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
1744: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
1745: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
1746: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
1747: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
1748: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,

Line 1745: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,

1741: p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
1742: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
1743: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
1744: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
1745: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
1746: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
1747: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
1748: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
1749: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,

Line 1746: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,

1742: p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
1743: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
1744: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
1745: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
1746: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
1747: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
1748: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
1749: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
1750: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,

Line 1747: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,

1743: p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
1744: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
1745: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
1746: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
1747: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
1748: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
1749: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
1750: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
1751: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,

Line 1748: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,

1744: p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
1745: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
1746: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
1747: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
1748: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
1749: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
1750: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
1751: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
1752: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,

Line 1749: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,

1745: p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
1746: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
1747: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
1748: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
1749: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
1750: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
1751: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
1752: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
1753: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,

Line 1750: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,

1746: p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
1747: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
1748: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
1749: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
1750: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
1751: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
1752: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
1753: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
1754: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,

Line 1751: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,

1747: p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
1748: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
1749: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
1750: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
1751: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
1752: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
1753: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
1754: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
1755: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,

Line 1752: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,

1748: p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
1749: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
1750: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
1751: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
1752: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
1753: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
1754: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
1755: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
1756: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,

Line 1753: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,

1749: p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
1750: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
1751: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
1752: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
1753: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
1754: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
1755: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
1756: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
1757: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,

Line 1754: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,

1750: p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
1751: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
1752: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
1753: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
1754: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
1755: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
1756: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
1757: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
1758: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,

Line 1755: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,

1751: p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
1752: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
1753: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
1754: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
1755: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
1756: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
1757: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
1758: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
1759: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,

Line 1756: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,

1752: p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
1753: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
1754: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
1755: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
1756: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
1757: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
1758: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
1759: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
1760: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,

Line 1757: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,

1753: p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
1754: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
1755: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
1756: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
1757: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
1758: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
1759: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
1760: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
1761: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPe,

Line 1758: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,

1754: p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
1755: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
1756: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
1757: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
1758: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
1759: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
1760: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
1761: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPe,
1762: p_Context IGC_CC_HEADERS_ALL.Context%TYPE,

Line 1759: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,

1755: p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
1756: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
1757: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
1758: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
1759: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
1760: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
1761: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPe,
1762: p_Context IGC_CC_HEADERS_ALL.Context%TYPE,
1763: p_CC_Guarantee_Flag IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,

Line 1760: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,

1756: p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
1757: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
1758: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
1759: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
1760: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
1761: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPe,
1762: p_Context IGC_CC_HEADERS_ALL.Context%TYPE,
1763: p_CC_Guarantee_Flag IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,
1764: G_FLAG IN OUT NOCOPY VARCHAR2

Line 1761: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPe,

1757: p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
1758: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
1759: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
1760: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
1761: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPe,
1762: p_Context IGC_CC_HEADERS_ALL.Context%TYPE,
1763: p_CC_Guarantee_Flag IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,
1764: G_FLAG IN OUT NOCOPY VARCHAR2
1765: ) IS

Line 1762: p_Context IGC_CC_HEADERS_ALL.Context%TYPE,

1758: p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
1759: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
1760: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
1761: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPe,
1762: p_Context IGC_CC_HEADERS_ALL.Context%TYPE,
1763: p_CC_Guarantee_Flag IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,
1764: G_FLAG IN OUT NOCOPY VARCHAR2
1765: ) IS
1766:

Line 1763: p_CC_Guarantee_Flag IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,

1759: p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
1760: p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
1761: p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPe,
1762: p_Context IGC_CC_HEADERS_ALL.Context%TYPE,
1763: p_CC_Guarantee_Flag IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,
1764: G_FLAG IN OUT NOCOPY VARCHAR2
1765: ) IS
1766:
1767: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';

Line 1824: UPDATE IGC_CC_HEADERS_ALL

1820:
1821: -- --------------------------------------------------------------------------
1822: -- Update the CC Header Record
1823: -- --------------------------------------------------------------------------
1824: UPDATE IGC_CC_HEADERS_ALL
1825: SET CC_Header_Id = p_CC_Header_Id,
1826: Parent_Header_Id = p_Parent_Header_Id,
1827: Org_Id = p_Org_id,
1828: CC_Type = p_CC_Type,

Line 2083: l_version_num IGC_CC_HEADERS_ALL.CC_Version_Num%TYPE;

2079: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Row';
2080: l_api_version CONSTANT NUMBER := 1.0;
2081: l_msg_count NUMBER ;
2082: l_msg_data VARCHAR2(2000) ;
2083: l_version_num IGC_CC_HEADERS_ALL.CC_Version_Num%TYPE;
2084: l_header_row_id Varchar2(18);
2085: l_return_status VARCHAR2(1);
2086: l_action_flag VARCHAR2(1) := 'D';
2087: -- l_debug VARCHAR2(1);

Line 2096: FROM IGC_CC_HEADERS_ALL

2092: l_bc_success BOOLEAN;
2093:
2094: CURSOR c_cc_header_row_id IS
2095: SELECT *
2096: FROM IGC_CC_HEADERS_ALL
2097: WHERE Rowid = p_Rowid;
2098:
2099: Recinfo c_cc_header_row_id%ROWTYPE;
2100:

Line 2477: FROM IGC_CC_HEADERS_ALL

2473: -- --------------------------------------------------------------------
2474: -- Delete all Header records for related CC Header IDs.
2475: -- --------------------------------------------------------------------
2476: DELETE
2477: FROM IGC_CC_HEADERS_ALL
2478: WHERE cc_header_id = Recinfo.cc_header_id;
2479:
2480: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
2481: IF g_debug_mode = 'Y' THEN