APPS.GCS_AD_TRIALBALANCE_PKG dependencies on GCS_AD_TRIAL_BALANCES

Line 912: from gcs_ad_trial_balances

908: END IF;
909:
910: select decode(count(ad_transaction_id), 0, 'ACTUAL', 'ADB')
911: into l_balance_type_code
912: from gcs_ad_trial_balances
913: where ad_transaction_id = -1
914: and financial_elem_id = 140;
915:
916: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

Line 963: 'DELETE FROM GCS_AD_TRIAL_BALANCES'

959: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
960: THEN
961: fnd_log.STRING (fnd_log.level_statement,
962: g_pkg_name || '.' || l_api_name,
963: 'DELETE FROM GCS_AD_TRIAL_BALANCES'
964: || g_nl
965: || 'WHERE AD_TRANSACTION_ID = '
966: || p_xns_id
967: );

Line 970: DELETE FROM gcs_ad_trial_balances

966: || p_xns_id
967: );
968: END IF;
969:
970: DELETE FROM gcs_ad_trial_balances
971: WHERE ad_transaction_id = p_xns_id;
972:
973: -- Update the new load
974: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

Line 978: 'UPDATE GCS_AD_TRIAL_BALANCES'

974: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
975: THEN
976: fnd_log.STRING (fnd_log.level_statement,
977: g_pkg_name || '.' || l_api_name,
978: 'UPDATE GCS_AD_TRIAL_BALANCES'
979: || g_nl
980: || 'SET ad_transaction_id = '
981: || p_xns_id
982: || ', last_update_date = sysdate'

Line 988: UPDATE gcs_ad_trial_balances

984: || 'WHERE AD_TRANSACTION_ID = -1'
985: );
986: END IF;
987:
988: UPDATE gcs_ad_trial_balances
989: SET ad_transaction_id = p_xns_id,
990: last_update_date = sysdate
991: WHERE ad_transaction_id = -1;
992: /*