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_PAY_SINGLE_INVOICE_PKG dependencies on AP_CHECKS

Line 94: l_quick_check_id AP_CHECKS.checkrun_name%type;

90:
91: l_hold_all_payments_flag ap_suppliers.hold_all_payments_flag%TYPE;
92: l_active_pay_sites ap_supplier_sites_all.pay_site_flag%TYPE;
93: l_accounting_event_id NUMBER(38);
94: l_quick_check_id AP_CHECKS.checkrun_name%type;
95: l_next_check_number AP_CHECKS.check_number%type;
96: l_check_number AP_CHECKS.check_number%type;
97: l_period_name GL_PERIOD_STATUSES.period_name%TYPE;
98:

Line 95: l_next_check_number AP_CHECKS.check_number%type;

91: l_hold_all_payments_flag ap_suppliers.hold_all_payments_flag%TYPE;
92: l_active_pay_sites ap_supplier_sites_all.pay_site_flag%TYPE;
93: l_accounting_event_id NUMBER(38);
94: l_quick_check_id AP_CHECKS.checkrun_name%type;
95: l_next_check_number AP_CHECKS.check_number%type;
96: l_check_number AP_CHECKS.check_number%type;
97: l_period_name GL_PERIOD_STATUSES.period_name%TYPE;
98:
99: l_debug_info VARCHAR2(100);

Line 96: l_check_number AP_CHECKS.check_number%type;

92: l_active_pay_sites ap_supplier_sites_all.pay_site_flag%TYPE;
93: l_accounting_event_id NUMBER(38);
94: l_quick_check_id AP_CHECKS.checkrun_name%type;
95: l_next_check_number AP_CHECKS.check_number%type;
96: l_check_number AP_CHECKS.check_number%type;
97: l_period_name GL_PERIOD_STATUSES.period_name%TYPE;
98:
99: l_debug_info VARCHAR2(100);
100: l_curr_calling_sequence VARCHAR2(2000);

Line 119: l_payment_type_flag ap_checks.payment_type_flag%TYPE; -- Bug3343314

115:
116:
117:
118:
119: l_payment_type_flag ap_checks.payment_type_flag%TYPE; -- Bug3343314
120: l_creation_date ap_checks.creation_date%TYPE; -- Bug3343314
121: l_created_by ap_checks.created_by%TYPE; -- Bug3343314
122: l_last_update_date ap_checks.last_update_date%TYPE; -- Bug3343314
123: l_last_updated_by ap_checks.last_updated_by%TYPE; -- Bug3343314

Line 120: l_creation_date ap_checks.creation_date%TYPE; -- Bug3343314

116:
117:
118:
119: l_payment_type_flag ap_checks.payment_type_flag%TYPE; -- Bug3343314
120: l_creation_date ap_checks.creation_date%TYPE; -- Bug3343314
121: l_created_by ap_checks.created_by%TYPE; -- Bug3343314
122: l_last_update_date ap_checks.last_update_date%TYPE; -- Bug3343314
123: l_last_updated_by ap_checks.last_updated_by%TYPE; -- Bug3343314
124: l_last_update_login ap_checks.last_update_login%TYPE; -- Bug3343314

Line 121: l_created_by ap_checks.created_by%TYPE; -- Bug3343314

117:
118:
119: l_payment_type_flag ap_checks.payment_type_flag%TYPE; -- Bug3343314
120: l_creation_date ap_checks.creation_date%TYPE; -- Bug3343314
121: l_created_by ap_checks.created_by%TYPE; -- Bug3343314
122: l_last_update_date ap_checks.last_update_date%TYPE; -- Bug3343314
123: l_last_updated_by ap_checks.last_updated_by%TYPE; -- Bug3343314
124: l_last_update_login ap_checks.last_update_login%TYPE; -- Bug3343314
125: l_org_id NUMBER;

Line 122: l_last_update_date ap_checks.last_update_date%TYPE; -- Bug3343314

