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.

APPS.AP_AUTO_PAYMENT_PKG dependencies on AP_CHECKS

Line 111: FROM ap_checks AC

107: , AC.global_attribute19
108: , AC.global_attribute20
109: , AC.global_attribute_category
110: , AC.org_id /* Bug 4759178. Added org_id */
111: FROM ap_checks AC
112: , ap_invoice_payments AIP
113: , ap_payment_schedules APS
114: , ap_system_parameters ASP
115: WHERE AC.check_id = P_Old_Check_Id

Line 125: l_doc_sequence_id ap_checks.doc_sequence_id%TYPE;

121: rec_new_payments c_new_payments%ROWTYPE;
122: l_debug_info VARCHAR2(240);
123: l_curr_calling_sequence VARCHAR2(2000);
124: l_doc_sequence_name fnd_document_sequences.name%TYPE;
125: l_doc_sequence_id ap_checks.doc_sequence_id%TYPE;
126: l_doc_sequence_value ap_checks.doc_sequence_value%TYPE;
127: l_doc_category_code ap_checks.doc_category_code%TYPE;
128: l_set_of_books_id ap_system_parameters.set_of_books_id%TYPE;
129: l_awt_success VARCHAR2(2000);

Line 126: l_doc_sequence_value ap_checks.doc_sequence_value%TYPE;

122: l_debug_info VARCHAR2(240);
123: l_curr_calling_sequence VARCHAR2(2000);
124: l_doc_sequence_name fnd_document_sequences.name%TYPE;
125: l_doc_sequence_id ap_checks.doc_sequence_id%TYPE;
126: l_doc_sequence_value ap_checks.doc_sequence_value%TYPE;
127: l_doc_category_code ap_checks.doc_category_code%TYPE;
128: l_set_of_books_id ap_system_parameters.set_of_books_id%TYPE;
129: l_awt_success VARCHAR2(2000);
130: l_awt_gross_amount NUMBER;

Line 127: l_doc_category_code ap_checks.doc_category_code%TYPE;

123: l_curr_calling_sequence VARCHAR2(2000);
124: l_doc_sequence_name fnd_document_sequences.name%TYPE;
125: l_doc_sequence_id ap_checks.doc_sequence_id%TYPE;
126: l_doc_sequence_value ap_checks.doc_sequence_value%TYPE;
127: l_doc_category_code ap_checks.doc_category_code%TYPE;
128: l_set_of_books_id ap_system_parameters.set_of_books_id%TYPE;
129: l_awt_success VARCHAR2(2000);
130: l_awt_gross_amount NUMBER;
131: l_accounting_event_id NUMBER; --Events Project 1

Line 134: l_payment_type_flag AP_CHECKS.payment_type_flag%TYPE; -- Bug3343314

130: l_awt_gross_amount NUMBER;
131: l_accounting_event_id NUMBER; --Events Project 1
132: l_prev_withheld_amt NUMBER; --bug3309344
133: l_prev_amt_paid NUMBER; --bug3309344
134: l_payment_type_flag AP_CHECKS.payment_type_flag%TYPE; -- Bug3343314
135: l_amount AP_CHECKS.amount%TYPE; -- Bug3343314
136: l_currency_code AP_CHECKS.currency_code%TYPE; -- Bug3343314
137: l_exchange_rate_type AP_CHECKS.exchange_rate_type%TYPE; -- Bug3343314
138: l_exchange_date AP_CHECKS.exchange_date%TYPE; -- Bug3343314

Line 135: l_amount AP_CHECKS.amount%TYPE; -- Bug3343314

131: l_accounting_event_id NUMBER; --Events Project 1
132: l_prev_withheld_amt NUMBER; --bug3309344
133: l_prev_amt_paid NUMBER; --bug3309344
134: l_payment_type_flag AP_CHECKS.payment_type_flag%TYPE; -- Bug3343314
135: l_amount AP_CHECKS.amount%TYPE; -- Bug3343314
136: l_currency_code AP_CHECKS.currency_code%TYPE; -- Bug3343314
137: l_exchange_rate_type AP_CHECKS.exchange_rate_type%TYPE; -- Bug3343314
138: l_exchange_date AP_CHECKS.exchange_date%TYPE; -- Bug3343314
139: l_exchange_rate AP_CHECKS.exchange_rate%TYPE; -- Bug3343314

