APPS.GCS_TREATMENTS_PKG dependencies on GCS_TREATMENTS_B

Line 28: FROM gcs_treatments_b cb

24: ) IS
25:
26: CURSOR treatment_row IS
27: SELECT rowid
28: FROM gcs_treatments_b cb
29: WHERE cb.TREATMENT_ID= insert_row.TREATMENT_ID;
30: BEGIN
31: IF TREATMENT_ID IS NULL THEN
32: raise no_data_found;

Line 35: INSERT INTO gcs_treatments_b

31: IF TREATMENT_ID IS NULL THEN
32: raise no_data_found;
33: END IF;
34:
35: INSERT INTO gcs_treatments_b
36: (
37: TREATMENT_ID,
38: CONSOLIDATION_TYPE_CODE,
39: ENABLED_FLAG,

Line 69: FROM gcs_treatments_b cb

65:
66: FROM dual
67: WHERE NOT EXISTS
68: (SELECT 1
69: FROM gcs_treatments_b cb
70: WHERE cb.TREATMENT_ID= insert_row.TREATMENT_ID);
71:
72: INSERT INTO gcs_treatments_TL
73: (

Line 138: UPDATE gcs_treatments_b cb

134: TREATMENT_NAME VARCHAR2
135: ) IS
136: BEGIN
137:
138: UPDATE gcs_treatments_b cb
139: SET
140: TREATMENT_ID=update_row.TREATMENT_ID,
141: CONSOLIDATION_TYPE_CODE=update_row.CONSOLIDATION_TYPE_CODE,
142: ENABLED_FLAG=update_row.ENABLED_FLAG,

Line 249: FROM GCS_TREATMENTS_B cb

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