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 928: || it is needed for the insert into ap_checks

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

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

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

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

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

Line 1249: || AP_CHECKS

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

Line 1255: SELECT ap_checks_s.nextval

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

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

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

Line 1287: AP_CHECKS_PKG.Insert_Row(

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

Line 1516: from ap_checks_all

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

Line 1524: update ap_checks_all

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

Line 1530: from ap_checks_all

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

Line 1606: UPDATE AP_CHECKS_ALL

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

Line 1619: UPDATE AP_CHECKS_ALL

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