Line 136: l_currency_code AP_CHECKS.currency_code%TYPE; -- Bug3343314

132: l_prev_withheld_amt NUMBER; --bug3309344
133: l_prev_amt_paid NUMBER; --bug3309344
134: l_payment_type_flag AP_CHECKS.payment_type_flag%TYPE; -- Bug3343314
135: l_amount AP_CHECKS.amount%TYPE; -- Bug3343314
136: l_currency_code AP_CHECKS.currency_code%TYPE; -- Bug3343314
137: l_exchange_rate_type AP_CHECKS.exchange_rate_type%TYPE; -- Bug3343314
138: l_exchange_date AP_CHECKS.exchange_date%TYPE; -- Bug3343314
139: l_exchange_rate AP_CHECKS.exchange_rate%TYPE; -- Bug3343314
140: l_base_amount AP_CHECKS.exchange_rate%TYPE; -- Bug3343314

Line 137: l_exchange_rate_type AP_CHECKS.exchange_rate_type%TYPE; -- Bug3343314

133: l_prev_amt_paid NUMBER; --bug3309344
134: l_payment_type_flag AP_CHECKS.payment_type_flag%TYPE; -- Bug3343314
135: l_amount AP_CHECKS.amount%TYPE; -- Bug3343314
136: l_currency_code AP_CHECKS.currency_code%TYPE; -- Bug3343314
137: l_exchange_rate_type AP_CHECKS.exchange_rate_type%TYPE; -- Bug3343314
138: l_exchange_date AP_CHECKS.exchange_date%TYPE; -- Bug3343314
139: l_exchange_rate AP_CHECKS.exchange_rate%TYPE; -- Bug3343314
140: l_base_amount AP_CHECKS.exchange_rate%TYPE; -- Bug3343314
141: l_creation_date AP_CHECKS.creation_date%TYPE; -- Bug3343314

Line 138: l_exchange_date AP_CHECKS.exchange_date%TYPE; -- Bug3343314

134: l_payment_type_flag AP_CHECKS.payment_type_flag%TYPE; -- Bug3343314
135: l_amount AP_CHECKS.amount%TYPE; -- Bug3343314
136: l_currency_code AP_CHECKS.currency_code%TYPE; -- Bug3343314
137: l_exchange_rate_type AP_CHECKS.exchange_rate_type%TYPE; -- Bug3343314
138: l_exchange_date AP_CHECKS.exchange_date%TYPE; -- Bug3343314
139: l_exchange_rate AP_CHECKS.exchange_rate%TYPE; -- Bug3343314
140: l_base_amount AP_CHECKS.exchange_rate%TYPE; -- Bug3343314
141: l_creation_date AP_CHECKS.creation_date%TYPE; -- Bug3343314
142: l_created_by AP_CHECKS.created_by%TYPE; -- Bug3343314

Line 139: l_exchange_rate AP_CHECKS.exchange_rate%TYPE; -- Bug3343314

135: l_amount AP_CHECKS.amount%TYPE; -- Bug3343314
136: l_currency_code AP_CHECKS.currency_code%TYPE; -- Bug3343314
137: l_exchange_rate_type AP_CHECKS.exchange_rate_type%TYPE; -- Bug3343314
138: l_exchange_date AP_CHECKS.exchange_date%TYPE; -- Bug3343314
139: l_exchange_rate AP_CHECKS.exchange_rate%TYPE; -- Bug3343314
140: l_base_amount AP_CHECKS.exchange_rate%TYPE; -- Bug3343314
141: l_creation_date AP_CHECKS.creation_date%TYPE; -- Bug3343314
142: l_created_by AP_CHECKS.created_by%TYPE; -- Bug3343314
143: l_last_update_date AP_CHECKS.last_update_date%TYPE; -- Bug3343314

Line 140: l_base_amount AP_CHECKS.exchange_rate%TYPE; -- Bug3343314

136: l_currency_code AP_CHECKS.currency_code%TYPE; -- Bug3343314
137: l_exchange_rate_type AP_CHECKS.exchange_rate_type%TYPE; -- Bug3343314
138: l_exchange_date AP_CHECKS.exchange_date%TYPE; -- Bug3343314
139: l_exchange_rate AP_CHECKS.exchange_rate%TYPE; -- Bug3343314
140: l_base_amount AP_CHECKS.exchange_rate%TYPE; -- Bug3343314
141: l_creation_date AP_CHECKS.creation_date%TYPE; -- Bug3343314
142: l_created_by AP_CHECKS.created_by%TYPE; -- Bug3343314
143: l_last_update_date AP_CHECKS.last_update_date%TYPE; -- Bug3343314
144: l_last_updated_by AP_CHECKS.last_updated_by%TYPE; -- Bug3343314

