APPS.GCS_AD_ENGINE dependencies on GCS_AD_TRANSACTIONS

Line 72: FROM GCS_AD_TRANSACTIONS

68: --xnsCursor:
69: --Select the transaction control record(s)
70: cursor xnsCursor is
71: SELECT *
72: FROM GCS_AD_TRANSACTIONS
73: WHERE ad_transaction_id = xnsId;
74:
75:
76: --linesCursor:

Line 306: Update gcs_ad_transactions

302: Fetch xnsCursor Into xnsData;
303: Close xnsCursor;
304:
305: -- Place the request_id onto the header row and commit
306: Update gcs_ad_transactions
307: Set request_id = requestId
308: Where ad_transaction_id = xnsId;
309: If SQL%ROWCOUNT = 1 Then COMMIT;
310: Else RAISE invalid_arguments;

Line 647: FROM gcs_ad_transactions

643: --Bugfix 4226223 : Populate the line_type_code on gcs_entry_lines
644: BEGIN
645: SELECT assoc_entry_id
646: INTO l_entry_id
647: FROM gcs_ad_transactions
648: WHERE ad_transaction_id = p_transaction_id;
649:
650: -- Bugfix 6469074: Remove call to update the line_type_code
651: /*