APPS.GMS_REPORT_SF270 dependencies on GMS_270_HISTORY

Line 4: Procedure INSERT_GMS_270_HISTORY(X_Award_Id IN NUMBER

1: PACKAGE BODY GMS_REPORT_SF270 AS
2: --$Header: gmsgrrab.pls 120.1 2006/02/14 01:49:41 lveerubh noship $
3:
4: Procedure INSERT_GMS_270_HISTORY(X_Award_Id IN NUMBER
5: ,X_Document_Number IN VARCHAR2
6: ,X_Total_Program_Outlays IN NUMBER
7: ,X_Version IN NUMBER
8: ,X_Status_Code IN VARCHAR2

Line 22: INSERT INTO GMS_270_HISTORY

18:
19: Begin
20:
21: Begin
22: INSERT INTO GMS_270_HISTORY
23: (
24: AWARD_ID
25: ,VERSION
26: ,STATUS_CODE

Line 77: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_REPORT_270: INSERT_GMS_270_HISTORY');

73: EXCEPTION
74: WHEN OTHERS THEN
75: X_Err_Code := 'U';
76: FND_MESSAGE.SET_NAME('GMS','GMS_UNEXPECTED_ERROR');
77: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_REPORT_270: INSERT_GMS_270_HISTORY');
78: FND_MESSAGE.SET_TOKEN('OERRNO',SQLCODE);
79: FND_MESSAGE.SET_TOKEN('OERRM',SQLERRM);
80: RAISE FND_API.G_EXC_ERROR;
81: End;

Line 87: End INSERT_GMS_270_HISTORY;

83: EXCEPTION
84: WHEN FND_API.G_EXC_ERROR THEN
85: RETURN;
86:
87: End INSERT_GMS_270_HISTORY;
88:
89: Procedure Populate_270_History(X_Award_Id IN NUMBER,
90: X_Report_Start_Date IN DATE,
91: X_Report_End_Date IN DATE,

Line 169: L_Report_Start_Date gms_270_history.report_start_date%type;

165: LEAST(X_Report_End_Date, end_date_active)
166: FROM gms_awards
167: WHERE award_id = X_Award_Id;
168:
169: L_Report_Start_Date gms_270_history.report_start_date%type;
170: L_Report_End_Date gms_270_history.report_end_date%type;
171:
172: /* End of changes for BUG : 2357578 */
173:

Line 170: L_Report_End_Date gms_270_history.report_end_date%type;

166: FROM gms_awards
167: WHERE award_id = X_Award_Id;
168:
169: L_Report_Start_Date gms_270_history.report_start_date%type;
170: L_Report_End_Date gms_270_history.report_end_date%type;
171:
172: /* End of changes for BUG : 2357578 */
173:
174: X_Expenditure_Item_Id NUMBER := NULL;

Line 271: from gms_270_history

267: /* Getting the latest version to be inserted */
268: select (nvl(max(version),0) +1)
269: into
270: X_Version
271: from gms_270_history
272: where award_id = X_Award_Id
273: and status_code = 'O';
274: End;
275:

Line 276: /* Inserting TWO Rows in GMS_270_HISTORY Table, one with a status of 'O' and one with a status of 'D' */

272: where award_id = X_Award_Id
273: and status_code = 'O';
274: End;
275:
276: /* Inserting TWO Rows in GMS_270_HISTORY Table, one with a status of 'O' and one with a status of 'D' */
277: Begin
278: X_Status_Code := 'O';
279: INSERT_GMS_270_HISTORY(X_Award_Id
280: ,X_Document_Number

Line 279: INSERT_GMS_270_HISTORY(X_Award_Id

275:
276: /* Inserting TWO Rows in GMS_270_HISTORY Table, one with a status of 'O' and one with a status of 'D' */
277: Begin
278: X_Status_Code := 'O';
279: INSERT_GMS_270_HISTORY(X_Award_Id
280: ,X_Document_Number
281: ,X_Total_Program_Outlays
282: ,X_Version
283: ,X_Status_Code

Line 294: INSERT_GMS_270_HISTORY(X_Award_Id

290: RAISE FND_API.G_EXC_ERROR;
291: End If;
292:
293: X_Status_Code := 'D';
294: INSERT_GMS_270_HISTORY(X_Award_Id
295: ,X_Document_Number
296: ,X_Total_Program_Outlays
297: ,X_Version
298: ,X_Status_Code