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