eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.GCS_AD_TRIALBALANCE_PKG dependencies on GCS_AD_TRANSACTIONS

Line 123: -- select assoc_entry_id from gcs_ad_transactions table

119: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
120: );
121: END IF;
122:
123: -- select assoc_entry_id from gcs_ad_transactions table
124: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
125: THEN
126: fnd_log.STRING (fnd_log.level_statement,
127: g_pkg_name || '.' || l_api_name,

Line 132: || 'FROM fem_cal_periods_attr fcpa, gcs_ad_transactions gat'

128: 'SELECT gat.assoc_entry_id, gat.cal_period_id, fcpa.number_assign_value + 1 '
129: || g_nl
130: || 'INTO l_entry_id, l_cal_period_id, l_year_to_apply_re '
131: || g_nl
132: || 'FROM fem_cal_periods_attr fcpa, gcs_ad_transactions gat'
133: || g_nl
134: || ' WHERE fcpa.cal_period_id = gat.cal_period_id
135: AND fcpa.attribute_id = ' ||
136: gcs_utility_pkg.g_dimension_attr_info ('CAL_PERIOD_ID-ACCOUNTING_YEAR').attribute_id ||'

Line 146: FROM fem_cal_periods_attr fcpa, gcs_ad_transactions gat

142: END IF;
143:
144: SELECT gat.assoc_entry_id, gat.cal_period_id, fcpa.number_assign_value + 1
145: INTO l_entry_id, l_cal_period_id, l_year_to_apply_re
146: FROM fem_cal_periods_attr fcpa, gcs_ad_transactions gat
147: WHERE fcpa.cal_period_id = gat.cal_period_id
148: AND fcpa.attribute_id =
149: gcs_utility_pkg.g_dimension_attr_info ('CAL_PERIOD_ID-ACCOUNTING_YEAR').attribute_id
150: AND fcpa.version_id =

Line 199: 'UPDATE gcs_ad_transactions'

195: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
196: THEN
197: fnd_log.STRING (fnd_log.level_statement,
198: g_pkg_name || '.' || l_api_name,
199: 'UPDATE gcs_ad_transactions'
200: || g_nl
201: || 'SET ASSOC_ENTRY_ID = '
202: || l_entry_id
203: || ', total_consideration = '

Line 213: UPDATE gcs_ad_transactions

209: || p_xns_id
210: );
211: END IF;
212:
213: UPDATE gcs_ad_transactions
214: SET assoc_entry_id = l_entry_id,
215: total_consideration = p_consideration_amount,
216: last_update_date = sysdate
217: WHERE ad_transaction_id = p_xns_id;

Line 264: -- update total_consideration in gcs_ad_transactions table

260: WHERE entry_id = l_entry_id;
261: END;
262:
263: IF p_consideration_amount is not null THEN
264: -- update total_consideration in gcs_ad_transactions table
265: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
266: THEN
267: fnd_log.STRING (fnd_log.level_statement,
268: g_pkg_name || '.' || l_api_name,

Line 269: 'UPDATE gcs_ad_transactions'

265: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
266: THEN
267: fnd_log.STRING (fnd_log.level_statement,
268: g_pkg_name || '.' || l_api_name,
269: 'UPDATE gcs_ad_transactions'
270: || g_nl
271: || 'SET total_consideration = '
272: || p_consideration_amount
273: || g_nl

Line 281: UPDATE gcs_ad_transactions

277: || p_xns_id
278: );
279: END IF;
280:
281: UPDATE gcs_ad_transactions
282: SET total_consideration = p_consideration_amount,
283: last_update_date = sysdate
284: WHERE ad_transaction_id = p_xns_id;
285: END IF;

Line 360: 'UPDATE gcs_ad_transactions'

356: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
357: THEN
358: fnd_log.STRING (fnd_log.level_statement,
359: g_pkg_name || '.' || l_api_name,
360: 'UPDATE gcs_ad_transactions'
361: || g_nl
362: || 'SET ASSOC_ENTRY_ID = '
363: || l_entry_id
364: || ', total_consideration = '

Line 374: UPDATE gcs_ad_transactions

370: || p_xns_id
371: );
372: END IF;
373:
374: UPDATE gcs_ad_transactions
375: SET assoc_entry_id = l_entry_id,
376: total_consideration = p_consideration_amount,
377: last_update_date = sysdate
378: WHERE ad_transaction_id = p_xns_id;

Line 542: 'select assoc_entry_id into l_orig_entry_id from gcs_ad_transactions

538: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
539: THEN
540: fnd_log.STRING (fnd_log.level_statement,
541: g_pkg_name || '.' || l_api_name,
542: 'select assoc_entry_id into l_orig_entry_id from gcs_ad_transactions
543: where ad_transaction_id = '
544: || p_xns_id
545: );
546: END IF;

Line 550: from gcs_ad_transactions

546: END IF;
547:
548: select assoc_entry_id
549: into l_orig_entry_id
550: from gcs_ad_transactions
551: where ad_transaction_id = p_xns_id;
552:
553: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
554: THEN

Line 688: 'update gcs_ad_transactions'

684: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
685: THEN
686: fnd_log.STRING (fnd_log.level_statement,
687: g_pkg_name || '.' || l_api_name,
688: 'update gcs_ad_transactions'
689: || g_nl
690: || 'set request_id = '
691: || fnd_global.conc_request_id
692: || g_nl

Line 698: UPDATE gcs_ad_transactions

694: || g_nl
695: || 'where ad_transaction_id = ' || p_xns_id
696: );
697: END IF;
698: UPDATE gcs_ad_transactions
699: SET request_id = fnd_global.conc_request_id,
700: last_update_date = sysdate
701: WHERE ad_transaction_id = p_xns_id;
702: /*

Line 899: from gcs_ad_transactions

895: END IF;
896:
897: select assoc_entry_id
898: into l_orig_entry_id
899: from gcs_ad_transactions
900: where ad_transaction_id = p_xns_id;
901:
902: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
903: THEN

Line 1178: FROM gcs_ad_transactions xns, gcs_cons_eng_run_dtls gcerd

1174: )
1175: IS
1176: cursor undo_c is
1177: SELECT decode(NVL(gcerd.run_detail_id, 0), 0, 'N', 'Y'), xns.assoc_entry_id
1178: FROM gcs_ad_transactions xns, gcs_cons_eng_run_dtls gcerd
1179: WHERE xns.ad_transaction_id = p_xns_id
1180: and gcerd.entry_id (+) = xns.assoc_entry_id;
1181:
1182: l_processed_flag VARCHAR2 (1);

Line 1220: 'UPDATE gcs_ad_transactions set assoc_entry_id = null, request_id = null WHERE ad_transaction_id = '

1216: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1217: THEN
1218: fnd_log.STRING (fnd_log.level_statement,
1219: g_pkg_name || '.' || l_api_name,
1220: 'UPDATE gcs_ad_transactions set assoc_entry_id = null, request_id = null WHERE ad_transaction_id = '
1221: || p_xns_id
1222: );
1223: END IF;
1224: update gcs_ad_transactions set assoc_entry_id = null, request_id = null where ad_transaction_id = p_xns_id;

Line 1224: update gcs_ad_transactions set assoc_entry_id = null, request_id = null where ad_transaction_id = p_xns_id;

1220: 'UPDATE gcs_ad_transactions set assoc_entry_id = null, request_id = null WHERE ad_transaction_id = '
1221: || p_xns_id
1222: );
1223: END IF;
1224: update gcs_ad_transactions set assoc_entry_id = null, request_id = null where ad_transaction_id = p_xns_id;
1225:
1226: begin
1227: wf_event.addparametertolist (p_name => 'CHANGE_TYPE_CODE',
1228: p_value => 'ACQDISP_UNDONE',

Line 1267: 'UPDATE gcs_ad_transactions set assoc_entry_id = null, request_id = null WHERE ad_transaction_id = '

1263: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1264: THEN
1265: fnd_log.STRING (fnd_log.level_statement,
1266: g_pkg_name || '.' || l_api_name,
1267: 'UPDATE gcs_ad_transactions set assoc_entry_id = null, request_id = null WHERE ad_transaction_id = '
1268: || p_xns_id
1269: );
1270: END IF;
1271: update gcs_ad_transactions set assoc_entry_id = null, request_id = null where ad_transaction_id = p_xns_id;

Line 1271: update gcs_ad_transactions set assoc_entry_id = null, request_id = null where ad_transaction_id = p_xns_id;

1267: 'UPDATE gcs_ad_transactions set assoc_entry_id = null, request_id = null WHERE ad_transaction_id = '
1268: || p_xns_id
1269: );
1270: END IF;
1271: update gcs_ad_transactions set assoc_entry_id = null, request_id = null where ad_transaction_id = p_xns_id;
1272: ELSE
1273: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1274: THEN
1275: fnd_log.STRING (fnd_log.level_statement,

Line 1277: 'UPDATE gcs_ad_transactions set request_id = null WHERE ad_transaction_id = '

1273: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1274: THEN
1275: fnd_log.STRING (fnd_log.level_statement,
1276: g_pkg_name || '.' || l_api_name,
1277: 'UPDATE gcs_ad_transactions set request_id = null WHERE ad_transaction_id = '
1278: || p_xns_id
1279: );
1280: END IF;
1281: update gcs_ad_transactions set request_id = null where ad_transaction_id = p_xns_id;

Line 1281: update gcs_ad_transactions set request_id = null where ad_transaction_id = p_xns_id;

1277: 'UPDATE gcs_ad_transactions set request_id = null WHERE ad_transaction_id = '
1278: || p_xns_id
1279: );
1280: END IF;
1281: update gcs_ad_transactions set request_id = null where ad_transaction_id = p_xns_id;
1282: end if;
1283:
1284: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1285: THEN