118:
119: l_payment_type_flag ap_checks.payment_type_flag%TYPE; -- Bug3343314
120: l_creation_date ap_checks.creation_date%TYPE; -- Bug3343314
121: l_created_by ap_checks.created_by%TYPE; -- Bug3343314
122: l_last_update_date ap_checks.last_update_date%TYPE; -- Bug3343314
123: l_last_updated_by ap_checks.last_updated_by%TYPE; -- Bug3343314
124: l_last_update_login ap_checks.last_update_login%TYPE; -- Bug3343314
125: l_org_id NUMBER;
126: l_bank_account_id ce_bank_acct_uses_all.bank_acct_use_id%TYPE;

Line 123: l_last_updated_by ap_checks.last_updated_by%TYPE; -- Bug3343314

119: l_payment_type_flag ap_checks.payment_type_flag%TYPE; -- Bug3343314
120: l_creation_date ap_checks.creation_date%TYPE; -- Bug3343314
121: l_created_by ap_checks.created_by%TYPE; -- Bug3343314
122: l_last_update_date ap_checks.last_update_date%TYPE; -- Bug3343314
123: l_last_updated_by ap_checks.last_updated_by%TYPE; -- Bug3343314
124: l_last_update_login ap_checks.last_update_login%TYPE; -- Bug3343314
125: l_org_id NUMBER;
126: l_bank_account_id ce_bank_acct_uses_all.bank_acct_use_id%TYPE;
127: l_bank_account_name ce_bank_accounts.bank_account_name%TYPE;

Line 124: l_last_update_login ap_checks.last_update_login%TYPE; -- Bug3343314

120: l_creation_date ap_checks.creation_date%TYPE; -- Bug3343314
121: l_created_by ap_checks.created_by%TYPE; -- Bug3343314
122: l_last_update_date ap_checks.last_update_date%TYPE; -- Bug3343314
123: l_last_updated_by ap_checks.last_updated_by%TYPE; -- Bug3343314
124: l_last_update_login ap_checks.last_update_login%TYPE; -- Bug3343314
125: l_org_id NUMBER;
126: l_bank_account_id ce_bank_acct_uses_all.bank_acct_use_id%TYPE;
127: l_bank_account_name ce_bank_accounts.bank_account_name%TYPE;
128: l_processing_type iby_payment_profiles.processing_type%TYPE;

Line 134: l_maturity_date ap_checks.future_pay_due_date%TYPE;

130: l_default_printer iby_payment_profiles.default_printer%TYPE;
131: l_payment_document_id ce_payment_documents.payment_document_id %TYPE;
132: l_bills_payable iby_payment_methods_vl.support_bills_payable_flag%TYPE;
133: l_maturity_date_offset_days iby_payment_methods_vl.maturity_date_offset_days%TYPE;
134: l_maturity_date ap_checks.future_pay_due_date%TYPE;
135: l_vendor_type_lookup_code ap_suppliers.vendor_type_lookup_code%TYPE;
136:
137: l_return_status VARCHAR2(100);
138: l_return_message VARCHAR2(3000);

Line 169: Xrate AP_CHECKS_ALL.exchange_rate%TYPE