Line 141: l_creation_date AP_CHECKS.creation_date%TYPE; -- Bug3343314

137: l_exchange_rate_type AP_CHECKS.exchange_rate_type%TYPE; -- Bug3343314
138: l_exchange_date AP_CHECKS.exchange_date%TYPE; -- Bug3343314
139: l_exchange_rate AP_CHECKS.exchange_rate%TYPE; -- Bug3343314
140: l_base_amount AP_CHECKS.exchange_rate%TYPE; -- Bug3343314
141: l_creation_date AP_CHECKS.creation_date%TYPE; -- Bug3343314
142: l_created_by AP_CHECKS.created_by%TYPE; -- Bug3343314
143: l_last_update_date AP_CHECKS.last_update_date%TYPE; -- Bug3343314
144: l_last_updated_by AP_CHECKS.last_updated_by%TYPE; -- Bug3343314
145: l_last_update_login AP_CHECKS.last_update_login%TYPE; -- Bug3343314

Line 142: l_created_by AP_CHECKS.created_by%TYPE; -- Bug3343314

138: l_exchange_date AP_CHECKS.exchange_date%TYPE; -- Bug3343314
139: l_exchange_rate AP_CHECKS.exchange_rate%TYPE; -- Bug3343314
140: l_base_amount AP_CHECKS.exchange_rate%TYPE; -- Bug3343314
141: l_creation_date AP_CHECKS.creation_date%TYPE; -- Bug3343314
142: l_created_by AP_CHECKS.created_by%TYPE; -- Bug3343314
143: l_last_update_date AP_CHECKS.last_update_date%TYPE; -- Bug3343314
144: l_last_updated_by AP_CHECKS.last_updated_by%TYPE; -- Bug3343314
145: l_last_update_login AP_CHECKS.last_update_login%TYPE; -- Bug3343314
146: l_org_id NUMBER;

Line 143: l_last_update_date AP_CHECKS.last_update_date%TYPE; -- Bug3343314

139: l_exchange_rate AP_CHECKS.exchange_rate%TYPE; -- Bug3343314
140: l_base_amount AP_CHECKS.exchange_rate%TYPE; -- Bug3343314
141: l_creation_date AP_CHECKS.creation_date%TYPE; -- Bug3343314
142: l_created_by AP_CHECKS.created_by%TYPE; -- Bug3343314
143: l_last_update_date AP_CHECKS.last_update_date%TYPE; -- Bug3343314
144: l_last_updated_by AP_CHECKS.last_updated_by%TYPE; -- Bug3343314
145: l_last_update_login AP_CHECKS.last_update_login%TYPE; -- Bug3343314
146: l_org_id NUMBER;
147: l_transaction_type AP_PAYMENT_HISTORY_ALL.transaction_type%TYPE;

Line 144: l_last_updated_by AP_CHECKS.last_updated_by%TYPE; -- Bug3343314

140: l_base_amount AP_CHECKS.exchange_rate%TYPE; -- Bug3343314
141: l_creation_date AP_CHECKS.creation_date%TYPE; -- Bug3343314
142: l_created_by AP_CHECKS.created_by%TYPE; -- Bug3343314
143: l_last_update_date AP_CHECKS.last_update_date%TYPE; -- Bug3343314
144: l_last_updated_by AP_CHECKS.last_updated_by%TYPE; -- Bug3343314
145: l_last_update_login AP_CHECKS.last_update_login%TYPE; -- Bug3343314
146: l_org_id NUMBER;
147: l_transaction_type AP_PAYMENT_HISTORY_ALL.transaction_type%TYPE;
148:

Line 145: l_last_update_login AP_CHECKS.last_update_login%TYPE; -- Bug3343314

