APPS.GCS_ELIM_RULE_STEPS_PKG dependencies on GCS_ELIM_RULE_STEPS_B

Line 26: FROM gcs_elim_rule_steps_b cb

22: IS
23:
24: CURSOR elimrulesteps_row IS
25: SELECT rowid
26: FROM gcs_elim_rule_steps_b cb
27: WHERE cb.RULE_STEP_ID= insert_row.RULE_STEP_ID;
28: BEGIN
29: IF RULE_STEP_ID IS NULL THEN
30: raise no_data_found;

Line 33: INSERT INTO gcs_elim_rule_steps_b

29: IF RULE_STEP_ID IS NULL THEN
30: raise no_data_found;
31: END IF;
32:
33: INSERT INTO gcs_elim_rule_steps_b
34: (
35: RULE_ID,
36: RULE_STEP_ID,
37: STEP_SEQ,

Line 67: FROM gcs_elim_rule_steps_b cb

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

Line 133: UPDATE gcs_elim_rule_steps_b cb

129: STEP_NAME VARCHAR2
130: ) IS
131: BEGIN
132:
133: UPDATE gcs_elim_rule_steps_b cb
134: SET
135: RULE_ID=update_row.RULE_ID,
136: RULE_STEP_ID = update_row.RULE_STEP_ID,
137: STEP_SEQ = update_row.STEP_SEQ,