APPS.FV_BUDGET_DISTRIBUTION_HDR_PKG dependencies on FV_BUDGET_DISTRIBUTION_HDR

Line 1: PACKAGE BODY FV_BUDGET_DISTRIBUTION_HDR_PKG as

1: PACKAGE BODY FV_BUDGET_DISTRIBUTION_HDR_PKG as
2: /* $Header: FVBEHDRB.pls 120.4 2003/12/17 21:19:48 ksriniva ship $ */
3: g_module_name VARCHAR2(100) := 'fv.plsql.FV_BUDGET_DISTRIBUTION_HDR_PKG.';
4:
5: PROCEDURE Insert_Row(X_ROWID IN OUT NOCOPY VARCHAR2,

Line 3: g_module_name VARCHAR2(100) := 'fv.plsql.FV_BUDGET_DISTRIBUTION_HDR_PKG.';

1: PACKAGE BODY FV_BUDGET_DISTRIBUTION_HDR_PKG as
2: /* $Header: FVBEHDRB.pls 120.4 2003/12/17 21:19:48 ksriniva ship $ */
3: g_module_name VARCHAR2(100) := 'fv.plsql.FV_BUDGET_DISTRIBUTION_HDR_PKG.';
4:
5: PROCEDURE Insert_Row(X_ROWID IN OUT NOCOPY VARCHAR2,
6: X_DISTRIBUTION_ID NUMBER,
7: X_FUND_VALUE VARCHAR2,

Line 37: CURSOR C IS SELECT ROWID FROM FV_BUDGET_DISTRIBUTION_HDR

33: ) IS
34: l_module_name VARCHAR2(200) := g_module_name || 'Insert_Row';
35: l_errbuf VARCHAR2(1024);
36:
37: CURSOR C IS SELECT ROWID FROM FV_BUDGET_DISTRIBUTION_HDR
38: WHERE DISTRIBUTION_ID = X_DISTRIBUTION_ID;
39: BEGIN
40: INSERT INTO FV_BUDGET_DISTRIBUTION_HDR(
41: DISTRIBUTION_ID,

Line 40: INSERT INTO FV_BUDGET_DISTRIBUTION_HDR(

36:
37: CURSOR C IS SELECT ROWID FROM FV_BUDGET_DISTRIBUTION_HDR
38: WHERE DISTRIBUTION_ID = X_DISTRIBUTION_ID;
39: BEGIN
40: INSERT INTO FV_BUDGET_DISTRIBUTION_HDR(
41: DISTRIBUTION_ID,
42: FUND_VALUE ,
43: SET_OF_BOOKS_ID ,
44: LAST_UPDATE_DATE,

Line 143: UPDATE FV_BUDGET_DISTRIBUTION_HDR

139: ) IS
140: l_module_name VARCHAR2(200) := g_module_name || 'Update_Row';
141: l_errbuf VARCHAR2(1024);
142: BEGIN
143: UPDATE FV_BUDGET_DISTRIBUTION_HDR
144: SET
145: DISTRIBUTION_ID = X_DISTRIBUTION_ID,
146: FUND_VALUE = X_FUND_VALUE,
147: SET_OF_BOOKS_ID = X_SET_OF_BOOKS_ID,

Line 204: FROM FV_BUDGET_DISTRIBUTION_HDR

200: attribute_category,
201: org_id,
202: facts_prgm_segment,
203: treasury_symbol_id
204: FROM FV_BUDGET_DISTRIBUTION_HDR
205: WHERE ROWID = X_ROWID
206: for UPDATE OF DISTRIBUTION_ID NOWAIT;
207: Recinfo C%ROWTYPE;
208:

Line 258: FROM FV_BUDGET_DISTRIBUTION_HDR

254: BEGIN
255: BEGIN
256: SELECT distribution_id
257: INTO x_distribution_id
258: FROM FV_BUDGET_DISTRIBUTION_HDR
259: WHERE rowid = x_rowid;
260:
261: SELECT fund_value
262: INTO x_fund_value

Line 263: FROM FV_BUDGET_DISTRIBUTION_HDR

259: WHERE rowid = x_rowid;
260:
261: SELECT fund_value
262: INTO x_fund_value
263: FROM FV_BUDGET_DISTRIBUTION_HDR
264: WHERE rowid = x_rowid;
265:
266: EXCEPTION
267: WHEN NO_DATA_FOUND THEN

Line 276: FROM FV_BUDGET_DISTRIBUTION_HDR

272: /* Delete FV_BUDGET_DISTRIBUTION_DTL - Master - Detail - Detail Record */
273: DELETE FROM FV_BUDGET_DISTRIBUTION_DTL
274: WHERE fund_value IN
275: (SELECT fund_value
276: FROM FV_BUDGET_DISTRIBUTION_HDR
277: WHERE fund_value = x_fund_value);
278:
279: IF (SQL%NOTFOUND) THEN
280: NULL;

Line 283: /* Delete FV_BUDGET_DISTRIBUTION_HDR - Master Record */

279: IF (SQL%NOTFOUND) THEN
280: NULL;
281: END IF;
282:
283: /* Delete FV_BUDGET_DISTRIBUTION_HDR - Master Record */
284: DELETE FROM FV_BUDGET_DISTRIBUTION_HDR
285: WHERE DISTRIBUTION_ID = X_DISTRIBUTION_ID ;
286:
287: IF (SQL%NOTFOUND) THEN

Line 284: DELETE FROM FV_BUDGET_DISTRIBUTION_HDR

280: NULL;
281: END IF;
282:
283: /* Delete FV_BUDGET_DISTRIBUTION_HDR - Master Record */
284: DELETE FROM FV_BUDGET_DISTRIBUTION_HDR
285: WHERE DISTRIBUTION_ID = X_DISTRIBUTION_ID ;
286:
287: IF (SQL%NOTFOUND) THEN
288: RAISE NO_DATA_FOUND;

Line 297: END FV_BUDGET_DISTRIBUTION_HDR_PKG;

293: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',l_errbuf);
294: RAISE;
295: END DELETE_ROW;
296:
297: END FV_BUDGET_DISTRIBUTION_HDR_PKG;