APPS.ARP_CONFIRMATION dependencies on AR_PAYMENT_SCHEDULES

Line 573: l_inv_ps_rec ar_payment_schedules%ROWTYPE;

569: -- Local variables:
570:
571: l_dummy NUMBER;
572:
573: l_inv_ps_rec ar_payment_schedules%ROWTYPE;
574: l_max_dates MaxDatesType; -- record type
575:
576: l_line_applied NUMBER;
577: l_tax_applied NUMBER;

Line 951: IN ar_payment_schedules.selected_for_receipt_batch_id%TYPE

947: p_confirm_gl_date IN DATE,
948: p_confirm_date IN DATE,
949: p_acctd_amount IN NUMBER,
950: p_batch_id
951: IN ar_payment_schedules.selected_for_receipt_batch_id%TYPE
952: ) IS
953:
954: -- Define cursor for applications:
955:

Line 1222: l_receipt_ps_rec ar_payment_schedules%ROWTYPE;

1218: p_closed_date DATE,
1219: p_closed_gl_date DATE
1220: ) IS
1221:
1222: l_receipt_ps_rec ar_payment_schedules%ROWTYPE;
1223: l_dummy NUMBER;
1224:
1225: BEGIN
1226:

Line 1232: FROM ar_payment_schedules

1228: -- Fetch receipt's payment schedule record:
1229:
1230: SELECT *
1231: INTO l_receipt_ps_rec
1232: FROM ar_payment_schedules
1233: WHERE cash_receipt_id = p_cr_rec.cash_receipt_id;
1234:
1235:
1236: -- set confirmed flag to 'Y' to mark receipt as confirmed:

Line 1239: -- Bug 1199703 : update ar_payment_schedules.gl_date when receipt is confirmed

1235:
1236: -- set confirmed flag to 'Y' to mark receipt as confirmed:
1237: l_receipt_ps_rec.receipt_confirmed_flag := 'Y';
1238:
1239: -- Bug 1199703 : update ar_payment_schedules.gl_date when receipt is confirmed
1240: l_receipt_ps_rec.gl_date := p_closed_gl_date;
1241:
1242: -- call utility handler routine to update payment schedule record:
1243:

Line 1906: | ar_payment_schedules. |

1902: | |
1903: | 01-SEP-95 OSTEINME created |
1904: | 08-NOV-01 Debbie Jancis Modified for mrc trigger elimination project |
1905: | added calls to ar_mrc_engine for updates to |
1906: | ar_payment_schedules. |
1907: +===========================================================================*/
1908:
1909:
1910: PROCEDURE reverse_application_to_ps(

Line 1916: ar_payment_schedules.selected_for_receipt_batch_id%TYPE

1912: ar_receivable_applications.receivable_application_id%TYPE,
1913: p_confirm_gl_date IN DATE,
1914: p_confirm_date IN DATE,
1915: p_batch_id IN
1916: ar_payment_schedules.selected_for_receipt_batch_id%TYPE
1917: ) IS
1918:
1919: l_ar_ps_key_value_list gl_ca_utility_pkg.r_key_value_arr;
1920:

Line 1926: ar_payment_schedules ps

1922:
1923: arp_standard.debug('arp_confirmation.reverse_application_to_ps()+');
1924:
1925: UPDATE
1926: ar_payment_schedules ps
1927: SET (
1928: status,
1929: gl_date_closed,
1930: actual_date_closed,

Line 1979: ar_payment_schedules ps2,

1975: trunc(sysdate),
1976: FND_GLOBAL.user_id
1977: FROM
1978: ar_receivable_applications ra,
1979: ar_payment_schedules ps2,
1980: ar_adjustments adj2,
1981: ar_receivable_applications ra2
1982: WHERE
1983: ra.receivable_application_id = p_ra_id

Line 2025: p_table_name => 'AR_PAYMENT_SCHEDULES',

2021: +---------------------------------*/
2022:
2023: ar_mrc_engine.maintain_mrc_data(
2024: p_event_mode => 'UPDATE',
2025: p_table_name => 'AR_PAYMENT_SCHEDULES',
2026: p_mode => 'BATCH',
2027: p_key_value_list => l_ar_ps_key_value_list);
2028:
2029: arp_standard.debug('arp_confirmation.reverse_application_to_ps()-');

Line 2655: l_receipt_ps_rec ar_payment_schedules%ROWTYPE;

2651: p_closed_date DATE,
2652: p_closed_gl_date DATE
2653: ) IS
2654:
2655: l_receipt_ps_rec ar_payment_schedules%ROWTYPE;
2656: l_dummy NUMBER;
2657:
2658: BEGIN
2659:

Line 2665: FROM ar_payment_schedules

2661: -- Fetch receipt's payment schedule record:
2662:
2663: SELECT *
2664: INTO l_receipt_ps_rec
2665: FROM ar_payment_schedules
2666: WHERE cash_receipt_id = p_cr_rec.cash_receipt_id;
2667:
2668:
2669: -- set confirmed flag to 'N' to mark receipt as unconfirmed: