APPS.GCS_DATA_TYPE_CODES_PKG dependencies on GCS_DATA_TYPE_CODES_B

Line 8: -- Inserts a row into the gcs_data_type_codes_b table.

4: --
5: -- Procedure
6: -- Insert_Row
7: -- Purpose
8: -- Inserts a row into the gcs_data_type_codes_b table.
9: -- Arguments
10: -- row_id
11: -- data_type_id
12: -- data_type_code

Line 46: FROM GCS_DATA_TYPE_CODES_B cb

42: last_update_login NUMBER,
43: object_version_number NUMBER) IS
44: CURSOR datatypes_row IS
45: SELECT rowid
46: FROM GCS_DATA_TYPE_CODES_B cb
47: WHERE cb.data_type_id = insert_row.data_type_id;
48:
49: BEGIN
50: IF data_type_id IS NULL THEN

Line 54: INSERT INTO GCS_DATA_TYPE_CODES_B

50: IF data_type_id IS NULL THEN
51: raise no_data_found;
52: END IF;
53:
54: INSERT INTO GCS_DATA_TYPE_CODES_B
55: (data_type_id,
56: data_type_code,
57: enforce_balancing_flag,
58: apply_elim_rules_flag,

Line 82: FROM GCS_DATA_TYPE_CODES_b cb

78: insert_row.object_version_number
79: FROM dual
80: WHERE NOT EXISTS
81: (SELECT 1
82: FROM GCS_DATA_TYPE_CODES_b cb
83: WHERE cb.data_type_id = insert_row.data_type_id);
84:
85: -- Bugfix 5155519 : Inserted rows for the other installed languages on the env.
86: INSERT INTO GCS_DATA_TYPE_CODES_tl

Line 131: -- Updates a row in the gcs_data_type_codes_b table.

127: --
128: -- Procedure
129: -- Update_Row
130: -- Purpose
131: -- Updates a row in the gcs_data_type_codes_b table.
132: -- Arguments
133: -- row_id
134: -- data_type_code
135: -- enforce_balancing_flag

Line 167: UPDATE GCS_DATA_TYPE_CODES_b cb

163: last_updated_by NUMBER,
164: last_update_login NUMBER,
165: object_version_number NUMBER) IS
166: BEGIN
167: UPDATE GCS_DATA_TYPE_CODES_b cb
168: SET data_type_id = update_row.data_type_id,
169: data_type_code = update_row.data_type_code,
170: enforce_balancing_flag = update_row.enforce_balancing_flag,
171: apply_elim_rules_flag = update_row.apply_elim_rules_flag,

Line 233: -- Loads a row into the gcs_data_type_codes_b table.

229: --
230: -- Procedure
231: -- Load_Row
232: -- Purpose
233: -- Loads a row into the gcs_data_type_codes_b table.
234: -- Arguments
235: -- data_type_code
236: -- owner
237: -- last_update_date

Line 292: FROM GCS_DATA_TYPE_CODES_B cb

288: */
289:
290: SELECT cb.last_updated_by, cb.last_update_date
291: INTO db_luby, db_ludate
292: FROM GCS_DATA_TYPE_CODES_B cb
293: WHERE cb.data_type_id = load_row.data_type_id;
294:
295: -- Test for customization information
296: IF fnd_load_util.upload_test(f_luby,

Line 459: FROM gcs_data_type_codes_b;

455: apply_elim_rules_flag,
456: apply_cons_rules_flag,
457: source_dataset_code BULK COLLECT
458: INTO g_datatype_info
459: FROM gcs_data_type_codes_b;
460:
461: END GCS_DATA_TYPE_CODES_PKG;