APPS.GL_BC_RULES_PKG dependencies on GL_BC_OPTION_DETAILS

Line 19: (SELECT 1 FROM gl_bc_option_details

15: dummy NUMBER;
16: BEGIN
17: SELECT 1 INTO dummy FROM dual
18: WHERE NOT EXISTS
19: (SELECT 1 FROM gl_bc_option_details
20: WHERE bc_option_id = X_bc_option_id
21: AND je_source_name = X_je_source_name
22: AND je_category_name = X_je_category_name
23: AND ((X_rowid IS NULL) OR (rowid <> X_rowid)));

Line 59: CURSOR C IS SELECT rowid FROM gl_bc_option_details

55: X_attribute12 VARCHAR2 ,
56: X_attribute13 VARCHAR2 ,
57: X_attribute14 VARCHAR2 ,
58: X_attribute15 VARCHAR2 ) IS
59: CURSOR C IS SELECT rowid FROM gl_bc_option_details
60: WHERE bc_option_id = X_bc_option_id
61: AND je_source_name = X_je_source_name
62: AND je_category_name = X_je_category_name;
63: BEGIN

Line 64: INSERT INTO gl_bc_option_details(

60: WHERE bc_option_id = X_bc_option_id
61: AND je_source_name = X_je_source_name
62: AND je_category_name = X_je_category_name;
63: BEGIN
64: INSERT INTO gl_bc_option_details(
65: bc_option_id ,
66: last_update_date ,
67: last_updated_by ,
68: last_update_login ,

Line 160: UPDATE gl_bc_option_details

156: X_attribute13 VARCHAR2 ,
157: X_attribute14 VARCHAR2 ,
158: X_attribute15 VARCHAR2 ) IS
159: BEGIN
160: UPDATE gl_bc_option_details
161: SET
162: bc_option_id = X_bc_option_id ,
163: last_update_date = X_last_update_date ,
164: last_updated_by = X_last_updated_by ,

Line 222: FROM gl_bc_option_details

218: X_attribute14 VARCHAR2 ,
219: X_attribute15 VARCHAR2 ) IS
220: CURSOR C IS
221: SELECT *
222: FROM gl_bc_option_details
223: WHERE rowid = X_rowid
224: FOR UPDATE OF bc_option_id NOWAIT;
225: RecInfo C%ROWTYPE;
226: BEGIN

Line 317: DELETE FROM gl_bc_option_details

313:
314:
315: PROCEDURE delete_row(X_rowid VARCHAR2) IS
316: BEGIN
317: DELETE FROM gl_bc_option_details
318: WHERE rowid = X_rowid;
319:
320: IF (SQL%NOTFOUND) THEN
321: RAISE NO_DATA_FOUND;