DBA Data[Home] [Help]

APPS.GCS_ELIM_RULES_PKG dependencies on GCS_ELIM_RULES_B

Line 26: FROM gcs_elim_rules_b cb

22: ) IS
23:
24: CURSOR elimrules_row IS
25: SELECT rowid
26: FROM gcs_elim_rules_b cb
27: WHERE cb.RULE_ID= insert_row.RULE_ID;
28: BEGIN
29: IF RULE_ID IS NULL THEN
30: raise no_data_found;

Line 33: INSERT INTO gcs_elim_rules_b

29: IF RULE_ID IS NULL THEN
30: raise no_data_found;
31: END IF;
32:
33: INSERT INTO gcs_elim_rules_b
34: (
35: RULE_ID,
36: SEEDED_RULE_FLAG,
37: TRANSACTION_TYPE_CODE,

Line 67: FROM gcs_elim_rules_b cb

63:
64: FROM dual
65: WHERE NOT EXISTS
66: (SELECT 1
67: FROM gcs_elim_rules_b cb
68: WHERE cb.RULE_ID= insert_row.RULE_ID);
69:
70: INSERT INTO gcs_elim_rules_tl
71: (

Line 136: UPDATE gcs_elim_rules_b cb

132: DESCRIPTION VARCHAR2
133: ) IS
134: BEGIN
135:
136: UPDATE gcs_elim_rules_b cb
137: SET
138: RULE_ID=update_row.RULE_ID,
139: SEEDED_RULE_FLAG=update_row.SEEDED_RULE_FLAG,
140: TRANSACTION_TYPE_CODE=update_row.TRANSACTION_TYPE_CODE,

Line 250: FROM gcs_elim_rules_b cb

246:
247: BEGIN
248: SELECT cb.last_updated_by, cb.last_update_date
249: INTO db_luby, db_ludate
250: FROM gcs_elim_rules_b cb
251: WHERE cb.RULE_ID = load_row.RULE_ID;
252:
253: -- Test for customization information
254: IF fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate,