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 102: FROM ap_checks AC

98: , AC.global_attribute19
99: , AC.global_attribute20
100: , AC.global_attribute_category
101: , AC.org_id /* Bug 4759178. Added org_id */
102: FROM ap_checks AC
103: , ap_invoice_payments AIP
104: , ap_payment_schedules APS
105: , ap_system_parameters ASP
106: WHERE AC.check_id = P_Old_Check_Id

Line 116: l_doc_sequence_id ap_checks.doc_sequence_id%TYPE;

112: rec_new_payments c_new_payments%ROWTYPE;
113: l_debug_info VARCHAR2(240);
114: l_curr_calling_sequence VARCHAR2(2000);
115: l_doc_sequence_name fnd_document_sequences.name%TYPE;
116: l_doc_sequence_id ap_checks.doc_sequence_id%TYPE;
117: l_doc_sequence_value ap_checks.doc_sequence_value%TYPE;
118: l_doc_category_code ap_checks.doc_category_code%TYPE;
119: l_set_of_books_id ap_system_parameters.set_of_books_id%TYPE;
120: l_awt_success VARCHAR2(2000);

Line 117: l_doc_sequence_value ap_checks.doc_sequence_value%TYPE;

113: l_debug_info VARCHAR2(240);
114: l_curr_calling_sequence VARCHAR2(2000);
115: l_doc_sequence_name fnd_document_sequences.name%TYPE;
116: l_doc_sequence_id ap_checks.doc_sequence_id%TYPE;
117: l_doc_sequence_value ap_checks.doc_sequence_value%TYPE;
118: l_doc_category_code ap_checks.doc_category_code%TYPE;
119: l_set_of_books_id ap_system_parameters.set_of_books_id%TYPE;
120: l_awt_success VARCHAR2(2000);
121: l_awt_gross_amount NUMBER;

Line 118: l_doc_category_code ap_checks.doc_category_code%TYPE;

114: l_curr_calling_sequence VARCHAR2(2000);
115: l_doc_sequence_name fnd_document_sequences.name%TYPE;
116: l_doc_sequence_id ap_checks.doc_sequence_id%TYPE;
117: l_doc_sequence_value ap_checks.doc_sequence_value%TYPE;
118: l_doc_category_code ap_checks.doc_category_code%TYPE;
119: l_set_of_books_id ap_system_parameters.set_of_books_id%TYPE;
120: l_awt_success VARCHAR2(2000);
121: l_awt_gross_amount NUMBER;
122: l_accounting_event_id NUMBER; --Events Project 1

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

121: l_awt_gross_amount NUMBER;
122: l_accounting_event_id NUMBER; --Events Project 1
123: l_prev_withheld_amt NUMBER; --bug3309344
124: l_prev_amt_paid NUMBER; --bug3309344
125: l_payment_type_flag AP_CHECKS.payment_type_flag%TYPE; -- Bug3343314
126: l_amount AP_CHECKS.amount%TYPE; -- Bug3343314
127: l_currency_code AP_CHECKS.currency_code%TYPE; -- Bug3343314
128: l_exchange_rate_type AP_CHECKS.exchange_rate_type%TYPE; -- Bug3343314
129: l_exchange_date AP_CHECKS.exchange_date%TYPE; -- Bug3343314

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

122: l_accounting_event_id NUMBER; --Events Project 1
123: l_prev_withheld_amt NUMBER; --bug3309344
124: l_prev_amt_paid NUMBER; --bug3309344
125: l_payment_type_flag AP_CHECKS.payment_type_flag%TYPE; -- Bug3343314
126: l_amount AP_CHECKS.amount%TYPE; -- Bug3343314
127: l_currency_code AP_CHECKS.currency_code%TYPE; -- Bug3343314
128: l_exchange_rate_type AP_CHECKS.exchange_rate_type%TYPE; -- Bug3343314
129: l_exchange_date AP_CHECKS.exchange_date%TYPE; -- Bug3343314
130: l_exchange_rate AP_CHECKS.exchange_rate%TYPE; -- Bug3343314

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

123: l_prev_withheld_amt NUMBER; --bug3309344
124: l_prev_amt_paid NUMBER; --bug3309344
125: l_payment_type_flag AP_CHECKS.payment_type_flag%TYPE; -- Bug3343314
126: l_amount AP_CHECKS.amount%TYPE; -- Bug3343314
127: l_currency_code AP_CHECKS.currency_code%TYPE; -- Bug3343314
128: l_exchange_rate_type AP_CHECKS.exchange_rate_type%TYPE; -- Bug3343314
129: l_exchange_date AP_CHECKS.exchange_date%TYPE; -- Bug3343314
130: l_exchange_rate AP_CHECKS.exchange_rate%TYPE; -- Bug3343314
131: l_base_amount AP_CHECKS.exchange_rate%TYPE; -- Bug3343314

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

124: l_prev_amt_paid NUMBER; --bug3309344
125: l_payment_type_flag AP_CHECKS.payment_type_flag%TYPE; -- Bug3343314
126: l_amount AP_CHECKS.amount%TYPE; -- Bug3343314
127: l_currency_code AP_CHECKS.currency_code%TYPE; -- Bug3343314
128: l_exchange_rate_type AP_CHECKS.exchange_rate_type%TYPE; -- Bug3343314
129: l_exchange_date AP_CHECKS.exchange_date%TYPE; -- Bug3343314
130: l_exchange_rate AP_CHECKS.exchange_rate%TYPE; -- Bug3343314
131: l_base_amount AP_CHECKS.exchange_rate%TYPE; -- Bug3343314
132: l_creation_date AP_CHECKS.creation_date%TYPE; -- Bug3343314

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

125: l_payment_type_flag AP_CHECKS.payment_type_flag%TYPE; -- Bug3343314
126: l_amount AP_CHECKS.amount%TYPE; -- Bug3343314
127: l_currency_code AP_CHECKS.currency_code%TYPE; -- Bug3343314
128: l_exchange_rate_type AP_CHECKS.exchange_rate_type%TYPE; -- Bug3343314
129: l_exchange_date AP_CHECKS.exchange_date%TYPE; -- Bug3343314
130: l_exchange_rate AP_CHECKS.exchange_rate%TYPE; -- Bug3343314
131: l_base_amount AP_CHECKS.exchange_rate%TYPE; -- Bug3343314
132: l_creation_date AP_CHECKS.creation_date%TYPE; -- Bug3343314
133: l_created_by AP_CHECKS.created_by%TYPE; -- Bug3343314

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

126: l_amount AP_CHECKS.amount%TYPE; -- Bug3343314
127: l_currency_code AP_CHECKS.currency_code%TYPE; -- Bug3343314
128: l_exchange_rate_type AP_CHECKS.exchange_rate_type%TYPE; -- Bug3343314
129: l_exchange_date AP_CHECKS.exchange_date%TYPE; -- Bug3343314
130: l_exchange_rate AP_CHECKS.exchange_rate%TYPE; -- Bug3343314
131: l_base_amount AP_CHECKS.exchange_rate%TYPE; -- Bug3343314
132: l_creation_date AP_CHECKS.creation_date%TYPE; -- Bug3343314
133: l_created_by AP_CHECKS.created_by%TYPE; -- Bug3343314
134: l_last_update_date AP_CHECKS.last_update_date%TYPE; -- Bug3343314

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

127: l_currency_code AP_CHECKS.currency_code%TYPE; -- Bug3343314
128: l_exchange_rate_type AP_CHECKS.exchange_rate_type%TYPE; -- Bug3343314
129: l_exchange_date AP_CHECKS.exchange_date%TYPE; -- Bug3343314
130: l_exchange_rate AP_CHECKS.exchange_rate%TYPE; -- Bug3343314
131: l_base_amount AP_CHECKS.exchange_rate%TYPE; -- Bug3343314
132: l_creation_date AP_CHECKS.creation_date%TYPE; -- Bug3343314
133: l_created_by AP_CHECKS.created_by%TYPE; -- Bug3343314
134: l_last_update_date AP_CHECKS.last_update_date%TYPE; -- Bug3343314
135: l_last_updated_by AP_CHECKS.last_updated_by%TYPE; -- Bug3343314

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

128: l_exchange_rate_type AP_CHECKS.exchange_rate_type%TYPE; -- Bug3343314
129: l_exchange_date AP_CHECKS.exchange_date%TYPE; -- Bug3343314
130: l_exchange_rate AP_CHECKS.exchange_rate%TYPE; -- Bug3343314
131: l_base_amount AP_CHECKS.exchange_rate%TYPE; -- Bug3343314
132: l_creation_date AP_CHECKS.creation_date%TYPE; -- Bug3343314
133: l_created_by AP_CHECKS.created_by%TYPE; -- Bug3343314
134: l_last_update_date AP_CHECKS.last_update_date%TYPE; -- Bug3343314
135: l_last_updated_by AP_CHECKS.last_updated_by%TYPE; -- Bug3343314
136: l_last_update_login AP_CHECKS.last_update_login%TYPE; -- Bug3343314

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

129: l_exchange_date AP_CHECKS.exchange_date%TYPE; -- Bug3343314
130: l_exchange_rate AP_CHECKS.exchange_rate%TYPE; -- Bug3343314
131: l_base_amount AP_CHECKS.exchange_rate%TYPE; -- Bug3343314
132: l_creation_date AP_CHECKS.creation_date%TYPE; -- Bug3343314
133: l_created_by AP_CHECKS.created_by%TYPE; -- Bug3343314
134: l_last_update_date AP_CHECKS.last_update_date%TYPE; -- Bug3343314
135: l_last_updated_by AP_CHECKS.last_updated_by%TYPE; -- Bug3343314
136: l_last_update_login AP_CHECKS.last_update_login%TYPE; -- Bug3343314
137: l_org_id NUMBER;

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

130: l_exchange_rate AP_CHECKS.exchange_rate%TYPE; -- Bug3343314
131: l_base_amount AP_CHECKS.exchange_rate%TYPE; -- Bug3343314
132: l_creation_date AP_CHECKS.creation_date%TYPE; -- Bug3343314
133: l_created_by AP_CHECKS.created_by%TYPE; -- Bug3343314
134: l_last_update_date AP_CHECKS.last_update_date%TYPE; -- Bug3343314
135: l_last_updated_by AP_CHECKS.last_updated_by%TYPE; -- Bug3343314
136: l_last_update_login AP_CHECKS.last_update_login%TYPE; -- Bug3343314
137: l_org_id NUMBER;
138: l_transaction_type AP_PAYMENT_HISTORY_ALL.transaction_type%TYPE;

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

131: l_base_amount AP_CHECKS.exchange_rate%TYPE; -- Bug3343314
132: l_creation_date AP_CHECKS.creation_date%TYPE; -- Bug3343314
133: l_created_by AP_CHECKS.created_by%TYPE; -- Bug3343314
134: l_last_update_date AP_CHECKS.last_update_date%TYPE; -- Bug3343314
135: l_last_updated_by AP_CHECKS.last_updated_by%TYPE; -- Bug3343314
136: l_last_update_login AP_CHECKS.last_update_login%TYPE; -- Bug3343314
137: l_org_id NUMBER;
138: l_transaction_type AP_PAYMENT_HISTORY_ALL.transaction_type%TYPE;
139:

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

132: l_creation_date AP_CHECKS.creation_date%TYPE; -- Bug3343314
133: l_created_by AP_CHECKS.created_by%TYPE; -- Bug3343314
134: l_last_update_date AP_CHECKS.last_update_date%TYPE; -- Bug3343314
135: l_last_updated_by AP_CHECKS.last_updated_by%TYPE; -- Bug3343314
136: l_last_update_login AP_CHECKS.last_update_login%TYPE; -- Bug3343314
137: l_org_id NUMBER;
138: l_transaction_type AP_PAYMENT_HISTORY_ALL.transaction_type%TYPE;
139:
140: BEGIN

Line 156: FROM ap_checks ac, ap_invoice_payments aip

152:
153:
154: SELECT ac.doc_category_code, aip.set_of_books_id
155: INTO l_doc_category_code, l_set_of_books_id
156: FROM ap_checks ac, ap_invoice_payments aip
157: WHERE AC.check_id = P_old_check_id
158: AND AC.check_id = AIP.check_id
159: AND AC.doc_sequence_value IS NOT NULL
160: AND rownum = 1;

Line 184: SELECT ap_checks_s.nextval

180: --
181: -------------------------------------------------------------------
182: l_debug_info := 'Get replace_check_id';
183:
184: SELECT ap_checks_s.nextval
185: INTO P_Replace_Check_Id
186: FROM dual;
187:
188: -------------------------------------------------------------------

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

185: INTO P_Replace_Check_Id
186: FROM dual;
187:
188: -------------------------------------------------------------------
189: l_debug_info := 'Insert into ap_checks for replace_check_id';
190: /* Bug 4759178. Added Org_id */
191: INSERT INTO AP_CHECKS
192: (CHECK_ID, CE_BANK_ACCT_USE_ID, BANK_ACCOUNT_NAME,
193: AMOUNT, CHECK_NUMBER, CHECK_DATE, CURRENCY_CODE,

Line 191: INSERT INTO AP_CHECKS

187:
188: -------------------------------------------------------------------
189: l_debug_info := 'Insert into ap_checks for replace_check_id';
190: /* Bug 4759178. Added Org_id */
191: INSERT INTO AP_CHECKS
192: (CHECK_ID, CE_BANK_ACCT_USE_ID, BANK_ACCOUNT_NAME,
193: AMOUNT, CHECK_NUMBER, CHECK_DATE, CURRENCY_CODE,
194: LAST_UPDATE_DATE, LAST_UPDATED_BY, VENDOR_ID, VENDOR_NAME,
195: VENDOR_SITE_ID, VENDOR_SITE_CODE, EXCHANGE_RATE, EXCHANGE_DATE,

Line 256: FROM ap_checks AC

252: AC.bank_charge_bearer, AC.settlement_priority, AC.payment_profile_id,
253: AC.payment_document_id, AC.party_id, AC.party_site_id, AC.legal_entity_id,
254: AC.REMIT_TO_SUPPLIER_NAME,AC.REMIT_TO_SUPPLIER_ID,AC.REMIT_TO_SUPPLIER_SITE, --Added for bug 8218410
255: AC.REMIT_TO_SUPPLIER_SITE_ID,AC.RELATIONSHIP_ID -- bug 8218410 ends
256: FROM ap_checks AC
257: WHERE AC.check_id = P_old_check_id;
258:
259: -- Bug3343314
260: SELECT payment_type_flag,

Line 286: FROM ap_checks

282: l_last_update_date,
283: l_last_updated_by,
284: l_last_update_login,
285: l_org_id
286: FROM ap_checks
287: WHERE check_id = p_replace_check_id;
288:
289: AP_ACCOUNTING_EVENTS_PKG.create_events
290: (

Line 354: FROM ap_checks

350: last_update_date = sysdate,
351: last_updated_by = P_Last_Updated_By
352: WHERE check_stock_id =
353: (SELECT check_stock_id
354: FROM ap_checks
355: WHERE check_id = P_Replace_Check_Id);
356:
357: -------------------------------------------------------------------
358: l_debug_info := 'Open c_new_payments cursor';

Line 552: UPDATE ap_checks

548: --
549: IF (P_Replace_Check_Date <> P_Orig_Payment_Date) THEN
550: l_debug_info := 'Update check amount';
551:
552: UPDATE ap_checks
553: SET amount = P_orig_amount
554: WHERE check_id = P_Old_Check_Id;
555: END IF;
556:

Line 613: ap_checks_all AC

609:
610: SELECT count(*)
611: INTO l_num_records
612: FROM ap_inv_selection_criteria_all AISC,
613: ap_checks_all AC
614: WHERE AC.check_id = P_check_id
615: AND AC.checkrun_name = AISC.checkrun_name;
616:
617: IF (l_num_records > 0) THEN