141: l_creation_date AP_CHECKS.creation_date%TYPE; -- Bug3343314
142: l_created_by AP_CHECKS.created_by%TYPE; -- Bug3343314
143: l_last_update_date AP_CHECKS.last_update_date%TYPE; -- Bug3343314
144: l_last_updated_by AP_CHECKS.last_updated_by%TYPE; -- Bug3343314
145: l_last_update_login AP_CHECKS.last_update_login%TYPE; -- Bug3343314
146: l_org_id NUMBER;
147: l_transaction_type AP_PAYMENT_HISTORY_ALL.transaction_type%TYPE;
148:
149: --bug14308871, added below three variables

Line 174: FROM ap_checks ac, ap_invoice_payments aip

170:
171:
172: SELECT ac.doc_category_code, aip.set_of_books_id
173: INTO l_doc_category_code, l_set_of_books_id
174: FROM ap_checks ac, ap_invoice_payments aip
175: WHERE AC.check_id = P_old_check_id
176: AND AC.check_id = AIP.check_id
177: AND AC.doc_sequence_value IS NOT NULL
178: AND rownum = 1;

Line 206: SELECT ap_checks_s.nextval

202: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'AP_AUTO_PAYMENT_PKG',l_debug_info);
203: END IF;
204:
205:
206: SELECT ap_checks_s.nextval
207: INTO P_Replace_Check_Id
208: FROM dual;
209:
210: -------------------------------------------------------------------

Line 211: l_debug_info := 'Insert into ap_checks for replace_check_id';

207: INTO P_Replace_Check_Id
208: FROM dual;
209:
210: -------------------------------------------------------------------
211: l_debug_info := 'Insert into ap_checks for replace_check_id';
212: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
213: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'AP_AUTO_PAYMENT_PKG',l_debug_info);
214: END IF;
215:

Line 217: INSERT INTO AP_CHECKS

213: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'AP_AUTO_PAYMENT_PKG',l_debug_info);
214: END IF;
215:
216: /* Bug 4759178. Added Org_id */
217: INSERT INTO AP_CHECKS
218: (CHECK_ID, CE_BANK_ACCT_USE_ID, BANK_ACCOUNT_NAME,
219: AMOUNT, CHECK_NUMBER, CHECK_DATE, CURRENCY_CODE,
220: LAST_UPDATE_DATE, LAST_UPDATED_BY, VENDOR_ID, VENDOR_NAME,
221: VENDOR_SITE_ID, VENDOR_SITE_CODE, EXCHANGE_RATE, EXCHANGE_DATE,

Line 285: FROM ap_checks AC

281: AC.payment_document_id, AC.party_id, AC.party_site_id, AC.legal_entity_id,
282: AC.REMIT_TO_SUPPLIER_NAME,AC.REMIT_TO_SUPPLIER_ID,AC.REMIT_TO_SUPPLIER_SITE, --Added for bug 8218410
283: AC.REMIT_TO_SUPPLIER_SITE_ID,AC.RELATIONSHIP_ID -- bug 8218410 ends
284: ,AC.EXTERNAL_BANK_ACCOUNT_ID /* Added for bug 12773903 */
285: FROM ap_checks AC
286: WHERE AC.check_id = P_old_check_id;
287:
288: -- Bug3343314
289: SELECT payment_type_flag,

Line 315: FROM ap_checks

311: l_last_update_date,
312: l_last_updated_by,
313: l_last_update_login,
314: l_org_id
315: FROM ap_checks
316: WHERE check_id = p_replace_check_id;
317:
318: AP_ACCOUNTING_EVENTS_PKG.create_events
319: (

Line 386: FROM ap_checks

382: last_update_date = sysdate,
383: last_updated_by = P_Last_Updated_By
384: WHERE check_stock_id =
385: (SELECT check_stock_id
386: FROM ap_checks
387: WHERE check_id = P_Replace_Check_Id);
388:
389: -------------------------------------------------------------------
390: l_debug_info := 'Open c_new_payments cursor';

Line 641: UPDATE ap_checks

637: --
638: IF (P_Replace_Check_Date <> P_Orig_Payment_Date) THEN
639: l_debug_info := 'Update check amount';
640:
641: UPDATE ap_checks
642: SET amount = P_orig_amount
643: WHERE check_id = P_Old_Check_Id;
644: END IF;
645:

Line 702: ap_checks_all AC

698:
699: SELECT count(*)
700: INTO l_num_records
701: FROM ap_inv_selection_criteria_all AISC,
702: ap_checks_all AC
703: WHERE AC.check_id = P_check_id
704: AND AC.checkrun_name = AISC.checkrun_name;
705:
706: IF (l_num_records > 0) THEN