1: PACKAGE BODY IGC_CC_ACCT_LINE_HISTORY_PKG as
2: /* $Header: IGCCALHB.pls 120.3.12000000.4 2007/10/19 07:23:49 smannava ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IGC_CC_ACCT_LINE_HISTORY_PKG';
5: g_debug_flag VARCHAR2(1) := 'N' ;
1: PACKAGE BODY IGC_CC_ACCT_LINE_HISTORY_PKG as
2: /* $Header: IGCCALHB.pls 120.3.12000000.4 2007/10/19 07:23:49 smannava ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IGC_CC_ACCT_LINE_HISTORY_PKG';
5: g_debug_flag VARCHAR2(1) := 'N' ;
6:
7:
8:
19: X_return_status OUT NOCOPY VARCHAR2,
20: X_msg_count OUT NOCOPY NUMBER,
21: X_msg_data OUT NOCOPY VARCHAR2,
22: p_Rowid IN OUT NOCOPY VARCHAR2,
23: p_CC_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
24: p_CC_Header_Id IGC_CC_ACCT_LINE_HISTORY.CC_Header_Id%TYPE,
25: p_Parent_Header_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Header_Id%TYPE,
26: p_Parent_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Acct_Line_Id%TYPE,
27: p_CC_Acct_Line_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Num%TYPE,
20: X_msg_count OUT NOCOPY NUMBER,
21: X_msg_data OUT NOCOPY VARCHAR2,
22: p_Rowid IN OUT NOCOPY VARCHAR2,
23: p_CC_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
24: p_CC_Header_Id IGC_CC_ACCT_LINE_HISTORY.CC_Header_Id%TYPE,
25: p_Parent_Header_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Header_Id%TYPE,
26: p_Parent_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Acct_Line_Id%TYPE,
27: p_CC_Acct_Line_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Num%TYPE,
28: p_CC_Acct_Version_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Num%TYPE,
21: X_msg_data OUT NOCOPY VARCHAR2,
22: p_Rowid IN OUT NOCOPY VARCHAR2,
23: p_CC_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
24: p_CC_Header_Id IGC_CC_ACCT_LINE_HISTORY.CC_Header_Id%TYPE,
25: p_Parent_Header_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Header_Id%TYPE,
26: p_Parent_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Acct_Line_Id%TYPE,
27: p_CC_Acct_Line_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Num%TYPE,
28: p_CC_Acct_Version_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Num%TYPE,
29: p_CC_Acct_Version_Action IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Action%TYPE,
22: p_Rowid IN OUT NOCOPY VARCHAR2,
23: p_CC_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
24: p_CC_Header_Id IGC_CC_ACCT_LINE_HISTORY.CC_Header_Id%TYPE,
25: p_Parent_Header_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Header_Id%TYPE,
26: p_Parent_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Acct_Line_Id%TYPE,
27: p_CC_Acct_Line_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Num%TYPE,
28: p_CC_Acct_Version_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Num%TYPE,
29: p_CC_Acct_Version_Action IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Action%TYPE,
30: p_CC_Charge_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Charge_Code_Combination_Id%TYPE,
23: p_CC_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
24: p_CC_Header_Id IGC_CC_ACCT_LINE_HISTORY.CC_Header_Id%TYPE,
25: p_Parent_Header_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Header_Id%TYPE,
26: p_Parent_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Acct_Line_Id%TYPE,
27: p_CC_Acct_Line_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Num%TYPE,
28: p_CC_Acct_Version_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Num%TYPE,
29: p_CC_Acct_Version_Action IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Action%TYPE,
30: p_CC_Charge_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Charge_Code_Combination_Id%TYPE,
31: p_CC_Budget_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Budget_Code_Combination_Id%TYPE,
24: p_CC_Header_Id IGC_CC_ACCT_LINE_HISTORY.CC_Header_Id%TYPE,
25: p_Parent_Header_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Header_Id%TYPE,
26: p_Parent_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Acct_Line_Id%TYPE,
27: p_CC_Acct_Line_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Num%TYPE,
28: p_CC_Acct_Version_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Num%TYPE,
29: p_CC_Acct_Version_Action IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Action%TYPE,
30: p_CC_Charge_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Charge_Code_Combination_Id%TYPE,
31: p_CC_Budget_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Budget_Code_Combination_Id%TYPE,
32: p_CC_Acct_Entered_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Entered_Amt%TYPE,
25: p_Parent_Header_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Header_Id%TYPE,
26: p_Parent_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Acct_Line_Id%TYPE,
27: p_CC_Acct_Line_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Num%TYPE,
28: p_CC_Acct_Version_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Num%TYPE,
29: p_CC_Acct_Version_Action IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Action%TYPE,
30: p_CC_Charge_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Charge_Code_Combination_Id%TYPE,
31: p_CC_Budget_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Budget_Code_Combination_Id%TYPE,
32: p_CC_Acct_Entered_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Entered_Amt%TYPE,
33: p_CC_Acct_Func_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
26: p_Parent_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Acct_Line_Id%TYPE,
27: p_CC_Acct_Line_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Num%TYPE,
28: p_CC_Acct_Version_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Num%TYPE,
29: p_CC_Acct_Version_Action IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Action%TYPE,
30: p_CC_Charge_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Charge_Code_Combination_Id%TYPE,
31: p_CC_Budget_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Budget_Code_Combination_Id%TYPE,
32: p_CC_Acct_Entered_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Entered_Amt%TYPE,
33: p_CC_Acct_Func_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
34: p_CC_Acct_Desc IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Desc%TYPE,
27: p_CC_Acct_Line_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Num%TYPE,
28: p_CC_Acct_Version_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Num%TYPE,
29: p_CC_Acct_Version_Action IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Action%TYPE,
30: p_CC_Charge_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Charge_Code_Combination_Id%TYPE,
31: p_CC_Budget_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Budget_Code_Combination_Id%TYPE,
32: p_CC_Acct_Entered_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Entered_Amt%TYPE,
33: p_CC_Acct_Func_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
34: p_CC_Acct_Desc IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Desc%TYPE,
35: p_CC_Acct_Billed_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Billed_Amt%TYPE,
28: p_CC_Acct_Version_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Num%TYPE,
29: p_CC_Acct_Version_Action IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Action%TYPE,
30: p_CC_Charge_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Charge_Code_Combination_Id%TYPE,
31: p_CC_Budget_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Budget_Code_Combination_Id%TYPE,
32: p_CC_Acct_Entered_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Entered_Amt%TYPE,
33: p_CC_Acct_Func_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
34: p_CC_Acct_Desc IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Desc%TYPE,
35: p_CC_Acct_Billed_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Billed_Amt%TYPE,
36: p_CC_Acct_Unbilled_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Unbilled_Amt%TYPE,
29: p_CC_Acct_Version_Action IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Action%TYPE,
30: p_CC_Charge_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Charge_Code_Combination_Id%TYPE,
31: p_CC_Budget_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Budget_Code_Combination_Id%TYPE,
32: p_CC_Acct_Entered_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Entered_Amt%TYPE,
33: p_CC_Acct_Func_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
34: p_CC_Acct_Desc IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Desc%TYPE,
35: p_CC_Acct_Billed_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Billed_Amt%TYPE,
36: p_CC_Acct_Unbilled_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Unbilled_Amt%TYPE,
37: p_CC_Acct_Taxable_Flag IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Taxable_Flag%TYPE,
30: p_CC_Charge_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Charge_Code_Combination_Id%TYPE,
31: p_CC_Budget_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Budget_Code_Combination_Id%TYPE,
32: p_CC_Acct_Entered_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Entered_Amt%TYPE,
33: p_CC_Acct_Func_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
34: p_CC_Acct_Desc IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Desc%TYPE,
35: p_CC_Acct_Billed_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Billed_Amt%TYPE,
36: p_CC_Acct_Unbilled_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Unbilled_Amt%TYPE,
37: p_CC_Acct_Taxable_Flag IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Taxable_Flag%TYPE,
38: p_Tax_Id IGC_CC_ACCT_LINE_HISTORY.Tax_Id%TYPE,
31: p_CC_Budget_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Budget_Code_Combination_Id%TYPE,
32: p_CC_Acct_Entered_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Entered_Amt%TYPE,
33: p_CC_Acct_Func_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
34: p_CC_Acct_Desc IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Desc%TYPE,
35: p_CC_Acct_Billed_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Billed_Amt%TYPE,
36: p_CC_Acct_Unbilled_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Unbilled_Amt%TYPE,
37: p_CC_Acct_Taxable_Flag IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Taxable_Flag%TYPE,
38: p_Tax_Id IGC_CC_ACCT_LINE_HISTORY.Tax_Id%TYPE,
39: p_CC_Acct_Encmbrnc_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
32: p_CC_Acct_Entered_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Entered_Amt%TYPE,
33: p_CC_Acct_Func_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
34: p_CC_Acct_Desc IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Desc%TYPE,
35: p_CC_Acct_Billed_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Billed_Amt%TYPE,
36: p_CC_Acct_Unbilled_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Unbilled_Amt%TYPE,
37: p_CC_Acct_Taxable_Flag IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Taxable_Flag%TYPE,
38: p_Tax_Id IGC_CC_ACCT_LINE_HISTORY.Tax_Id%TYPE,
39: p_CC_Acct_Encmbrnc_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
40: p_CC_Acct_Encmbrnc_Date IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Date%TYPE,
33: p_CC_Acct_Func_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
34: p_CC_Acct_Desc IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Desc%TYPE,
35: p_CC_Acct_Billed_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Billed_Amt%TYPE,
36: p_CC_Acct_Unbilled_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Unbilled_Amt%TYPE,
37: p_CC_Acct_Taxable_Flag IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Taxable_Flag%TYPE,
38: p_Tax_Id IGC_CC_ACCT_LINE_HISTORY.Tax_Id%TYPE,
39: p_CC_Acct_Encmbrnc_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
40: p_CC_Acct_Encmbrnc_Date IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Date%TYPE,
41: p_CC_Acct_Encmbrnc_Status IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Status%TYPE,
34: p_CC_Acct_Desc IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Desc%TYPE,
35: p_CC_Acct_Billed_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Billed_Amt%TYPE,
36: p_CC_Acct_Unbilled_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Unbilled_Amt%TYPE,
37: p_CC_Acct_Taxable_Flag IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Taxable_Flag%TYPE,
38: p_Tax_Id IGC_CC_ACCT_LINE_HISTORY.Tax_Id%TYPE,
39: p_CC_Acct_Encmbrnc_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
40: p_CC_Acct_Encmbrnc_Date IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Date%TYPE,
41: p_CC_Acct_Encmbrnc_Status IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Status%TYPE,
42: p_Project_Id IGC_CC_ACCT_LINE_HISTORY.Project_Id%TYPE,
35: p_CC_Acct_Billed_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Billed_Amt%TYPE,
36: p_CC_Acct_Unbilled_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Unbilled_Amt%TYPE,
37: p_CC_Acct_Taxable_Flag IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Taxable_Flag%TYPE,
38: p_Tax_Id IGC_CC_ACCT_LINE_HISTORY.Tax_Id%TYPE,
39: p_CC_Acct_Encmbrnc_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
40: p_CC_Acct_Encmbrnc_Date IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Date%TYPE,
41: p_CC_Acct_Encmbrnc_Status IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Status%TYPE,
42: p_Project_Id IGC_CC_ACCT_LINE_HISTORY.Project_Id%TYPE,
43: p_Task_Id IGC_CC_ACCT_LINE_HISTORY.Task_Id%TYPE,
36: p_CC_Acct_Unbilled_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Unbilled_Amt%TYPE,
37: p_CC_Acct_Taxable_Flag IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Taxable_Flag%TYPE,
38: p_Tax_Id IGC_CC_ACCT_LINE_HISTORY.Tax_Id%TYPE,
39: p_CC_Acct_Encmbrnc_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
40: p_CC_Acct_Encmbrnc_Date IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Date%TYPE,
41: p_CC_Acct_Encmbrnc_Status IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Status%TYPE,
42: p_Project_Id IGC_CC_ACCT_LINE_HISTORY.Project_Id%TYPE,
43: p_Task_Id IGC_CC_ACCT_LINE_HISTORY.Task_Id%TYPE,
44: p_Expenditure_Type IGC_CC_ACCT_LINE_HISTORY.Expenditure_Type%TYPE,
37: p_CC_Acct_Taxable_Flag IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Taxable_Flag%TYPE,
38: p_Tax_Id IGC_CC_ACCT_LINE_HISTORY.Tax_Id%TYPE,
39: p_CC_Acct_Encmbrnc_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
40: p_CC_Acct_Encmbrnc_Date IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Date%TYPE,
41: p_CC_Acct_Encmbrnc_Status IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Status%TYPE,
42: p_Project_Id IGC_CC_ACCT_LINE_HISTORY.Project_Id%TYPE,
43: p_Task_Id IGC_CC_ACCT_LINE_HISTORY.Task_Id%TYPE,
44: p_Expenditure_Type IGC_CC_ACCT_LINE_HISTORY.Expenditure_Type%TYPE,
45: p_Expenditure_Org_Id IGC_CC_ACCT_LINE_HISTORY.Expenditure_Org_Id%TYPE,
38: p_Tax_Id IGC_CC_ACCT_LINE_HISTORY.Tax_Id%TYPE,
39: p_CC_Acct_Encmbrnc_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
40: p_CC_Acct_Encmbrnc_Date IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Date%TYPE,
41: p_CC_Acct_Encmbrnc_Status IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Status%TYPE,
42: p_Project_Id IGC_CC_ACCT_LINE_HISTORY.Project_Id%TYPE,
43: p_Task_Id IGC_CC_ACCT_LINE_HISTORY.Task_Id%TYPE,
44: p_Expenditure_Type IGC_CC_ACCT_LINE_HISTORY.Expenditure_Type%TYPE,
45: p_Expenditure_Org_Id IGC_CC_ACCT_LINE_HISTORY.Expenditure_Org_Id%TYPE,
46: p_Expenditure_Item_Date IGC_CC_ACCT_LINE_HISTORY.Expenditure_Item_Date%TYPE,
39: p_CC_Acct_Encmbrnc_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
40: p_CC_Acct_Encmbrnc_Date IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Date%TYPE,
41: p_CC_Acct_Encmbrnc_Status IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Status%TYPE,
42: p_Project_Id IGC_CC_ACCT_LINE_HISTORY.Project_Id%TYPE,
43: p_Task_Id IGC_CC_ACCT_LINE_HISTORY.Task_Id%TYPE,
44: p_Expenditure_Type IGC_CC_ACCT_LINE_HISTORY.Expenditure_Type%TYPE,
45: p_Expenditure_Org_Id IGC_CC_ACCT_LINE_HISTORY.Expenditure_Org_Id%TYPE,
46: p_Expenditure_Item_Date IGC_CC_ACCT_LINE_HISTORY.Expenditure_Item_Date%TYPE,
47: p_Last_Update_Date IGC_CC_ACCT_LINE_HISTORY.Last_Update_Date%TYPE,
40: p_CC_Acct_Encmbrnc_Date IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Date%TYPE,
41: p_CC_Acct_Encmbrnc_Status IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Status%TYPE,
42: p_Project_Id IGC_CC_ACCT_LINE_HISTORY.Project_Id%TYPE,
43: p_Task_Id IGC_CC_ACCT_LINE_HISTORY.Task_Id%TYPE,
44: p_Expenditure_Type IGC_CC_ACCT_LINE_HISTORY.Expenditure_Type%TYPE,
45: p_Expenditure_Org_Id IGC_CC_ACCT_LINE_HISTORY.Expenditure_Org_Id%TYPE,
46: p_Expenditure_Item_Date IGC_CC_ACCT_LINE_HISTORY.Expenditure_Item_Date%TYPE,
47: p_Last_Update_Date IGC_CC_ACCT_LINE_HISTORY.Last_Update_Date%TYPE,
48: p_Last_Updated_By IGC_CC_ACCT_LINE_HISTORY.Last_Updated_By%TYPE,
41: p_CC_Acct_Encmbrnc_Status IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Status%TYPE,
42: p_Project_Id IGC_CC_ACCT_LINE_HISTORY.Project_Id%TYPE,
43: p_Task_Id IGC_CC_ACCT_LINE_HISTORY.Task_Id%TYPE,
44: p_Expenditure_Type IGC_CC_ACCT_LINE_HISTORY.Expenditure_Type%TYPE,
45: p_Expenditure_Org_Id IGC_CC_ACCT_LINE_HISTORY.Expenditure_Org_Id%TYPE,
46: p_Expenditure_Item_Date IGC_CC_ACCT_LINE_HISTORY.Expenditure_Item_Date%TYPE,
47: p_Last_Update_Date IGC_CC_ACCT_LINE_HISTORY.Last_Update_Date%TYPE,
48: p_Last_Updated_By IGC_CC_ACCT_LINE_HISTORY.Last_Updated_By%TYPE,
49: p_Last_Update_Login IGC_CC_ACCT_LINE_HISTORY.Last_Update_Login%TYPE,
42: p_Project_Id IGC_CC_ACCT_LINE_HISTORY.Project_Id%TYPE,
43: p_Task_Id IGC_CC_ACCT_LINE_HISTORY.Task_Id%TYPE,
44: p_Expenditure_Type IGC_CC_ACCT_LINE_HISTORY.Expenditure_Type%TYPE,
45: p_Expenditure_Org_Id IGC_CC_ACCT_LINE_HISTORY.Expenditure_Org_Id%TYPE,
46: p_Expenditure_Item_Date IGC_CC_ACCT_LINE_HISTORY.Expenditure_Item_Date%TYPE,
47: p_Last_Update_Date IGC_CC_ACCT_LINE_HISTORY.Last_Update_Date%TYPE,
48: p_Last_Updated_By IGC_CC_ACCT_LINE_HISTORY.Last_Updated_By%TYPE,
49: p_Last_Update_Login IGC_CC_ACCT_LINE_HISTORY.Last_Update_Login%TYPE,
50: p_Creation_Date IGC_CC_ACCT_LINE_HISTORY.Creation_Date%TYPE,
43: p_Task_Id IGC_CC_ACCT_LINE_HISTORY.Task_Id%TYPE,
44: p_Expenditure_Type IGC_CC_ACCT_LINE_HISTORY.Expenditure_Type%TYPE,
45: p_Expenditure_Org_Id IGC_CC_ACCT_LINE_HISTORY.Expenditure_Org_Id%TYPE,
46: p_Expenditure_Item_Date IGC_CC_ACCT_LINE_HISTORY.Expenditure_Item_Date%TYPE,
47: p_Last_Update_Date IGC_CC_ACCT_LINE_HISTORY.Last_Update_Date%TYPE,
48: p_Last_Updated_By IGC_CC_ACCT_LINE_HISTORY.Last_Updated_By%TYPE,
49: p_Last_Update_Login IGC_CC_ACCT_LINE_HISTORY.Last_Update_Login%TYPE,
50: p_Creation_Date IGC_CC_ACCT_LINE_HISTORY.Creation_Date%TYPE,
51: p_Created_By IGC_CC_ACCT_LINE_HISTORY.Created_By%TYPE,
44: p_Expenditure_Type IGC_CC_ACCT_LINE_HISTORY.Expenditure_Type%TYPE,
45: p_Expenditure_Org_Id IGC_CC_ACCT_LINE_HISTORY.Expenditure_Org_Id%TYPE,
46: p_Expenditure_Item_Date IGC_CC_ACCT_LINE_HISTORY.Expenditure_Item_Date%TYPE,
47: p_Last_Update_Date IGC_CC_ACCT_LINE_HISTORY.Last_Update_Date%TYPE,
48: p_Last_Updated_By IGC_CC_ACCT_LINE_HISTORY.Last_Updated_By%TYPE,
49: p_Last_Update_Login IGC_CC_ACCT_LINE_HISTORY.Last_Update_Login%TYPE,
50: p_Creation_Date IGC_CC_ACCT_LINE_HISTORY.Creation_Date%TYPE,
51: p_Created_By IGC_CC_ACCT_LINE_HISTORY.Created_By%TYPE,
52: p_Attribute1 IGC_CC_ACCT_LINE_HISTORY.Attribute1%TYPE,
45: p_Expenditure_Org_Id IGC_CC_ACCT_LINE_HISTORY.Expenditure_Org_Id%TYPE,
46: p_Expenditure_Item_Date IGC_CC_ACCT_LINE_HISTORY.Expenditure_Item_Date%TYPE,
47: p_Last_Update_Date IGC_CC_ACCT_LINE_HISTORY.Last_Update_Date%TYPE,
48: p_Last_Updated_By IGC_CC_ACCT_LINE_HISTORY.Last_Updated_By%TYPE,
49: p_Last_Update_Login IGC_CC_ACCT_LINE_HISTORY.Last_Update_Login%TYPE,
50: p_Creation_Date IGC_CC_ACCT_LINE_HISTORY.Creation_Date%TYPE,
51: p_Created_By IGC_CC_ACCT_LINE_HISTORY.Created_By%TYPE,
52: p_Attribute1 IGC_CC_ACCT_LINE_HISTORY.Attribute1%TYPE,
53: p_Attribute2 IGC_CC_ACCT_LINE_HISTORY.Attribute2%TYPE,
46: p_Expenditure_Item_Date IGC_CC_ACCT_LINE_HISTORY.Expenditure_Item_Date%TYPE,
47: p_Last_Update_Date IGC_CC_ACCT_LINE_HISTORY.Last_Update_Date%TYPE,
48: p_Last_Updated_By IGC_CC_ACCT_LINE_HISTORY.Last_Updated_By%TYPE,
49: p_Last_Update_Login IGC_CC_ACCT_LINE_HISTORY.Last_Update_Login%TYPE,
50: p_Creation_Date IGC_CC_ACCT_LINE_HISTORY.Creation_Date%TYPE,
51: p_Created_By IGC_CC_ACCT_LINE_HISTORY.Created_By%TYPE,
52: p_Attribute1 IGC_CC_ACCT_LINE_HISTORY.Attribute1%TYPE,
53: p_Attribute2 IGC_CC_ACCT_LINE_HISTORY.Attribute2%TYPE,
54: p_Attribute3 IGC_CC_ACCT_LINE_HISTORY.Attribute3%TYPE,
47: p_Last_Update_Date IGC_CC_ACCT_LINE_HISTORY.Last_Update_Date%TYPE,
48: p_Last_Updated_By IGC_CC_ACCT_LINE_HISTORY.Last_Updated_By%TYPE,
49: p_Last_Update_Login IGC_CC_ACCT_LINE_HISTORY.Last_Update_Login%TYPE,
50: p_Creation_Date IGC_CC_ACCT_LINE_HISTORY.Creation_Date%TYPE,
51: p_Created_By IGC_CC_ACCT_LINE_HISTORY.Created_By%TYPE,
52: p_Attribute1 IGC_CC_ACCT_LINE_HISTORY.Attribute1%TYPE,
53: p_Attribute2 IGC_CC_ACCT_LINE_HISTORY.Attribute2%TYPE,
54: p_Attribute3 IGC_CC_ACCT_LINE_HISTORY.Attribute3%TYPE,
55: p_Attribute4 IGC_CC_ACCT_LINE_HISTORY.Attribute4%TYPE,
48: p_Last_Updated_By IGC_CC_ACCT_LINE_HISTORY.Last_Updated_By%TYPE,
49: p_Last_Update_Login IGC_CC_ACCT_LINE_HISTORY.Last_Update_Login%TYPE,
50: p_Creation_Date IGC_CC_ACCT_LINE_HISTORY.Creation_Date%TYPE,
51: p_Created_By IGC_CC_ACCT_LINE_HISTORY.Created_By%TYPE,
52: p_Attribute1 IGC_CC_ACCT_LINE_HISTORY.Attribute1%TYPE,
53: p_Attribute2 IGC_CC_ACCT_LINE_HISTORY.Attribute2%TYPE,
54: p_Attribute3 IGC_CC_ACCT_LINE_HISTORY.Attribute3%TYPE,
55: p_Attribute4 IGC_CC_ACCT_LINE_HISTORY.Attribute4%TYPE,
56: p_Attribute5 IGC_CC_ACCT_LINE_HISTORY.Attribute5%TYPE,
49: p_Last_Update_Login IGC_CC_ACCT_LINE_HISTORY.Last_Update_Login%TYPE,
50: p_Creation_Date IGC_CC_ACCT_LINE_HISTORY.Creation_Date%TYPE,
51: p_Created_By IGC_CC_ACCT_LINE_HISTORY.Created_By%TYPE,
52: p_Attribute1 IGC_CC_ACCT_LINE_HISTORY.Attribute1%TYPE,
53: p_Attribute2 IGC_CC_ACCT_LINE_HISTORY.Attribute2%TYPE,
54: p_Attribute3 IGC_CC_ACCT_LINE_HISTORY.Attribute3%TYPE,
55: p_Attribute4 IGC_CC_ACCT_LINE_HISTORY.Attribute4%TYPE,
56: p_Attribute5 IGC_CC_ACCT_LINE_HISTORY.Attribute5%TYPE,
57: p_Attribute6 IGC_CC_ACCT_LINE_HISTORY.Attribute6%TYPE,
50: p_Creation_Date IGC_CC_ACCT_LINE_HISTORY.Creation_Date%TYPE,
51: p_Created_By IGC_CC_ACCT_LINE_HISTORY.Created_By%TYPE,
52: p_Attribute1 IGC_CC_ACCT_LINE_HISTORY.Attribute1%TYPE,
53: p_Attribute2 IGC_CC_ACCT_LINE_HISTORY.Attribute2%TYPE,
54: p_Attribute3 IGC_CC_ACCT_LINE_HISTORY.Attribute3%TYPE,
55: p_Attribute4 IGC_CC_ACCT_LINE_HISTORY.Attribute4%TYPE,
56: p_Attribute5 IGC_CC_ACCT_LINE_HISTORY.Attribute5%TYPE,
57: p_Attribute6 IGC_CC_ACCT_LINE_HISTORY.Attribute6%TYPE,
58: p_Attribute7 IGC_CC_ACCT_LINE_HISTORY.Attribute7%TYPE,
51: p_Created_By IGC_CC_ACCT_LINE_HISTORY.Created_By%TYPE,
52: p_Attribute1 IGC_CC_ACCT_LINE_HISTORY.Attribute1%TYPE,
53: p_Attribute2 IGC_CC_ACCT_LINE_HISTORY.Attribute2%TYPE,
54: p_Attribute3 IGC_CC_ACCT_LINE_HISTORY.Attribute3%TYPE,
55: p_Attribute4 IGC_CC_ACCT_LINE_HISTORY.Attribute4%TYPE,
56: p_Attribute5 IGC_CC_ACCT_LINE_HISTORY.Attribute5%TYPE,
57: p_Attribute6 IGC_CC_ACCT_LINE_HISTORY.Attribute6%TYPE,
58: p_Attribute7 IGC_CC_ACCT_LINE_HISTORY.Attribute7%TYPE,
59: p_Attribute8 IGC_CC_ACCT_LINE_HISTORY.Attribute8%TYPE,
52: p_Attribute1 IGC_CC_ACCT_LINE_HISTORY.Attribute1%TYPE,
53: p_Attribute2 IGC_CC_ACCT_LINE_HISTORY.Attribute2%TYPE,
54: p_Attribute3 IGC_CC_ACCT_LINE_HISTORY.Attribute3%TYPE,
55: p_Attribute4 IGC_CC_ACCT_LINE_HISTORY.Attribute4%TYPE,
56: p_Attribute5 IGC_CC_ACCT_LINE_HISTORY.Attribute5%TYPE,
57: p_Attribute6 IGC_CC_ACCT_LINE_HISTORY.Attribute6%TYPE,
58: p_Attribute7 IGC_CC_ACCT_LINE_HISTORY.Attribute7%TYPE,
59: p_Attribute8 IGC_CC_ACCT_LINE_HISTORY.Attribute8%TYPE,
60: p_Attribute9 IGC_CC_ACCT_LINE_HISTORY.Attribute9%TYPE,
53: p_Attribute2 IGC_CC_ACCT_LINE_HISTORY.Attribute2%TYPE,
54: p_Attribute3 IGC_CC_ACCT_LINE_HISTORY.Attribute3%TYPE,
55: p_Attribute4 IGC_CC_ACCT_LINE_HISTORY.Attribute4%TYPE,
56: p_Attribute5 IGC_CC_ACCT_LINE_HISTORY.Attribute5%TYPE,
57: p_Attribute6 IGC_CC_ACCT_LINE_HISTORY.Attribute6%TYPE,
58: p_Attribute7 IGC_CC_ACCT_LINE_HISTORY.Attribute7%TYPE,
59: p_Attribute8 IGC_CC_ACCT_LINE_HISTORY.Attribute8%TYPE,
60: p_Attribute9 IGC_CC_ACCT_LINE_HISTORY.Attribute9%TYPE,
61: p_Attribute10 IGC_CC_ACCT_LINE_HISTORY.Attribute10%TYPE,
54: p_Attribute3 IGC_CC_ACCT_LINE_HISTORY.Attribute3%TYPE,
55: p_Attribute4 IGC_CC_ACCT_LINE_HISTORY.Attribute4%TYPE,
56: p_Attribute5 IGC_CC_ACCT_LINE_HISTORY.Attribute5%TYPE,
57: p_Attribute6 IGC_CC_ACCT_LINE_HISTORY.Attribute6%TYPE,
58: p_Attribute7 IGC_CC_ACCT_LINE_HISTORY.Attribute7%TYPE,
59: p_Attribute8 IGC_CC_ACCT_LINE_HISTORY.Attribute8%TYPE,
60: p_Attribute9 IGC_CC_ACCT_LINE_HISTORY.Attribute9%TYPE,
61: p_Attribute10 IGC_CC_ACCT_LINE_HISTORY.Attribute10%TYPE,
62: p_Attribute11 IGC_CC_ACCT_LINE_HISTORY.Attribute11%TYPE,
55: p_Attribute4 IGC_CC_ACCT_LINE_HISTORY.Attribute4%TYPE,
56: p_Attribute5 IGC_CC_ACCT_LINE_HISTORY.Attribute5%TYPE,
57: p_Attribute6 IGC_CC_ACCT_LINE_HISTORY.Attribute6%TYPE,
58: p_Attribute7 IGC_CC_ACCT_LINE_HISTORY.Attribute7%TYPE,
59: p_Attribute8 IGC_CC_ACCT_LINE_HISTORY.Attribute8%TYPE,
60: p_Attribute9 IGC_CC_ACCT_LINE_HISTORY.Attribute9%TYPE,
61: p_Attribute10 IGC_CC_ACCT_LINE_HISTORY.Attribute10%TYPE,
62: p_Attribute11 IGC_CC_ACCT_LINE_HISTORY.Attribute11%TYPE,
63: p_Attribute12 IGC_CC_ACCT_LINE_HISTORY.Attribute12%TYPE,
56: p_Attribute5 IGC_CC_ACCT_LINE_HISTORY.Attribute5%TYPE,
57: p_Attribute6 IGC_CC_ACCT_LINE_HISTORY.Attribute6%TYPE,
58: p_Attribute7 IGC_CC_ACCT_LINE_HISTORY.Attribute7%TYPE,
59: p_Attribute8 IGC_CC_ACCT_LINE_HISTORY.Attribute8%TYPE,
60: p_Attribute9 IGC_CC_ACCT_LINE_HISTORY.Attribute9%TYPE,
61: p_Attribute10 IGC_CC_ACCT_LINE_HISTORY.Attribute10%TYPE,
62: p_Attribute11 IGC_CC_ACCT_LINE_HISTORY.Attribute11%TYPE,
63: p_Attribute12 IGC_CC_ACCT_LINE_HISTORY.Attribute12%TYPE,
64: p_Attribute13 IGC_CC_ACCT_LINE_HISTORY.Attribute13%TYPE,
57: p_Attribute6 IGC_CC_ACCT_LINE_HISTORY.Attribute6%TYPE,
58: p_Attribute7 IGC_CC_ACCT_LINE_HISTORY.Attribute7%TYPE,
59: p_Attribute8 IGC_CC_ACCT_LINE_HISTORY.Attribute8%TYPE,
60: p_Attribute9 IGC_CC_ACCT_LINE_HISTORY.Attribute9%TYPE,
61: p_Attribute10 IGC_CC_ACCT_LINE_HISTORY.Attribute10%TYPE,
62: p_Attribute11 IGC_CC_ACCT_LINE_HISTORY.Attribute11%TYPE,
63: p_Attribute12 IGC_CC_ACCT_LINE_HISTORY.Attribute12%TYPE,
64: p_Attribute13 IGC_CC_ACCT_LINE_HISTORY.Attribute13%TYPE,
65: p_Attribute14 IGC_CC_ACCT_LINE_HISTORY.Attribute14%TYPE,
58: p_Attribute7 IGC_CC_ACCT_LINE_HISTORY.Attribute7%TYPE,
59: p_Attribute8 IGC_CC_ACCT_LINE_HISTORY.Attribute8%TYPE,
60: p_Attribute9 IGC_CC_ACCT_LINE_HISTORY.Attribute9%TYPE,
61: p_Attribute10 IGC_CC_ACCT_LINE_HISTORY.Attribute10%TYPE,
62: p_Attribute11 IGC_CC_ACCT_LINE_HISTORY.Attribute11%TYPE,
63: p_Attribute12 IGC_CC_ACCT_LINE_HISTORY.Attribute12%TYPE,
64: p_Attribute13 IGC_CC_ACCT_LINE_HISTORY.Attribute13%TYPE,
65: p_Attribute14 IGC_CC_ACCT_LINE_HISTORY.Attribute14%TYPE,
66: p_Attribute15 IGC_CC_ACCT_LINE_HISTORY.Attribute15%TYPE,
59: p_Attribute8 IGC_CC_ACCT_LINE_HISTORY.Attribute8%TYPE,
60: p_Attribute9 IGC_CC_ACCT_LINE_HISTORY.Attribute9%TYPE,
61: p_Attribute10 IGC_CC_ACCT_LINE_HISTORY.Attribute10%TYPE,
62: p_Attribute11 IGC_CC_ACCT_LINE_HISTORY.Attribute11%TYPE,
63: p_Attribute12 IGC_CC_ACCT_LINE_HISTORY.Attribute12%TYPE,
64: p_Attribute13 IGC_CC_ACCT_LINE_HISTORY.Attribute13%TYPE,
65: p_Attribute14 IGC_CC_ACCT_LINE_HISTORY.Attribute14%TYPE,
66: p_Attribute15 IGC_CC_ACCT_LINE_HISTORY.Attribute15%TYPE,
67: p_Context IGC_CC_ACCT_LINE_HISTORY.Context%TYPE,
60: p_Attribute9 IGC_CC_ACCT_LINE_HISTORY.Attribute9%TYPE,
61: p_Attribute10 IGC_CC_ACCT_LINE_HISTORY.Attribute10%TYPE,
62: p_Attribute11 IGC_CC_ACCT_LINE_HISTORY.Attribute11%TYPE,
63: p_Attribute12 IGC_CC_ACCT_LINE_HISTORY.Attribute12%TYPE,
64: p_Attribute13 IGC_CC_ACCT_LINE_HISTORY.Attribute13%TYPE,
65: p_Attribute14 IGC_CC_ACCT_LINE_HISTORY.Attribute14%TYPE,
66: p_Attribute15 IGC_CC_ACCT_LINE_HISTORY.Attribute15%TYPE,
67: p_Context IGC_CC_ACCT_LINE_HISTORY.Context%TYPE,
68: p_cc_func_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE,
61: p_Attribute10 IGC_CC_ACCT_LINE_HISTORY.Attribute10%TYPE,
62: p_Attribute11 IGC_CC_ACCT_LINE_HISTORY.Attribute11%TYPE,
63: p_Attribute12 IGC_CC_ACCT_LINE_HISTORY.Attribute12%TYPE,
64: p_Attribute13 IGC_CC_ACCT_LINE_HISTORY.Attribute13%TYPE,
65: p_Attribute14 IGC_CC_ACCT_LINE_HISTORY.Attribute14%TYPE,
66: p_Attribute15 IGC_CC_ACCT_LINE_HISTORY.Attribute15%TYPE,
67: p_Context IGC_CC_ACCT_LINE_HISTORY.Context%TYPE,
68: p_cc_func_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE,
69: p_cc_ent_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_ent_withheld_amt%TYPE,
62: p_Attribute11 IGC_CC_ACCT_LINE_HISTORY.Attribute11%TYPE,
63: p_Attribute12 IGC_CC_ACCT_LINE_HISTORY.Attribute12%TYPE,
64: p_Attribute13 IGC_CC_ACCT_LINE_HISTORY.Attribute13%TYPE,
65: p_Attribute14 IGC_CC_ACCT_LINE_HISTORY.Attribute14%TYPE,
66: p_Attribute15 IGC_CC_ACCT_LINE_HISTORY.Attribute15%TYPE,
67: p_Context IGC_CC_ACCT_LINE_HISTORY.Context%TYPE,
68: p_cc_func_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE,
69: p_cc_ent_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_ent_withheld_amt%TYPE,
70: G_FLAG IN OUT NOCOPY VARCHAR2,
63: p_Attribute12 IGC_CC_ACCT_LINE_HISTORY.Attribute12%TYPE,
64: p_Attribute13 IGC_CC_ACCT_LINE_HISTORY.Attribute13%TYPE,
65: p_Attribute14 IGC_CC_ACCT_LINE_HISTORY.Attribute14%TYPE,
66: p_Attribute15 IGC_CC_ACCT_LINE_HISTORY.Attribute15%TYPE,
67: p_Context IGC_CC_ACCT_LINE_HISTORY.Context%TYPE,
68: p_cc_func_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE,
69: p_cc_ent_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_ent_withheld_amt%TYPE,
70: G_FLAG IN OUT NOCOPY VARCHAR2,
71: P_Tax_Classif_Code IGC_CC_ACCT_LINE_HISTORY.Tax_Classif_Code%TYPE
64: p_Attribute13 IGC_CC_ACCT_LINE_HISTORY.Attribute13%TYPE,
65: p_Attribute14 IGC_CC_ACCT_LINE_HISTORY.Attribute14%TYPE,
66: p_Attribute15 IGC_CC_ACCT_LINE_HISTORY.Attribute15%TYPE,
67: p_Context IGC_CC_ACCT_LINE_HISTORY.Context%TYPE,
68: p_cc_func_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE,
69: p_cc_ent_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_ent_withheld_amt%TYPE,
70: G_FLAG IN OUT NOCOPY VARCHAR2,
71: P_Tax_Classif_Code IGC_CC_ACCT_LINE_HISTORY.Tax_Classif_Code%TYPE
72: ) IS
65: p_Attribute14 IGC_CC_ACCT_LINE_HISTORY.Attribute14%TYPE,
66: p_Attribute15 IGC_CC_ACCT_LINE_HISTORY.Attribute15%TYPE,
67: p_Context IGC_CC_ACCT_LINE_HISTORY.Context%TYPE,
68: p_cc_func_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE,
69: p_cc_ent_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_ent_withheld_amt%TYPE,
70: G_FLAG IN OUT NOCOPY VARCHAR2,
71: P_Tax_Classif_Code IGC_CC_ACCT_LINE_HISTORY.Tax_Classif_Code%TYPE
72: ) IS
73:
67: p_Context IGC_CC_ACCT_LINE_HISTORY.Context%TYPE,
68: p_cc_func_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE,
69: p_cc_ent_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_ent_withheld_amt%TYPE,
70: G_FLAG IN OUT NOCOPY VARCHAR2,
71: P_Tax_Classif_Code IGC_CC_ACCT_LINE_HISTORY.Tax_Classif_Code%TYPE
72: ) IS
73:
74: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
75: l_api_version CONSTANT NUMBER := 1.0;
81: l_return_status VARCHAR2(1);
82:
83: CURSOR C_acct_hst_row_id IS
84: SELECT Rowid
85: FROM IGC_CC_ACCT_LINE_HISTORY
86: WHERE CC_Acct_Line_Id = p_CC_Acct_Line_Id
87: AND CC_Acct_Version_Num = p_CC_Acct_Version_Num;
88:
89: CURSOR c_igc_app_id IS
127: -- -----------------------------------------------------------------
128: -- Insert the account line history record as requested.
129: -- -----------------------------------------------------------------
130: INSERT
131: INTO IGC_CC_ACCT_LINE_HISTORY
132: (CC_Acct_Line_Id,
133: CC_Header_Id,
134: Parent_Header_Id,
135: Parent_Acct_Line_Id,
301: -- ------------------------------------------------------------------
302: IF (l_MRC_Enabled = 'Y') THEN
303:
304: -- ------------------------------------------------------------------
305: -- MRC Handler For IGC_CC_ACCT_LINE_HISTORY to insert all MRC records for
306: -- the reporting set of books for this PRIMARY set of books.
307: -- ------------------------------------------------------------------
308: IGC_CC_MC_MAIN_HST_PVT.get_rsobs_ACCT_LINES (
309: l_api_version,
422: X_return_status OUT NOCOPY VARCHAR2,
423: X_msg_count OUT NOCOPY NUMBER,
424: X_msg_data OUT NOCOPY VARCHAR2,
425: p_Rowid IN OUT NOCOPY VARCHAR2,
426: p_CC_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
427: p_CC_Header_Id IGC_CC_ACCT_LINE_HISTORY.CC_Header_Id%TYPE,
428: p_Parent_Header_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Header_Id%TYPE,
429: p_Parent_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Acct_Line_Id%TYPE,
430: p_CC_Acct_Line_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Num%TYPE,
423: X_msg_count OUT NOCOPY NUMBER,
424: X_msg_data OUT NOCOPY VARCHAR2,
425: p_Rowid IN OUT NOCOPY VARCHAR2,
426: p_CC_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
427: p_CC_Header_Id IGC_CC_ACCT_LINE_HISTORY.CC_Header_Id%TYPE,
428: p_Parent_Header_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Header_Id%TYPE,
429: p_Parent_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Acct_Line_Id%TYPE,
430: p_CC_Acct_Line_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Num%TYPE,
431: p_CC_Acct_Version_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Num%TYPE,
424: X_msg_data OUT NOCOPY VARCHAR2,
425: p_Rowid IN OUT NOCOPY VARCHAR2,
426: p_CC_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
427: p_CC_Header_Id IGC_CC_ACCT_LINE_HISTORY.CC_Header_Id%TYPE,
428: p_Parent_Header_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Header_Id%TYPE,
429: p_Parent_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Acct_Line_Id%TYPE,
430: p_CC_Acct_Line_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Num%TYPE,
431: p_CC_Acct_Version_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Num%TYPE,
432: p_CC_Acct_Version_Action IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Action%TYPE,
425: p_Rowid IN OUT NOCOPY VARCHAR2,
426: p_CC_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
427: p_CC_Header_Id IGC_CC_ACCT_LINE_HISTORY.CC_Header_Id%TYPE,
428: p_Parent_Header_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Header_Id%TYPE,
429: p_Parent_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Acct_Line_Id%TYPE,
430: p_CC_Acct_Line_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Num%TYPE,
431: p_CC_Acct_Version_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Num%TYPE,
432: p_CC_Acct_Version_Action IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Action%TYPE,
433: p_CC_Charge_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Charge_Code_Combination_Id%TYPE,
426: p_CC_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
427: p_CC_Header_Id IGC_CC_ACCT_LINE_HISTORY.CC_Header_Id%TYPE,
428: p_Parent_Header_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Header_Id%TYPE,
429: p_Parent_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Acct_Line_Id%TYPE,
430: p_CC_Acct_Line_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Num%TYPE,
431: p_CC_Acct_Version_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Num%TYPE,
432: p_CC_Acct_Version_Action IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Action%TYPE,
433: p_CC_Charge_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Charge_Code_Combination_Id%TYPE,
434: p_CC_Budget_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Budget_Code_Combination_Id%TYPE,
427: p_CC_Header_Id IGC_CC_ACCT_LINE_HISTORY.CC_Header_Id%TYPE,
428: p_Parent_Header_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Header_Id%TYPE,
429: p_Parent_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Acct_Line_Id%TYPE,
430: p_CC_Acct_Line_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Num%TYPE,
431: p_CC_Acct_Version_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Num%TYPE,
432: p_CC_Acct_Version_Action IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Action%TYPE,
433: p_CC_Charge_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Charge_Code_Combination_Id%TYPE,
434: p_CC_Budget_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Budget_Code_Combination_Id%TYPE,
435: p_CC_Acct_Entered_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Entered_Amt%TYPE,
428: p_Parent_Header_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Header_Id%TYPE,
429: p_Parent_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Acct_Line_Id%TYPE,
430: p_CC_Acct_Line_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Num%TYPE,
431: p_CC_Acct_Version_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Num%TYPE,
432: p_CC_Acct_Version_Action IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Action%TYPE,
433: p_CC_Charge_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Charge_Code_Combination_Id%TYPE,
434: p_CC_Budget_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Budget_Code_Combination_Id%TYPE,
435: p_CC_Acct_Entered_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Entered_Amt%TYPE,
436: p_CC_Acct_Func_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
429: p_Parent_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Acct_Line_Id%TYPE,
430: p_CC_Acct_Line_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Num%TYPE,
431: p_CC_Acct_Version_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Num%TYPE,
432: p_CC_Acct_Version_Action IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Action%TYPE,
433: p_CC_Charge_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Charge_Code_Combination_Id%TYPE,
434: p_CC_Budget_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Budget_Code_Combination_Id%TYPE,
435: p_CC_Acct_Entered_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Entered_Amt%TYPE,
436: p_CC_Acct_Func_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
437: p_CC_Acct_Desc IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Desc%TYPE,
430: p_CC_Acct_Line_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Num%TYPE,
431: p_CC_Acct_Version_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Num%TYPE,
432: p_CC_Acct_Version_Action IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Action%TYPE,
433: p_CC_Charge_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Charge_Code_Combination_Id%TYPE,
434: p_CC_Budget_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Budget_Code_Combination_Id%TYPE,
435: p_CC_Acct_Entered_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Entered_Amt%TYPE,
436: p_CC_Acct_Func_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
437: p_CC_Acct_Desc IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Desc%TYPE,
438: p_CC_Acct_Billed_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Billed_Amt%TYPE,
431: p_CC_Acct_Version_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Num%TYPE,
432: p_CC_Acct_Version_Action IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Action%TYPE,
433: p_CC_Charge_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Charge_Code_Combination_Id%TYPE,
434: p_CC_Budget_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Budget_Code_Combination_Id%TYPE,
435: p_CC_Acct_Entered_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Entered_Amt%TYPE,
436: p_CC_Acct_Func_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
437: p_CC_Acct_Desc IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Desc%TYPE,
438: p_CC_Acct_Billed_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Billed_Amt%TYPE,
439: p_CC_Acct_Unbilled_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Unbilled_Amt%TYPE,
432: p_CC_Acct_Version_Action IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Action%TYPE,
433: p_CC_Charge_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Charge_Code_Combination_Id%TYPE,
434: p_CC_Budget_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Budget_Code_Combination_Id%TYPE,
435: p_CC_Acct_Entered_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Entered_Amt%TYPE,
436: p_CC_Acct_Func_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
437: p_CC_Acct_Desc IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Desc%TYPE,
438: p_CC_Acct_Billed_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Billed_Amt%TYPE,
439: p_CC_Acct_Unbilled_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Unbilled_Amt%TYPE,
440: p_CC_Acct_Taxable_Flag IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Taxable_Flag%TYPE,
433: p_CC_Charge_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Charge_Code_Combination_Id%TYPE,
434: p_CC_Budget_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Budget_Code_Combination_Id%TYPE,
435: p_CC_Acct_Entered_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Entered_Amt%TYPE,
436: p_CC_Acct_Func_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
437: p_CC_Acct_Desc IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Desc%TYPE,
438: p_CC_Acct_Billed_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Billed_Amt%TYPE,
439: p_CC_Acct_Unbilled_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Unbilled_Amt%TYPE,
440: p_CC_Acct_Taxable_Flag IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Taxable_Flag%TYPE,
441: p_Tax_Id IGC_CC_ACCT_LINE_HISTORY.Tax_Id%TYPE,
434: p_CC_Budget_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Budget_Code_Combination_Id%TYPE,
435: p_CC_Acct_Entered_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Entered_Amt%TYPE,
436: p_CC_Acct_Func_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
437: p_CC_Acct_Desc IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Desc%TYPE,
438: p_CC_Acct_Billed_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Billed_Amt%TYPE,
439: p_CC_Acct_Unbilled_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Unbilled_Amt%TYPE,
440: p_CC_Acct_Taxable_Flag IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Taxable_Flag%TYPE,
441: p_Tax_Id IGC_CC_ACCT_LINE_HISTORY.Tax_Id%TYPE,
442: p_CC_Acct_Encmbrnc_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
435: p_CC_Acct_Entered_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Entered_Amt%TYPE,
436: p_CC_Acct_Func_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
437: p_CC_Acct_Desc IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Desc%TYPE,
438: p_CC_Acct_Billed_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Billed_Amt%TYPE,
439: p_CC_Acct_Unbilled_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Unbilled_Amt%TYPE,
440: p_CC_Acct_Taxable_Flag IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Taxable_Flag%TYPE,
441: p_Tax_Id IGC_CC_ACCT_LINE_HISTORY.Tax_Id%TYPE,
442: p_CC_Acct_Encmbrnc_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
443: p_CC_Acct_Encmbrnc_Date IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Date%TYPE,
436: p_CC_Acct_Func_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
437: p_CC_Acct_Desc IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Desc%TYPE,
438: p_CC_Acct_Billed_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Billed_Amt%TYPE,
439: p_CC_Acct_Unbilled_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Unbilled_Amt%TYPE,
440: p_CC_Acct_Taxable_Flag IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Taxable_Flag%TYPE,
441: p_Tax_Id IGC_CC_ACCT_LINE_HISTORY.Tax_Id%TYPE,
442: p_CC_Acct_Encmbrnc_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
443: p_CC_Acct_Encmbrnc_Date IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Date%TYPE,
444: p_CC_Acct_Encmbrnc_Status IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Status%TYPE,
437: p_CC_Acct_Desc IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Desc%TYPE,
438: p_CC_Acct_Billed_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Billed_Amt%TYPE,
439: p_CC_Acct_Unbilled_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Unbilled_Amt%TYPE,
440: p_CC_Acct_Taxable_Flag IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Taxable_Flag%TYPE,
441: p_Tax_Id IGC_CC_ACCT_LINE_HISTORY.Tax_Id%TYPE,
442: p_CC_Acct_Encmbrnc_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
443: p_CC_Acct_Encmbrnc_Date IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Date%TYPE,
444: p_CC_Acct_Encmbrnc_Status IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Status%TYPE,
445: p_Project_Id IGC_CC_ACCT_LINE_HISTORY.Project_Id%TYPE,
438: p_CC_Acct_Billed_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Billed_Amt%TYPE,
439: p_CC_Acct_Unbilled_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Unbilled_Amt%TYPE,
440: p_CC_Acct_Taxable_Flag IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Taxable_Flag%TYPE,
441: p_Tax_Id IGC_CC_ACCT_LINE_HISTORY.Tax_Id%TYPE,
442: p_CC_Acct_Encmbrnc_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
443: p_CC_Acct_Encmbrnc_Date IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Date%TYPE,
444: p_CC_Acct_Encmbrnc_Status IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Status%TYPE,
445: p_Project_Id IGC_CC_ACCT_LINE_HISTORY.Project_Id%TYPE,
446: p_Task_Id IGC_CC_ACCT_LINE_HISTORY.Task_Id%TYPE,
439: p_CC_Acct_Unbilled_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Unbilled_Amt%TYPE,
440: p_CC_Acct_Taxable_Flag IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Taxable_Flag%TYPE,
441: p_Tax_Id IGC_CC_ACCT_LINE_HISTORY.Tax_Id%TYPE,
442: p_CC_Acct_Encmbrnc_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
443: p_CC_Acct_Encmbrnc_Date IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Date%TYPE,
444: p_CC_Acct_Encmbrnc_Status IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Status%TYPE,
445: p_Project_Id IGC_CC_ACCT_LINE_HISTORY.Project_Id%TYPE,
446: p_Task_Id IGC_CC_ACCT_LINE_HISTORY.Task_Id%TYPE,
447: p_Expenditure_Type IGC_CC_ACCT_LINE_HISTORY.Expenditure_Type%TYPE,
440: p_CC_Acct_Taxable_Flag IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Taxable_Flag%TYPE,
441: p_Tax_Id IGC_CC_ACCT_LINE_HISTORY.Tax_Id%TYPE,
442: p_CC_Acct_Encmbrnc_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
443: p_CC_Acct_Encmbrnc_Date IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Date%TYPE,
444: p_CC_Acct_Encmbrnc_Status IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Status%TYPE,
445: p_Project_Id IGC_CC_ACCT_LINE_HISTORY.Project_Id%TYPE,
446: p_Task_Id IGC_CC_ACCT_LINE_HISTORY.Task_Id%TYPE,
447: p_Expenditure_Type IGC_CC_ACCT_LINE_HISTORY.Expenditure_Type%TYPE,
448: p_Expenditure_Org_Id IGC_CC_ACCT_LINE_HISTORY.Expenditure_Org_Id%TYPE,
441: p_Tax_Id IGC_CC_ACCT_LINE_HISTORY.Tax_Id%TYPE,
442: p_CC_Acct_Encmbrnc_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
443: p_CC_Acct_Encmbrnc_Date IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Date%TYPE,
444: p_CC_Acct_Encmbrnc_Status IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Status%TYPE,
445: p_Project_Id IGC_CC_ACCT_LINE_HISTORY.Project_Id%TYPE,
446: p_Task_Id IGC_CC_ACCT_LINE_HISTORY.Task_Id%TYPE,
447: p_Expenditure_Type IGC_CC_ACCT_LINE_HISTORY.Expenditure_Type%TYPE,
448: p_Expenditure_Org_Id IGC_CC_ACCT_LINE_HISTORY.Expenditure_Org_Id%TYPE,
449: p_Expenditure_Item_Date IGC_CC_ACCT_LINE_HISTORY.Expenditure_Item_Date%TYPE,
442: p_CC_Acct_Encmbrnc_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
443: p_CC_Acct_Encmbrnc_Date IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Date%TYPE,
444: p_CC_Acct_Encmbrnc_Status IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Status%TYPE,
445: p_Project_Id IGC_CC_ACCT_LINE_HISTORY.Project_Id%TYPE,
446: p_Task_Id IGC_CC_ACCT_LINE_HISTORY.Task_Id%TYPE,
447: p_Expenditure_Type IGC_CC_ACCT_LINE_HISTORY.Expenditure_Type%TYPE,
448: p_Expenditure_Org_Id IGC_CC_ACCT_LINE_HISTORY.Expenditure_Org_Id%TYPE,
449: p_Expenditure_Item_Date IGC_CC_ACCT_LINE_HISTORY.Expenditure_Item_Date%TYPE,
450: p_Last_Update_Date IGC_CC_ACCT_LINE_HISTORY.Last_Update_Date%TYPE,
443: p_CC_Acct_Encmbrnc_Date IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Date%TYPE,
444: p_CC_Acct_Encmbrnc_Status IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Status%TYPE,
445: p_Project_Id IGC_CC_ACCT_LINE_HISTORY.Project_Id%TYPE,
446: p_Task_Id IGC_CC_ACCT_LINE_HISTORY.Task_Id%TYPE,
447: p_Expenditure_Type IGC_CC_ACCT_LINE_HISTORY.Expenditure_Type%TYPE,
448: p_Expenditure_Org_Id IGC_CC_ACCT_LINE_HISTORY.Expenditure_Org_Id%TYPE,
449: p_Expenditure_Item_Date IGC_CC_ACCT_LINE_HISTORY.Expenditure_Item_Date%TYPE,
450: p_Last_Update_Date IGC_CC_ACCT_LINE_HISTORY.Last_Update_Date%TYPE,
451: p_Last_Updated_By IGC_CC_ACCT_LINE_HISTORY.Last_Updated_By%TYPE,
444: p_CC_Acct_Encmbrnc_Status IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Status%TYPE,
445: p_Project_Id IGC_CC_ACCT_LINE_HISTORY.Project_Id%TYPE,
446: p_Task_Id IGC_CC_ACCT_LINE_HISTORY.Task_Id%TYPE,
447: p_Expenditure_Type IGC_CC_ACCT_LINE_HISTORY.Expenditure_Type%TYPE,
448: p_Expenditure_Org_Id IGC_CC_ACCT_LINE_HISTORY.Expenditure_Org_Id%TYPE,
449: p_Expenditure_Item_Date IGC_CC_ACCT_LINE_HISTORY.Expenditure_Item_Date%TYPE,
450: p_Last_Update_Date IGC_CC_ACCT_LINE_HISTORY.Last_Update_Date%TYPE,
451: p_Last_Updated_By IGC_CC_ACCT_LINE_HISTORY.Last_Updated_By%TYPE,
452: p_Last_Update_Login IGC_CC_ACCT_LINE_HISTORY.Last_Update_Login%TYPE,
445: p_Project_Id IGC_CC_ACCT_LINE_HISTORY.Project_Id%TYPE,
446: p_Task_Id IGC_CC_ACCT_LINE_HISTORY.Task_Id%TYPE,
447: p_Expenditure_Type IGC_CC_ACCT_LINE_HISTORY.Expenditure_Type%TYPE,
448: p_Expenditure_Org_Id IGC_CC_ACCT_LINE_HISTORY.Expenditure_Org_Id%TYPE,
449: p_Expenditure_Item_Date IGC_CC_ACCT_LINE_HISTORY.Expenditure_Item_Date%TYPE,
450: p_Last_Update_Date IGC_CC_ACCT_LINE_HISTORY.Last_Update_Date%TYPE,
451: p_Last_Updated_By IGC_CC_ACCT_LINE_HISTORY.Last_Updated_By%TYPE,
452: p_Last_Update_Login IGC_CC_ACCT_LINE_HISTORY.Last_Update_Login%TYPE,
453: p_Creation_Date IGC_CC_ACCT_LINE_HISTORY.Creation_Date%TYPE,
446: p_Task_Id IGC_CC_ACCT_LINE_HISTORY.Task_Id%TYPE,
447: p_Expenditure_Type IGC_CC_ACCT_LINE_HISTORY.Expenditure_Type%TYPE,
448: p_Expenditure_Org_Id IGC_CC_ACCT_LINE_HISTORY.Expenditure_Org_Id%TYPE,
449: p_Expenditure_Item_Date IGC_CC_ACCT_LINE_HISTORY.Expenditure_Item_Date%TYPE,
450: p_Last_Update_Date IGC_CC_ACCT_LINE_HISTORY.Last_Update_Date%TYPE,
451: p_Last_Updated_By IGC_CC_ACCT_LINE_HISTORY.Last_Updated_By%TYPE,
452: p_Last_Update_Login IGC_CC_ACCT_LINE_HISTORY.Last_Update_Login%TYPE,
453: p_Creation_Date IGC_CC_ACCT_LINE_HISTORY.Creation_Date%TYPE,
454: p_Created_By IGC_CC_ACCT_LINE_HISTORY.Created_By%TYPE,
447: p_Expenditure_Type IGC_CC_ACCT_LINE_HISTORY.Expenditure_Type%TYPE,
448: p_Expenditure_Org_Id IGC_CC_ACCT_LINE_HISTORY.Expenditure_Org_Id%TYPE,
449: p_Expenditure_Item_Date IGC_CC_ACCT_LINE_HISTORY.Expenditure_Item_Date%TYPE,
450: p_Last_Update_Date IGC_CC_ACCT_LINE_HISTORY.Last_Update_Date%TYPE,
451: p_Last_Updated_By IGC_CC_ACCT_LINE_HISTORY.Last_Updated_By%TYPE,
452: p_Last_Update_Login IGC_CC_ACCT_LINE_HISTORY.Last_Update_Login%TYPE,
453: p_Creation_Date IGC_CC_ACCT_LINE_HISTORY.Creation_Date%TYPE,
454: p_Created_By IGC_CC_ACCT_LINE_HISTORY.Created_By%TYPE,
455: p_Attribute1 IGC_CC_ACCT_LINE_HISTORY.Attribute1%TYPE,
448: p_Expenditure_Org_Id IGC_CC_ACCT_LINE_HISTORY.Expenditure_Org_Id%TYPE,
449: p_Expenditure_Item_Date IGC_CC_ACCT_LINE_HISTORY.Expenditure_Item_Date%TYPE,
450: p_Last_Update_Date IGC_CC_ACCT_LINE_HISTORY.Last_Update_Date%TYPE,
451: p_Last_Updated_By IGC_CC_ACCT_LINE_HISTORY.Last_Updated_By%TYPE,
452: p_Last_Update_Login IGC_CC_ACCT_LINE_HISTORY.Last_Update_Login%TYPE,
453: p_Creation_Date IGC_CC_ACCT_LINE_HISTORY.Creation_Date%TYPE,
454: p_Created_By IGC_CC_ACCT_LINE_HISTORY.Created_By%TYPE,
455: p_Attribute1 IGC_CC_ACCT_LINE_HISTORY.Attribute1%TYPE,
456: p_Attribute2 IGC_CC_ACCT_LINE_HISTORY.Attribute2%TYPE,
449: p_Expenditure_Item_Date IGC_CC_ACCT_LINE_HISTORY.Expenditure_Item_Date%TYPE,
450: p_Last_Update_Date IGC_CC_ACCT_LINE_HISTORY.Last_Update_Date%TYPE,
451: p_Last_Updated_By IGC_CC_ACCT_LINE_HISTORY.Last_Updated_By%TYPE,
452: p_Last_Update_Login IGC_CC_ACCT_LINE_HISTORY.Last_Update_Login%TYPE,
453: p_Creation_Date IGC_CC_ACCT_LINE_HISTORY.Creation_Date%TYPE,
454: p_Created_By IGC_CC_ACCT_LINE_HISTORY.Created_By%TYPE,
455: p_Attribute1 IGC_CC_ACCT_LINE_HISTORY.Attribute1%TYPE,
456: p_Attribute2 IGC_CC_ACCT_LINE_HISTORY.Attribute2%TYPE,
457: p_Attribute3 IGC_CC_ACCT_LINE_HISTORY.Attribute3%TYPE,
450: p_Last_Update_Date IGC_CC_ACCT_LINE_HISTORY.Last_Update_Date%TYPE,
451: p_Last_Updated_By IGC_CC_ACCT_LINE_HISTORY.Last_Updated_By%TYPE,
452: p_Last_Update_Login IGC_CC_ACCT_LINE_HISTORY.Last_Update_Login%TYPE,
453: p_Creation_Date IGC_CC_ACCT_LINE_HISTORY.Creation_Date%TYPE,
454: p_Created_By IGC_CC_ACCT_LINE_HISTORY.Created_By%TYPE,
455: p_Attribute1 IGC_CC_ACCT_LINE_HISTORY.Attribute1%TYPE,
456: p_Attribute2 IGC_CC_ACCT_LINE_HISTORY.Attribute2%TYPE,
457: p_Attribute3 IGC_CC_ACCT_LINE_HISTORY.Attribute3%TYPE,
458: p_Attribute4 IGC_CC_ACCT_LINE_HISTORY.Attribute4%TYPE,
451: p_Last_Updated_By IGC_CC_ACCT_LINE_HISTORY.Last_Updated_By%TYPE,
452: p_Last_Update_Login IGC_CC_ACCT_LINE_HISTORY.Last_Update_Login%TYPE,
453: p_Creation_Date IGC_CC_ACCT_LINE_HISTORY.Creation_Date%TYPE,
454: p_Created_By IGC_CC_ACCT_LINE_HISTORY.Created_By%TYPE,
455: p_Attribute1 IGC_CC_ACCT_LINE_HISTORY.Attribute1%TYPE,
456: p_Attribute2 IGC_CC_ACCT_LINE_HISTORY.Attribute2%TYPE,
457: p_Attribute3 IGC_CC_ACCT_LINE_HISTORY.Attribute3%TYPE,
458: p_Attribute4 IGC_CC_ACCT_LINE_HISTORY.Attribute4%TYPE,
459: p_Attribute5 IGC_CC_ACCT_LINE_HISTORY.Attribute5%TYPE,
452: p_Last_Update_Login IGC_CC_ACCT_LINE_HISTORY.Last_Update_Login%TYPE,
453: p_Creation_Date IGC_CC_ACCT_LINE_HISTORY.Creation_Date%TYPE,
454: p_Created_By IGC_CC_ACCT_LINE_HISTORY.Created_By%TYPE,
455: p_Attribute1 IGC_CC_ACCT_LINE_HISTORY.Attribute1%TYPE,
456: p_Attribute2 IGC_CC_ACCT_LINE_HISTORY.Attribute2%TYPE,
457: p_Attribute3 IGC_CC_ACCT_LINE_HISTORY.Attribute3%TYPE,
458: p_Attribute4 IGC_CC_ACCT_LINE_HISTORY.Attribute4%TYPE,
459: p_Attribute5 IGC_CC_ACCT_LINE_HISTORY.Attribute5%TYPE,
460: p_Attribute6 IGC_CC_ACCT_LINE_HISTORY.Attribute6%TYPE,
453: p_Creation_Date IGC_CC_ACCT_LINE_HISTORY.Creation_Date%TYPE,
454: p_Created_By IGC_CC_ACCT_LINE_HISTORY.Created_By%TYPE,
455: p_Attribute1 IGC_CC_ACCT_LINE_HISTORY.Attribute1%TYPE,
456: p_Attribute2 IGC_CC_ACCT_LINE_HISTORY.Attribute2%TYPE,
457: p_Attribute3 IGC_CC_ACCT_LINE_HISTORY.Attribute3%TYPE,
458: p_Attribute4 IGC_CC_ACCT_LINE_HISTORY.Attribute4%TYPE,
459: p_Attribute5 IGC_CC_ACCT_LINE_HISTORY.Attribute5%TYPE,
460: p_Attribute6 IGC_CC_ACCT_LINE_HISTORY.Attribute6%TYPE,
461: p_Attribute7 IGC_CC_ACCT_LINE_HISTORY.Attribute7%TYPE,
454: p_Created_By IGC_CC_ACCT_LINE_HISTORY.Created_By%TYPE,
455: p_Attribute1 IGC_CC_ACCT_LINE_HISTORY.Attribute1%TYPE,
456: p_Attribute2 IGC_CC_ACCT_LINE_HISTORY.Attribute2%TYPE,
457: p_Attribute3 IGC_CC_ACCT_LINE_HISTORY.Attribute3%TYPE,
458: p_Attribute4 IGC_CC_ACCT_LINE_HISTORY.Attribute4%TYPE,
459: p_Attribute5 IGC_CC_ACCT_LINE_HISTORY.Attribute5%TYPE,
460: p_Attribute6 IGC_CC_ACCT_LINE_HISTORY.Attribute6%TYPE,
461: p_Attribute7 IGC_CC_ACCT_LINE_HISTORY.Attribute7%TYPE,
462: p_Attribute8 IGC_CC_ACCT_LINE_HISTORY.Attribute8%TYPE,
455: p_Attribute1 IGC_CC_ACCT_LINE_HISTORY.Attribute1%TYPE,
456: p_Attribute2 IGC_CC_ACCT_LINE_HISTORY.Attribute2%TYPE,
457: p_Attribute3 IGC_CC_ACCT_LINE_HISTORY.Attribute3%TYPE,
458: p_Attribute4 IGC_CC_ACCT_LINE_HISTORY.Attribute4%TYPE,
459: p_Attribute5 IGC_CC_ACCT_LINE_HISTORY.Attribute5%TYPE,
460: p_Attribute6 IGC_CC_ACCT_LINE_HISTORY.Attribute6%TYPE,
461: p_Attribute7 IGC_CC_ACCT_LINE_HISTORY.Attribute7%TYPE,
462: p_Attribute8 IGC_CC_ACCT_LINE_HISTORY.Attribute8%TYPE,
463: p_Attribute9 IGC_CC_ACCT_LINE_HISTORY.Attribute9%TYPE,
456: p_Attribute2 IGC_CC_ACCT_LINE_HISTORY.Attribute2%TYPE,
457: p_Attribute3 IGC_CC_ACCT_LINE_HISTORY.Attribute3%TYPE,
458: p_Attribute4 IGC_CC_ACCT_LINE_HISTORY.Attribute4%TYPE,
459: p_Attribute5 IGC_CC_ACCT_LINE_HISTORY.Attribute5%TYPE,
460: p_Attribute6 IGC_CC_ACCT_LINE_HISTORY.Attribute6%TYPE,
461: p_Attribute7 IGC_CC_ACCT_LINE_HISTORY.Attribute7%TYPE,
462: p_Attribute8 IGC_CC_ACCT_LINE_HISTORY.Attribute8%TYPE,
463: p_Attribute9 IGC_CC_ACCT_LINE_HISTORY.Attribute9%TYPE,
464: p_Attribute10 IGC_CC_ACCT_LINE_HISTORY.Attribute10%TYPE,
457: p_Attribute3 IGC_CC_ACCT_LINE_HISTORY.Attribute3%TYPE,
458: p_Attribute4 IGC_CC_ACCT_LINE_HISTORY.Attribute4%TYPE,
459: p_Attribute5 IGC_CC_ACCT_LINE_HISTORY.Attribute5%TYPE,
460: p_Attribute6 IGC_CC_ACCT_LINE_HISTORY.Attribute6%TYPE,
461: p_Attribute7 IGC_CC_ACCT_LINE_HISTORY.Attribute7%TYPE,
462: p_Attribute8 IGC_CC_ACCT_LINE_HISTORY.Attribute8%TYPE,
463: p_Attribute9 IGC_CC_ACCT_LINE_HISTORY.Attribute9%TYPE,
464: p_Attribute10 IGC_CC_ACCT_LINE_HISTORY.Attribute10%TYPE,
465: p_Attribute11 IGC_CC_ACCT_LINE_HISTORY.Attribute11%TYPE,
458: p_Attribute4 IGC_CC_ACCT_LINE_HISTORY.Attribute4%TYPE,
459: p_Attribute5 IGC_CC_ACCT_LINE_HISTORY.Attribute5%TYPE,
460: p_Attribute6 IGC_CC_ACCT_LINE_HISTORY.Attribute6%TYPE,
461: p_Attribute7 IGC_CC_ACCT_LINE_HISTORY.Attribute7%TYPE,
462: p_Attribute8 IGC_CC_ACCT_LINE_HISTORY.Attribute8%TYPE,
463: p_Attribute9 IGC_CC_ACCT_LINE_HISTORY.Attribute9%TYPE,
464: p_Attribute10 IGC_CC_ACCT_LINE_HISTORY.Attribute10%TYPE,
465: p_Attribute11 IGC_CC_ACCT_LINE_HISTORY.Attribute11%TYPE,
466: p_Attribute12 IGC_CC_ACCT_LINE_HISTORY.Attribute12%TYPE,
459: p_Attribute5 IGC_CC_ACCT_LINE_HISTORY.Attribute5%TYPE,
460: p_Attribute6 IGC_CC_ACCT_LINE_HISTORY.Attribute6%TYPE,
461: p_Attribute7 IGC_CC_ACCT_LINE_HISTORY.Attribute7%TYPE,
462: p_Attribute8 IGC_CC_ACCT_LINE_HISTORY.Attribute8%TYPE,
463: p_Attribute9 IGC_CC_ACCT_LINE_HISTORY.Attribute9%TYPE,
464: p_Attribute10 IGC_CC_ACCT_LINE_HISTORY.Attribute10%TYPE,
465: p_Attribute11 IGC_CC_ACCT_LINE_HISTORY.Attribute11%TYPE,
466: p_Attribute12 IGC_CC_ACCT_LINE_HISTORY.Attribute12%TYPE,
467: p_Attribute13 IGC_CC_ACCT_LINE_HISTORY.Attribute13%TYPE,
460: p_Attribute6 IGC_CC_ACCT_LINE_HISTORY.Attribute6%TYPE,
461: p_Attribute7 IGC_CC_ACCT_LINE_HISTORY.Attribute7%TYPE,
462: p_Attribute8 IGC_CC_ACCT_LINE_HISTORY.Attribute8%TYPE,
463: p_Attribute9 IGC_CC_ACCT_LINE_HISTORY.Attribute9%TYPE,
464: p_Attribute10 IGC_CC_ACCT_LINE_HISTORY.Attribute10%TYPE,
465: p_Attribute11 IGC_CC_ACCT_LINE_HISTORY.Attribute11%TYPE,
466: p_Attribute12 IGC_CC_ACCT_LINE_HISTORY.Attribute12%TYPE,
467: p_Attribute13 IGC_CC_ACCT_LINE_HISTORY.Attribute13%TYPE,
468: p_Attribute14 IGC_CC_ACCT_LINE_HISTORY.Attribute14%TYPE,
461: p_Attribute7 IGC_CC_ACCT_LINE_HISTORY.Attribute7%TYPE,
462: p_Attribute8 IGC_CC_ACCT_LINE_HISTORY.Attribute8%TYPE,
463: p_Attribute9 IGC_CC_ACCT_LINE_HISTORY.Attribute9%TYPE,
464: p_Attribute10 IGC_CC_ACCT_LINE_HISTORY.Attribute10%TYPE,
465: p_Attribute11 IGC_CC_ACCT_LINE_HISTORY.Attribute11%TYPE,
466: p_Attribute12 IGC_CC_ACCT_LINE_HISTORY.Attribute12%TYPE,
467: p_Attribute13 IGC_CC_ACCT_LINE_HISTORY.Attribute13%TYPE,
468: p_Attribute14 IGC_CC_ACCT_LINE_HISTORY.Attribute14%TYPE,
469: p_Attribute15 IGC_CC_ACCT_LINE_HISTORY.Attribute15%TYPE,
462: p_Attribute8 IGC_CC_ACCT_LINE_HISTORY.Attribute8%TYPE,
463: p_Attribute9 IGC_CC_ACCT_LINE_HISTORY.Attribute9%TYPE,
464: p_Attribute10 IGC_CC_ACCT_LINE_HISTORY.Attribute10%TYPE,
465: p_Attribute11 IGC_CC_ACCT_LINE_HISTORY.Attribute11%TYPE,
466: p_Attribute12 IGC_CC_ACCT_LINE_HISTORY.Attribute12%TYPE,
467: p_Attribute13 IGC_CC_ACCT_LINE_HISTORY.Attribute13%TYPE,
468: p_Attribute14 IGC_CC_ACCT_LINE_HISTORY.Attribute14%TYPE,
469: p_Attribute15 IGC_CC_ACCT_LINE_HISTORY.Attribute15%TYPE,
470: p_Context IGC_CC_ACCT_LINE_HISTORY.Context%TYPE,
463: p_Attribute9 IGC_CC_ACCT_LINE_HISTORY.Attribute9%TYPE,
464: p_Attribute10 IGC_CC_ACCT_LINE_HISTORY.Attribute10%TYPE,
465: p_Attribute11 IGC_CC_ACCT_LINE_HISTORY.Attribute11%TYPE,
466: p_Attribute12 IGC_CC_ACCT_LINE_HISTORY.Attribute12%TYPE,
467: p_Attribute13 IGC_CC_ACCT_LINE_HISTORY.Attribute13%TYPE,
468: p_Attribute14 IGC_CC_ACCT_LINE_HISTORY.Attribute14%TYPE,
469: p_Attribute15 IGC_CC_ACCT_LINE_HISTORY.Attribute15%TYPE,
470: p_Context IGC_CC_ACCT_LINE_HISTORY.Context%TYPE,
471: p_cc_func_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE,
464: p_Attribute10 IGC_CC_ACCT_LINE_HISTORY.Attribute10%TYPE,
465: p_Attribute11 IGC_CC_ACCT_LINE_HISTORY.Attribute11%TYPE,
466: p_Attribute12 IGC_CC_ACCT_LINE_HISTORY.Attribute12%TYPE,
467: p_Attribute13 IGC_CC_ACCT_LINE_HISTORY.Attribute13%TYPE,
468: p_Attribute14 IGC_CC_ACCT_LINE_HISTORY.Attribute14%TYPE,
469: p_Attribute15 IGC_CC_ACCT_LINE_HISTORY.Attribute15%TYPE,
470: p_Context IGC_CC_ACCT_LINE_HISTORY.Context%TYPE,
471: p_cc_func_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE,
472: p_cc_ent_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_ent_withheld_amt%TYPE,
465: p_Attribute11 IGC_CC_ACCT_LINE_HISTORY.Attribute11%TYPE,
466: p_Attribute12 IGC_CC_ACCT_LINE_HISTORY.Attribute12%TYPE,
467: p_Attribute13 IGC_CC_ACCT_LINE_HISTORY.Attribute13%TYPE,
468: p_Attribute14 IGC_CC_ACCT_LINE_HISTORY.Attribute14%TYPE,
469: p_Attribute15 IGC_CC_ACCT_LINE_HISTORY.Attribute15%TYPE,
470: p_Context IGC_CC_ACCT_LINE_HISTORY.Context%TYPE,
471: p_cc_func_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE,
472: p_cc_ent_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_ent_withheld_amt%TYPE,
473: X_row_locked OUT NOCOPY VARCHAR2,
466: p_Attribute12 IGC_CC_ACCT_LINE_HISTORY.Attribute12%TYPE,
467: p_Attribute13 IGC_CC_ACCT_LINE_HISTORY.Attribute13%TYPE,
468: p_Attribute14 IGC_CC_ACCT_LINE_HISTORY.Attribute14%TYPE,
469: p_Attribute15 IGC_CC_ACCT_LINE_HISTORY.Attribute15%TYPE,
470: p_Context IGC_CC_ACCT_LINE_HISTORY.Context%TYPE,
471: p_cc_func_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE,
472: p_cc_ent_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_ent_withheld_amt%TYPE,
473: X_row_locked OUT NOCOPY VARCHAR2,
474: G_FLAG IN OUT NOCOPY VARCHAR2,
467: p_Attribute13 IGC_CC_ACCT_LINE_HISTORY.Attribute13%TYPE,
468: p_Attribute14 IGC_CC_ACCT_LINE_HISTORY.Attribute14%TYPE,
469: p_Attribute15 IGC_CC_ACCT_LINE_HISTORY.Attribute15%TYPE,
470: p_Context IGC_CC_ACCT_LINE_HISTORY.Context%TYPE,
471: p_cc_func_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE,
472: p_cc_ent_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_ent_withheld_amt%TYPE,
473: X_row_locked OUT NOCOPY VARCHAR2,
474: G_FLAG IN OUT NOCOPY VARCHAR2,
475: P_Tax_Classif_Code IGC_CC_ACCT_LINE_HISTORY.Tax_Classif_Code%TYPE
468: p_Attribute14 IGC_CC_ACCT_LINE_HISTORY.Attribute14%TYPE,
469: p_Attribute15 IGC_CC_ACCT_LINE_HISTORY.Attribute15%TYPE,
470: p_Context IGC_CC_ACCT_LINE_HISTORY.Context%TYPE,
471: p_cc_func_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE,
472: p_cc_ent_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_ent_withheld_amt%TYPE,
473: X_row_locked OUT NOCOPY VARCHAR2,
474: G_FLAG IN OUT NOCOPY VARCHAR2,
475: P_Tax_Classif_Code IGC_CC_ACCT_LINE_HISTORY.Tax_Classif_Code%TYPE
476: ) IS
471: p_cc_func_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE,
472: p_cc_ent_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_ent_withheld_amt%TYPE,
473: X_row_locked OUT NOCOPY VARCHAR2,
474: G_FLAG IN OUT NOCOPY VARCHAR2,
475: P_Tax_Classif_Code IGC_CC_ACCT_LINE_HISTORY.Tax_Classif_Code%TYPE
476: ) IS
477:
478: l_api_name CONSTANT VARCHAR2(30) := 'Lock_Row';
479: l_api_version CONSTANT NUMBER := 1.0;
480: Counter NUMBER;
481:
482: CURSOR C IS
483: SELECT *
484: FROM IGC_CC_ACCT_LINE_HISTORY
485: WHERE Rowid = p_Rowid
486: FOR UPDATE of CC_Acct_Line_Id NOWAIT;
487:
488: Recinfo C%ROWTYPE;
709: X_return_status OUT NOCOPY VARCHAR2,
710: X_msg_count OUT NOCOPY NUMBER,
711: X_msg_data OUT NOCOPY VARCHAR2,
712: p_Rowid IN OUT NOCOPY VARCHAR2,
713: p_CC_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
714: p_CC_Header_Id IGC_CC_ACCT_LINE_HISTORY.CC_Header_Id%TYPE,
715: p_Parent_Header_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Header_Id%TYPE,
716: p_Parent_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Acct_Line_Id%TYPE,
717: p_CC_Acct_Line_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Num%TYPE,
710: X_msg_count OUT NOCOPY NUMBER,
711: X_msg_data OUT NOCOPY VARCHAR2,
712: p_Rowid IN OUT NOCOPY VARCHAR2,
713: p_CC_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
714: p_CC_Header_Id IGC_CC_ACCT_LINE_HISTORY.CC_Header_Id%TYPE,
715: p_Parent_Header_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Header_Id%TYPE,
716: p_Parent_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Acct_Line_Id%TYPE,
717: p_CC_Acct_Line_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Num%TYPE,
718: p_CC_Acct_Version_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Num%TYPE,
711: X_msg_data OUT NOCOPY VARCHAR2,
712: p_Rowid IN OUT NOCOPY VARCHAR2,
713: p_CC_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
714: p_CC_Header_Id IGC_CC_ACCT_LINE_HISTORY.CC_Header_Id%TYPE,
715: p_Parent_Header_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Header_Id%TYPE,
716: p_Parent_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Acct_Line_Id%TYPE,
717: p_CC_Acct_Line_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Num%TYPE,
718: p_CC_Acct_Version_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Num%TYPE,
719: p_CC_Acct_Version_Action IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Action%TYPE,
712: p_Rowid IN OUT NOCOPY VARCHAR2,
713: p_CC_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
714: p_CC_Header_Id IGC_CC_ACCT_LINE_HISTORY.CC_Header_Id%TYPE,
715: p_Parent_Header_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Header_Id%TYPE,
716: p_Parent_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Acct_Line_Id%TYPE,
717: p_CC_Acct_Line_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Num%TYPE,
718: p_CC_Acct_Version_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Num%TYPE,
719: p_CC_Acct_Version_Action IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Action%TYPE,
720: p_CC_Charge_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Charge_Code_Combination_Id%TYPE,
713: p_CC_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
714: p_CC_Header_Id IGC_CC_ACCT_LINE_HISTORY.CC_Header_Id%TYPE,
715: p_Parent_Header_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Header_Id%TYPE,
716: p_Parent_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Acct_Line_Id%TYPE,
717: p_CC_Acct_Line_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Num%TYPE,
718: p_CC_Acct_Version_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Num%TYPE,
719: p_CC_Acct_Version_Action IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Action%TYPE,
720: p_CC_Charge_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Charge_Code_Combination_Id%TYPE,
721: p_CC_Budget_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Budget_Code_Combination_Id%TYPE,
714: p_CC_Header_Id IGC_CC_ACCT_LINE_HISTORY.CC_Header_Id%TYPE,
715: p_Parent_Header_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Header_Id%TYPE,
716: p_Parent_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Acct_Line_Id%TYPE,
717: p_CC_Acct_Line_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Num%TYPE,
718: p_CC_Acct_Version_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Num%TYPE,
719: p_CC_Acct_Version_Action IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Action%TYPE,
720: p_CC_Charge_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Charge_Code_Combination_Id%TYPE,
721: p_CC_Budget_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Budget_Code_Combination_Id%TYPE,
722: p_CC_Acct_Entered_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Entered_Amt%TYPE,
715: p_Parent_Header_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Header_Id%TYPE,
716: p_Parent_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Acct_Line_Id%TYPE,
717: p_CC_Acct_Line_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Num%TYPE,
718: p_CC_Acct_Version_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Num%TYPE,
719: p_CC_Acct_Version_Action IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Action%TYPE,
720: p_CC_Charge_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Charge_Code_Combination_Id%TYPE,
721: p_CC_Budget_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Budget_Code_Combination_Id%TYPE,
722: p_CC_Acct_Entered_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Entered_Amt%TYPE,
723: p_CC_Acct_Func_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
716: p_Parent_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Acct_Line_Id%TYPE,
717: p_CC_Acct_Line_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Num%TYPE,
718: p_CC_Acct_Version_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Num%TYPE,
719: p_CC_Acct_Version_Action IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Action%TYPE,
720: p_CC_Charge_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Charge_Code_Combination_Id%TYPE,
721: p_CC_Budget_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Budget_Code_Combination_Id%TYPE,
722: p_CC_Acct_Entered_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Entered_Amt%TYPE,
723: p_CC_Acct_Func_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
724: p_CC_Acct_Desc IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Desc%TYPE,
717: p_CC_Acct_Line_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Num%TYPE,
718: p_CC_Acct_Version_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Num%TYPE,
719: p_CC_Acct_Version_Action IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Action%TYPE,
720: p_CC_Charge_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Charge_Code_Combination_Id%TYPE,
721: p_CC_Budget_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Budget_Code_Combination_Id%TYPE,
722: p_CC_Acct_Entered_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Entered_Amt%TYPE,
723: p_CC_Acct_Func_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
724: p_CC_Acct_Desc IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Desc%TYPE,
725: p_CC_Acct_Billed_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Billed_Amt%TYPE,
718: p_CC_Acct_Version_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Num%TYPE,
719: p_CC_Acct_Version_Action IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Action%TYPE,
720: p_CC_Charge_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Charge_Code_Combination_Id%TYPE,
721: p_CC_Budget_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Budget_Code_Combination_Id%TYPE,
722: p_CC_Acct_Entered_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Entered_Amt%TYPE,
723: p_CC_Acct_Func_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
724: p_CC_Acct_Desc IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Desc%TYPE,
725: p_CC_Acct_Billed_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Billed_Amt%TYPE,
726: p_CC_Acct_Unbilled_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Unbilled_Amt%TYPE,
719: p_CC_Acct_Version_Action IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Action%TYPE,
720: p_CC_Charge_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Charge_Code_Combination_Id%TYPE,
721: p_CC_Budget_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Budget_Code_Combination_Id%TYPE,
722: p_CC_Acct_Entered_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Entered_Amt%TYPE,
723: p_CC_Acct_Func_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
724: p_CC_Acct_Desc IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Desc%TYPE,
725: p_CC_Acct_Billed_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Billed_Amt%TYPE,
726: p_CC_Acct_Unbilled_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Unbilled_Amt%TYPE,
727: p_CC_Acct_Taxable_Flag IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Taxable_Flag%TYPE,
720: p_CC_Charge_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Charge_Code_Combination_Id%TYPE,
721: p_CC_Budget_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Budget_Code_Combination_Id%TYPE,
722: p_CC_Acct_Entered_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Entered_Amt%TYPE,
723: p_CC_Acct_Func_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
724: p_CC_Acct_Desc IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Desc%TYPE,
725: p_CC_Acct_Billed_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Billed_Amt%TYPE,
726: p_CC_Acct_Unbilled_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Unbilled_Amt%TYPE,
727: p_CC_Acct_Taxable_Flag IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Taxable_Flag%TYPE,
728: p_Tax_Id IGC_CC_ACCT_LINE_HISTORY.Tax_Id%TYPE,
721: p_CC_Budget_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Budget_Code_Combination_Id%TYPE,
722: p_CC_Acct_Entered_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Entered_Amt%TYPE,
723: p_CC_Acct_Func_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
724: p_CC_Acct_Desc IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Desc%TYPE,
725: p_CC_Acct_Billed_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Billed_Amt%TYPE,
726: p_CC_Acct_Unbilled_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Unbilled_Amt%TYPE,
727: p_CC_Acct_Taxable_Flag IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Taxable_Flag%TYPE,
728: p_Tax_Id IGC_CC_ACCT_LINE_HISTORY.Tax_Id%TYPE,
729: p_CC_Acct_Encmbrnc_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
722: p_CC_Acct_Entered_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Entered_Amt%TYPE,
723: p_CC_Acct_Func_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
724: p_CC_Acct_Desc IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Desc%TYPE,
725: p_CC_Acct_Billed_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Billed_Amt%TYPE,
726: p_CC_Acct_Unbilled_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Unbilled_Amt%TYPE,
727: p_CC_Acct_Taxable_Flag IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Taxable_Flag%TYPE,
728: p_Tax_Id IGC_CC_ACCT_LINE_HISTORY.Tax_Id%TYPE,
729: p_CC_Acct_Encmbrnc_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
730: p_CC_Acct_Encmbrnc_Date IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Date%TYPE,
723: p_CC_Acct_Func_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
724: p_CC_Acct_Desc IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Desc%TYPE,
725: p_CC_Acct_Billed_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Billed_Amt%TYPE,
726: p_CC_Acct_Unbilled_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Unbilled_Amt%TYPE,
727: p_CC_Acct_Taxable_Flag IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Taxable_Flag%TYPE,
728: p_Tax_Id IGC_CC_ACCT_LINE_HISTORY.Tax_Id%TYPE,
729: p_CC_Acct_Encmbrnc_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
730: p_CC_Acct_Encmbrnc_Date IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Date%TYPE,
731: p_CC_Acct_Encmbrnc_Status IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Status%TYPE,
724: p_CC_Acct_Desc IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Desc%TYPE,
725: p_CC_Acct_Billed_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Billed_Amt%TYPE,
726: p_CC_Acct_Unbilled_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Unbilled_Amt%TYPE,
727: p_CC_Acct_Taxable_Flag IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Taxable_Flag%TYPE,
728: p_Tax_Id IGC_CC_ACCT_LINE_HISTORY.Tax_Id%TYPE,
729: p_CC_Acct_Encmbrnc_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
730: p_CC_Acct_Encmbrnc_Date IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Date%TYPE,
731: p_CC_Acct_Encmbrnc_Status IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Status%TYPE,
732: p_Project_Id IGC_CC_ACCT_LINE_HISTORY.Project_Id%TYPE,
725: p_CC_Acct_Billed_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Billed_Amt%TYPE,
726: p_CC_Acct_Unbilled_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Unbilled_Amt%TYPE,
727: p_CC_Acct_Taxable_Flag IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Taxable_Flag%TYPE,
728: p_Tax_Id IGC_CC_ACCT_LINE_HISTORY.Tax_Id%TYPE,
729: p_CC_Acct_Encmbrnc_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
730: p_CC_Acct_Encmbrnc_Date IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Date%TYPE,
731: p_CC_Acct_Encmbrnc_Status IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Status%TYPE,
732: p_Project_Id IGC_CC_ACCT_LINE_HISTORY.Project_Id%TYPE,
733: p_Task_Id IGC_CC_ACCT_LINE_HISTORY.Task_Id%TYPE,
726: p_CC_Acct_Unbilled_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Unbilled_Amt%TYPE,
727: p_CC_Acct_Taxable_Flag IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Taxable_Flag%TYPE,
728: p_Tax_Id IGC_CC_ACCT_LINE_HISTORY.Tax_Id%TYPE,
729: p_CC_Acct_Encmbrnc_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
730: p_CC_Acct_Encmbrnc_Date IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Date%TYPE,
731: p_CC_Acct_Encmbrnc_Status IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Status%TYPE,
732: p_Project_Id IGC_CC_ACCT_LINE_HISTORY.Project_Id%TYPE,
733: p_Task_Id IGC_CC_ACCT_LINE_HISTORY.Task_Id%TYPE,
734: p_Expenditure_Type IGC_CC_ACCT_LINE_HISTORY.Expenditure_Type%TYPE,
727: p_CC_Acct_Taxable_Flag IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Taxable_Flag%TYPE,
728: p_Tax_Id IGC_CC_ACCT_LINE_HISTORY.Tax_Id%TYPE,
729: p_CC_Acct_Encmbrnc_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
730: p_CC_Acct_Encmbrnc_Date IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Date%TYPE,
731: p_CC_Acct_Encmbrnc_Status IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Status%TYPE,
732: p_Project_Id IGC_CC_ACCT_LINE_HISTORY.Project_Id%TYPE,
733: p_Task_Id IGC_CC_ACCT_LINE_HISTORY.Task_Id%TYPE,
734: p_Expenditure_Type IGC_CC_ACCT_LINE_HISTORY.Expenditure_Type%TYPE,
735: p_Expenditure_Org_Id IGC_CC_ACCT_LINE_HISTORY.Expenditure_Org_Id%TYPE,
728: p_Tax_Id IGC_CC_ACCT_LINE_HISTORY.Tax_Id%TYPE,
729: p_CC_Acct_Encmbrnc_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
730: p_CC_Acct_Encmbrnc_Date IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Date%TYPE,
731: p_CC_Acct_Encmbrnc_Status IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Status%TYPE,
732: p_Project_Id IGC_CC_ACCT_LINE_HISTORY.Project_Id%TYPE,
733: p_Task_Id IGC_CC_ACCT_LINE_HISTORY.Task_Id%TYPE,
734: p_Expenditure_Type IGC_CC_ACCT_LINE_HISTORY.Expenditure_Type%TYPE,
735: p_Expenditure_Org_Id IGC_CC_ACCT_LINE_HISTORY.Expenditure_Org_Id%TYPE,
736: p_Expenditure_Item_Date IGC_CC_ACCT_LINE_HISTORY.Expenditure_Item_Date%TYPE,
729: p_CC_Acct_Encmbrnc_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
730: p_CC_Acct_Encmbrnc_Date IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Date%TYPE,
731: p_CC_Acct_Encmbrnc_Status IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Status%TYPE,
732: p_Project_Id IGC_CC_ACCT_LINE_HISTORY.Project_Id%TYPE,
733: p_Task_Id IGC_CC_ACCT_LINE_HISTORY.Task_Id%TYPE,
734: p_Expenditure_Type IGC_CC_ACCT_LINE_HISTORY.Expenditure_Type%TYPE,
735: p_Expenditure_Org_Id IGC_CC_ACCT_LINE_HISTORY.Expenditure_Org_Id%TYPE,
736: p_Expenditure_Item_Date IGC_CC_ACCT_LINE_HISTORY.Expenditure_Item_Date%TYPE,
737: p_Last_Update_Date IGC_CC_ACCT_LINE_HISTORY.Last_Update_Date%TYPE,
730: p_CC_Acct_Encmbrnc_Date IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Date%TYPE,
731: p_CC_Acct_Encmbrnc_Status IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Status%TYPE,
732: p_Project_Id IGC_CC_ACCT_LINE_HISTORY.Project_Id%TYPE,
733: p_Task_Id IGC_CC_ACCT_LINE_HISTORY.Task_Id%TYPE,
734: p_Expenditure_Type IGC_CC_ACCT_LINE_HISTORY.Expenditure_Type%TYPE,
735: p_Expenditure_Org_Id IGC_CC_ACCT_LINE_HISTORY.Expenditure_Org_Id%TYPE,
736: p_Expenditure_Item_Date IGC_CC_ACCT_LINE_HISTORY.Expenditure_Item_Date%TYPE,
737: p_Last_Update_Date IGC_CC_ACCT_LINE_HISTORY.Last_Update_Date%TYPE,
738: p_Last_Updated_By IGC_CC_ACCT_LINE_HISTORY.Last_Updated_By%TYPE,
731: p_CC_Acct_Encmbrnc_Status IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Status%TYPE,
732: p_Project_Id IGC_CC_ACCT_LINE_HISTORY.Project_Id%TYPE,
733: p_Task_Id IGC_CC_ACCT_LINE_HISTORY.Task_Id%TYPE,
734: p_Expenditure_Type IGC_CC_ACCT_LINE_HISTORY.Expenditure_Type%TYPE,
735: p_Expenditure_Org_Id IGC_CC_ACCT_LINE_HISTORY.Expenditure_Org_Id%TYPE,
736: p_Expenditure_Item_Date IGC_CC_ACCT_LINE_HISTORY.Expenditure_Item_Date%TYPE,
737: p_Last_Update_Date IGC_CC_ACCT_LINE_HISTORY.Last_Update_Date%TYPE,
738: p_Last_Updated_By IGC_CC_ACCT_LINE_HISTORY.Last_Updated_By%TYPE,
739: p_Last_Update_Login IGC_CC_ACCT_LINE_HISTORY.Last_Update_Login%TYPE,
732: p_Project_Id IGC_CC_ACCT_LINE_HISTORY.Project_Id%TYPE,
733: p_Task_Id IGC_CC_ACCT_LINE_HISTORY.Task_Id%TYPE,
734: p_Expenditure_Type IGC_CC_ACCT_LINE_HISTORY.Expenditure_Type%TYPE,
735: p_Expenditure_Org_Id IGC_CC_ACCT_LINE_HISTORY.Expenditure_Org_Id%TYPE,
736: p_Expenditure_Item_Date IGC_CC_ACCT_LINE_HISTORY.Expenditure_Item_Date%TYPE,
737: p_Last_Update_Date IGC_CC_ACCT_LINE_HISTORY.Last_Update_Date%TYPE,
738: p_Last_Updated_By IGC_CC_ACCT_LINE_HISTORY.Last_Updated_By%TYPE,
739: p_Last_Update_Login IGC_CC_ACCT_LINE_HISTORY.Last_Update_Login%TYPE,
740: p_Creation_Date IGC_CC_ACCT_LINE_HISTORY.Creation_Date%TYPE,
733: p_Task_Id IGC_CC_ACCT_LINE_HISTORY.Task_Id%TYPE,
734: p_Expenditure_Type IGC_CC_ACCT_LINE_HISTORY.Expenditure_Type%TYPE,
735: p_Expenditure_Org_Id IGC_CC_ACCT_LINE_HISTORY.Expenditure_Org_Id%TYPE,
736: p_Expenditure_Item_Date IGC_CC_ACCT_LINE_HISTORY.Expenditure_Item_Date%TYPE,
737: p_Last_Update_Date IGC_CC_ACCT_LINE_HISTORY.Last_Update_Date%TYPE,
738: p_Last_Updated_By IGC_CC_ACCT_LINE_HISTORY.Last_Updated_By%TYPE,
739: p_Last_Update_Login IGC_CC_ACCT_LINE_HISTORY.Last_Update_Login%TYPE,
740: p_Creation_Date IGC_CC_ACCT_LINE_HISTORY.Creation_Date%TYPE,
741: p_Created_By IGC_CC_ACCT_LINE_HISTORY.Created_By%TYPE,
734: p_Expenditure_Type IGC_CC_ACCT_LINE_HISTORY.Expenditure_Type%TYPE,
735: p_Expenditure_Org_Id IGC_CC_ACCT_LINE_HISTORY.Expenditure_Org_Id%TYPE,
736: p_Expenditure_Item_Date IGC_CC_ACCT_LINE_HISTORY.Expenditure_Item_Date%TYPE,
737: p_Last_Update_Date IGC_CC_ACCT_LINE_HISTORY.Last_Update_Date%TYPE,
738: p_Last_Updated_By IGC_CC_ACCT_LINE_HISTORY.Last_Updated_By%TYPE,
739: p_Last_Update_Login IGC_CC_ACCT_LINE_HISTORY.Last_Update_Login%TYPE,
740: p_Creation_Date IGC_CC_ACCT_LINE_HISTORY.Creation_Date%TYPE,
741: p_Created_By IGC_CC_ACCT_LINE_HISTORY.Created_By%TYPE,
742: p_Attribute1 IGC_CC_ACCT_LINE_HISTORY.Attribute1%TYPE,
735: p_Expenditure_Org_Id IGC_CC_ACCT_LINE_HISTORY.Expenditure_Org_Id%TYPE,
736: p_Expenditure_Item_Date IGC_CC_ACCT_LINE_HISTORY.Expenditure_Item_Date%TYPE,
737: p_Last_Update_Date IGC_CC_ACCT_LINE_HISTORY.Last_Update_Date%TYPE,
738: p_Last_Updated_By IGC_CC_ACCT_LINE_HISTORY.Last_Updated_By%TYPE,
739: p_Last_Update_Login IGC_CC_ACCT_LINE_HISTORY.Last_Update_Login%TYPE,
740: p_Creation_Date IGC_CC_ACCT_LINE_HISTORY.Creation_Date%TYPE,
741: p_Created_By IGC_CC_ACCT_LINE_HISTORY.Created_By%TYPE,
742: p_Attribute1 IGC_CC_ACCT_LINE_HISTORY.Attribute1%TYPE,
743: p_Attribute2 IGC_CC_ACCT_LINE_HISTORY.Attribute2%TYPE,
736: p_Expenditure_Item_Date IGC_CC_ACCT_LINE_HISTORY.Expenditure_Item_Date%TYPE,
737: p_Last_Update_Date IGC_CC_ACCT_LINE_HISTORY.Last_Update_Date%TYPE,
738: p_Last_Updated_By IGC_CC_ACCT_LINE_HISTORY.Last_Updated_By%TYPE,
739: p_Last_Update_Login IGC_CC_ACCT_LINE_HISTORY.Last_Update_Login%TYPE,
740: p_Creation_Date IGC_CC_ACCT_LINE_HISTORY.Creation_Date%TYPE,
741: p_Created_By IGC_CC_ACCT_LINE_HISTORY.Created_By%TYPE,
742: p_Attribute1 IGC_CC_ACCT_LINE_HISTORY.Attribute1%TYPE,
743: p_Attribute2 IGC_CC_ACCT_LINE_HISTORY.Attribute2%TYPE,
744: p_Attribute3 IGC_CC_ACCT_LINE_HISTORY.Attribute3%TYPE,
737: p_Last_Update_Date IGC_CC_ACCT_LINE_HISTORY.Last_Update_Date%TYPE,
738: p_Last_Updated_By IGC_CC_ACCT_LINE_HISTORY.Last_Updated_By%TYPE,
739: p_Last_Update_Login IGC_CC_ACCT_LINE_HISTORY.Last_Update_Login%TYPE,
740: p_Creation_Date IGC_CC_ACCT_LINE_HISTORY.Creation_Date%TYPE,
741: p_Created_By IGC_CC_ACCT_LINE_HISTORY.Created_By%TYPE,
742: p_Attribute1 IGC_CC_ACCT_LINE_HISTORY.Attribute1%TYPE,
743: p_Attribute2 IGC_CC_ACCT_LINE_HISTORY.Attribute2%TYPE,
744: p_Attribute3 IGC_CC_ACCT_LINE_HISTORY.Attribute3%TYPE,
745: p_Attribute4 IGC_CC_ACCT_LINE_HISTORY.Attribute4%TYPE,
738: p_Last_Updated_By IGC_CC_ACCT_LINE_HISTORY.Last_Updated_By%TYPE,
739: p_Last_Update_Login IGC_CC_ACCT_LINE_HISTORY.Last_Update_Login%TYPE,
740: p_Creation_Date IGC_CC_ACCT_LINE_HISTORY.Creation_Date%TYPE,
741: p_Created_By IGC_CC_ACCT_LINE_HISTORY.Created_By%TYPE,
742: p_Attribute1 IGC_CC_ACCT_LINE_HISTORY.Attribute1%TYPE,
743: p_Attribute2 IGC_CC_ACCT_LINE_HISTORY.Attribute2%TYPE,
744: p_Attribute3 IGC_CC_ACCT_LINE_HISTORY.Attribute3%TYPE,
745: p_Attribute4 IGC_CC_ACCT_LINE_HISTORY.Attribute4%TYPE,
746: p_Attribute5 IGC_CC_ACCT_LINE_HISTORY.Attribute5%TYPE,
739: p_Last_Update_Login IGC_CC_ACCT_LINE_HISTORY.Last_Update_Login%TYPE,
740: p_Creation_Date IGC_CC_ACCT_LINE_HISTORY.Creation_Date%TYPE,
741: p_Created_By IGC_CC_ACCT_LINE_HISTORY.Created_By%TYPE,
742: p_Attribute1 IGC_CC_ACCT_LINE_HISTORY.Attribute1%TYPE,
743: p_Attribute2 IGC_CC_ACCT_LINE_HISTORY.Attribute2%TYPE,
744: p_Attribute3 IGC_CC_ACCT_LINE_HISTORY.Attribute3%TYPE,
745: p_Attribute4 IGC_CC_ACCT_LINE_HISTORY.Attribute4%TYPE,
746: p_Attribute5 IGC_CC_ACCT_LINE_HISTORY.Attribute5%TYPE,
747: p_Attribute6 IGC_CC_ACCT_LINE_HISTORY.Attribute6%TYPE,
740: p_Creation_Date IGC_CC_ACCT_LINE_HISTORY.Creation_Date%TYPE,
741: p_Created_By IGC_CC_ACCT_LINE_HISTORY.Created_By%TYPE,
742: p_Attribute1 IGC_CC_ACCT_LINE_HISTORY.Attribute1%TYPE,
743: p_Attribute2 IGC_CC_ACCT_LINE_HISTORY.Attribute2%TYPE,
744: p_Attribute3 IGC_CC_ACCT_LINE_HISTORY.Attribute3%TYPE,
745: p_Attribute4 IGC_CC_ACCT_LINE_HISTORY.Attribute4%TYPE,
746: p_Attribute5 IGC_CC_ACCT_LINE_HISTORY.Attribute5%TYPE,
747: p_Attribute6 IGC_CC_ACCT_LINE_HISTORY.Attribute6%TYPE,
748: p_Attribute7 IGC_CC_ACCT_LINE_HISTORY.Attribute7%TYPE,
741: p_Created_By IGC_CC_ACCT_LINE_HISTORY.Created_By%TYPE,
742: p_Attribute1 IGC_CC_ACCT_LINE_HISTORY.Attribute1%TYPE,
743: p_Attribute2 IGC_CC_ACCT_LINE_HISTORY.Attribute2%TYPE,
744: p_Attribute3 IGC_CC_ACCT_LINE_HISTORY.Attribute3%TYPE,
745: p_Attribute4 IGC_CC_ACCT_LINE_HISTORY.Attribute4%TYPE,
746: p_Attribute5 IGC_CC_ACCT_LINE_HISTORY.Attribute5%TYPE,
747: p_Attribute6 IGC_CC_ACCT_LINE_HISTORY.Attribute6%TYPE,
748: p_Attribute7 IGC_CC_ACCT_LINE_HISTORY.Attribute7%TYPE,
749: p_Attribute8 IGC_CC_ACCT_LINE_HISTORY.Attribute8%TYPE,
742: p_Attribute1 IGC_CC_ACCT_LINE_HISTORY.Attribute1%TYPE,
743: p_Attribute2 IGC_CC_ACCT_LINE_HISTORY.Attribute2%TYPE,
744: p_Attribute3 IGC_CC_ACCT_LINE_HISTORY.Attribute3%TYPE,
745: p_Attribute4 IGC_CC_ACCT_LINE_HISTORY.Attribute4%TYPE,
746: p_Attribute5 IGC_CC_ACCT_LINE_HISTORY.Attribute5%TYPE,
747: p_Attribute6 IGC_CC_ACCT_LINE_HISTORY.Attribute6%TYPE,
748: p_Attribute7 IGC_CC_ACCT_LINE_HISTORY.Attribute7%TYPE,
749: p_Attribute8 IGC_CC_ACCT_LINE_HISTORY.Attribute8%TYPE,
750: p_Attribute9 IGC_CC_ACCT_LINE_HISTORY.Attribute9%TYPE,
743: p_Attribute2 IGC_CC_ACCT_LINE_HISTORY.Attribute2%TYPE,
744: p_Attribute3 IGC_CC_ACCT_LINE_HISTORY.Attribute3%TYPE,
745: p_Attribute4 IGC_CC_ACCT_LINE_HISTORY.Attribute4%TYPE,
746: p_Attribute5 IGC_CC_ACCT_LINE_HISTORY.Attribute5%TYPE,
747: p_Attribute6 IGC_CC_ACCT_LINE_HISTORY.Attribute6%TYPE,
748: p_Attribute7 IGC_CC_ACCT_LINE_HISTORY.Attribute7%TYPE,
749: p_Attribute8 IGC_CC_ACCT_LINE_HISTORY.Attribute8%TYPE,
750: p_Attribute9 IGC_CC_ACCT_LINE_HISTORY.Attribute9%TYPE,
751: p_Attribute10 IGC_CC_ACCT_LINE_HISTORY.Attribute10%TYPE,
744: p_Attribute3 IGC_CC_ACCT_LINE_HISTORY.Attribute3%TYPE,
745: p_Attribute4 IGC_CC_ACCT_LINE_HISTORY.Attribute4%TYPE,
746: p_Attribute5 IGC_CC_ACCT_LINE_HISTORY.Attribute5%TYPE,
747: p_Attribute6 IGC_CC_ACCT_LINE_HISTORY.Attribute6%TYPE,
748: p_Attribute7 IGC_CC_ACCT_LINE_HISTORY.Attribute7%TYPE,
749: p_Attribute8 IGC_CC_ACCT_LINE_HISTORY.Attribute8%TYPE,
750: p_Attribute9 IGC_CC_ACCT_LINE_HISTORY.Attribute9%TYPE,
751: p_Attribute10 IGC_CC_ACCT_LINE_HISTORY.Attribute10%TYPE,
752: p_Attribute11 IGC_CC_ACCT_LINE_HISTORY.Attribute11%TYPE,
745: p_Attribute4 IGC_CC_ACCT_LINE_HISTORY.Attribute4%TYPE,
746: p_Attribute5 IGC_CC_ACCT_LINE_HISTORY.Attribute5%TYPE,
747: p_Attribute6 IGC_CC_ACCT_LINE_HISTORY.Attribute6%TYPE,
748: p_Attribute7 IGC_CC_ACCT_LINE_HISTORY.Attribute7%TYPE,
749: p_Attribute8 IGC_CC_ACCT_LINE_HISTORY.Attribute8%TYPE,
750: p_Attribute9 IGC_CC_ACCT_LINE_HISTORY.Attribute9%TYPE,
751: p_Attribute10 IGC_CC_ACCT_LINE_HISTORY.Attribute10%TYPE,
752: p_Attribute11 IGC_CC_ACCT_LINE_HISTORY.Attribute11%TYPE,
753: p_Attribute12 IGC_CC_ACCT_LINE_HISTORY.Attribute12%TYPE,
746: p_Attribute5 IGC_CC_ACCT_LINE_HISTORY.Attribute5%TYPE,
747: p_Attribute6 IGC_CC_ACCT_LINE_HISTORY.Attribute6%TYPE,
748: p_Attribute7 IGC_CC_ACCT_LINE_HISTORY.Attribute7%TYPE,
749: p_Attribute8 IGC_CC_ACCT_LINE_HISTORY.Attribute8%TYPE,
750: p_Attribute9 IGC_CC_ACCT_LINE_HISTORY.Attribute9%TYPE,
751: p_Attribute10 IGC_CC_ACCT_LINE_HISTORY.Attribute10%TYPE,
752: p_Attribute11 IGC_CC_ACCT_LINE_HISTORY.Attribute11%TYPE,
753: p_Attribute12 IGC_CC_ACCT_LINE_HISTORY.Attribute12%TYPE,
754: p_Attribute13 IGC_CC_ACCT_LINE_HISTORY.Attribute13%TYPE,
747: p_Attribute6 IGC_CC_ACCT_LINE_HISTORY.Attribute6%TYPE,
748: p_Attribute7 IGC_CC_ACCT_LINE_HISTORY.Attribute7%TYPE,
749: p_Attribute8 IGC_CC_ACCT_LINE_HISTORY.Attribute8%TYPE,
750: p_Attribute9 IGC_CC_ACCT_LINE_HISTORY.Attribute9%TYPE,
751: p_Attribute10 IGC_CC_ACCT_LINE_HISTORY.Attribute10%TYPE,
752: p_Attribute11 IGC_CC_ACCT_LINE_HISTORY.Attribute11%TYPE,
753: p_Attribute12 IGC_CC_ACCT_LINE_HISTORY.Attribute12%TYPE,
754: p_Attribute13 IGC_CC_ACCT_LINE_HISTORY.Attribute13%TYPE,
755: p_Attribute14 IGC_CC_ACCT_LINE_HISTORY.Attribute14%TYPE,
748: p_Attribute7 IGC_CC_ACCT_LINE_HISTORY.Attribute7%TYPE,
749: p_Attribute8 IGC_CC_ACCT_LINE_HISTORY.Attribute8%TYPE,
750: p_Attribute9 IGC_CC_ACCT_LINE_HISTORY.Attribute9%TYPE,
751: p_Attribute10 IGC_CC_ACCT_LINE_HISTORY.Attribute10%TYPE,
752: p_Attribute11 IGC_CC_ACCT_LINE_HISTORY.Attribute11%TYPE,
753: p_Attribute12 IGC_CC_ACCT_LINE_HISTORY.Attribute12%TYPE,
754: p_Attribute13 IGC_CC_ACCT_LINE_HISTORY.Attribute13%TYPE,
755: p_Attribute14 IGC_CC_ACCT_LINE_HISTORY.Attribute14%TYPE,
756: p_Attribute15 IGC_CC_ACCT_LINE_HISTORY.Attribute15%TYPE,
749: p_Attribute8 IGC_CC_ACCT_LINE_HISTORY.Attribute8%TYPE,
750: p_Attribute9 IGC_CC_ACCT_LINE_HISTORY.Attribute9%TYPE,
751: p_Attribute10 IGC_CC_ACCT_LINE_HISTORY.Attribute10%TYPE,
752: p_Attribute11 IGC_CC_ACCT_LINE_HISTORY.Attribute11%TYPE,
753: p_Attribute12 IGC_CC_ACCT_LINE_HISTORY.Attribute12%TYPE,
754: p_Attribute13 IGC_CC_ACCT_LINE_HISTORY.Attribute13%TYPE,
755: p_Attribute14 IGC_CC_ACCT_LINE_HISTORY.Attribute14%TYPE,
756: p_Attribute15 IGC_CC_ACCT_LINE_HISTORY.Attribute15%TYPE,
757: p_Context IGC_CC_ACCT_LINE_HISTORY.Context%TYPE,
750: p_Attribute9 IGC_CC_ACCT_LINE_HISTORY.Attribute9%TYPE,
751: p_Attribute10 IGC_CC_ACCT_LINE_HISTORY.Attribute10%TYPE,
752: p_Attribute11 IGC_CC_ACCT_LINE_HISTORY.Attribute11%TYPE,
753: p_Attribute12 IGC_CC_ACCT_LINE_HISTORY.Attribute12%TYPE,
754: p_Attribute13 IGC_CC_ACCT_LINE_HISTORY.Attribute13%TYPE,
755: p_Attribute14 IGC_CC_ACCT_LINE_HISTORY.Attribute14%TYPE,
756: p_Attribute15 IGC_CC_ACCT_LINE_HISTORY.Attribute15%TYPE,
757: p_Context IGC_CC_ACCT_LINE_HISTORY.Context%TYPE,
758: p_cc_func_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE,
751: p_Attribute10 IGC_CC_ACCT_LINE_HISTORY.Attribute10%TYPE,
752: p_Attribute11 IGC_CC_ACCT_LINE_HISTORY.Attribute11%TYPE,
753: p_Attribute12 IGC_CC_ACCT_LINE_HISTORY.Attribute12%TYPE,
754: p_Attribute13 IGC_CC_ACCT_LINE_HISTORY.Attribute13%TYPE,
755: p_Attribute14 IGC_CC_ACCT_LINE_HISTORY.Attribute14%TYPE,
756: p_Attribute15 IGC_CC_ACCT_LINE_HISTORY.Attribute15%TYPE,
757: p_Context IGC_CC_ACCT_LINE_HISTORY.Context%TYPE,
758: p_cc_func_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE,
759: p_cc_ent_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_ent_withheld_amt%TYPE,
752: p_Attribute11 IGC_CC_ACCT_LINE_HISTORY.Attribute11%TYPE,
753: p_Attribute12 IGC_CC_ACCT_LINE_HISTORY.Attribute12%TYPE,
754: p_Attribute13 IGC_CC_ACCT_LINE_HISTORY.Attribute13%TYPE,
755: p_Attribute14 IGC_CC_ACCT_LINE_HISTORY.Attribute14%TYPE,
756: p_Attribute15 IGC_CC_ACCT_LINE_HISTORY.Attribute15%TYPE,
757: p_Context IGC_CC_ACCT_LINE_HISTORY.Context%TYPE,
758: p_cc_func_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE,
759: p_cc_ent_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_ent_withheld_amt%TYPE,
760: G_FLAG IN OUT NOCOPY VARCHAR2,
753: p_Attribute12 IGC_CC_ACCT_LINE_HISTORY.Attribute12%TYPE,
754: p_Attribute13 IGC_CC_ACCT_LINE_HISTORY.Attribute13%TYPE,
755: p_Attribute14 IGC_CC_ACCT_LINE_HISTORY.Attribute14%TYPE,
756: p_Attribute15 IGC_CC_ACCT_LINE_HISTORY.Attribute15%TYPE,
757: p_Context IGC_CC_ACCT_LINE_HISTORY.Context%TYPE,
758: p_cc_func_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE,
759: p_cc_ent_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_ent_withheld_amt%TYPE,
760: G_FLAG IN OUT NOCOPY VARCHAR2,
761: P_Tax_Classif_Code IGC_CC_ACCT_LINE_HISTORY.Tax_Classif_Code%TYPE
754: p_Attribute13 IGC_CC_ACCT_LINE_HISTORY.Attribute13%TYPE,
755: p_Attribute14 IGC_CC_ACCT_LINE_HISTORY.Attribute14%TYPE,
756: p_Attribute15 IGC_CC_ACCT_LINE_HISTORY.Attribute15%TYPE,
757: p_Context IGC_CC_ACCT_LINE_HISTORY.Context%TYPE,
758: p_cc_func_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE,
759: p_cc_ent_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_ent_withheld_amt%TYPE,
760: G_FLAG IN OUT NOCOPY VARCHAR2,
761: P_Tax_Classif_Code IGC_CC_ACCT_LINE_HISTORY.Tax_Classif_Code%TYPE
762: ) IS
755: p_Attribute14 IGC_CC_ACCT_LINE_HISTORY.Attribute14%TYPE,
756: p_Attribute15 IGC_CC_ACCT_LINE_HISTORY.Attribute15%TYPE,
757: p_Context IGC_CC_ACCT_LINE_HISTORY.Context%TYPE,
758: p_cc_func_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE,
759: p_cc_ent_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_ent_withheld_amt%TYPE,
760: G_FLAG IN OUT NOCOPY VARCHAR2,
761: P_Tax_Classif_Code IGC_CC_ACCT_LINE_HISTORY.Tax_Classif_Code%TYPE
762: ) IS
763:
757: p_Context IGC_CC_ACCT_LINE_HISTORY.Context%TYPE,
758: p_cc_func_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE,
759: p_cc_ent_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_ent_withheld_amt%TYPE,
760: G_FLAG IN OUT NOCOPY VARCHAR2,
761: P_Tax_Classif_Code IGC_CC_ACCT_LINE_HISTORY.Tax_Classif_Code%TYPE
762: ) IS
763:
764: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
765: l_api_version CONSTANT NUMBER := 1.0;
782: END IF;
783:
784: X_return_status := FND_API.G_RET_STS_SUCCESS ;
785:
786: UPDATE IGC_CC_ACCT_LINE_HISTORY
787: SET CC_Acct_Line_Id = p_CC_Acct_Line_Id,
788: CC_Header_Id = p_CC_Header_Id,
789: Parent_Header_Id = p_Parent_Header_Id,
790: Parent_Acct_Line_Id = p_Parent_Acct_Line_Id,
919:
920: X_return_status := FND_API.G_RET_STS_SUCCESS ;
921:
922: DELETE
923: FROM IGC_CC_ACCT_LINE_HISTORY
924: WHERE rowid = p_Rowid;
925:
926: IF (SQL%NOTFOUND) THEN
927: RAISE NO_DATA_FOUND;
965:
966: END Delete_Row;
967:
968:
969: END IGC_CC_ACCT_LINE_HISTORY_PKG;