APPS.GCS_INTERCO_RULES_PKG dependencies on GCS_INTERCO_RULES_B

Line 41: FROM gcs_interco_rules_b cb

37: ) IS
38:
39: CURSOR intercorules_row IS
40: SELECT rowid
41: FROM gcs_interco_rules_b cb
42: WHERE cb.RULE_ID= insert_row.RULE_ID;
43: BEGIN
44: IF RULE_ID IS NULL THEN
45: raise no_data_found;

Line 48: INSERT INTO gcs_interco_rules_b

44: IF RULE_ID IS NULL THEN
45: raise no_data_found;
46: END IF;
47:
48: INSERT INTO gcs_interco_rules_b
49: (
50: RULE_ID,
51: ENABLED_FLAG,
52: THRESHOLD_AMOUNT,

Line 112: FROM gcs_interco_rules_b cb

108:
109: FROM dual
110: WHERE NOT EXISTS
111: (SELECT 1
112: FROM gcs_interco_rules_b cb
113: WHERE cb.RULE_ID= insert_row.RULE_ID);
114:
115: INSERT INTO gcs_interco_rules_tl
116: (

Line 198: UPDATE gcs_interco_rules_b cb

194: DESCRIPTION varchar2
195: ) IS
196: BEGIN
197:
198: UPDATE gcs_interco_rules_b cb
199: SET
200:
201: ENABLED_FLAG =update_row.ENABLED_FLAG,
202: THRESHOLD_AMOUNT =update_row.THRESHOLD_AMOUNT,

Line 344: FROM gcs_interco_rules_b cb

340:
341: BEGIN
342: SELECT cb.last_updated_by, cb.last_update_date
343: INTO db_luby, db_ludate
344: FROM gcs_interco_rules_b cb
345: WHERE cb.RULE_ID = load_row.RULE_ID;
346:
347: -- Test for customization information
348: IF fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate,