APPS.GCS_WEBADI_PKG dependencies on GCS_DATA_SUB_DTLS

Line 102: gcs_data_sub_dtls

98:
99: -- Delete the row created by Data Submission OA UI
100: -- Bugfix 5736334: Added nvl for curreny_code as it can be null for transactional currency.
101: DELETE FROM
102: gcs_data_sub_dtls
103: WHERE
104: entity_id = p_entity_name
105: AND to_char(cal_period_id) = p_period
106: AND balance_type_code = p_balance_type

Line 111: FROM gcs_data_sub_dtls check_exists

107: AND currency_type_code = p_currency_type
108: AND nvl(currency_code, 'NULL') = nvl(p_currency_code,'NULL')
109: AND most_recent_flag = 'X'
110: AND EXISTS (SELECT 'X'
111: FROM gcs_data_sub_dtls check_exists
112: WHERE check_exists.entity_id = p_entity_name
113: AND to_char(check_exists.cal_period_id) = p_period
114: AND check_exists.balance_type_code = p_balance_type
115: AND check_exists.currency_type_code = p_currency_type

Line 121: INSERT INTO gcs_data_sub_dtls

117: AND check_exists. most_recent_flag = 'X' );
118:
119: -- Always create a new row with the Header data.
120:
121: INSERT INTO gcs_data_sub_dtls
122: ( load_id,
123: load_name,
124: entity_id,
125: cal_period_id,