165: );
166:
167: TYPE r_check_info IS RECORD
168: (
169: Xrate AP_CHECKS_ALL.exchange_rate%TYPE
170: ,Xrate_date AP_CHECKS_ALL.exchange_date%TYPE
171: ,Xrate_type AP_CHECKS_ALL.exchange_rate_type%TYPE
172: ,Check_id AP_CHECKS_ALL.check_id%TYPE
173: ,Checkrun_Name AP_CHECKS_ALL.checkrun_name%TYPE

Line 170: ,Xrate_date AP_CHECKS_ALL.exchange_date%TYPE

166:
167: TYPE r_check_info IS RECORD
168: (
169: Xrate AP_CHECKS_ALL.exchange_rate%TYPE
170: ,Xrate_date AP_CHECKS_ALL.exchange_date%TYPE
171: ,Xrate_type AP_CHECKS_ALL.exchange_rate_type%TYPE
172: ,Check_id AP_CHECKS_ALL.check_id%TYPE
173: ,Checkrun_Name AP_CHECKS_ALL.checkrun_name%TYPE
174: ,Internal_Bank_Acct_Id CE_BANK_ACCT_USES_ALL.bank_acct_use_id%TYPE

Line 171: ,Xrate_type AP_CHECKS_ALL.exchange_rate_type%TYPE

167: TYPE r_check_info IS RECORD
168: (
169: Xrate AP_CHECKS_ALL.exchange_rate%TYPE
170: ,Xrate_date AP_CHECKS_ALL.exchange_date%TYPE
171: ,Xrate_type AP_CHECKS_ALL.exchange_rate_type%TYPE
172: ,Check_id AP_CHECKS_ALL.check_id%TYPE
173: ,Checkrun_Name AP_CHECKS_ALL.checkrun_name%TYPE
174: ,Internal_Bank_Acct_Id CE_BANK_ACCT_USES_ALL.bank_acct_use_id%TYPE
175: ,Bank_Account_Name CE_BANK_ACCOUNTS.bank_account_name%TYPE

Line 172: ,Check_id AP_CHECKS_ALL.check_id%TYPE

168: (
169: Xrate AP_CHECKS_ALL.exchange_rate%TYPE
170: ,Xrate_date AP_CHECKS_ALL.exchange_date%TYPE
171: ,Xrate_type AP_CHECKS_ALL.exchange_rate_type%TYPE
172: ,Check_id AP_CHECKS_ALL.check_id%TYPE
173: ,Checkrun_Name AP_CHECKS_ALL.checkrun_name%TYPE
174: ,Internal_Bank_Acct_Id CE_BANK_ACCT_USES_ALL.bank_acct_use_id%TYPE
175: ,Bank_Account_Name CE_BANK_ACCOUNTS.bank_account_name%TYPE
176: ,Bank_Account_Num CE_BANK_ACCOUNTS.bank_account_num%TYPE

Line 173: ,Checkrun_Name AP_CHECKS_ALL.checkrun_name%TYPE

169: Xrate AP_CHECKS_ALL.exchange_rate%TYPE
170: ,Xrate_date AP_CHECKS_ALL.exchange_date%TYPE
171: ,Xrate_type AP_CHECKS_ALL.exchange_rate_type%TYPE
172: ,Check_id AP_CHECKS_ALL.check_id%TYPE
173: ,Checkrun_Name AP_CHECKS_ALL.checkrun_name%TYPE
174: ,Internal_Bank_Acct_Id CE_BANK_ACCT_USES_ALL.bank_acct_use_id%TYPE
175: ,Bank_Account_Name CE_BANK_ACCOUNTS.bank_account_name%TYPE
176: ,Bank_Account_Num CE_BANK_ACCOUNTS.bank_account_num%TYPE
177: ,Bank_Account_Type CE_BANK_ACCOUNTS.account_classification%TYPE

Line 180: ,Status_Lookup_Code AP_CHECKS_ALL.status_lookup_code%TYPE

176: ,Bank_Account_Num CE_BANK_ACCOUNTS.bank_account_num%TYPE
177: ,Bank_Account_Type CE_BANK_ACCOUNTS.account_classification%TYPE
178: ,Bank_Num CE_BANK_BRANCHES_V.branch_number%TYPE
179: ,Legal_Entity_Id CE_BANK_ACCOUNTS.account_owner_org_id%TYPE
180: ,Status_Lookup_Code AP_CHECKS_ALL.status_lookup_code%TYPE
181: );
182:
183: TYPE r_ap_ven_sites_info IS RECORD
184: (

Line 929: || it is needed for the insert into ap_checks

925:
926: /*
927: || =======================================================
928: || Need to get the party name from hz_parties as it
929: || it is needed for the insert into ap_checks
930: || =======================================================
931: */
932:
933: l_debug_info := 'Get Supplier Party Name';

Line 981: || to insert a row in the table AP_CHECKS_ALL

977: || It also will return the payment_method_code for each
978: || payment_num on the list p_payment_num_list.
979: ||
980: || It will also return the following bits of information needed
981: || to insert a row in the table AP_CHECKS_ALL
982: ||
983: || Currency_code,
984: || Payment_method,
985: || Vendor_id, <-- Already have this information

Line 1078: AND table_name IN ('AP_CHECKS','AP_CHECKS_ALL');

1074: SELECT 'row exists'
1075: INTO l_valid_sequence_exists
1076: FROM fnd_doc_sequence_categories
1077: WHERE code = l_doc_category_code
1078: AND table_name IN ('AP_CHECKS','AP_CHECKS_ALL');
1079: exception
1080: when no_data_found then
1081:
1082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1250: || AP_CHECKS

1246:
1247: /*
1248: || ==============================================================
1249: || Step ?: Get Check_ID for creaation of record in the table
1250: || AP_CHECKS
1251: || --------------------------------------------------------------
1252: */
1253:
1254: -- First select the value for the CHECK_ID before insert

Line 1256: SELECT ap_checks_s.nextval

1252: */
1253:
1254: -- First select the value for the CHECK_ID before insert
1255:
1256: SELECT ap_checks_s.nextval
1257: INTO l_check_rec.check_id
1258: FROM sys.dual;
1259:
1260: l_debug_info := 'Get Quick Check Id';

Line 1280: || Step ? - Create Check (record in the table AP_CHECKS

1276: END IF;
1277:
1278: /*
1279: || ==============================================================
1280: || Step ? - Create Check (record in the table AP_CHECKS
1281: || --------------------------------------------------------------
1282: */
1283:
1284: l_debug_info := 'Calling Ap_Check_Pkg.Insert_Row';

Line 1288: AP_CHECKS_PKG.Insert_Row(

1284: l_debug_info := 'Calling Ap_Check_Pkg.Insert_Row';
1285: print_debuginfo(l_module_name, l_debug_info,
1286: G_LEVEL_PROCEDURE);
1287:
1288: AP_CHECKS_PKG.Insert_Row(
1289: X_Rowid => l_dummy_rowid,
1290: X_Amount => l_amount,
1291: X_Ce_Bank_Acct_Use_Id => p_internal_bank_acct_id,
1292: X_Bank_Account_Name => l_check_rec.bank_account_name,

Line 1517: from ap_checks_all

1513:
1514: --bug 5982788
1515:
1516: select checkrun_name into l_check_rec.Checkrun_name
1517: from ap_checks_all
1518: where check_id = l_check_rec.check_id ;
1519:
1520:
1521: ELSIF p_payment_type_flag = 'M' THEN

Line 1525: update ap_checks_all

1521: ELSIF p_payment_type_flag = 'M' THEN
1522:
1523: l_manual_payment_flag := 'Y';
1524: --bug 5982788
1525: update ap_checks_all
1526: set checkrun_name = l_check_rec.check_id
1527: where check_id = l_check_rec.check_id ;
1528:
1529:

Line 1531: from ap_checks_all

1527: where check_id = l_check_rec.check_id ;
1528:
1529:
1530: select checkrun_name into l_check_rec.Checkrun_name
1531: from ap_checks_all
1532: where check_id = l_check_rec.check_id ;
1533:
1534:
1535: END IF;

Line 1607: UPDATE AP_CHECKS_ALL

1603: );
1604:
1605: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1606:
1607: UPDATE AP_CHECKS_ALL
1608: SET payment_id = l_payment_id
1609: WHERE check_id = l_check_rec.check_id;
1610:
1611:

Line 1620: UPDATE AP_CHECKS_ALL

1616: l_check_number := l_pmt_ref_num;
1617: END IF;
1618:
1619: IF l_next_check_number <> l_check_number THEN
1620: UPDATE AP_CHECKS_ALL
1621: SET check_number = l_check_number
1622: WHERE check_id = l_check_rec.check_id;
1623: END IF;
1624: END IF;