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_PPA_PKG dependencies on AP_PAYMENT_SCHEDULES

Line 265: ap_payment_schedules ps

261: i.goods_received_date
262: FROM ap_terms t,
263: ap_invoice_distributions d,
264: ap_invoices i,
265: ap_payment_schedules ps
266: WHERE i.payment_status_flag = 'N'
267: AND ps.amount_remaining > 0
268: AND ps.invoice_id = i.invoice_id
269: AND i.invoice_id = d.invoice_id

Line 1119: FROM ap_payment_schedules

1115: sum(nvl(amount_remaining, gross_amount))
1116: INTO p_last_inv_ps_pay_num, p_ps_total_gross_amount,
1117: p_ps_total_inv_curr_gross_amt, -- R11: Xcurr
1118: l_amount_remaining
1119: FROM ap_payment_schedules
1120: WHERE invoice_id = p_invoice_id;
1121:
1122: ------------------------------------------------
1123: l_debug_info := 'Retrieve last_term_ps_pay_num';

Line 1205: UPDATE ap_payment_schedules

1201: INTO l_pay_curr_code
1202: FROM ap_invoices
1203: WHERE invoice_id = p_invoice_id;
1204:
1205: UPDATE ap_payment_schedules
1206: SET due_date = p_ppa_due_date,
1207: discount_amount_available = p_1st_disc_amt_available,
1208: discount_amount_remaining = p_1st_disc_amt_available,
1209: second_disc_amt_available = p_2nd_disc_amt_available,

Line 1226: (p_table_name => 'AP_PAYMENT_SCHEDULES',

1222: AND payment_num = p_payment_num;
1223:
1224: --Bug 4539462 DBI logging
1225: AP_DBI_PKG.Maintain_DBI_Summary
1226: (p_table_name => 'AP_PAYMENT_SCHEDULES',
1227: p_operation => 'U',
1228: p_key_value1 => p_invoice_id,
1229: p_key_value2 => p_payment_num,
1230: p_calling_sequence => l_curr_calling_sequence);

Line 1236: FROM ap_payment_schedules

1232: --Bug Fix:1237758
1233: --The following code added to take care of rounding errors
1234: SELECT SUM(gross_amount)
1235: INTO l_pay_sched_total
1236: FROM ap_payment_schedules
1237: WHERE invoice_id = P_Invoice_Id;
1238:
1239: --AP_LOGGING_PKG.AP_End_Block(l_debug_loc);
1240:

Line 1282: DELETE FROM ap_payment_schedules

1278:
1279: l_curr_calling_sequence := 'AP_PPA_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
1280:
1281:
1282: DELETE FROM ap_payment_schedules
1283: WHERE invoice_id = p_invoice_id
1284: AND payment_num > p_payment_num;
1285:
1286: --Bug 4539462 DBI logging

Line 1288: (p_table_name => 'AP_PAYMENT_SCHEDULES',

1284: AND payment_num > p_payment_num;
1285:
1286: --Bug 4539462 DBI logging
1287: AP_DBI_PKG.Maintain_DBI_Summary
1288: (p_table_name => 'AP_PAYMENT_SCHEDULES',
1289: p_operation => 'D',
1290: p_key_value1 => p_invoice_id,
1291: p_calling_sequence => l_curr_calling_sequence);
1292:

Line 1682: INSERT INTO ap_payment_schedules

1678: FROM ap_invoices
1679: WHERE invoice_id = p_invoice_id;
1680:
1681:
1682: INSERT INTO ap_payment_schedules
1683: (invoice_id,
1684: payment_num,
1685: last_updated_by,
1686: last_update_date,

Line 1740: (p_table_name => 'AP_PAYMENT_SCHEDULES',

1736: l_org_id); /* Bug 3700128. MOAC Project */
1737:
1738: --Bug 4539462 DBI logging
1739: AP_DBI_PKG.Maintain_DBI_Summary
1740: (p_table_name => 'AP_PAYMENT_SCHEDULES',
1741: p_operation => 'I',
1742: p_key_value1 => p_invoice_id,
1743: p_key_value2 => p_ps_pay_num,
1744: p_calling_sequence => l_curr_calling_sequence);

Line 1995: l_debug_loc := 'Update ap_payment_schedules - set gross_amount';

1991: l_key_value NUMBER;
1992:
1993: BEGIN
1994:
1995: l_debug_loc := 'Update ap_payment_schedules - set gross_amount';
1996: l_curr_calling_sequence := 'AP_PPA_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
1997:
1998: SELECT SUM(gross_amount)
1999: INTO l_pay_sched_total

Line 2000: FROM ap_payment_schedules

1996: l_curr_calling_sequence := 'AP_PPA_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
1997:
1998: SELECT SUM(gross_amount)
1999: INTO l_pay_sched_total
2000: FROM ap_payment_schedules
2001: WHERE invoice_id = P_Invoice_Id;
2002:
2003: SELECT nvl(pay_curr_invoice_amount,invoice_amount) pay_curr_invoice_amount
2004: INTO l_pay_curr_invoice_amount

Line 2012: UPDATE AP_PAYMENT_SCHEDULES

2008: -- Adjust Payment Schedules for rounding errors
2009: IF (l_pay_sched_total <> l_Pay_Curr_Invoice_Amount) THEN
2010:
2011:
2012: UPDATE AP_PAYMENT_SCHEDULES
2013: SET gross_amount = gross_amount + TO_NUMBER(l_Pay_Curr_Invoice_Amount) -
2014: TO_NUMBER(l_pay_sched_total),
2015: amount_remaining=amount_remaining + TO_NUMBER(l_Pay_Curr_Invoice_Amount) -
2016: TO_NUMBER(l_pay_sched_total)

Line 2019: FROM ap_payment_schedules

2015: amount_remaining=amount_remaining + TO_NUMBER(l_Pay_Curr_Invoice_Amount) -
2016: TO_NUMBER(l_pay_sched_total)
2017: WHERE invoice_id = P_Invoice_Id
2018: AND payment_num = (SELECT MAX(payment_num)
2019: FROM ap_payment_schedules
2020: WHERE invoice_id = P_Invoice_Id);
2021:
2022: --Bug 4539462 DBI logging
2023: AP_DBI_PKG.Maintain_DBI_Summary

Line 2024: (p_table_name => 'AP_PAYMENT_SCHEDULES',

2020: WHERE invoice_id = P_Invoice_Id);
2021:
2022: --Bug 4539462 DBI logging
2023: AP_DBI_PKG.Maintain_DBI_Summary
2024: (p_table_name => 'AP_PAYMENT_SCHEDULES',
2025: p_operation => 'U',
2026: p_key_value1 => p_invoice_id,
2027: p_key_value2 => l_key_value,
2028: p_calling_sequence => l_curr_calling_sequence);