eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGC_CC_DET_PF_HISTORY_PKG dependencies on IGC_CC_DET_PF

Line 1: PACKAGE BODY IGC_CC_DET_PF_HISTORY_PKG as

1: PACKAGE BODY IGC_CC_DET_PF_HISTORY_PKG as
2: /* $Header: IGCCDFHB.pls 120.3.12000000.3 2007/10/19 07:03:44 smannava ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IGC_CC_DET_PF_HISTORY_PKG';
5: g_debug_flag VARCHAR2(1) := 'N' ;

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IGC_CC_DET_PF_HISTORY_PKG';

1: PACKAGE BODY IGC_CC_DET_PF_HISTORY_PKG as
2: /* $Header: IGCCDFHB.pls 120.3.12000000.3 2007/10/19 07:03:44 smannava ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IGC_CC_DET_PF_HISTORY_PKG';
5: g_debug_flag VARCHAR2(1) := 'N' ;
6:
7: /* ================================================================================
8: PROCEDURE Insert_Row

Line 20: p_CC_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Id%TYPE,

16: X_return_status OUT NOCOPY VARCHAR2,
17: X_msg_count OUT NOCOPY NUMBER,
18: X_msg_data OUT NOCOPY VARCHAR2,
19: p_Rowid IN OUT NOCOPY VARCHAR2,
20: p_CC_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Id%TYPE,
21: p_CC_Det_PF_Line_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Num%TYPE,
22: p_CC_Acct_Line_Id IGC_CC_DET_PF_HISTORY.CC_Acct_Line_Id%TYPE,
23: p_Parent_Acct_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Acct_Line_Id%TYPE,
24: p_Parent_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Det_PF_Line_Id%TYPE,

Line 21: p_CC_Det_PF_Line_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Num%TYPE,

17: X_msg_count OUT NOCOPY NUMBER,
18: X_msg_data OUT NOCOPY VARCHAR2,
19: p_Rowid IN OUT NOCOPY VARCHAR2,
20: p_CC_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Id%TYPE,
21: p_CC_Det_PF_Line_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Num%TYPE,
22: p_CC_Acct_Line_Id IGC_CC_DET_PF_HISTORY.CC_Acct_Line_Id%TYPE,
23: p_Parent_Acct_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Acct_Line_Id%TYPE,
24: p_Parent_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Det_PF_Line_Id%TYPE,
25: p_Det_PF_Version_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Num%TYPE,

Line 22: p_CC_Acct_Line_Id IGC_CC_DET_PF_HISTORY.CC_Acct_Line_Id%TYPE,

18: X_msg_data OUT NOCOPY VARCHAR2,
19: p_Rowid IN OUT NOCOPY VARCHAR2,
20: p_CC_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Id%TYPE,
21: p_CC_Det_PF_Line_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Num%TYPE,
22: p_CC_Acct_Line_Id IGC_CC_DET_PF_HISTORY.CC_Acct_Line_Id%TYPE,
23: p_Parent_Acct_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Acct_Line_Id%TYPE,
24: p_Parent_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Det_PF_Line_Id%TYPE,
25: p_Det_PF_Version_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Num%TYPE,
26: p_Det_PF_Version_Action IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Action%TYPE,

Line 23: p_Parent_Acct_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Acct_Line_Id%TYPE,

19: p_Rowid IN OUT NOCOPY VARCHAR2,
20: p_CC_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Id%TYPE,
21: p_CC_Det_PF_Line_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Num%TYPE,
22: p_CC_Acct_Line_Id IGC_CC_DET_PF_HISTORY.CC_Acct_Line_Id%TYPE,
23: p_Parent_Acct_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Acct_Line_Id%TYPE,
24: p_Parent_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Det_PF_Line_Id%TYPE,
25: p_Det_PF_Version_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Num%TYPE,
26: p_Det_PF_Version_Action IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Action%TYPE,
27: p_CC_Det_PF_Entered_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Entered_Amt%TYPE,

Line 24: p_Parent_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Det_PF_Line_Id%TYPE,

20: p_CC_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Id%TYPE,
21: p_CC_Det_PF_Line_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Num%TYPE,
22: p_CC_Acct_Line_Id IGC_CC_DET_PF_HISTORY.CC_Acct_Line_Id%TYPE,
23: p_Parent_Acct_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Acct_Line_Id%TYPE,
24: p_Parent_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Det_PF_Line_Id%TYPE,
25: p_Det_PF_Version_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Num%TYPE,
26: p_Det_PF_Version_Action IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Action%TYPE,
27: p_CC_Det_PF_Entered_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Entered_Amt%TYPE,
28: p_CC_Det_PF_Func_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Func_Amt%TYPE,

Line 25: p_Det_PF_Version_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Num%TYPE,

21: p_CC_Det_PF_Line_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Num%TYPE,
22: p_CC_Acct_Line_Id IGC_CC_DET_PF_HISTORY.CC_Acct_Line_Id%TYPE,
23: p_Parent_Acct_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Acct_Line_Id%TYPE,
24: p_Parent_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Det_PF_Line_Id%TYPE,
25: p_Det_PF_Version_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Num%TYPE,
26: p_Det_PF_Version_Action IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Action%TYPE,
27: p_CC_Det_PF_Entered_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Entered_Amt%TYPE,
28: p_CC_Det_PF_Func_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Func_Amt%TYPE,
29: p_CC_Det_PF_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Date%TYPE,

Line 26: p_Det_PF_Version_Action IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Action%TYPE,

22: p_CC_Acct_Line_Id IGC_CC_DET_PF_HISTORY.CC_Acct_Line_Id%TYPE,
23: p_Parent_Acct_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Acct_Line_Id%TYPE,
24: p_Parent_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Det_PF_Line_Id%TYPE,
25: p_Det_PF_Version_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Num%TYPE,
26: p_Det_PF_Version_Action IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Action%TYPE,
27: p_CC_Det_PF_Entered_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Entered_Amt%TYPE,
28: p_CC_Det_PF_Func_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Func_Amt%TYPE,
29: p_CC_Det_PF_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Date%TYPE,
30: p_CC_Det_PF_Billed_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Billed_Amt%TYPE,

Line 27: p_CC_Det_PF_Entered_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Entered_Amt%TYPE,

23: p_Parent_Acct_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Acct_Line_Id%TYPE,
24: p_Parent_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Det_PF_Line_Id%TYPE,
25: p_Det_PF_Version_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Num%TYPE,
26: p_Det_PF_Version_Action IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Action%TYPE,
27: p_CC_Det_PF_Entered_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Entered_Amt%TYPE,
28: p_CC_Det_PF_Func_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Func_Amt%TYPE,
29: p_CC_Det_PF_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Date%TYPE,
30: p_CC_Det_PF_Billed_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Billed_Amt%TYPE,
31: p_CC_Det_PF_Unbilled_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Unbilled_Amt%TYPE,

Line 28: p_CC_Det_PF_Func_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Func_Amt%TYPE,

24: p_Parent_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Det_PF_Line_Id%TYPE,
25: p_Det_PF_Version_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Num%TYPE,
26: p_Det_PF_Version_Action IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Action%TYPE,
27: p_CC_Det_PF_Entered_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Entered_Amt%TYPE,
28: p_CC_Det_PF_Func_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Func_Amt%TYPE,
29: p_CC_Det_PF_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Date%TYPE,
30: p_CC_Det_PF_Billed_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Billed_Amt%TYPE,
31: p_CC_Det_PF_Unbilled_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Unbilled_Amt%TYPE,
32: p_CC_Det_PF_Encmbrnc_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Amt%TYPE,

Line 29: p_CC_Det_PF_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Date%TYPE,

25: p_Det_PF_Version_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Num%TYPE,
26: p_Det_PF_Version_Action IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Action%TYPE,
27: p_CC_Det_PF_Entered_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Entered_Amt%TYPE,
28: p_CC_Det_PF_Func_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Func_Amt%TYPE,
29: p_CC_Det_PF_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Date%TYPE,
30: p_CC_Det_PF_Billed_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Billed_Amt%TYPE,
31: p_CC_Det_PF_Unbilled_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Unbilled_Amt%TYPE,
32: p_CC_Det_PF_Encmbrnc_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Amt%TYPE,
33: p_CC_Det_PF_Encmbrnc_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Date%TYPE,

Line 30: p_CC_Det_PF_Billed_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Billed_Amt%TYPE,

26: p_Det_PF_Version_Action IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Action%TYPE,
27: p_CC_Det_PF_Entered_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Entered_Amt%TYPE,
28: p_CC_Det_PF_Func_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Func_Amt%TYPE,
29: p_CC_Det_PF_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Date%TYPE,
30: p_CC_Det_PF_Billed_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Billed_Amt%TYPE,
31: p_CC_Det_PF_Unbilled_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Unbilled_Amt%TYPE,
32: p_CC_Det_PF_Encmbrnc_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Amt%TYPE,
33: p_CC_Det_PF_Encmbrnc_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Date%TYPE,
34: p_CC_Det_PF_Encmbrnc_Status IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Status%TYPE,

Line 31: p_CC_Det_PF_Unbilled_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Unbilled_Amt%TYPE,

27: p_CC_Det_PF_Entered_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Entered_Amt%TYPE,
28: p_CC_Det_PF_Func_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Func_Amt%TYPE,
29: p_CC_Det_PF_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Date%TYPE,
30: p_CC_Det_PF_Billed_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Billed_Amt%TYPE,
31: p_CC_Det_PF_Unbilled_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Unbilled_Amt%TYPE,
32: p_CC_Det_PF_Encmbrnc_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Amt%TYPE,
33: p_CC_Det_PF_Encmbrnc_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Date%TYPE,
34: p_CC_Det_PF_Encmbrnc_Status IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Status%TYPE,
35: p_Last_Update_Date IGC_CC_DET_PF_HISTORY.Last_Update_Date%TYPE,

Line 32: p_CC_Det_PF_Encmbrnc_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Amt%TYPE,

28: p_CC_Det_PF_Func_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Func_Amt%TYPE,
29: p_CC_Det_PF_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Date%TYPE,
30: p_CC_Det_PF_Billed_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Billed_Amt%TYPE,
31: p_CC_Det_PF_Unbilled_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Unbilled_Amt%TYPE,
32: p_CC_Det_PF_Encmbrnc_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Amt%TYPE,
33: p_CC_Det_PF_Encmbrnc_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Date%TYPE,
34: p_CC_Det_PF_Encmbrnc_Status IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Status%TYPE,
35: p_Last_Update_Date IGC_CC_DET_PF_HISTORY.Last_Update_Date%TYPE,
36: p_Last_Updated_By IGC_CC_DET_PF_HISTORY.Last_Updated_By%TYPE,

Line 33: p_CC_Det_PF_Encmbrnc_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Date%TYPE,

29: p_CC_Det_PF_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Date%TYPE,
30: p_CC_Det_PF_Billed_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Billed_Amt%TYPE,
31: p_CC_Det_PF_Unbilled_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Unbilled_Amt%TYPE,
32: p_CC_Det_PF_Encmbrnc_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Amt%TYPE,
33: p_CC_Det_PF_Encmbrnc_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Date%TYPE,
34: p_CC_Det_PF_Encmbrnc_Status IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Status%TYPE,
35: p_Last_Update_Date IGC_CC_DET_PF_HISTORY.Last_Update_Date%TYPE,
36: p_Last_Updated_By IGC_CC_DET_PF_HISTORY.Last_Updated_By%TYPE,
37: p_Last_Update_Login IGC_CC_DET_PF_HISTORY.Last_Update_Login%TYPE,

Line 34: p_CC_Det_PF_Encmbrnc_Status IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Status%TYPE,

30: p_CC_Det_PF_Billed_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Billed_Amt%TYPE,
31: p_CC_Det_PF_Unbilled_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Unbilled_Amt%TYPE,
32: p_CC_Det_PF_Encmbrnc_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Amt%TYPE,
33: p_CC_Det_PF_Encmbrnc_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Date%TYPE,
34: p_CC_Det_PF_Encmbrnc_Status IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Status%TYPE,
35: p_Last_Update_Date IGC_CC_DET_PF_HISTORY.Last_Update_Date%TYPE,
36: p_Last_Updated_By IGC_CC_DET_PF_HISTORY.Last_Updated_By%TYPE,
37: p_Last_Update_Login IGC_CC_DET_PF_HISTORY.Last_Update_Login%TYPE,
38: p_Creation_Date IGC_CC_DET_PF_HISTORY.Creation_Date%TYPE,

Line 35: p_Last_Update_Date IGC_CC_DET_PF_HISTORY.Last_Update_Date%TYPE,

31: p_CC_Det_PF_Unbilled_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Unbilled_Amt%TYPE,
32: p_CC_Det_PF_Encmbrnc_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Amt%TYPE,
33: p_CC_Det_PF_Encmbrnc_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Date%TYPE,
34: p_CC_Det_PF_Encmbrnc_Status IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Status%TYPE,
35: p_Last_Update_Date IGC_CC_DET_PF_HISTORY.Last_Update_Date%TYPE,
36: p_Last_Updated_By IGC_CC_DET_PF_HISTORY.Last_Updated_By%TYPE,
37: p_Last_Update_Login IGC_CC_DET_PF_HISTORY.Last_Update_Login%TYPE,
38: p_Creation_Date IGC_CC_DET_PF_HISTORY.Creation_Date%TYPE,
39: p_Created_By IGC_CC_DET_PF_HISTORY.Created_By%TYPE,

Line 36: p_Last_Updated_By IGC_CC_DET_PF_HISTORY.Last_Updated_By%TYPE,

32: p_CC_Det_PF_Encmbrnc_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Amt%TYPE,
33: p_CC_Det_PF_Encmbrnc_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Date%TYPE,
34: p_CC_Det_PF_Encmbrnc_Status IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Status%TYPE,
35: p_Last_Update_Date IGC_CC_DET_PF_HISTORY.Last_Update_Date%TYPE,
36: p_Last_Updated_By IGC_CC_DET_PF_HISTORY.Last_Updated_By%TYPE,
37: p_Last_Update_Login IGC_CC_DET_PF_HISTORY.Last_Update_Login%TYPE,
38: p_Creation_Date IGC_CC_DET_PF_HISTORY.Creation_Date%TYPE,
39: p_Created_By IGC_CC_DET_PF_HISTORY.Created_By%TYPE,
40: p_Attribute1 IGC_CC_DET_PF_HISTORY.Attribute1%TYPE,

Line 37: p_Last_Update_Login IGC_CC_DET_PF_HISTORY.Last_Update_Login%TYPE,

33: p_CC_Det_PF_Encmbrnc_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Date%TYPE,
34: p_CC_Det_PF_Encmbrnc_Status IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Status%TYPE,
35: p_Last_Update_Date IGC_CC_DET_PF_HISTORY.Last_Update_Date%TYPE,
36: p_Last_Updated_By IGC_CC_DET_PF_HISTORY.Last_Updated_By%TYPE,
37: p_Last_Update_Login IGC_CC_DET_PF_HISTORY.Last_Update_Login%TYPE,
38: p_Creation_Date IGC_CC_DET_PF_HISTORY.Creation_Date%TYPE,
39: p_Created_By IGC_CC_DET_PF_HISTORY.Created_By%TYPE,
40: p_Attribute1 IGC_CC_DET_PF_HISTORY.Attribute1%TYPE,
41: p_Attribute2 IGC_CC_DET_PF_HISTORY.Attribute2%TYPE,

Line 38: p_Creation_Date IGC_CC_DET_PF_HISTORY.Creation_Date%TYPE,

34: p_CC_Det_PF_Encmbrnc_Status IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Status%TYPE,
35: p_Last_Update_Date IGC_CC_DET_PF_HISTORY.Last_Update_Date%TYPE,
36: p_Last_Updated_By IGC_CC_DET_PF_HISTORY.Last_Updated_By%TYPE,
37: p_Last_Update_Login IGC_CC_DET_PF_HISTORY.Last_Update_Login%TYPE,
38: p_Creation_Date IGC_CC_DET_PF_HISTORY.Creation_Date%TYPE,
39: p_Created_By IGC_CC_DET_PF_HISTORY.Created_By%TYPE,
40: p_Attribute1 IGC_CC_DET_PF_HISTORY.Attribute1%TYPE,
41: p_Attribute2 IGC_CC_DET_PF_HISTORY.Attribute2%TYPE,
42: p_Attribute3 IGC_CC_DET_PF_HISTORY.Attribute3%TYPE,

Line 39: p_Created_By IGC_CC_DET_PF_HISTORY.Created_By%TYPE,

35: p_Last_Update_Date IGC_CC_DET_PF_HISTORY.Last_Update_Date%TYPE,
36: p_Last_Updated_By IGC_CC_DET_PF_HISTORY.Last_Updated_By%TYPE,
37: p_Last_Update_Login IGC_CC_DET_PF_HISTORY.Last_Update_Login%TYPE,
38: p_Creation_Date IGC_CC_DET_PF_HISTORY.Creation_Date%TYPE,
39: p_Created_By IGC_CC_DET_PF_HISTORY.Created_By%TYPE,
40: p_Attribute1 IGC_CC_DET_PF_HISTORY.Attribute1%TYPE,
41: p_Attribute2 IGC_CC_DET_PF_HISTORY.Attribute2%TYPE,
42: p_Attribute3 IGC_CC_DET_PF_HISTORY.Attribute3%TYPE,
43: p_Attribute4 IGC_CC_DET_PF_HISTORY.Attribute4%TYPE,

Line 40: p_Attribute1 IGC_CC_DET_PF_HISTORY.Attribute1%TYPE,

36: p_Last_Updated_By IGC_CC_DET_PF_HISTORY.Last_Updated_By%TYPE,
37: p_Last_Update_Login IGC_CC_DET_PF_HISTORY.Last_Update_Login%TYPE,
38: p_Creation_Date IGC_CC_DET_PF_HISTORY.Creation_Date%TYPE,
39: p_Created_By IGC_CC_DET_PF_HISTORY.Created_By%TYPE,
40: p_Attribute1 IGC_CC_DET_PF_HISTORY.Attribute1%TYPE,
41: p_Attribute2 IGC_CC_DET_PF_HISTORY.Attribute2%TYPE,
42: p_Attribute3 IGC_CC_DET_PF_HISTORY.Attribute3%TYPE,
43: p_Attribute4 IGC_CC_DET_PF_HISTORY.Attribute4%TYPE,
44: p_Attribute5 IGC_CC_DET_PF_HISTORY.Attribute5%TYPE,

Line 41: p_Attribute2 IGC_CC_DET_PF_HISTORY.Attribute2%TYPE,

37: p_Last_Update_Login IGC_CC_DET_PF_HISTORY.Last_Update_Login%TYPE,
38: p_Creation_Date IGC_CC_DET_PF_HISTORY.Creation_Date%TYPE,
39: p_Created_By IGC_CC_DET_PF_HISTORY.Created_By%TYPE,
40: p_Attribute1 IGC_CC_DET_PF_HISTORY.Attribute1%TYPE,
41: p_Attribute2 IGC_CC_DET_PF_HISTORY.Attribute2%TYPE,
42: p_Attribute3 IGC_CC_DET_PF_HISTORY.Attribute3%TYPE,
43: p_Attribute4 IGC_CC_DET_PF_HISTORY.Attribute4%TYPE,
44: p_Attribute5 IGC_CC_DET_PF_HISTORY.Attribute5%TYPE,
45: p_Attribute6 IGC_CC_DET_PF_HISTORY.Attribute6%TYPE,

Line 42: p_Attribute3 IGC_CC_DET_PF_HISTORY.Attribute3%TYPE,

38: p_Creation_Date IGC_CC_DET_PF_HISTORY.Creation_Date%TYPE,
39: p_Created_By IGC_CC_DET_PF_HISTORY.Created_By%TYPE,
40: p_Attribute1 IGC_CC_DET_PF_HISTORY.Attribute1%TYPE,
41: p_Attribute2 IGC_CC_DET_PF_HISTORY.Attribute2%TYPE,
42: p_Attribute3 IGC_CC_DET_PF_HISTORY.Attribute3%TYPE,
43: p_Attribute4 IGC_CC_DET_PF_HISTORY.Attribute4%TYPE,
44: p_Attribute5 IGC_CC_DET_PF_HISTORY.Attribute5%TYPE,
45: p_Attribute6 IGC_CC_DET_PF_HISTORY.Attribute6%TYPE,
46: p_Attribute7 IGC_CC_DET_PF_HISTORY.Attribute7%TYPE,

Line 43: p_Attribute4 IGC_CC_DET_PF_HISTORY.Attribute4%TYPE,

39: p_Created_By IGC_CC_DET_PF_HISTORY.Created_By%TYPE,
40: p_Attribute1 IGC_CC_DET_PF_HISTORY.Attribute1%TYPE,
41: p_Attribute2 IGC_CC_DET_PF_HISTORY.Attribute2%TYPE,
42: p_Attribute3 IGC_CC_DET_PF_HISTORY.Attribute3%TYPE,
43: p_Attribute4 IGC_CC_DET_PF_HISTORY.Attribute4%TYPE,
44: p_Attribute5 IGC_CC_DET_PF_HISTORY.Attribute5%TYPE,
45: p_Attribute6 IGC_CC_DET_PF_HISTORY.Attribute6%TYPE,
46: p_Attribute7 IGC_CC_DET_PF_HISTORY.Attribute7%TYPE,
47: p_Attribute8 IGC_CC_DET_PF_HISTORY.Attribute8%TYPE,

Line 44: p_Attribute5 IGC_CC_DET_PF_HISTORY.Attribute5%TYPE,

40: p_Attribute1 IGC_CC_DET_PF_HISTORY.Attribute1%TYPE,
41: p_Attribute2 IGC_CC_DET_PF_HISTORY.Attribute2%TYPE,
42: p_Attribute3 IGC_CC_DET_PF_HISTORY.Attribute3%TYPE,
43: p_Attribute4 IGC_CC_DET_PF_HISTORY.Attribute4%TYPE,
44: p_Attribute5 IGC_CC_DET_PF_HISTORY.Attribute5%TYPE,
45: p_Attribute6 IGC_CC_DET_PF_HISTORY.Attribute6%TYPE,
46: p_Attribute7 IGC_CC_DET_PF_HISTORY.Attribute7%TYPE,
47: p_Attribute8 IGC_CC_DET_PF_HISTORY.Attribute8%TYPE,
48: p_Attribute9 IGC_CC_DET_PF_HISTORY.Attribute9%TYPE,

Line 45: p_Attribute6 IGC_CC_DET_PF_HISTORY.Attribute6%TYPE,

41: p_Attribute2 IGC_CC_DET_PF_HISTORY.Attribute2%TYPE,
42: p_Attribute3 IGC_CC_DET_PF_HISTORY.Attribute3%TYPE,
43: p_Attribute4 IGC_CC_DET_PF_HISTORY.Attribute4%TYPE,
44: p_Attribute5 IGC_CC_DET_PF_HISTORY.Attribute5%TYPE,
45: p_Attribute6 IGC_CC_DET_PF_HISTORY.Attribute6%TYPE,
46: p_Attribute7 IGC_CC_DET_PF_HISTORY.Attribute7%TYPE,
47: p_Attribute8 IGC_CC_DET_PF_HISTORY.Attribute8%TYPE,
48: p_Attribute9 IGC_CC_DET_PF_HISTORY.Attribute9%TYPE,
49: p_Attribute10 IGC_CC_DET_PF_HISTORY.Attribute10%TYPE,

Line 46: p_Attribute7 IGC_CC_DET_PF_HISTORY.Attribute7%TYPE,

42: p_Attribute3 IGC_CC_DET_PF_HISTORY.Attribute3%TYPE,
43: p_Attribute4 IGC_CC_DET_PF_HISTORY.Attribute4%TYPE,
44: p_Attribute5 IGC_CC_DET_PF_HISTORY.Attribute5%TYPE,
45: p_Attribute6 IGC_CC_DET_PF_HISTORY.Attribute6%TYPE,
46: p_Attribute7 IGC_CC_DET_PF_HISTORY.Attribute7%TYPE,
47: p_Attribute8 IGC_CC_DET_PF_HISTORY.Attribute8%TYPE,
48: p_Attribute9 IGC_CC_DET_PF_HISTORY.Attribute9%TYPE,
49: p_Attribute10 IGC_CC_DET_PF_HISTORY.Attribute10%TYPE,
50: p_Attribute11 IGC_CC_DET_PF_HISTORY.Attribute11%TYPE,

Line 47: p_Attribute8 IGC_CC_DET_PF_HISTORY.Attribute8%TYPE,

43: p_Attribute4 IGC_CC_DET_PF_HISTORY.Attribute4%TYPE,
44: p_Attribute5 IGC_CC_DET_PF_HISTORY.Attribute5%TYPE,
45: p_Attribute6 IGC_CC_DET_PF_HISTORY.Attribute6%TYPE,
46: p_Attribute7 IGC_CC_DET_PF_HISTORY.Attribute7%TYPE,
47: p_Attribute8 IGC_CC_DET_PF_HISTORY.Attribute8%TYPE,
48: p_Attribute9 IGC_CC_DET_PF_HISTORY.Attribute9%TYPE,
49: p_Attribute10 IGC_CC_DET_PF_HISTORY.Attribute10%TYPE,
50: p_Attribute11 IGC_CC_DET_PF_HISTORY.Attribute11%TYPE,
51: p_Attribute12 IGC_CC_DET_PF_HISTORY.Attribute12%TYPE,

Line 48: p_Attribute9 IGC_CC_DET_PF_HISTORY.Attribute9%TYPE,

44: p_Attribute5 IGC_CC_DET_PF_HISTORY.Attribute5%TYPE,
45: p_Attribute6 IGC_CC_DET_PF_HISTORY.Attribute6%TYPE,
46: p_Attribute7 IGC_CC_DET_PF_HISTORY.Attribute7%TYPE,
47: p_Attribute8 IGC_CC_DET_PF_HISTORY.Attribute8%TYPE,
48: p_Attribute9 IGC_CC_DET_PF_HISTORY.Attribute9%TYPE,
49: p_Attribute10 IGC_CC_DET_PF_HISTORY.Attribute10%TYPE,
50: p_Attribute11 IGC_CC_DET_PF_HISTORY.Attribute11%TYPE,
51: p_Attribute12 IGC_CC_DET_PF_HISTORY.Attribute12%TYPE,
52: p_Attribute13 IGC_CC_DET_PF_HISTORY.Attribute13%TYPE,

Line 49: p_Attribute10 IGC_CC_DET_PF_HISTORY.Attribute10%TYPE,

45: p_Attribute6 IGC_CC_DET_PF_HISTORY.Attribute6%TYPE,
46: p_Attribute7 IGC_CC_DET_PF_HISTORY.Attribute7%TYPE,
47: p_Attribute8 IGC_CC_DET_PF_HISTORY.Attribute8%TYPE,
48: p_Attribute9 IGC_CC_DET_PF_HISTORY.Attribute9%TYPE,
49: p_Attribute10 IGC_CC_DET_PF_HISTORY.Attribute10%TYPE,
50: p_Attribute11 IGC_CC_DET_PF_HISTORY.Attribute11%TYPE,
51: p_Attribute12 IGC_CC_DET_PF_HISTORY.Attribute12%TYPE,
52: p_Attribute13 IGC_CC_DET_PF_HISTORY.Attribute13%TYPE,
53: p_Attribute14 IGC_CC_DET_PF_HISTORY.Attribute14%TYPE,

Line 50: p_Attribute11 IGC_CC_DET_PF_HISTORY.Attribute11%TYPE,

46: p_Attribute7 IGC_CC_DET_PF_HISTORY.Attribute7%TYPE,
47: p_Attribute8 IGC_CC_DET_PF_HISTORY.Attribute8%TYPE,
48: p_Attribute9 IGC_CC_DET_PF_HISTORY.Attribute9%TYPE,
49: p_Attribute10 IGC_CC_DET_PF_HISTORY.Attribute10%TYPE,
50: p_Attribute11 IGC_CC_DET_PF_HISTORY.Attribute11%TYPE,
51: p_Attribute12 IGC_CC_DET_PF_HISTORY.Attribute12%TYPE,
52: p_Attribute13 IGC_CC_DET_PF_HISTORY.Attribute13%TYPE,
53: p_Attribute14 IGC_CC_DET_PF_HISTORY.Attribute14%TYPE,
54: p_Attribute15 IGC_CC_DET_PF_HISTORY.Attribute15%TYPE,

Line 51: p_Attribute12 IGC_CC_DET_PF_HISTORY.Attribute12%TYPE,

47: p_Attribute8 IGC_CC_DET_PF_HISTORY.Attribute8%TYPE,
48: p_Attribute9 IGC_CC_DET_PF_HISTORY.Attribute9%TYPE,
49: p_Attribute10 IGC_CC_DET_PF_HISTORY.Attribute10%TYPE,
50: p_Attribute11 IGC_CC_DET_PF_HISTORY.Attribute11%TYPE,
51: p_Attribute12 IGC_CC_DET_PF_HISTORY.Attribute12%TYPE,
52: p_Attribute13 IGC_CC_DET_PF_HISTORY.Attribute13%TYPE,
53: p_Attribute14 IGC_CC_DET_PF_HISTORY.Attribute14%TYPE,
54: p_Attribute15 IGC_CC_DET_PF_HISTORY.Attribute15%TYPE,
55: p_Context IGC_CC_DET_PF_HISTORY.Context%TYPE,

Line 52: p_Attribute13 IGC_CC_DET_PF_HISTORY.Attribute13%TYPE,

48: p_Attribute9 IGC_CC_DET_PF_HISTORY.Attribute9%TYPE,
49: p_Attribute10 IGC_CC_DET_PF_HISTORY.Attribute10%TYPE,
50: p_Attribute11 IGC_CC_DET_PF_HISTORY.Attribute11%TYPE,
51: p_Attribute12 IGC_CC_DET_PF_HISTORY.Attribute12%TYPE,
52: p_Attribute13 IGC_CC_DET_PF_HISTORY.Attribute13%TYPE,
53: p_Attribute14 IGC_CC_DET_PF_HISTORY.Attribute14%TYPE,
54: p_Attribute15 IGC_CC_DET_PF_HISTORY.Attribute15%TYPE,
55: p_Context IGC_CC_DET_PF_HISTORY.Context%TYPE,
56: G_FLAG IN OUT NOCOPY VARCHAR2

Line 53: p_Attribute14 IGC_CC_DET_PF_HISTORY.Attribute14%TYPE,

49: p_Attribute10 IGC_CC_DET_PF_HISTORY.Attribute10%TYPE,
50: p_Attribute11 IGC_CC_DET_PF_HISTORY.Attribute11%TYPE,
51: p_Attribute12 IGC_CC_DET_PF_HISTORY.Attribute12%TYPE,
52: p_Attribute13 IGC_CC_DET_PF_HISTORY.Attribute13%TYPE,
53: p_Attribute14 IGC_CC_DET_PF_HISTORY.Attribute14%TYPE,
54: p_Attribute15 IGC_CC_DET_PF_HISTORY.Attribute15%TYPE,
55: p_Context IGC_CC_DET_PF_HISTORY.Context%TYPE,
56: G_FLAG IN OUT NOCOPY VARCHAR2
57: ) IS

Line 54: p_Attribute15 IGC_CC_DET_PF_HISTORY.Attribute15%TYPE,

50: p_Attribute11 IGC_CC_DET_PF_HISTORY.Attribute11%TYPE,
51: p_Attribute12 IGC_CC_DET_PF_HISTORY.Attribute12%TYPE,
52: p_Attribute13 IGC_CC_DET_PF_HISTORY.Attribute13%TYPE,
53: p_Attribute14 IGC_CC_DET_PF_HISTORY.Attribute14%TYPE,
54: p_Attribute15 IGC_CC_DET_PF_HISTORY.Attribute15%TYPE,
55: p_Context IGC_CC_DET_PF_HISTORY.Context%TYPE,
56: G_FLAG IN OUT NOCOPY VARCHAR2
57: ) IS
58:

Line 55: p_Context IGC_CC_DET_PF_HISTORY.Context%TYPE,

51: p_Attribute12 IGC_CC_DET_PF_HISTORY.Attribute12%TYPE,
52: p_Attribute13 IGC_CC_DET_PF_HISTORY.Attribute13%TYPE,
53: p_Attribute14 IGC_CC_DET_PF_HISTORY.Attribute14%TYPE,
54: p_Attribute15 IGC_CC_DET_PF_HISTORY.Attribute15%TYPE,
55: p_Context IGC_CC_DET_PF_HISTORY.Context%TYPE,
56: G_FLAG IN OUT NOCOPY VARCHAR2
57: ) IS
58:
59: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';

Line 70: FROM IGC_CC_DET_PF_HISTORY

66: l_return_status VARCHAR2(1);
67:
68: CURSOR C_DET_PF_HST_ROWID IS
69: SELECT Rowid
70: FROM IGC_CC_DET_PF_HISTORY
71: WHERE CC_Det_PF_Line_Id = p_CC_Det_PF_Line_Id
72: AND CC_Det_PF_Version_Num = p_Det_PF_Version_Num;
73:
74: CURSOR c_igc_app_id IS

Line 84: IGC_CC_DET_PF IDP

80: SELECT SET_OF_BOOKS_ID,
81: ORG_ID,CONVERSION_DATE
82: FROM IGC_CC_HEADERS ICH,
83: IGC_CC_ACCT_LINES IAL,
84: IGC_CC_DET_PF IDP
85: WHERE ICH.CC_HEADER_ID = IAL.CC_HEADER_ID
86: AND IDP.CC_ACCT_LINE_ID = IAL.CC_ACCT_LINE_ID
87: AND IDP.CC_DET_PF_LINE_ID = p_CC_Det_Pf_Line_Id;
88:

Line 117: INTO IGC_CC_DET_PF_HISTORY

113: -- -----------------------------------------------------------------
114: -- Insert the DET PF line History record as requested.
115: -- -----------------------------------------------------------------
116: INSERT
117: INTO IGC_CC_DET_PF_HISTORY
118: (CC_Det_PF_Line_Id,
119: Parent_Det_PF_Line_Id,
120: CC_Acct_Line_Id,
121: Parent_Acct_Line_Id,

Line 265: -- MRC Handler For IGC_CC_DET_PF to insert all MRC records for

261: -- ------------------------------------------------------------------
262: IF (l_MRC_Enabled = 'Y') THEN
263:
264: -- ------------------------------------------------------------------
265: -- MRC Handler For IGC_CC_DET_PF to insert all MRC records for
266: -- the reporting set of books for this PRIMARY set of books.
267: -- ------------------------------------------------------------------
268: IGC_CC_MC_MAIN_HST_PVT.get_rsobs_DET_PF(
269: l_api_version,

Line 382: p_CC_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Id%TYPE,

378: X_return_status OUT NOCOPY VARCHAR2,
379: X_msg_count OUT NOCOPY NUMBER,
380: X_msg_data OUT NOCOPY VARCHAR2,
381: p_Rowid IN OUT NOCOPY VARCHAR2,
382: p_CC_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Id%TYPE,
383: p_CC_Det_PF_Line_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Num%TYPE,
384: p_CC_Acct_Line_Id IGC_CC_DET_PF_HISTORY.CC_Acct_Line_Id%TYPE,
385: p_Parent_Acct_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Acct_Line_Id%TYPE,
386: p_Parent_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Det_PF_Line_Id%TYPE,

Line 383: p_CC_Det_PF_Line_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Num%TYPE,

379: X_msg_count OUT NOCOPY NUMBER,
380: X_msg_data OUT NOCOPY VARCHAR2,
381: p_Rowid IN OUT NOCOPY VARCHAR2,
382: p_CC_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Id%TYPE,
383: p_CC_Det_PF_Line_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Num%TYPE,
384: p_CC_Acct_Line_Id IGC_CC_DET_PF_HISTORY.CC_Acct_Line_Id%TYPE,
385: p_Parent_Acct_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Acct_Line_Id%TYPE,
386: p_Parent_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Det_PF_Line_Id%TYPE,
387: p_Det_PF_Version_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Num%TYPE,

Line 384: p_CC_Acct_Line_Id IGC_CC_DET_PF_HISTORY.CC_Acct_Line_Id%TYPE,

380: X_msg_data OUT NOCOPY VARCHAR2,
381: p_Rowid IN OUT NOCOPY VARCHAR2,
382: p_CC_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Id%TYPE,
383: p_CC_Det_PF_Line_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Num%TYPE,
384: p_CC_Acct_Line_Id IGC_CC_DET_PF_HISTORY.CC_Acct_Line_Id%TYPE,
385: p_Parent_Acct_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Acct_Line_Id%TYPE,
386: p_Parent_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Det_PF_Line_Id%TYPE,
387: p_Det_PF_Version_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Num%TYPE,
388: p_Det_PF_Version_Action IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Action%TYPE,

Line 385: p_Parent_Acct_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Acct_Line_Id%TYPE,

381: p_Rowid IN OUT NOCOPY VARCHAR2,
382: p_CC_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Id%TYPE,
383: p_CC_Det_PF_Line_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Num%TYPE,
384: p_CC_Acct_Line_Id IGC_CC_DET_PF_HISTORY.CC_Acct_Line_Id%TYPE,
385: p_Parent_Acct_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Acct_Line_Id%TYPE,
386: p_Parent_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Det_PF_Line_Id%TYPE,
387: p_Det_PF_Version_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Num%TYPE,
388: p_Det_PF_Version_Action IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Action%TYPE,
389: p_CC_Det_PF_Entered_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Entered_Amt%TYPE,

Line 386: p_Parent_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Det_PF_Line_Id%TYPE,

382: p_CC_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Id%TYPE,
383: p_CC_Det_PF_Line_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Num%TYPE,
384: p_CC_Acct_Line_Id IGC_CC_DET_PF_HISTORY.CC_Acct_Line_Id%TYPE,
385: p_Parent_Acct_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Acct_Line_Id%TYPE,
386: p_Parent_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Det_PF_Line_Id%TYPE,
387: p_Det_PF_Version_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Num%TYPE,
388: p_Det_PF_Version_Action IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Action%TYPE,
389: p_CC_Det_PF_Entered_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Entered_Amt%TYPE,
390: p_CC_Det_PF_Func_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Func_Amt%TYPE,

Line 387: p_Det_PF_Version_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Num%TYPE,

383: p_CC_Det_PF_Line_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Num%TYPE,
384: p_CC_Acct_Line_Id IGC_CC_DET_PF_HISTORY.CC_Acct_Line_Id%TYPE,
385: p_Parent_Acct_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Acct_Line_Id%TYPE,
386: p_Parent_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Det_PF_Line_Id%TYPE,
387: p_Det_PF_Version_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Num%TYPE,
388: p_Det_PF_Version_Action IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Action%TYPE,
389: p_CC_Det_PF_Entered_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Entered_Amt%TYPE,
390: p_CC_Det_PF_Func_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Func_Amt%TYPE,
391: p_CC_Det_PF_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Date%TYPE,

Line 388: p_Det_PF_Version_Action IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Action%TYPE,

384: p_CC_Acct_Line_Id IGC_CC_DET_PF_HISTORY.CC_Acct_Line_Id%TYPE,
385: p_Parent_Acct_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Acct_Line_Id%TYPE,
386: p_Parent_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Det_PF_Line_Id%TYPE,
387: p_Det_PF_Version_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Num%TYPE,
388: p_Det_PF_Version_Action IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Action%TYPE,
389: p_CC_Det_PF_Entered_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Entered_Amt%TYPE,
390: p_CC_Det_PF_Func_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Func_Amt%TYPE,
391: p_CC_Det_PF_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Date%TYPE,
392: p_CC_Det_PF_Billed_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Billed_Amt%TYPE,

Line 389: p_CC_Det_PF_Entered_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Entered_Amt%TYPE,

385: p_Parent_Acct_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Acct_Line_Id%TYPE,
386: p_Parent_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Det_PF_Line_Id%TYPE,
387: p_Det_PF_Version_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Num%TYPE,
388: p_Det_PF_Version_Action IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Action%TYPE,
389: p_CC_Det_PF_Entered_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Entered_Amt%TYPE,
390: p_CC_Det_PF_Func_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Func_Amt%TYPE,
391: p_CC_Det_PF_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Date%TYPE,
392: p_CC_Det_PF_Billed_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Billed_Amt%TYPE,
393: p_CC_Det_PF_Unbilled_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Unbilled_Amt%TYPE,

Line 390: p_CC_Det_PF_Func_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Func_Amt%TYPE,

386: p_Parent_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Det_PF_Line_Id%TYPE,
387: p_Det_PF_Version_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Num%TYPE,
388: p_Det_PF_Version_Action IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Action%TYPE,
389: p_CC_Det_PF_Entered_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Entered_Amt%TYPE,
390: p_CC_Det_PF_Func_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Func_Amt%TYPE,
391: p_CC_Det_PF_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Date%TYPE,
392: p_CC_Det_PF_Billed_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Billed_Amt%TYPE,
393: p_CC_Det_PF_Unbilled_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Unbilled_Amt%TYPE,
394: p_CC_Det_PF_Encmbrnc_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Amt%TYPE,

Line 391: p_CC_Det_PF_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Date%TYPE,

387: p_Det_PF_Version_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Num%TYPE,
388: p_Det_PF_Version_Action IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Action%TYPE,
389: p_CC_Det_PF_Entered_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Entered_Amt%TYPE,
390: p_CC_Det_PF_Func_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Func_Amt%TYPE,
391: p_CC_Det_PF_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Date%TYPE,
392: p_CC_Det_PF_Billed_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Billed_Amt%TYPE,
393: p_CC_Det_PF_Unbilled_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Unbilled_Amt%TYPE,
394: p_CC_Det_PF_Encmbrnc_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Amt%TYPE,
395: p_CC_Det_PF_Encmbrnc_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Date%TYPE,

Line 392: p_CC_Det_PF_Billed_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Billed_Amt%TYPE,

388: p_Det_PF_Version_Action IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Action%TYPE,
389: p_CC_Det_PF_Entered_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Entered_Amt%TYPE,
390: p_CC_Det_PF_Func_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Func_Amt%TYPE,
391: p_CC_Det_PF_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Date%TYPE,
392: p_CC_Det_PF_Billed_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Billed_Amt%TYPE,
393: p_CC_Det_PF_Unbilled_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Unbilled_Amt%TYPE,
394: p_CC_Det_PF_Encmbrnc_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Amt%TYPE,
395: p_CC_Det_PF_Encmbrnc_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Date%TYPE,
396: p_CC_Det_PF_Encmbrnc_Status IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Status%TYPE,

Line 393: p_CC_Det_PF_Unbilled_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Unbilled_Amt%TYPE,

389: p_CC_Det_PF_Entered_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Entered_Amt%TYPE,
390: p_CC_Det_PF_Func_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Func_Amt%TYPE,
391: p_CC_Det_PF_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Date%TYPE,
392: p_CC_Det_PF_Billed_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Billed_Amt%TYPE,
393: p_CC_Det_PF_Unbilled_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Unbilled_Amt%TYPE,
394: p_CC_Det_PF_Encmbrnc_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Amt%TYPE,
395: p_CC_Det_PF_Encmbrnc_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Date%TYPE,
396: p_CC_Det_PF_Encmbrnc_Status IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Status%TYPE,
397: p_Last_Update_Date IGC_CC_DET_PF_HISTORY.Last_Update_Date%TYPE,

Line 394: p_CC_Det_PF_Encmbrnc_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Amt%TYPE,

390: p_CC_Det_PF_Func_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Func_Amt%TYPE,
391: p_CC_Det_PF_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Date%TYPE,
392: p_CC_Det_PF_Billed_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Billed_Amt%TYPE,
393: p_CC_Det_PF_Unbilled_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Unbilled_Amt%TYPE,
394: p_CC_Det_PF_Encmbrnc_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Amt%TYPE,
395: p_CC_Det_PF_Encmbrnc_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Date%TYPE,
396: p_CC_Det_PF_Encmbrnc_Status IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Status%TYPE,
397: p_Last_Update_Date IGC_CC_DET_PF_HISTORY.Last_Update_Date%TYPE,
398: p_Last_Updated_By IGC_CC_DET_PF_HISTORY.Last_Updated_By%TYPE,

Line 395: p_CC_Det_PF_Encmbrnc_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Date%TYPE,

391: p_CC_Det_PF_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Date%TYPE,
392: p_CC_Det_PF_Billed_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Billed_Amt%TYPE,
393: p_CC_Det_PF_Unbilled_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Unbilled_Amt%TYPE,
394: p_CC_Det_PF_Encmbrnc_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Amt%TYPE,
395: p_CC_Det_PF_Encmbrnc_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Date%TYPE,
396: p_CC_Det_PF_Encmbrnc_Status IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Status%TYPE,
397: p_Last_Update_Date IGC_CC_DET_PF_HISTORY.Last_Update_Date%TYPE,
398: p_Last_Updated_By IGC_CC_DET_PF_HISTORY.Last_Updated_By%TYPE,
399: p_Last_Update_Login IGC_CC_DET_PF_HISTORY.Last_Update_Login%TYPE,

Line 396: p_CC_Det_PF_Encmbrnc_Status IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Status%TYPE,

392: p_CC_Det_PF_Billed_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Billed_Amt%TYPE,
393: p_CC_Det_PF_Unbilled_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Unbilled_Amt%TYPE,
394: p_CC_Det_PF_Encmbrnc_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Amt%TYPE,
395: p_CC_Det_PF_Encmbrnc_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Date%TYPE,
396: p_CC_Det_PF_Encmbrnc_Status IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Status%TYPE,
397: p_Last_Update_Date IGC_CC_DET_PF_HISTORY.Last_Update_Date%TYPE,
398: p_Last_Updated_By IGC_CC_DET_PF_HISTORY.Last_Updated_By%TYPE,
399: p_Last_Update_Login IGC_CC_DET_PF_HISTORY.Last_Update_Login%TYPE,
400: p_Creation_Date IGC_CC_DET_PF_HISTORY.Creation_Date%TYPE,

Line 397: p_Last_Update_Date IGC_CC_DET_PF_HISTORY.Last_Update_Date%TYPE,

393: p_CC_Det_PF_Unbilled_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Unbilled_Amt%TYPE,
394: p_CC_Det_PF_Encmbrnc_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Amt%TYPE,
395: p_CC_Det_PF_Encmbrnc_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Date%TYPE,
396: p_CC_Det_PF_Encmbrnc_Status IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Status%TYPE,
397: p_Last_Update_Date IGC_CC_DET_PF_HISTORY.Last_Update_Date%TYPE,
398: p_Last_Updated_By IGC_CC_DET_PF_HISTORY.Last_Updated_By%TYPE,
399: p_Last_Update_Login IGC_CC_DET_PF_HISTORY.Last_Update_Login%TYPE,
400: p_Creation_Date IGC_CC_DET_PF_HISTORY.Creation_Date%TYPE,
401: p_Created_By IGC_CC_DET_PF_HISTORY.Created_By%TYPE,

Line 398: p_Last_Updated_By IGC_CC_DET_PF_HISTORY.Last_Updated_By%TYPE,

394: p_CC_Det_PF_Encmbrnc_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Amt%TYPE,
395: p_CC_Det_PF_Encmbrnc_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Date%TYPE,
396: p_CC_Det_PF_Encmbrnc_Status IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Status%TYPE,
397: p_Last_Update_Date IGC_CC_DET_PF_HISTORY.Last_Update_Date%TYPE,
398: p_Last_Updated_By IGC_CC_DET_PF_HISTORY.Last_Updated_By%TYPE,
399: p_Last_Update_Login IGC_CC_DET_PF_HISTORY.Last_Update_Login%TYPE,
400: p_Creation_Date IGC_CC_DET_PF_HISTORY.Creation_Date%TYPE,
401: p_Created_By IGC_CC_DET_PF_HISTORY.Created_By%TYPE,
402: p_Attribute1 IGC_CC_DET_PF_HISTORY.Attribute1%TYPE,

Line 399: p_Last_Update_Login IGC_CC_DET_PF_HISTORY.Last_Update_Login%TYPE,

395: p_CC_Det_PF_Encmbrnc_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Date%TYPE,
396: p_CC_Det_PF_Encmbrnc_Status IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Status%TYPE,
397: p_Last_Update_Date IGC_CC_DET_PF_HISTORY.Last_Update_Date%TYPE,
398: p_Last_Updated_By IGC_CC_DET_PF_HISTORY.Last_Updated_By%TYPE,
399: p_Last_Update_Login IGC_CC_DET_PF_HISTORY.Last_Update_Login%TYPE,
400: p_Creation_Date IGC_CC_DET_PF_HISTORY.Creation_Date%TYPE,
401: p_Created_By IGC_CC_DET_PF_HISTORY.Created_By%TYPE,
402: p_Attribute1 IGC_CC_DET_PF_HISTORY.Attribute1%TYPE,
403: p_Attribute2 IGC_CC_DET_PF_HISTORY.Attribute2%TYPE,

Line 400: p_Creation_Date IGC_CC_DET_PF_HISTORY.Creation_Date%TYPE,

396: p_CC_Det_PF_Encmbrnc_Status IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Status%TYPE,
397: p_Last_Update_Date IGC_CC_DET_PF_HISTORY.Last_Update_Date%TYPE,
398: p_Last_Updated_By IGC_CC_DET_PF_HISTORY.Last_Updated_By%TYPE,
399: p_Last_Update_Login IGC_CC_DET_PF_HISTORY.Last_Update_Login%TYPE,
400: p_Creation_Date IGC_CC_DET_PF_HISTORY.Creation_Date%TYPE,
401: p_Created_By IGC_CC_DET_PF_HISTORY.Created_By%TYPE,
402: p_Attribute1 IGC_CC_DET_PF_HISTORY.Attribute1%TYPE,
403: p_Attribute2 IGC_CC_DET_PF_HISTORY.Attribute2%TYPE,
404: p_Attribute3 IGC_CC_DET_PF_HISTORY.Attribute3%TYPE,

Line 401: p_Created_By IGC_CC_DET_PF_HISTORY.Created_By%TYPE,

397: p_Last_Update_Date IGC_CC_DET_PF_HISTORY.Last_Update_Date%TYPE,
398: p_Last_Updated_By IGC_CC_DET_PF_HISTORY.Last_Updated_By%TYPE,
399: p_Last_Update_Login IGC_CC_DET_PF_HISTORY.Last_Update_Login%TYPE,
400: p_Creation_Date IGC_CC_DET_PF_HISTORY.Creation_Date%TYPE,
401: p_Created_By IGC_CC_DET_PF_HISTORY.Created_By%TYPE,
402: p_Attribute1 IGC_CC_DET_PF_HISTORY.Attribute1%TYPE,
403: p_Attribute2 IGC_CC_DET_PF_HISTORY.Attribute2%TYPE,
404: p_Attribute3 IGC_CC_DET_PF_HISTORY.Attribute3%TYPE,
405: p_Attribute4 IGC_CC_DET_PF_HISTORY.Attribute4%TYPE,

Line 402: p_Attribute1 IGC_CC_DET_PF_HISTORY.Attribute1%TYPE,

398: p_Last_Updated_By IGC_CC_DET_PF_HISTORY.Last_Updated_By%TYPE,
399: p_Last_Update_Login IGC_CC_DET_PF_HISTORY.Last_Update_Login%TYPE,
400: p_Creation_Date IGC_CC_DET_PF_HISTORY.Creation_Date%TYPE,
401: p_Created_By IGC_CC_DET_PF_HISTORY.Created_By%TYPE,
402: p_Attribute1 IGC_CC_DET_PF_HISTORY.Attribute1%TYPE,
403: p_Attribute2 IGC_CC_DET_PF_HISTORY.Attribute2%TYPE,
404: p_Attribute3 IGC_CC_DET_PF_HISTORY.Attribute3%TYPE,
405: p_Attribute4 IGC_CC_DET_PF_HISTORY.Attribute4%TYPE,
406: p_Attribute5 IGC_CC_DET_PF_HISTORY.Attribute5%TYPE,

Line 403: p_Attribute2 IGC_CC_DET_PF_HISTORY.Attribute2%TYPE,

399: p_Last_Update_Login IGC_CC_DET_PF_HISTORY.Last_Update_Login%TYPE,
400: p_Creation_Date IGC_CC_DET_PF_HISTORY.Creation_Date%TYPE,
401: p_Created_By IGC_CC_DET_PF_HISTORY.Created_By%TYPE,
402: p_Attribute1 IGC_CC_DET_PF_HISTORY.Attribute1%TYPE,
403: p_Attribute2 IGC_CC_DET_PF_HISTORY.Attribute2%TYPE,
404: p_Attribute3 IGC_CC_DET_PF_HISTORY.Attribute3%TYPE,
405: p_Attribute4 IGC_CC_DET_PF_HISTORY.Attribute4%TYPE,
406: p_Attribute5 IGC_CC_DET_PF_HISTORY.Attribute5%TYPE,
407: p_Attribute6 IGC_CC_DET_PF_HISTORY.Attribute6%TYPE,

Line 404: p_Attribute3 IGC_CC_DET_PF_HISTORY.Attribute3%TYPE,

400: p_Creation_Date IGC_CC_DET_PF_HISTORY.Creation_Date%TYPE,
401: p_Created_By IGC_CC_DET_PF_HISTORY.Created_By%TYPE,
402: p_Attribute1 IGC_CC_DET_PF_HISTORY.Attribute1%TYPE,
403: p_Attribute2 IGC_CC_DET_PF_HISTORY.Attribute2%TYPE,
404: p_Attribute3 IGC_CC_DET_PF_HISTORY.Attribute3%TYPE,
405: p_Attribute4 IGC_CC_DET_PF_HISTORY.Attribute4%TYPE,
406: p_Attribute5 IGC_CC_DET_PF_HISTORY.Attribute5%TYPE,
407: p_Attribute6 IGC_CC_DET_PF_HISTORY.Attribute6%TYPE,
408: p_Attribute7 IGC_CC_DET_PF_HISTORY.Attribute7%TYPE,

Line 405: p_Attribute4 IGC_CC_DET_PF_HISTORY.Attribute4%TYPE,

401: p_Created_By IGC_CC_DET_PF_HISTORY.Created_By%TYPE,
402: p_Attribute1 IGC_CC_DET_PF_HISTORY.Attribute1%TYPE,
403: p_Attribute2 IGC_CC_DET_PF_HISTORY.Attribute2%TYPE,
404: p_Attribute3 IGC_CC_DET_PF_HISTORY.Attribute3%TYPE,
405: p_Attribute4 IGC_CC_DET_PF_HISTORY.Attribute4%TYPE,
406: p_Attribute5 IGC_CC_DET_PF_HISTORY.Attribute5%TYPE,
407: p_Attribute6 IGC_CC_DET_PF_HISTORY.Attribute6%TYPE,
408: p_Attribute7 IGC_CC_DET_PF_HISTORY.Attribute7%TYPE,
409: p_Attribute8 IGC_CC_DET_PF_HISTORY.Attribute8%TYPE,

Line 406: p_Attribute5 IGC_CC_DET_PF_HISTORY.Attribute5%TYPE,

402: p_Attribute1 IGC_CC_DET_PF_HISTORY.Attribute1%TYPE,
403: p_Attribute2 IGC_CC_DET_PF_HISTORY.Attribute2%TYPE,
404: p_Attribute3 IGC_CC_DET_PF_HISTORY.Attribute3%TYPE,
405: p_Attribute4 IGC_CC_DET_PF_HISTORY.Attribute4%TYPE,
406: p_Attribute5 IGC_CC_DET_PF_HISTORY.Attribute5%TYPE,
407: p_Attribute6 IGC_CC_DET_PF_HISTORY.Attribute6%TYPE,
408: p_Attribute7 IGC_CC_DET_PF_HISTORY.Attribute7%TYPE,
409: p_Attribute8 IGC_CC_DET_PF_HISTORY.Attribute8%TYPE,
410: p_Attribute9 IGC_CC_DET_PF_HISTORY.Attribute9%TYPE,

Line 407: p_Attribute6 IGC_CC_DET_PF_HISTORY.Attribute6%TYPE,

403: p_Attribute2 IGC_CC_DET_PF_HISTORY.Attribute2%TYPE,
404: p_Attribute3 IGC_CC_DET_PF_HISTORY.Attribute3%TYPE,
405: p_Attribute4 IGC_CC_DET_PF_HISTORY.Attribute4%TYPE,
406: p_Attribute5 IGC_CC_DET_PF_HISTORY.Attribute5%TYPE,
407: p_Attribute6 IGC_CC_DET_PF_HISTORY.Attribute6%TYPE,
408: p_Attribute7 IGC_CC_DET_PF_HISTORY.Attribute7%TYPE,
409: p_Attribute8 IGC_CC_DET_PF_HISTORY.Attribute8%TYPE,
410: p_Attribute9 IGC_CC_DET_PF_HISTORY.Attribute9%TYPE,
411: p_Attribute10 IGC_CC_DET_PF_HISTORY.Attribute10%TYPE,

Line 408: p_Attribute7 IGC_CC_DET_PF_HISTORY.Attribute7%TYPE,

404: p_Attribute3 IGC_CC_DET_PF_HISTORY.Attribute3%TYPE,
405: p_Attribute4 IGC_CC_DET_PF_HISTORY.Attribute4%TYPE,
406: p_Attribute5 IGC_CC_DET_PF_HISTORY.Attribute5%TYPE,
407: p_Attribute6 IGC_CC_DET_PF_HISTORY.Attribute6%TYPE,
408: p_Attribute7 IGC_CC_DET_PF_HISTORY.Attribute7%TYPE,
409: p_Attribute8 IGC_CC_DET_PF_HISTORY.Attribute8%TYPE,
410: p_Attribute9 IGC_CC_DET_PF_HISTORY.Attribute9%TYPE,
411: p_Attribute10 IGC_CC_DET_PF_HISTORY.Attribute10%TYPE,
412: p_Attribute11 IGC_CC_DET_PF_HISTORY.Attribute11%TYPE,

Line 409: p_Attribute8 IGC_CC_DET_PF_HISTORY.Attribute8%TYPE,

405: p_Attribute4 IGC_CC_DET_PF_HISTORY.Attribute4%TYPE,
406: p_Attribute5 IGC_CC_DET_PF_HISTORY.Attribute5%TYPE,
407: p_Attribute6 IGC_CC_DET_PF_HISTORY.Attribute6%TYPE,
408: p_Attribute7 IGC_CC_DET_PF_HISTORY.Attribute7%TYPE,
409: p_Attribute8 IGC_CC_DET_PF_HISTORY.Attribute8%TYPE,
410: p_Attribute9 IGC_CC_DET_PF_HISTORY.Attribute9%TYPE,
411: p_Attribute10 IGC_CC_DET_PF_HISTORY.Attribute10%TYPE,
412: p_Attribute11 IGC_CC_DET_PF_HISTORY.Attribute11%TYPE,
413: p_Attribute12 IGC_CC_DET_PF_HISTORY.Attribute12%TYPE,

Line 410: p_Attribute9 IGC_CC_DET_PF_HISTORY.Attribute9%TYPE,

406: p_Attribute5 IGC_CC_DET_PF_HISTORY.Attribute5%TYPE,
407: p_Attribute6 IGC_CC_DET_PF_HISTORY.Attribute6%TYPE,
408: p_Attribute7 IGC_CC_DET_PF_HISTORY.Attribute7%TYPE,
409: p_Attribute8 IGC_CC_DET_PF_HISTORY.Attribute8%TYPE,
410: p_Attribute9 IGC_CC_DET_PF_HISTORY.Attribute9%TYPE,
411: p_Attribute10 IGC_CC_DET_PF_HISTORY.Attribute10%TYPE,
412: p_Attribute11 IGC_CC_DET_PF_HISTORY.Attribute11%TYPE,
413: p_Attribute12 IGC_CC_DET_PF_HISTORY.Attribute12%TYPE,
414: p_Attribute13 IGC_CC_DET_PF_HISTORY.Attribute13%TYPE,

Line 411: p_Attribute10 IGC_CC_DET_PF_HISTORY.Attribute10%TYPE,

407: p_Attribute6 IGC_CC_DET_PF_HISTORY.Attribute6%TYPE,
408: p_Attribute7 IGC_CC_DET_PF_HISTORY.Attribute7%TYPE,
409: p_Attribute8 IGC_CC_DET_PF_HISTORY.Attribute8%TYPE,
410: p_Attribute9 IGC_CC_DET_PF_HISTORY.Attribute9%TYPE,
411: p_Attribute10 IGC_CC_DET_PF_HISTORY.Attribute10%TYPE,
412: p_Attribute11 IGC_CC_DET_PF_HISTORY.Attribute11%TYPE,
413: p_Attribute12 IGC_CC_DET_PF_HISTORY.Attribute12%TYPE,
414: p_Attribute13 IGC_CC_DET_PF_HISTORY.Attribute13%TYPE,
415: p_Attribute14 IGC_CC_DET_PF_HISTORY.Attribute14%TYPE,

Line 412: p_Attribute11 IGC_CC_DET_PF_HISTORY.Attribute11%TYPE,

408: p_Attribute7 IGC_CC_DET_PF_HISTORY.Attribute7%TYPE,
409: p_Attribute8 IGC_CC_DET_PF_HISTORY.Attribute8%TYPE,
410: p_Attribute9 IGC_CC_DET_PF_HISTORY.Attribute9%TYPE,
411: p_Attribute10 IGC_CC_DET_PF_HISTORY.Attribute10%TYPE,
412: p_Attribute11 IGC_CC_DET_PF_HISTORY.Attribute11%TYPE,
413: p_Attribute12 IGC_CC_DET_PF_HISTORY.Attribute12%TYPE,
414: p_Attribute13 IGC_CC_DET_PF_HISTORY.Attribute13%TYPE,
415: p_Attribute14 IGC_CC_DET_PF_HISTORY.Attribute14%TYPE,
416: p_Attribute15 IGC_CC_DET_PF_HISTORY.Attribute15%TYPE,

Line 413: p_Attribute12 IGC_CC_DET_PF_HISTORY.Attribute12%TYPE,

409: p_Attribute8 IGC_CC_DET_PF_HISTORY.Attribute8%TYPE,
410: p_Attribute9 IGC_CC_DET_PF_HISTORY.Attribute9%TYPE,
411: p_Attribute10 IGC_CC_DET_PF_HISTORY.Attribute10%TYPE,
412: p_Attribute11 IGC_CC_DET_PF_HISTORY.Attribute11%TYPE,
413: p_Attribute12 IGC_CC_DET_PF_HISTORY.Attribute12%TYPE,
414: p_Attribute13 IGC_CC_DET_PF_HISTORY.Attribute13%TYPE,
415: p_Attribute14 IGC_CC_DET_PF_HISTORY.Attribute14%TYPE,
416: p_Attribute15 IGC_CC_DET_PF_HISTORY.Attribute15%TYPE,
417: p_Context IGC_CC_DET_PF_HISTORY.Context%TYPE,

Line 414: p_Attribute13 IGC_CC_DET_PF_HISTORY.Attribute13%TYPE,

410: p_Attribute9 IGC_CC_DET_PF_HISTORY.Attribute9%TYPE,
411: p_Attribute10 IGC_CC_DET_PF_HISTORY.Attribute10%TYPE,
412: p_Attribute11 IGC_CC_DET_PF_HISTORY.Attribute11%TYPE,
413: p_Attribute12 IGC_CC_DET_PF_HISTORY.Attribute12%TYPE,
414: p_Attribute13 IGC_CC_DET_PF_HISTORY.Attribute13%TYPE,
415: p_Attribute14 IGC_CC_DET_PF_HISTORY.Attribute14%TYPE,
416: p_Attribute15 IGC_CC_DET_PF_HISTORY.Attribute15%TYPE,
417: p_Context IGC_CC_DET_PF_HISTORY.Context%TYPE,
418: X_row_locked OUT NOCOPY VARCHAR2,

Line 415: p_Attribute14 IGC_CC_DET_PF_HISTORY.Attribute14%TYPE,

411: p_Attribute10 IGC_CC_DET_PF_HISTORY.Attribute10%TYPE,
412: p_Attribute11 IGC_CC_DET_PF_HISTORY.Attribute11%TYPE,
413: p_Attribute12 IGC_CC_DET_PF_HISTORY.Attribute12%TYPE,
414: p_Attribute13 IGC_CC_DET_PF_HISTORY.Attribute13%TYPE,
415: p_Attribute14 IGC_CC_DET_PF_HISTORY.Attribute14%TYPE,
416: p_Attribute15 IGC_CC_DET_PF_HISTORY.Attribute15%TYPE,
417: p_Context IGC_CC_DET_PF_HISTORY.Context%TYPE,
418: X_row_locked OUT NOCOPY VARCHAR2,
419: G_FLAG IN OUT NOCOPY VARCHAR2

Line 416: p_Attribute15 IGC_CC_DET_PF_HISTORY.Attribute15%TYPE,

412: p_Attribute11 IGC_CC_DET_PF_HISTORY.Attribute11%TYPE,
413: p_Attribute12 IGC_CC_DET_PF_HISTORY.Attribute12%TYPE,
414: p_Attribute13 IGC_CC_DET_PF_HISTORY.Attribute13%TYPE,
415: p_Attribute14 IGC_CC_DET_PF_HISTORY.Attribute14%TYPE,
416: p_Attribute15 IGC_CC_DET_PF_HISTORY.Attribute15%TYPE,
417: p_Context IGC_CC_DET_PF_HISTORY.Context%TYPE,
418: X_row_locked OUT NOCOPY VARCHAR2,
419: G_FLAG IN OUT NOCOPY VARCHAR2
420: ) IS

Line 417: p_Context IGC_CC_DET_PF_HISTORY.Context%TYPE,

413: p_Attribute12 IGC_CC_DET_PF_HISTORY.Attribute12%TYPE,
414: p_Attribute13 IGC_CC_DET_PF_HISTORY.Attribute13%TYPE,
415: p_Attribute14 IGC_CC_DET_PF_HISTORY.Attribute14%TYPE,
416: p_Attribute15 IGC_CC_DET_PF_HISTORY.Attribute15%TYPE,
417: p_Context IGC_CC_DET_PF_HISTORY.Context%TYPE,
418: X_row_locked OUT NOCOPY VARCHAR2,
419: G_FLAG IN OUT NOCOPY VARCHAR2
420: ) IS
421:

Line 428: FROM IGC_CC_DET_PF_HISTORY

424: Counter NUMBER;
425:
426: CURSOR C IS
427: SELECT *
428: FROM IGC_CC_DET_PF_HISTORY
429: WHERE Rowid = p_Rowid
430: FOR UPDATE of CC_Det_PF_Line_Id NOWAIT;
431:
432: Recinfo C%ROWTYPE;

Line 622: p_CC_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Id%TYPE,

618: X_return_status OUT NOCOPY VARCHAR2,
619: X_msg_count OUT NOCOPY NUMBER,
620: X_msg_data OUT NOCOPY VARCHAR2,
621: p_Rowid IN OUT NOCOPY VARCHAR2,
622: p_CC_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Id%TYPE,
623: p_CC_Det_PF_Line_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Num%TYPE,
624: p_CC_Acct_Line_Id IGC_CC_DET_PF_HISTORY.CC_Acct_Line_Id%TYPE,
625: p_Parent_Acct_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Acct_Line_Id%TYPE,
626: p_Parent_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Det_PF_Line_Id%TYPE,

Line 623: p_CC_Det_PF_Line_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Num%TYPE,

619: X_msg_count OUT NOCOPY NUMBER,
620: X_msg_data OUT NOCOPY VARCHAR2,
621: p_Rowid IN OUT NOCOPY VARCHAR2,
622: p_CC_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Id%TYPE,
623: p_CC_Det_PF_Line_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Num%TYPE,
624: p_CC_Acct_Line_Id IGC_CC_DET_PF_HISTORY.CC_Acct_Line_Id%TYPE,
625: p_Parent_Acct_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Acct_Line_Id%TYPE,
626: p_Parent_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Det_PF_Line_Id%TYPE,
627: p_Det_PF_Version_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Num%TYPE,

Line 624: p_CC_Acct_Line_Id IGC_CC_DET_PF_HISTORY.CC_Acct_Line_Id%TYPE,

620: X_msg_data OUT NOCOPY VARCHAR2,
621: p_Rowid IN OUT NOCOPY VARCHAR2,
622: p_CC_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Id%TYPE,
623: p_CC_Det_PF_Line_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Num%TYPE,
624: p_CC_Acct_Line_Id IGC_CC_DET_PF_HISTORY.CC_Acct_Line_Id%TYPE,
625: p_Parent_Acct_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Acct_Line_Id%TYPE,
626: p_Parent_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Det_PF_Line_Id%TYPE,
627: p_Det_PF_Version_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Num%TYPE,
628: p_Det_PF_Version_Action IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Action%TYPE,

Line 625: p_Parent_Acct_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Acct_Line_Id%TYPE,

621: p_Rowid IN OUT NOCOPY VARCHAR2,
622: p_CC_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Id%TYPE,
623: p_CC_Det_PF_Line_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Num%TYPE,
624: p_CC_Acct_Line_Id IGC_CC_DET_PF_HISTORY.CC_Acct_Line_Id%TYPE,
625: p_Parent_Acct_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Acct_Line_Id%TYPE,
626: p_Parent_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Det_PF_Line_Id%TYPE,
627: p_Det_PF_Version_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Num%TYPE,
628: p_Det_PF_Version_Action IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Action%TYPE,
629: p_CC_Det_PF_Entered_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Entered_Amt%TYPE,

Line 626: p_Parent_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Det_PF_Line_Id%TYPE,

622: p_CC_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Id%TYPE,
623: p_CC_Det_PF_Line_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Num%TYPE,
624: p_CC_Acct_Line_Id IGC_CC_DET_PF_HISTORY.CC_Acct_Line_Id%TYPE,
625: p_Parent_Acct_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Acct_Line_Id%TYPE,
626: p_Parent_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Det_PF_Line_Id%TYPE,
627: p_Det_PF_Version_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Num%TYPE,
628: p_Det_PF_Version_Action IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Action%TYPE,
629: p_CC_Det_PF_Entered_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Entered_Amt%TYPE,
630: p_CC_Det_PF_Func_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Func_Amt%TYPE,

Line 627: p_Det_PF_Version_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Num%TYPE,

623: p_CC_Det_PF_Line_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Num%TYPE,
624: p_CC_Acct_Line_Id IGC_CC_DET_PF_HISTORY.CC_Acct_Line_Id%TYPE,
625: p_Parent_Acct_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Acct_Line_Id%TYPE,
626: p_Parent_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Det_PF_Line_Id%TYPE,
627: p_Det_PF_Version_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Num%TYPE,
628: p_Det_PF_Version_Action IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Action%TYPE,
629: p_CC_Det_PF_Entered_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Entered_Amt%TYPE,
630: p_CC_Det_PF_Func_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Func_Amt%TYPE,
631: p_CC_Det_PF_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Date%TYPE,

Line 628: p_Det_PF_Version_Action IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Action%TYPE,

624: p_CC_Acct_Line_Id IGC_CC_DET_PF_HISTORY.CC_Acct_Line_Id%TYPE,
625: p_Parent_Acct_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Acct_Line_Id%TYPE,
626: p_Parent_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Det_PF_Line_Id%TYPE,
627: p_Det_PF_Version_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Num%TYPE,
628: p_Det_PF_Version_Action IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Action%TYPE,
629: p_CC_Det_PF_Entered_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Entered_Amt%TYPE,
630: p_CC_Det_PF_Func_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Func_Amt%TYPE,
631: p_CC_Det_PF_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Date%TYPE,
632: p_CC_Det_PF_Billed_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Billed_Amt%TYPE,

Line 629: p_CC_Det_PF_Entered_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Entered_Amt%TYPE,

625: p_Parent_Acct_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Acct_Line_Id%TYPE,
626: p_Parent_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Det_PF_Line_Id%TYPE,
627: p_Det_PF_Version_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Num%TYPE,
628: p_Det_PF_Version_Action IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Action%TYPE,
629: p_CC_Det_PF_Entered_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Entered_Amt%TYPE,
630: p_CC_Det_PF_Func_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Func_Amt%TYPE,
631: p_CC_Det_PF_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Date%TYPE,
632: p_CC_Det_PF_Billed_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Billed_Amt%TYPE,
633: p_CC_Det_PF_Unbilled_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Unbilled_Amt%TYPE,

Line 630: p_CC_Det_PF_Func_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Func_Amt%TYPE,

626: p_Parent_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Det_PF_Line_Id%TYPE,
627: p_Det_PF_Version_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Num%TYPE,
628: p_Det_PF_Version_Action IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Action%TYPE,
629: p_CC_Det_PF_Entered_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Entered_Amt%TYPE,
630: p_CC_Det_PF_Func_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Func_Amt%TYPE,
631: p_CC_Det_PF_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Date%TYPE,
632: p_CC_Det_PF_Billed_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Billed_Amt%TYPE,
633: p_CC_Det_PF_Unbilled_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Unbilled_Amt%TYPE,
634: p_CC_Det_PF_Encmbrnc_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Amt%TYPE,

Line 631: p_CC_Det_PF_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Date%TYPE,

627: p_Det_PF_Version_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Num%TYPE,
628: p_Det_PF_Version_Action IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Action%TYPE,
629: p_CC_Det_PF_Entered_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Entered_Amt%TYPE,
630: p_CC_Det_PF_Func_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Func_Amt%TYPE,
631: p_CC_Det_PF_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Date%TYPE,
632: p_CC_Det_PF_Billed_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Billed_Amt%TYPE,
633: p_CC_Det_PF_Unbilled_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Unbilled_Amt%TYPE,
634: p_CC_Det_PF_Encmbrnc_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Amt%TYPE,
635: p_CC_Det_PF_Encmbrnc_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Date%TYPE,

Line 632: p_CC_Det_PF_Billed_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Billed_Amt%TYPE,

628: p_Det_PF_Version_Action IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Action%TYPE,
629: p_CC_Det_PF_Entered_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Entered_Amt%TYPE,
630: p_CC_Det_PF_Func_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Func_Amt%TYPE,
631: p_CC_Det_PF_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Date%TYPE,
632: p_CC_Det_PF_Billed_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Billed_Amt%TYPE,
633: p_CC_Det_PF_Unbilled_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Unbilled_Amt%TYPE,
634: p_CC_Det_PF_Encmbrnc_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Amt%TYPE,
635: p_CC_Det_PF_Encmbrnc_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Date%TYPE,
636: p_CC_Det_PF_Encmbrnc_Status IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Status%TYPE,

Line 633: p_CC_Det_PF_Unbilled_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Unbilled_Amt%TYPE,

629: p_CC_Det_PF_Entered_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Entered_Amt%TYPE,
630: p_CC_Det_PF_Func_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Func_Amt%TYPE,
631: p_CC_Det_PF_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Date%TYPE,
632: p_CC_Det_PF_Billed_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Billed_Amt%TYPE,
633: p_CC_Det_PF_Unbilled_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Unbilled_Amt%TYPE,
634: p_CC_Det_PF_Encmbrnc_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Amt%TYPE,
635: p_CC_Det_PF_Encmbrnc_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Date%TYPE,
636: p_CC_Det_PF_Encmbrnc_Status IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Status%TYPE,
637: p_Last_Update_Date IGC_CC_DET_PF_HISTORY.Last_Update_Date%TYPE,

Line 634: p_CC_Det_PF_Encmbrnc_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Amt%TYPE,

630: p_CC_Det_PF_Func_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Func_Amt%TYPE,
631: p_CC_Det_PF_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Date%TYPE,
632: p_CC_Det_PF_Billed_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Billed_Amt%TYPE,
633: p_CC_Det_PF_Unbilled_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Unbilled_Amt%TYPE,
634: p_CC_Det_PF_Encmbrnc_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Amt%TYPE,
635: p_CC_Det_PF_Encmbrnc_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Date%TYPE,
636: p_CC_Det_PF_Encmbrnc_Status IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Status%TYPE,
637: p_Last_Update_Date IGC_CC_DET_PF_HISTORY.Last_Update_Date%TYPE,
638: p_Last_Updated_By IGC_CC_DET_PF_HISTORY.Last_Updated_By%TYPE,

Line 635: p_CC_Det_PF_Encmbrnc_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Date%TYPE,

631: p_CC_Det_PF_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Date%TYPE,
632: p_CC_Det_PF_Billed_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Billed_Amt%TYPE,
633: p_CC_Det_PF_Unbilled_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Unbilled_Amt%TYPE,
634: p_CC_Det_PF_Encmbrnc_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Amt%TYPE,
635: p_CC_Det_PF_Encmbrnc_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Date%TYPE,
636: p_CC_Det_PF_Encmbrnc_Status IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Status%TYPE,
637: p_Last_Update_Date IGC_CC_DET_PF_HISTORY.Last_Update_Date%TYPE,
638: p_Last_Updated_By IGC_CC_DET_PF_HISTORY.Last_Updated_By%TYPE,
639: p_Last_Update_Login IGC_CC_DET_PF_HISTORY.Last_Update_Login%TYPE,

Line 636: p_CC_Det_PF_Encmbrnc_Status IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Status%TYPE,

632: p_CC_Det_PF_Billed_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Billed_Amt%TYPE,
633: p_CC_Det_PF_Unbilled_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Unbilled_Amt%TYPE,
634: p_CC_Det_PF_Encmbrnc_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Amt%TYPE,
635: p_CC_Det_PF_Encmbrnc_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Date%TYPE,
636: p_CC_Det_PF_Encmbrnc_Status IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Status%TYPE,
637: p_Last_Update_Date IGC_CC_DET_PF_HISTORY.Last_Update_Date%TYPE,
638: p_Last_Updated_By IGC_CC_DET_PF_HISTORY.Last_Updated_By%TYPE,
639: p_Last_Update_Login IGC_CC_DET_PF_HISTORY.Last_Update_Login%TYPE,
640: p_Creation_Date IGC_CC_DET_PF_HISTORY.Creation_Date%TYPE,

Line 637: p_Last_Update_Date IGC_CC_DET_PF_HISTORY.Last_Update_Date%TYPE,

633: p_CC_Det_PF_Unbilled_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Unbilled_Amt%TYPE,
634: p_CC_Det_PF_Encmbrnc_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Amt%TYPE,
635: p_CC_Det_PF_Encmbrnc_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Date%TYPE,
636: p_CC_Det_PF_Encmbrnc_Status IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Status%TYPE,
637: p_Last_Update_Date IGC_CC_DET_PF_HISTORY.Last_Update_Date%TYPE,
638: p_Last_Updated_By IGC_CC_DET_PF_HISTORY.Last_Updated_By%TYPE,
639: p_Last_Update_Login IGC_CC_DET_PF_HISTORY.Last_Update_Login%TYPE,
640: p_Creation_Date IGC_CC_DET_PF_HISTORY.Creation_Date%TYPE,
641: p_Created_By IGC_CC_DET_PF_HISTORY.Created_By%TYPE,

Line 638: p_Last_Updated_By IGC_CC_DET_PF_HISTORY.Last_Updated_By%TYPE,

634: p_CC_Det_PF_Encmbrnc_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Amt%TYPE,
635: p_CC_Det_PF_Encmbrnc_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Date%TYPE,
636: p_CC_Det_PF_Encmbrnc_Status IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Status%TYPE,
637: p_Last_Update_Date IGC_CC_DET_PF_HISTORY.Last_Update_Date%TYPE,
638: p_Last_Updated_By IGC_CC_DET_PF_HISTORY.Last_Updated_By%TYPE,
639: p_Last_Update_Login IGC_CC_DET_PF_HISTORY.Last_Update_Login%TYPE,
640: p_Creation_Date IGC_CC_DET_PF_HISTORY.Creation_Date%TYPE,
641: p_Created_By IGC_CC_DET_PF_HISTORY.Created_By%TYPE,
642: p_Attribute1 IGC_CC_DET_PF_HISTORY.Attribute1%TYPE,

Line 639: p_Last_Update_Login IGC_CC_DET_PF_HISTORY.Last_Update_Login%TYPE,

635: p_CC_Det_PF_Encmbrnc_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Date%TYPE,
636: p_CC_Det_PF_Encmbrnc_Status IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Status%TYPE,
637: p_Last_Update_Date IGC_CC_DET_PF_HISTORY.Last_Update_Date%TYPE,
638: p_Last_Updated_By IGC_CC_DET_PF_HISTORY.Last_Updated_By%TYPE,
639: p_Last_Update_Login IGC_CC_DET_PF_HISTORY.Last_Update_Login%TYPE,
640: p_Creation_Date IGC_CC_DET_PF_HISTORY.Creation_Date%TYPE,
641: p_Created_By IGC_CC_DET_PF_HISTORY.Created_By%TYPE,
642: p_Attribute1 IGC_CC_DET_PF_HISTORY.Attribute1%TYPE,
643: p_Attribute2 IGC_CC_DET_PF_HISTORY.Attribute2%TYPE,

Line 640: p_Creation_Date IGC_CC_DET_PF_HISTORY.Creation_Date%TYPE,

636: p_CC_Det_PF_Encmbrnc_Status IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Status%TYPE,
637: p_Last_Update_Date IGC_CC_DET_PF_HISTORY.Last_Update_Date%TYPE,
638: p_Last_Updated_By IGC_CC_DET_PF_HISTORY.Last_Updated_By%TYPE,
639: p_Last_Update_Login IGC_CC_DET_PF_HISTORY.Last_Update_Login%TYPE,
640: p_Creation_Date IGC_CC_DET_PF_HISTORY.Creation_Date%TYPE,
641: p_Created_By IGC_CC_DET_PF_HISTORY.Created_By%TYPE,
642: p_Attribute1 IGC_CC_DET_PF_HISTORY.Attribute1%TYPE,
643: p_Attribute2 IGC_CC_DET_PF_HISTORY.Attribute2%TYPE,
644: p_Attribute3 IGC_CC_DET_PF_HISTORY.Attribute3%TYPE,

Line 641: p_Created_By IGC_CC_DET_PF_HISTORY.Created_By%TYPE,

637: p_Last_Update_Date IGC_CC_DET_PF_HISTORY.Last_Update_Date%TYPE,
638: p_Last_Updated_By IGC_CC_DET_PF_HISTORY.Last_Updated_By%TYPE,
639: p_Last_Update_Login IGC_CC_DET_PF_HISTORY.Last_Update_Login%TYPE,
640: p_Creation_Date IGC_CC_DET_PF_HISTORY.Creation_Date%TYPE,
641: p_Created_By IGC_CC_DET_PF_HISTORY.Created_By%TYPE,
642: p_Attribute1 IGC_CC_DET_PF_HISTORY.Attribute1%TYPE,
643: p_Attribute2 IGC_CC_DET_PF_HISTORY.Attribute2%TYPE,
644: p_Attribute3 IGC_CC_DET_PF_HISTORY.Attribute3%TYPE,
645: p_Attribute4 IGC_CC_DET_PF_HISTORY.Attribute4%TYPE,

Line 642: p_Attribute1 IGC_CC_DET_PF_HISTORY.Attribute1%TYPE,

638: p_Last_Updated_By IGC_CC_DET_PF_HISTORY.Last_Updated_By%TYPE,
639: p_Last_Update_Login IGC_CC_DET_PF_HISTORY.Last_Update_Login%TYPE,
640: p_Creation_Date IGC_CC_DET_PF_HISTORY.Creation_Date%TYPE,
641: p_Created_By IGC_CC_DET_PF_HISTORY.Created_By%TYPE,
642: p_Attribute1 IGC_CC_DET_PF_HISTORY.Attribute1%TYPE,
643: p_Attribute2 IGC_CC_DET_PF_HISTORY.Attribute2%TYPE,
644: p_Attribute3 IGC_CC_DET_PF_HISTORY.Attribute3%TYPE,
645: p_Attribute4 IGC_CC_DET_PF_HISTORY.Attribute4%TYPE,
646: p_Attribute5 IGC_CC_DET_PF_HISTORY.Attribute5%TYPE,

Line 643: p_Attribute2 IGC_CC_DET_PF_HISTORY.Attribute2%TYPE,

639: p_Last_Update_Login IGC_CC_DET_PF_HISTORY.Last_Update_Login%TYPE,
640: p_Creation_Date IGC_CC_DET_PF_HISTORY.Creation_Date%TYPE,
641: p_Created_By IGC_CC_DET_PF_HISTORY.Created_By%TYPE,
642: p_Attribute1 IGC_CC_DET_PF_HISTORY.Attribute1%TYPE,
643: p_Attribute2 IGC_CC_DET_PF_HISTORY.Attribute2%TYPE,
644: p_Attribute3 IGC_CC_DET_PF_HISTORY.Attribute3%TYPE,
645: p_Attribute4 IGC_CC_DET_PF_HISTORY.Attribute4%TYPE,
646: p_Attribute5 IGC_CC_DET_PF_HISTORY.Attribute5%TYPE,
647: p_Attribute6 IGC_CC_DET_PF_HISTORY.Attribute6%TYPE,

Line 644: p_Attribute3 IGC_CC_DET_PF_HISTORY.Attribute3%TYPE,

640: p_Creation_Date IGC_CC_DET_PF_HISTORY.Creation_Date%TYPE,
641: p_Created_By IGC_CC_DET_PF_HISTORY.Created_By%TYPE,
642: p_Attribute1 IGC_CC_DET_PF_HISTORY.Attribute1%TYPE,
643: p_Attribute2 IGC_CC_DET_PF_HISTORY.Attribute2%TYPE,
644: p_Attribute3 IGC_CC_DET_PF_HISTORY.Attribute3%TYPE,
645: p_Attribute4 IGC_CC_DET_PF_HISTORY.Attribute4%TYPE,
646: p_Attribute5 IGC_CC_DET_PF_HISTORY.Attribute5%TYPE,
647: p_Attribute6 IGC_CC_DET_PF_HISTORY.Attribute6%TYPE,
648: p_Attribute7 IGC_CC_DET_PF_HISTORY.Attribute7%TYPE,

Line 645: p_Attribute4 IGC_CC_DET_PF_HISTORY.Attribute4%TYPE,

641: p_Created_By IGC_CC_DET_PF_HISTORY.Created_By%TYPE,
642: p_Attribute1 IGC_CC_DET_PF_HISTORY.Attribute1%TYPE,
643: p_Attribute2 IGC_CC_DET_PF_HISTORY.Attribute2%TYPE,
644: p_Attribute3 IGC_CC_DET_PF_HISTORY.Attribute3%TYPE,
645: p_Attribute4 IGC_CC_DET_PF_HISTORY.Attribute4%TYPE,
646: p_Attribute5 IGC_CC_DET_PF_HISTORY.Attribute5%TYPE,
647: p_Attribute6 IGC_CC_DET_PF_HISTORY.Attribute6%TYPE,
648: p_Attribute7 IGC_CC_DET_PF_HISTORY.Attribute7%TYPE,
649: p_Attribute8 IGC_CC_DET_PF_HISTORY.Attribute8%TYPE,

Line 646: p_Attribute5 IGC_CC_DET_PF_HISTORY.Attribute5%TYPE,

642: p_Attribute1 IGC_CC_DET_PF_HISTORY.Attribute1%TYPE,
643: p_Attribute2 IGC_CC_DET_PF_HISTORY.Attribute2%TYPE,
644: p_Attribute3 IGC_CC_DET_PF_HISTORY.Attribute3%TYPE,
645: p_Attribute4 IGC_CC_DET_PF_HISTORY.Attribute4%TYPE,
646: p_Attribute5 IGC_CC_DET_PF_HISTORY.Attribute5%TYPE,
647: p_Attribute6 IGC_CC_DET_PF_HISTORY.Attribute6%TYPE,
648: p_Attribute7 IGC_CC_DET_PF_HISTORY.Attribute7%TYPE,
649: p_Attribute8 IGC_CC_DET_PF_HISTORY.Attribute8%TYPE,
650: p_Attribute9 IGC_CC_DET_PF_HISTORY.Attribute9%TYPE,

Line 647: p_Attribute6 IGC_CC_DET_PF_HISTORY.Attribute6%TYPE,

643: p_Attribute2 IGC_CC_DET_PF_HISTORY.Attribute2%TYPE,
644: p_Attribute3 IGC_CC_DET_PF_HISTORY.Attribute3%TYPE,
645: p_Attribute4 IGC_CC_DET_PF_HISTORY.Attribute4%TYPE,
646: p_Attribute5 IGC_CC_DET_PF_HISTORY.Attribute5%TYPE,
647: p_Attribute6 IGC_CC_DET_PF_HISTORY.Attribute6%TYPE,
648: p_Attribute7 IGC_CC_DET_PF_HISTORY.Attribute7%TYPE,
649: p_Attribute8 IGC_CC_DET_PF_HISTORY.Attribute8%TYPE,
650: p_Attribute9 IGC_CC_DET_PF_HISTORY.Attribute9%TYPE,
651: p_Attribute10 IGC_CC_DET_PF_HISTORY.Attribute10%TYPE,

Line 648: p_Attribute7 IGC_CC_DET_PF_HISTORY.Attribute7%TYPE,

644: p_Attribute3 IGC_CC_DET_PF_HISTORY.Attribute3%TYPE,
645: p_Attribute4 IGC_CC_DET_PF_HISTORY.Attribute4%TYPE,
646: p_Attribute5 IGC_CC_DET_PF_HISTORY.Attribute5%TYPE,
647: p_Attribute6 IGC_CC_DET_PF_HISTORY.Attribute6%TYPE,
648: p_Attribute7 IGC_CC_DET_PF_HISTORY.Attribute7%TYPE,
649: p_Attribute8 IGC_CC_DET_PF_HISTORY.Attribute8%TYPE,
650: p_Attribute9 IGC_CC_DET_PF_HISTORY.Attribute9%TYPE,
651: p_Attribute10 IGC_CC_DET_PF_HISTORY.Attribute10%TYPE,
652: p_Attribute11 IGC_CC_DET_PF_HISTORY.Attribute11%TYPE,

Line 649: p_Attribute8 IGC_CC_DET_PF_HISTORY.Attribute8%TYPE,

645: p_Attribute4 IGC_CC_DET_PF_HISTORY.Attribute4%TYPE,
646: p_Attribute5 IGC_CC_DET_PF_HISTORY.Attribute5%TYPE,
647: p_Attribute6 IGC_CC_DET_PF_HISTORY.Attribute6%TYPE,
648: p_Attribute7 IGC_CC_DET_PF_HISTORY.Attribute7%TYPE,
649: p_Attribute8 IGC_CC_DET_PF_HISTORY.Attribute8%TYPE,
650: p_Attribute9 IGC_CC_DET_PF_HISTORY.Attribute9%TYPE,
651: p_Attribute10 IGC_CC_DET_PF_HISTORY.Attribute10%TYPE,
652: p_Attribute11 IGC_CC_DET_PF_HISTORY.Attribute11%TYPE,
653: p_Attribute12 IGC_CC_DET_PF_HISTORY.Attribute12%TYPE,

Line 650: p_Attribute9 IGC_CC_DET_PF_HISTORY.Attribute9%TYPE,

646: p_Attribute5 IGC_CC_DET_PF_HISTORY.Attribute5%TYPE,
647: p_Attribute6 IGC_CC_DET_PF_HISTORY.Attribute6%TYPE,
648: p_Attribute7 IGC_CC_DET_PF_HISTORY.Attribute7%TYPE,
649: p_Attribute8 IGC_CC_DET_PF_HISTORY.Attribute8%TYPE,
650: p_Attribute9 IGC_CC_DET_PF_HISTORY.Attribute9%TYPE,
651: p_Attribute10 IGC_CC_DET_PF_HISTORY.Attribute10%TYPE,
652: p_Attribute11 IGC_CC_DET_PF_HISTORY.Attribute11%TYPE,
653: p_Attribute12 IGC_CC_DET_PF_HISTORY.Attribute12%TYPE,
654: p_Attribute13 IGC_CC_DET_PF_HISTORY.Attribute13%TYPE,

Line 651: p_Attribute10 IGC_CC_DET_PF_HISTORY.Attribute10%TYPE,

647: p_Attribute6 IGC_CC_DET_PF_HISTORY.Attribute6%TYPE,
648: p_Attribute7 IGC_CC_DET_PF_HISTORY.Attribute7%TYPE,
649: p_Attribute8 IGC_CC_DET_PF_HISTORY.Attribute8%TYPE,
650: p_Attribute9 IGC_CC_DET_PF_HISTORY.Attribute9%TYPE,
651: p_Attribute10 IGC_CC_DET_PF_HISTORY.Attribute10%TYPE,
652: p_Attribute11 IGC_CC_DET_PF_HISTORY.Attribute11%TYPE,
653: p_Attribute12 IGC_CC_DET_PF_HISTORY.Attribute12%TYPE,
654: p_Attribute13 IGC_CC_DET_PF_HISTORY.Attribute13%TYPE,
655: p_Attribute14 IGC_CC_DET_PF_HISTORY.Attribute14%TYPE,

Line 652: p_Attribute11 IGC_CC_DET_PF_HISTORY.Attribute11%TYPE,

648: p_Attribute7 IGC_CC_DET_PF_HISTORY.Attribute7%TYPE,
649: p_Attribute8 IGC_CC_DET_PF_HISTORY.Attribute8%TYPE,
650: p_Attribute9 IGC_CC_DET_PF_HISTORY.Attribute9%TYPE,
651: p_Attribute10 IGC_CC_DET_PF_HISTORY.Attribute10%TYPE,
652: p_Attribute11 IGC_CC_DET_PF_HISTORY.Attribute11%TYPE,
653: p_Attribute12 IGC_CC_DET_PF_HISTORY.Attribute12%TYPE,
654: p_Attribute13 IGC_CC_DET_PF_HISTORY.Attribute13%TYPE,
655: p_Attribute14 IGC_CC_DET_PF_HISTORY.Attribute14%TYPE,
656: p_Attribute15 IGC_CC_DET_PF_HISTORY.Attribute15%TYPE,

Line 653: p_Attribute12 IGC_CC_DET_PF_HISTORY.Attribute12%TYPE,

649: p_Attribute8 IGC_CC_DET_PF_HISTORY.Attribute8%TYPE,
650: p_Attribute9 IGC_CC_DET_PF_HISTORY.Attribute9%TYPE,
651: p_Attribute10 IGC_CC_DET_PF_HISTORY.Attribute10%TYPE,
652: p_Attribute11 IGC_CC_DET_PF_HISTORY.Attribute11%TYPE,
653: p_Attribute12 IGC_CC_DET_PF_HISTORY.Attribute12%TYPE,
654: p_Attribute13 IGC_CC_DET_PF_HISTORY.Attribute13%TYPE,
655: p_Attribute14 IGC_CC_DET_PF_HISTORY.Attribute14%TYPE,
656: p_Attribute15 IGC_CC_DET_PF_HISTORY.Attribute15%TYPE,
657: p_Context IGC_CC_DET_PF_HISTORY.Context%TYPE,

Line 654: p_Attribute13 IGC_CC_DET_PF_HISTORY.Attribute13%TYPE,

650: p_Attribute9 IGC_CC_DET_PF_HISTORY.Attribute9%TYPE,
651: p_Attribute10 IGC_CC_DET_PF_HISTORY.Attribute10%TYPE,
652: p_Attribute11 IGC_CC_DET_PF_HISTORY.Attribute11%TYPE,
653: p_Attribute12 IGC_CC_DET_PF_HISTORY.Attribute12%TYPE,
654: p_Attribute13 IGC_CC_DET_PF_HISTORY.Attribute13%TYPE,
655: p_Attribute14 IGC_CC_DET_PF_HISTORY.Attribute14%TYPE,
656: p_Attribute15 IGC_CC_DET_PF_HISTORY.Attribute15%TYPE,
657: p_Context IGC_CC_DET_PF_HISTORY.Context%TYPE,
658: G_FLAG IN OUT NOCOPY VARCHAR2

Line 655: p_Attribute14 IGC_CC_DET_PF_HISTORY.Attribute14%TYPE,

651: p_Attribute10 IGC_CC_DET_PF_HISTORY.Attribute10%TYPE,
652: p_Attribute11 IGC_CC_DET_PF_HISTORY.Attribute11%TYPE,
653: p_Attribute12 IGC_CC_DET_PF_HISTORY.Attribute12%TYPE,
654: p_Attribute13 IGC_CC_DET_PF_HISTORY.Attribute13%TYPE,
655: p_Attribute14 IGC_CC_DET_PF_HISTORY.Attribute14%TYPE,
656: p_Attribute15 IGC_CC_DET_PF_HISTORY.Attribute15%TYPE,
657: p_Context IGC_CC_DET_PF_HISTORY.Context%TYPE,
658: G_FLAG IN OUT NOCOPY VARCHAR2
659: ) IS

Line 656: p_Attribute15 IGC_CC_DET_PF_HISTORY.Attribute15%TYPE,

652: p_Attribute11 IGC_CC_DET_PF_HISTORY.Attribute11%TYPE,
653: p_Attribute12 IGC_CC_DET_PF_HISTORY.Attribute12%TYPE,
654: p_Attribute13 IGC_CC_DET_PF_HISTORY.Attribute13%TYPE,
655: p_Attribute14 IGC_CC_DET_PF_HISTORY.Attribute14%TYPE,
656: p_Attribute15 IGC_CC_DET_PF_HISTORY.Attribute15%TYPE,
657: p_Context IGC_CC_DET_PF_HISTORY.Context%TYPE,
658: G_FLAG IN OUT NOCOPY VARCHAR2
659: ) IS
660:

Line 657: p_Context IGC_CC_DET_PF_HISTORY.Context%TYPE,

653: p_Attribute12 IGC_CC_DET_PF_HISTORY.Attribute12%TYPE,
654: p_Attribute13 IGC_CC_DET_PF_HISTORY.Attribute13%TYPE,
655: p_Attribute14 IGC_CC_DET_PF_HISTORY.Attribute14%TYPE,
656: p_Attribute15 IGC_CC_DET_PF_HISTORY.Attribute15%TYPE,
657: p_Context IGC_CC_DET_PF_HISTORY.Context%TYPE,
658: G_FLAG IN OUT NOCOPY VARCHAR2
659: ) IS
660:
661: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';

Line 683: UPDATE IGC_CC_DET_PF_HISTORY

679: END IF;
680:
681: X_return_status := FND_API.G_RET_STS_SUCCESS ;
682:
683: UPDATE IGC_CC_DET_PF_HISTORY
684: SET CC_Det_PF_Line_Id = p_CC_Det_PF_Line_Id,
685: Parent_Det_PF_Line_Id = p_Parent_Det_PF_Line_Id,
686: CC_Acct_Line_Id = p_CC_Acct_Line_Id,
687: Parent_Acct_Line_Id = p_Parent_Acct_Line_Id,

Line 807: FROM IGC_CC_DET_PF_HISTORY

803:
804: X_return_status := FND_API.G_RET_STS_SUCCESS ;
805:
806: DELETE
807: FROM IGC_CC_DET_PF_HISTORY
808: WHERE rowid = p_Rowid;
809:
810: IF (SQL%NOTFOUND) THEN
811: RAISE NO_DATA_FOUND;

Line 852: END IGC_CC_DET_PF_HISTORY_PKG;

848: p_data => X_msg_data );
849:
850: END Delete_Row;
851:
852: END IGC_CC_DET_PF_HISTORY_PKG;