APPS.GL_BUDGETS_PKG dependencies on GL_BUDGET_VERSIONS

Line 35: FROM gl_budget_versions bv, gl_budgets b

31: x_first_valid_period_name VARCHAR2,
32: x_last_valid_period_name VARCHAR2) IS
33: CURSOR chk_details IS
34: SELECT 'Master budget'
35: FROM gl_budget_versions bv, gl_budgets b
36: WHERE bv.control_budget_version_id =
37: x_budget_version_id
38: AND b.budget_name = bv.budget_name
39: AND b.budget_type = bv.budget_type

Line 85: FROM gl_budget_versions bv

81: SELECT 'Master budget'
82: FROM gl_budgets b
83: WHERE b.budget_name =
84: (SELECT bv.budget_name
85: FROM gl_budget_versions bv
86: WHERE bv.budget_version_id =
87: x_master_budget_version_id)
88: AND b.budget_type = 'standard'
89: AND b.first_valid_period_name =

Line 147: SELECT gl_budget_versions_s.NEXTVAL

143: END check_unique;
144:
145: FUNCTION get_unique_id RETURN NUMBER IS
146: CURSOR get_new_id IS
147: SELECT gl_budget_versions_s.NEXTVAL
148: FROM dual;
149: new_id number;
150: BEGIN
151: OPEN get_new_id;

Line 160: fnd_message.set_token('SEQUENCE', 'GL_BUDGET_VERSIONS_S');

156: return(new_id);
157: ELSE
158: CLOSE get_new_id;
159: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
160: fnd_message.set_token('SEQUENCE', 'GL_BUDGET_VERSIONS_S');
161: app_exception.raise_exception;
162: END IF;
163:
164: EXCEPTION

Line 396: -- Insert the associated rows in gl_budget_versions

392: RAISE NO_DATA_FOUND;
393: end if;
394: CLOSE C;
395:
396: -- Insert the associated rows in gl_budget_versions
397: gl_budget_versions_pkg.insert_record( x_budget_version_id,
398: x_budget_name,
399: x_status,
400: x_master_budget_version_id,

Line 397: gl_budget_versions_pkg.insert_record( x_budget_version_id,

393: end if;
394: CLOSE C;
395:
396: -- Insert the associated rows in gl_budget_versions
397: gl_budget_versions_pkg.insert_record( x_budget_version_id,
398: x_budget_name,
399: x_status,
400: x_master_budget_version_id,
401: x_user_id,

Line 651: -- Update the associated row in gl_budget_versions

647: if (SQL%NOTFOUND) then
648: RAISE NO_DATA_FOUND;
649: end if;
650:
651: -- Update the associated row in gl_budget_versions
652: gl_budget_versions_pkg.update_record( x_budget_version_id,
653: x_budget_name,
654: x_status,
655: x_master_budget_version_id,

Line 652: gl_budget_versions_pkg.update_record( x_budget_version_id,

648: RAISE NO_DATA_FOUND;
649: end if;
650:
651: -- Update the associated row in gl_budget_versions
652: gl_budget_versions_pkg.update_record( x_budget_version_id,
653: x_budget_name,
654: x_status,
655: x_master_budget_version_id,
656: x_user_id,