APPS.GL_BUDORG_BC_OPTIONS_PKG dependencies on GL_BUDORG_BC_OPTIONS

Line 1: PACKAGE BODY gl_budorg_bc_options_pkg AS

1: PACKAGE BODY gl_budorg_bc_options_pkg AS
2: /* $Header: glibebcb.pls 120.4.12010000.1 2008/07/28 13:23:31 appldev ship $ */
3:
4: --
5: -- PUBLIC FUNCTIONS

Line 28: gl_budorg_bc_options ba,

24: WHERE EXISTS
25: (SELECT 'X'
26: FROM gl_budgets b1,
27: gl_budget_versions bv1,
28: gl_budorg_bc_options ba,
29: gl_period_statuses pf1,
30: gl_period_statuses pl1,
31: gl_budgets b2,
32: gl_budget_versions bv2,

Line 61: FROM gl_budorg_bc_options

57: );
58:
59: CURSOR C IS
60: SELECT rowid
61: FROM gl_budorg_bc_options
62: WHERE range_id = X_Range_Id
63: AND funding_budget_version_id = X_Funding_Budget_Version_Id;
64:
65: dummy VARCHAR2(100);

Line 79: INSERT INTO gl_budorg_bc_options(

75: CLOSE check_overlaps;
76: END IF;
77:
78:
79: INSERT INTO gl_budorg_bc_options(
80: last_update_date,
81: last_updated_by,
82: creation_date,
83: created_by,

Line 121: FROM gl_budorg_bc_options

117: X_Range_Id NUMBER
118: ) IS
119: CURSOR C IS
120: SELECT *
121: FROM gl_budorg_bc_options
122: WHERE rowid = X_Rowid
123: FOR UPDATE of Range_Id NOWAIT;
124: Recinfo C%ROWTYPE;
125: BEGIN

Line 168: UPDATE gl_budorg_bc_options

164: X_Funding_Budget_Version_Id NUMBER,
165: X_Range_Id NUMBER
166: ) IS
167: BEGIN
168: UPDATE gl_budorg_bc_options
169: SET
170:
171: last_update_date = X_Last_Update_Date,
172: last_updated_by = X_Last_Updated_By,

Line 189: DELETE FROM gl_budorg_bc_options

185: END Update_Row;
186:
187: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
188: BEGIN
189: DELETE FROM gl_budorg_bc_options
190: WHERE rowid = X_Rowid;
191:
192: if (SQL%NOTFOUND) then
193: RAISE NO_DATA_FOUND;

Line 199: DELETE FROM gl_budorg_bc_options

195: END Delete_Row;
196:
197: PROCEDURE delete_budorg_bc_options(xrange_id NUMBER)IS
198: BEGIN
199: DELETE FROM gl_budorg_bc_options
200: WHERE range_id = xrange_id;
201: EXCEPTION
202: WHEN no_data_found THEN
203: RETURN;

Line 208: 'gl_budorg_bc_options_pkg.delete_budorg_bc_options');

204: WHEN OTHERS THEN
205: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
206: fnd_message.set_token(
207: 'PROCEDURE',
208: 'gl_budorg_bc_options_pkg.delete_budorg_bc_options');
209: RAISE;
210: END delete_budorg_bc_options;
211:
212:

Line 405: 'GL_BUDORG_BC_OPTIONS_PKG.Insert_BC_Options');

401: RAISE;
402: WHEN OTHERS THEN
403: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
404: fnd_message.set_token('PROCEDURE',
405: 'GL_BUDORG_BC_OPTIONS_PKG.Insert_BC_Options');
406: RAISE;
407:
408: END Insert_BC_Options;
409:

Line 581: UPDATE gl_budorg_bc_options

577: NULL;
578: END IF;
579:
580:
581: UPDATE gl_budorg_bc_options
582: SET
583: last_update_date = X_Last_Update_Date,
584: last_updated_by = X_Last_Updated_By,
585: last_update_login = X_Last_Update_Login,

Line 603: 'GL_BUDORG_BC_OPTIONS_PKG.Update_BC_Options');

599: RAISE;
600: WHEN OTHERS THEN
601: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
602: fnd_message.set_token('PROCEDURE',
603: 'GL_BUDORG_BC_OPTIONS_PKG.Update_BC_Options');
604: RAISE;
605:
606: END Update_BC_Options;
607:

Line 609: END gl_budorg_bc_options_pkg;

605:
606: END Update_BC_Options;
607:
608:
609: END gl_budorg_bc_options_pkg;