APPS.GCS_DATASUB_WF_PKG dependencies on GCS_BAL_INTERFACE_T

Line 291: 'The transfer of data from GCS_BAL_INTERFACE_T to FEM_BAL_INTERFACE_T failed. Please review the information in FND_LOG_MESSAGES for more details.');

287: fnd_file.put_line(fnd_file.log,
288: 'The index defined on FEM_BAL_INTERFACE_T does not contain all columns that are part of the processing key. Please review the index definition.');
289: ELSIF (l_status_code = 'TRANSFER_ERROR') THEN
290: fnd_file.put_line(fnd_file.log,
291: 'The transfer of data from GCS_BAL_INTERFACE_T to FEM_BAL_INTERFACE_T failed. Please review the information in FND_LOG_MESSAGES for more details.');
292: ELSE
293: fnd_file.put_line(fnd_file.log, 'Transformation on data failed.');
294: END IF;
295: fnd_file.put_line(fnd_file.log, '<<<<< End of Error >>>>>');

Line 1055: UPDATE gcs_bal_interface_t

1051: '<>');
1052: END IF;
1053:
1054: IF (l_currency_type_code = 'TRANSLATED') THEN
1055: UPDATE gcs_bal_interface_t
1056: SET ytd_debit_balance_e = DECODE(l_datasub_info.measure_type_code,
1057: 'BALANCE',
1058: DECODE(SIGN(ytd_balance_e),
1059: 1,

Line 1110: UPDATE gcs_bal_interface_t

1106: l_datasub_info.currency_code)
1107: WHERE load_id = l_datasub_info.load_id;
1108:
1109: ELSIF (l_datasub_info.currency_type_code = 'BASE_CURRENCY') THEN
1110: UPDATE gcs_bal_interface_t
1111: SET ytd_debit_balance_e = DECODE(l_datasub_info.measure_type_code,
1112: 'BALANCE',
1113: DECODE(SIGN(ytd_balance_e),
1114: 1,

Line 1194: UPDATE gcs_bal_interface_t

1190: l_datasub_info.currency_code)
1191: WHERE load_id = l_datasub_info.load_id;
1192:
1193: ELSE
1194: UPDATE gcs_bal_interface_t
1195: SET ytd_debit_balance_e = DECODE(l_datasub_info.measure_type_code,
1196: 'BALANCE',
1197: DECODE(SIGN(ytd_balance_e),
1198: 1,

Line 1437: FROM gcs_bal_interface_t gbit,

1433: NVL(gbit.ptd_credit_balance_e, 0)),
1434: --Bugfix 5066041: Added additional columns to support new data types
1435: p_budget_display_code,
1436: p_encumbrance_type_code
1437: FROM gcs_bal_interface_t gbit,
1438: fem_ln_items_b flb,
1439: fem_ln_items_attr flia,
1440: fem_ext_acct_types_attr feata
1441: WHERE gbit.load_id = p_load_id

Line 1538: p_staging_table_name => 'GCS_BAL_INTERFACE_T',

1534: x_return_status => p_return_status,
1535: x_msg_count => l_msg_count,
1536: x_msg_data => l_msg_data,
1537: p_rule_set_id => p_set_id,
1538: p_staging_table_name => 'GCS_BAL_INTERFACE_T',
1539: p_debug_mode => NULL,
1540: p_filter_column_name1 => 'LOAD_ID',
1541: p_filter_column_value1 => p_load_id);
1542:

Line 1553: p_staging_table_name => 'GCS_BAL_INTERFACE_T',

1549: x_return_status => p_return_status,
1550: x_msg_count => l_msg_count,
1551: x_msg_data => l_msg_data,
1552: p_rule_set_id => p_set_id,
1553: p_staging_table_name => 'GCS_BAL_INTERFACE_T',
1554: p_debug_mode => NULL,
1555: p_filter_column_name1 => 'LOAD_ID',
1556: p_filter_column_value1 => p_load_id);
1557:

Line 2139: UPDATE gcs_bal_interface_t

2135:
2136: IF (l_status_code <> 'C') THEN
2137: IF (l_status_code = 'E') THEN
2138: -- Update the entire set of rows with the same error message
2139: UPDATE gcs_bal_interface_t
2140: SET error_message_code = 'Please refer to concurrent request : ' ||
2141: FND_GLOBAL.conc_request_id ||
2142: ' for more details.'
2143: WHERE load_id = l_datasub_info.load_id;

Line 2146: UPDATE gcs_bal_interface_t

2142: ' for more details.'
2143: WHERE load_id = l_datasub_info.load_id;
2144: ELSE
2145: -- Update the rows to check FEM_BAL_INTERFACE_T for remaining issues
2146: UPDATE gcs_bal_interface_t
2147: SET error_message_code = 'Please refer to FEM_BAL_INTERFACE_T to see if any rows failed.'
2148: WHERE load_id = l_datasub_info.load_id;
2149: END IF;
2150: END IF;

Line 2252: FROM gcs_bal_interface_t

2248: gcs_datasub_utility_pkg.validate_dimension_members(p_load_id => l_datasub_info.load_id);
2249:
2250: SELECT error_message_code BULK COLLECT
2251: INTO l_msg_info
2252: FROM gcs_bal_interface_t
2253: WHERE load_id = l_datasub_info.load_id;
2254:
2255: p_result := 'COMPLETE:T';
2256: