[Home] [Help]
PACKAGE: APPS.IGC_CC_DET_PF_HISTORY_PKG
Source
1 PACKAGE IGC_CC_DET_PF_HISTORY_PKG AUTHID CURRENT_USER as
2 /* $Header: IGCCDFHS.pls 120.5.12020000.1 2013/02/15 20:48:35 appldev ship $ */
3
4 /* ================================================================================
5 PROCEDURE Insert_Row
6 ===============================================================================*/
7
8 PROCEDURE Insert_Row(
9 p_api_version IN NUMBER,
10 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
11 p_commit IN VARCHAR2 := FND_API.G_FALSE,
12 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
13 X_return_status OUT NOCOPY VARCHAR2,
14 X_msg_count OUT NOCOPY NUMBER,
15 X_msg_data OUT NOCOPY VARCHAR2,
16 p_Rowid IN OUT NOCOPY VARCHAR2,
17 p_CC_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Id%TYPE,
18 p_CC_Det_PF_Line_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Num%TYPE,
19 p_CC_Acct_Line_Id IGC_CC_DET_PF_HISTORY.CC_Acct_Line_Id%TYPE,
20 p_Parent_Acct_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Acct_Line_Id%TYPE,
21 p_Parent_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Det_PF_Line_Id%TYPE,
22 p_Det_PF_Version_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Num%TYPE,
23 p_Det_PF_Version_Action IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Action%TYPE,
24 p_CC_Det_PF_Entered_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Entered_Amt%TYPE,
25 p_CC_Det_PF_Func_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Func_Amt%TYPE,
26 p_CC_Det_PF_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Date%TYPE,
27 p_CC_Det_PF_Billed_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Billed_Amt%TYPE,
28 p_CC_Det_PF_Unbilled_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Unbilled_Amt%TYPE,
29 p_CC_Det_PF_Encmbrnc_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Amt%TYPE,
30 p_CC_Det_PF_Encmbrnc_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Date%TYPE,
31 p_CC_Det_PF_Encmbrnc_Status IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Status%TYPE,
32 p_Last_Update_Date IGC_CC_DET_PF_HISTORY.Last_Update_Date%TYPE,
33 p_Last_Updated_By IGC_CC_DET_PF_HISTORY.Last_Updated_By%TYPE,
34 p_Last_Update_Login IGC_CC_DET_PF_HISTORY.Last_Update_Login%TYPE,
35 p_Creation_Date IGC_CC_DET_PF_HISTORY.Creation_Date%TYPE,
36 p_Created_By IGC_CC_DET_PF_HISTORY.Created_By%TYPE,
37 p_Attribute1 IGC_CC_DET_PF_HISTORY.Attribute1%TYPE,
38 p_Attribute2 IGC_CC_DET_PF_HISTORY.Attribute2%TYPE,
39 p_Attribute3 IGC_CC_DET_PF_HISTORY.Attribute3%TYPE,
40 p_Attribute4 IGC_CC_DET_PF_HISTORY.Attribute4%TYPE,
41 p_Attribute5 IGC_CC_DET_PF_HISTORY.Attribute5%TYPE,
42 p_Attribute6 IGC_CC_DET_PF_HISTORY.Attribute6%TYPE,
43 p_Attribute7 IGC_CC_DET_PF_HISTORY.Attribute7%TYPE,
44 p_Attribute8 IGC_CC_DET_PF_HISTORY.Attribute8%TYPE,
45 p_Attribute9 IGC_CC_DET_PF_HISTORY.Attribute9%TYPE,
46 p_Attribute10 IGC_CC_DET_PF_HISTORY.Attribute10%TYPE,
47 p_Attribute11 IGC_CC_DET_PF_HISTORY.Attribute11%TYPE,
48 p_Attribute12 IGC_CC_DET_PF_HISTORY.Attribute12%TYPE,
49 p_Attribute13 IGC_CC_DET_PF_HISTORY.Attribute13%TYPE,
50 p_Attribute14 IGC_CC_DET_PF_HISTORY.Attribute14%TYPE,
51 p_Attribute15 IGC_CC_DET_PF_HISTORY.Attribute15%TYPE,
52 p_Context IGC_CC_DET_PF_HISTORY.Context%TYPE,
53 G_FLAG IN OUT NOCOPY VARCHAR2
54 );
55
56 /* ================================================================================
57 PROCEDURE Lock_Row
58 ===============================================================================*/
59
60
61 PROCEDURE Lock_Row (
62 p_api_version IN NUMBER,
63 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
64 p_commit IN VARCHAR2 := FND_API.G_FALSE,
65 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
66 X_return_status OUT NOCOPY VARCHAR2,
67 X_msg_count OUT NOCOPY NUMBER,
68 X_msg_data OUT NOCOPY VARCHAR2,
69 p_Rowid IN OUT NOCOPY VARCHAR2,
70 p_CC_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Id%TYPE,
71 p_CC_Det_PF_Line_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Num%TYPE,
72 p_CC_Acct_Line_Id IGC_CC_DET_PF_HISTORY.CC_Acct_Line_Id%TYPE,
73 p_Parent_Acct_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Acct_Line_Id%TYPE,
74 p_Parent_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Det_PF_Line_Id%TYPE,
75 p_Det_PF_Version_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Num%TYPE,
76 p_Det_PF_Version_Action IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Action%TYPE,
77 p_CC_Det_PF_Entered_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Entered_Amt%TYPE,
78 p_CC_Det_PF_Func_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Func_Amt%TYPE,
79 p_CC_Det_PF_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Date%TYPE,
80 p_CC_Det_PF_Billed_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Billed_Amt%TYPE,
81 p_CC_Det_PF_Unbilled_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Unbilled_Amt%TYPE,
82 p_CC_Det_PF_Encmbrnc_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Amt%TYPE,
83 p_CC_Det_PF_Encmbrnc_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Date%TYPE,
84 p_CC_Det_PF_Encmbrnc_Status IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Status%TYPE,
85 p_Last_Update_Date IGC_CC_DET_PF_HISTORY.Last_Update_Date%TYPE,
86 p_Last_Updated_By IGC_CC_DET_PF_HISTORY.Last_Updated_By%TYPE,
87 p_Last_Update_Login IGC_CC_DET_PF_HISTORY.Last_Update_Login%TYPE,
88 p_Creation_Date IGC_CC_DET_PF_HISTORY.Creation_Date%TYPE,
89 p_Created_By IGC_CC_DET_PF_HISTORY.Created_By%TYPE,
90 p_Attribute1 IGC_CC_DET_PF_HISTORY.Attribute1%TYPE,
91 p_Attribute2 IGC_CC_DET_PF_HISTORY.Attribute2%TYPE,
92 p_Attribute3 IGC_CC_DET_PF_HISTORY.Attribute3%TYPE,
93 p_Attribute4 IGC_CC_DET_PF_HISTORY.Attribute4%TYPE,
94 p_Attribute5 IGC_CC_DET_PF_HISTORY.Attribute5%TYPE,
95 p_Attribute6 IGC_CC_DET_PF_HISTORY.Attribute6%TYPE,
96 p_Attribute7 IGC_CC_DET_PF_HISTORY.Attribute7%TYPE,
97 p_Attribute8 IGC_CC_DET_PF_HISTORY.Attribute8%TYPE,
98 p_Attribute9 IGC_CC_DET_PF_HISTORY.Attribute9%TYPE,
99 p_Attribute10 IGC_CC_DET_PF_HISTORY.Attribute10%TYPE,
100 p_Attribute11 IGC_CC_DET_PF_HISTORY.Attribute11%TYPE,
101 p_Attribute12 IGC_CC_DET_PF_HISTORY.Attribute12%TYPE,
102 p_Attribute13 IGC_CC_DET_PF_HISTORY.Attribute13%TYPE,
103 p_Attribute14 IGC_CC_DET_PF_HISTORY.Attribute14%TYPE,
104 p_Attribute15 IGC_CC_DET_PF_HISTORY.Attribute15%TYPE,
105 p_Context IGC_CC_DET_PF_HISTORY.Context%TYPE,
106 X_row_locked OUT NOCOPY VARCHAR2,
107 G_FLAG IN OUT NOCOPY VARCHAR2
108 );
109
110 /* ================================================================================
111 PROCEDURE Update_Row
112 ===============================================================================*/
113
114
115 PROCEDURE Update_Row(
116 p_api_version IN NUMBER,
117 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
118 p_commit IN VARCHAR2 := FND_API.G_FALSE,
119 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
120 X_return_status OUT NOCOPY VARCHAR2,
121 X_msg_count OUT NOCOPY NUMBER,
122 X_msg_data OUT NOCOPY VARCHAR2,
123 p_Rowid IN OUT NOCOPY VARCHAR2,
124 p_CC_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Id%TYPE,
125 p_CC_Det_PF_Line_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Num%TYPE,
126 p_CC_Acct_Line_Id IGC_CC_DET_PF_HISTORY.CC_Acct_Line_Id%TYPE,
127 p_Parent_Acct_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Acct_Line_Id%TYPE,
128 p_Parent_Det_PF_Line_Id IGC_CC_DET_PF_HISTORY.Parent_Det_PF_Line_Id%TYPE,
129 p_Det_PF_Version_Num IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Num%TYPE,
130 p_Det_PF_Version_Action IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Action%TYPE,
131 p_CC_Det_PF_Entered_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Entered_Amt%TYPE,
132 p_CC_Det_PF_Func_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Func_Amt%TYPE,
133 p_CC_Det_PF_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Date%TYPE,
134 p_CC_Det_PF_Billed_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Billed_Amt%TYPE,
135 p_CC_Det_PF_Unbilled_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Unbilled_Amt%TYPE,
136 p_CC_Det_PF_Encmbrnc_Amt IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Amt%TYPE,
137 p_CC_Det_PF_Encmbrnc_Date IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Date%TYPE,
138 p_CC_Det_PF_Encmbrnc_Status IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Status%TYPE,
139 p_Last_Update_Date IGC_CC_DET_PF_HISTORY.Last_Update_Date%TYPE,
140 p_Last_Updated_By IGC_CC_DET_PF_HISTORY.Last_Updated_By%TYPE,
141 p_Last_Update_Login IGC_CC_DET_PF_HISTORY.Last_Update_Login%TYPE,
142 p_Creation_Date IGC_CC_DET_PF_HISTORY.Creation_Date%TYPE,
143 p_Created_By IGC_CC_DET_PF_HISTORY.Created_By%TYPE,
144 p_Attribute1 IGC_CC_DET_PF_HISTORY.Attribute1%TYPE,
145 p_Attribute2 IGC_CC_DET_PF_HISTORY.Attribute2%TYPE,
146 p_Attribute3 IGC_CC_DET_PF_HISTORY.Attribute3%TYPE,
147 p_Attribute4 IGC_CC_DET_PF_HISTORY.Attribute4%TYPE,
148 p_Attribute5 IGC_CC_DET_PF_HISTORY.Attribute5%TYPE,
149 p_Attribute6 IGC_CC_DET_PF_HISTORY.Attribute6%TYPE,
150 p_Attribute7 IGC_CC_DET_PF_HISTORY.Attribute7%TYPE,
151 p_Attribute8 IGC_CC_DET_PF_HISTORY.Attribute8%TYPE,
152 p_Attribute9 IGC_CC_DET_PF_HISTORY.Attribute9%TYPE,
153 p_Attribute10 IGC_CC_DET_PF_HISTORY.Attribute10%TYPE,
154 p_Attribute11 IGC_CC_DET_PF_HISTORY.Attribute11%TYPE,
155 p_Attribute12 IGC_CC_DET_PF_HISTORY.Attribute12%TYPE,
156 p_Attribute13 IGC_CC_DET_PF_HISTORY.Attribute13%TYPE,
157 p_Attribute14 IGC_CC_DET_PF_HISTORY.Attribute14%TYPE,
158 p_Attribute15 IGC_CC_DET_PF_HISTORY.Attribute15%TYPE,
159 p_Context IGC_CC_DET_PF_HISTORY.Context%TYPE,
160 G_FLAG IN OUT NOCOPY VARCHAR2
161
162 );
163
164
165 /* ================================================================================
166 PROCEDURE Delete_Row
167 ===============================================================================*/
168
169 PROCEDURE Delete_Row(
170 p_api_version IN NUMBER,
171 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
172 p_commit IN VARCHAR2 := FND_API.G_FALSE,
173 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
174 X_return_status OUT NOCOPY VARCHAR2,
175 X_msg_count OUT NOCOPY NUMBER,
176 X_msg_data OUT NOCOPY VARCHAR2,
177 p_Rowid VARCHAR2,
178 G_FLAG IN OUT NOCOPY VARCHAR2
179 );
180
181 END IGC_CC_DET_PF_HISTORY_PKG;