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 243: ap_payment_schedules ps

239: i.goods_received_date
240: FROM ap_terms t,
241: ap_invoice_distributions d,
242: ap_invoices i,
243: ap_payment_schedules ps
244: WHERE i.payment_status_flag = 'N'
245: AND ps.amount_remaining > 0
246: AND ps.invoice_id = i.invoice_id
247: AND i.invoice_id = d.invoice_id

Line 1078: FROM ap_payment_schedules

1074: sum(nvl(amount_remaining, gross_amount))
1075: INTO p_last_inv_ps_pay_num, p_ps_total_gross_amount,
1076: p_ps_total_inv_curr_gross_amt, -- R11: Xcurr
1077: l_amount_remaining
1078: FROM ap_payment_schedules
1079: WHERE invoice_id = p_invoice_id;
1080:
1081: ------------------------------------------------
1082: l_debug_info := 'Retrieve last_term_ps_pay_num';

Line 1164: UPDATE ap_payment_schedules

1160: INTO l_pay_curr_code
1161: FROM ap_invoices
1162: WHERE invoice_id = p_invoice_id;
1163:
1164: UPDATE ap_payment_schedules
1165: SET due_date = p_ppa_due_date,
1166: discount_amount_available = p_1st_disc_amt_available,
1167: discount_amount_remaining = p_1st_disc_amt_available,
1168: second_disc_amt_available = p_2nd_disc_amt_available,

Line 1185: (p_table_name => 'AP_PAYMENT_SCHEDULES',

1181: AND payment_num = p_payment_num;
1182:
1183: --Bug 4539462 DBI logging
1184: AP_DBI_PKG.Maintain_DBI_Summary
1185: (p_table_name => 'AP_PAYMENT_SCHEDULES',
1186: p_operation => 'U',
1187: p_key_value1 => p_invoice_id,
1188: p_key_value2 => p_payment_num,
1189: p_calling_sequence => l_curr_calling_sequence);

Line 1195: FROM ap_payment_schedules

1191: --Bug Fix:1237758
1192: --The following code added to take care of rounding errors
1193: SELECT SUM(gross_amount)
1194: INTO l_pay_sched_total
1195: FROM ap_payment_schedules
1196: WHERE invoice_id = P_Invoice_Id;
1197:
1198: --AP_LOGGING_PKG.AP_End_Block(l_debug_loc);
1199:

Line 1241: DELETE FROM ap_payment_schedules

1237:
1238: l_curr_calling_sequence := 'AP_PPA_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
1239:
1240:
1241: DELETE FROM ap_payment_schedules
1242: WHERE invoice_id = p_invoice_id
1243: AND payment_num > p_payment_num;
1244:
1245: --Bug 4539462 DBI logging

Line 1247: (p_table_name => 'AP_PAYMENT_SCHEDULES',

1243: AND payment_num > p_payment_num;
1244:
1245: --Bug 4539462 DBI logging
1246: AP_DBI_PKG.Maintain_DBI_Summary
1247: (p_table_name => 'AP_PAYMENT_SCHEDULES',
1248: p_operation => 'D',
1249: p_key_value1 => p_invoice_id,
1250: p_calling_sequence => l_curr_calling_sequence);
1251:

Line 1605: INSERT INTO ap_payment_schedules

1601: FROM ap_invoices
1602: WHERE invoice_id = p_invoice_id;
1603:
1604:
1605: INSERT INTO ap_payment_schedules
1606: (invoice_id,
1607: payment_num,
1608: last_updated_by,
1609: last_update_date,

Line 1663: (p_table_name => 'AP_PAYMENT_SCHEDULES',

1659: l_org_id); /* Bug 3700128. MOAC Project */
1660:
1661: --Bug 4539462 DBI logging
1662: AP_DBI_PKG.Maintain_DBI_Summary
1663: (p_table_name => 'AP_PAYMENT_SCHEDULES',
1664: p_operation => 'I',
1665: p_key_value1 => p_invoice_id,
1666: p_key_value2 => p_ps_pay_num,
1667: p_calling_sequence => l_curr_calling_sequence);

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

1900: l_key_value NUMBER;
1901:
1902: BEGIN
1903:
1904: l_debug_loc := 'Update ap_payment_schedules - set gross_amount';
1905: l_curr_calling_sequence := 'AP_PPA_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
1906:
1907: SELECT SUM(gross_amount)
1908: INTO l_pay_sched_total

Line 1909: FROM ap_payment_schedules

1905: l_curr_calling_sequence := 'AP_PPA_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
1906:
1907: SELECT SUM(gross_amount)
1908: INTO l_pay_sched_total
1909: FROM ap_payment_schedules
1910: WHERE invoice_id = P_Invoice_Id;
1911:
1912: SELECT nvl(pay_curr_invoice_amount,invoice_amount) pay_curr_invoice_amount
1913: INTO l_pay_curr_invoice_amount

Line 1921: UPDATE AP_PAYMENT_SCHEDULES

1917: -- Adjust Payment Schedules for rounding errors
1918: IF (l_pay_sched_total <> l_Pay_Curr_Invoice_Amount) THEN
1919:
1920:
1921: UPDATE AP_PAYMENT_SCHEDULES
1922: SET gross_amount = gross_amount + TO_NUMBER(l_Pay_Curr_Invoice_Amount) -
1923: TO_NUMBER(l_pay_sched_total),
1924: amount_remaining=amount_remaining + TO_NUMBER(l_Pay_Curr_Invoice_Amount) -
1925: TO_NUMBER(l_pay_sched_total)

Line 1928: FROM ap_payment_schedules

1924: amount_remaining=amount_remaining + TO_NUMBER(l_Pay_Curr_Invoice_Amount) -
1925: TO_NUMBER(l_pay_sched_total)
1926: WHERE invoice_id = P_Invoice_Id
1927: AND payment_num = (SELECT MAX(payment_num)
1928: FROM ap_payment_schedules
1929: WHERE invoice_id = P_Invoice_Id);
1930:
1931: --Bug 4539462 DBI logging
1932: AP_DBI_PKG.Maintain_DBI_Summary

Line 1933: (p_table_name => 'AP_PAYMENT_SCHEDULES',

1929: WHERE invoice_id = P_Invoice_Id);
1930:
1931: --Bug 4539462 DBI logging
1932: AP_DBI_PKG.Maintain_DBI_Summary
1933: (p_table_name => 'AP_PAYMENT_SCHEDULES',
1934: p_operation => 'U',
1935: p_key_value1 => p_invoice_id,
1936: p_key_value2 => l_key_value,
1937: p_calling_sequence => l_curr_calling_sequence);