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_ALL

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 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 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;