APPS.GL_SUMMARY_BC_OPTIONS_PKG dependencies on GL_SUMMARY_BC_OPTIONS

Line 1: PACKAGE BODY gl_summary_bc_options_pkg AS

1: PACKAGE BODY gl_summary_bc_options_pkg AS
2: /* $Header: glistbcb.pls 120.4.12010000.1 2008/07/28 13:26:46 appldev ship $ */
3:
4: --
5: -- PUBLIC FUNCTIONS

Line 29: gl_summary_bc_options sa,

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

Line 64: FROM gl_summary_bc_options

60:
61:
62: CURSOR C IS
63: SELECT rowid
64: FROM gl_summary_bc_options
65: WHERE template_id = X_Template_Id
66: AND funding_budget_version_id = X_Funding_Budget_Version_Id;
67:
68: dummy VARCHAR2(100);

Line 81: INSERT INTO GL_SUMMARY_BC_OPTIONS(

77: ELSE
78: CLOSE check_overlaps;
79: END IF;
80:
81: INSERT INTO GL_SUMMARY_BC_OPTIONS(
82: template_id,
83: last_update_date,
84: last_updated_by,
85: funds_check_level_code,

Line 131: FROM GL_SUMMARY_BC_OPTIONS

127: X_Funding_Budget_Version_Id NUMBER
128: ) IS
129: CURSOR C IS
130: SELECT *
131: FROM GL_SUMMARY_BC_OPTIONS
132: WHERE rowid = X_Rowid
133: FOR UPDATE of template_id NOWAIT;
134: Recinfo C%ROWTYPE;
135: BEGIN

Line 388: 'GL_SUMMARY_BC_OPTIONS_PKG.Insert_BC_Options');

384: RAISE;
385: WHEN OTHERS THEN
386: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
387: fnd_message.set_token('PROCEDURE',
388: 'GL_SUMMARY_BC_OPTIONS_PKG.Insert_BC_Options');
389: RAISE;
390:
391: END Insert_BC_Options;
392:

Line 393: END gl_summary_bc_options_pkg;

389: RAISE;
390:
391: END Insert_BC_Options;
392:
393: END gl_summary_bc_options_pkg;