APPS.GL_BC_OPTIONS_PKG dependencies on GL_BC_OPTIONS

Line 1: PACKAGE BODY gl_bc_options_pkg AS

1: PACKAGE BODY gl_bc_options_pkg AS
2: /* $Header: glnlsbcb.pls 120.5 2005/05/05 02:06:55 kvora ship $ */
3:
4: Procedure load_row(
5: x_bc_option_id in number,

Line 52: from gl_bc_options

48: the creation date for update_row. */
49:
50: select creation_date,rowid
51: into v_creation_date, v_rowid
52: from gl_bc_options
53: where bc_option_id = x_bc_option_id;
54:
55: /* Update only if force_edits is 'Y' or it is seed data */
56: if ((x_force_edits = 'Y') OR (x_owner = 'SEED')) THEN

Line 58: gl_bc_options_pkg.update_row(

54:
55: /* Update only if force_edits is 'Y' or it is seed data */
56: if ((x_force_edits = 'Y') OR (x_owner = 'SEED')) THEN
57: -- update row if present
58: gl_bc_options_pkg.update_row(
59: x_row_id => v_rowid ,
60: x_bc_option_id => x_bc_option_id,
61: x_bc_option_name => x_bc_option_name,
62: x_description => x_description,

Line 88: gl_bc_options_pkg.insert_row(

84: end if;
85:
86: exception
87: when NO_DATA_FOUND then
88: gl_bc_options_pkg.insert_row(
89: x_row_id => v_rowid ,
90: x_bc_option_id => x_bc_option_id,
91: x_bc_option_name => x_bc_option_name,
92: x_description => x_description,

Line 136: update gl_bc_options

132: end if;
133:
134: /* Update only if force_edits is 'Y' or it is seed data */
135: if ((x_force_edits = 'Y') OR (x_owner = 'SEED')) then
136: update gl_bc_options
137: set
138: bc_option_name = x_bc_option_name,
139: description = x_description,
140: last_update_date = sysdate,

Line 189: Update gl_bc_options

185: ) as
186: begin
187:
188: --update non translatable column
189: Update gl_bc_options
190: set bc_option_id = x_bc_option_id,
191: bc_option_name = x_bc_option_name,
192: context = x_context,
193: attribute1 = x_attribute1,

Line 251: from gl_bc_options

247: ) as
248:
249: cursor bc_option_row is
250: select rowid
251: from gl_bc_options
252: where bc_option_id = x_bc_option_id;
253:
254: begin
255:

Line 260: INSERT INTO GL_BC_OPTIONS(

256: if (x_bc_option_id is NULL) then
257: raise no_data_found;
258: end if;
259:
260: INSERT INTO GL_BC_OPTIONS(
261: bc_option_id,
262: bc_option_name,
263: last_update_date,
264: last_updated_by,

Line 313: from gl_bc_options B

309: x_context
310: from dual
311: where not exists
312: ( select null
313: from gl_bc_options B
314: where B.bc_option_id = x_bc_option_id );
315:
316:
317: open bc_option_row;

Line 327: end gl_bc_options_pkg;

323: close bc_option_row;
324:
325: end insert_row;
326:
327: end gl_bc_options_pkg;