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.6 2010/08/04 13:28:55 amaddula 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.6 2010/08/04 13:28:55 amaddula 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 39: CURSOR C IS SELECT ROWID FROM FV_BUDGET_DISTRIBUTION_HDR

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

Line 42: INSERT INTO FV_BUDGET_DISTRIBUTION_HDR(

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

Line 150: UPDATE FV_BUDGET_DISTRIBUTION_HDR

146: ) IS
147: l_module_name VARCHAR2(200) := g_module_name || 'Update_Row';
148: l_errbuf VARCHAR2(1024);
149: BEGIN
150: UPDATE FV_BUDGET_DISTRIBUTION_HDR
151: SET
152: DISTRIBUTION_ID = X_DISTRIBUTION_ID,
153: FUND_VALUE = X_FUND_VALUE,
154: SET_OF_BOOKS_ID = X_SET_OF_BOOKS_ID,

Line 213: FROM FV_BUDGET_DISTRIBUTION_HDR

209: attribute_category,
210: org_id,
211: facts_prgm_segment,
212: treasury_symbol_id
213: FROM FV_BUDGET_DISTRIBUTION_HDR
214: WHERE ROWID = X_ROWID
215: for UPDATE OF DISTRIBUTION_ID NOWAIT;
216: Recinfo C%ROWTYPE;
217:

Line 267: FROM FV_BUDGET_DISTRIBUTION_HDR

263: BEGIN
264: BEGIN
265: SELECT distribution_id
266: INTO x_distribution_id
267: FROM FV_BUDGET_DISTRIBUTION_HDR
268: WHERE rowid = x_rowid;
269:
270: SELECT fund_value
271: INTO x_fund_value

Line 272: FROM FV_BUDGET_DISTRIBUTION_HDR

268: WHERE rowid = x_rowid;
269:
270: SELECT fund_value
271: INTO x_fund_value
272: FROM FV_BUDGET_DISTRIBUTION_HDR
273: WHERE rowid = x_rowid;
274:
275: EXCEPTION
276: WHEN NO_DATA_FOUND THEN

Line 285: FROM FV_BUDGET_DISTRIBUTION_HDR

281: /* Delete FV_BUDGET_DISTRIBUTION_DTL - Master - Detail - Detail Record */
282: DELETE FROM FV_BUDGET_DISTRIBUTION_DTL
283: WHERE fund_value IN
284: (SELECT fund_value
285: FROM FV_BUDGET_DISTRIBUTION_HDR
286: WHERE fund_value = x_fund_value);
287:
288: IF (SQL%NOTFOUND) THEN
289: NULL;

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

288: IF (SQL%NOTFOUND) THEN
289: NULL;
290: END IF;
291:
292: /* Delete FV_BUDGET_DISTRIBUTION_HDR - Master Record */
293: DELETE FROM FV_BUDGET_DISTRIBUTION_HDR
294: WHERE DISTRIBUTION_ID = X_DISTRIBUTION_ID ;
295:
296: IF (SQL%NOTFOUND) THEN

Line 293: DELETE FROM FV_BUDGET_DISTRIBUTION_HDR

289: NULL;
290: END IF;
291:
292: /* Delete FV_BUDGET_DISTRIBUTION_HDR - Master Record */
293: DELETE FROM FV_BUDGET_DISTRIBUTION_HDR
294: WHERE DISTRIBUTION_ID = X_DISTRIBUTION_ID ;
295:
296: IF (SQL%NOTFOUND) THEN
297: RAISE NO_DATA_FOUND;

Line 306: END FV_BUDGET_DISTRIBUTION_HDR_PKG;

302: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',l_errbuf);
303: RAISE;
304: END DELETE_ROW;
305:
306: END FV_BUDGET_DISTRIBUTION_HDR_PKG;