APPS.ARP_CONFIRMATION dependencies on AR_PAYMENT_SCHEDULES

Line 590: l_inv_ps_rec ar_payment_schedules%ROWTYPE;

586: -- Local variables:
587:
588: l_dummy NUMBER;
589:
590: l_inv_ps_rec ar_payment_schedules%ROWTYPE;
591: l_max_dates MaxDatesType; -- record type
592:
593: l_line_applied NUMBER;
594: l_tax_applied NUMBER;

Line 968: IN ar_payment_schedules.selected_for_receipt_batch_id%TYPE

964: p_confirm_gl_date IN DATE,
965: p_confirm_date IN DATE,
966: p_acctd_amount IN NUMBER,
967: p_batch_id
968: IN ar_payment_schedules.selected_for_receipt_batch_id%TYPE
969: ) IS
970:
971: -- Define cursor for applications:
972:

Line 1239: l_receipt_ps_rec ar_payment_schedules%ROWTYPE;

1235: p_closed_date DATE,
1236: p_closed_gl_date DATE
1237: ) IS
1238:
1239: l_receipt_ps_rec ar_payment_schedules%ROWTYPE;
1240: l_dummy NUMBER;
1241:
1242: BEGIN
1243:

Line 1249: FROM ar_payment_schedules

1245: -- Fetch receipt's payment schedule record:
1246:
1247: SELECT *
1248: INTO l_receipt_ps_rec
1249: FROM ar_payment_schedules
1250: WHERE cash_receipt_id = p_cr_rec.cash_receipt_id;
1251:
1252:
1253: -- set confirmed flag to 'Y' to mark receipt as confirmed:

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

1252:
1253: -- set confirmed flag to 'Y' to mark receipt as confirmed:
1254: l_receipt_ps_rec.receipt_confirmed_flag := 'Y';
1255:
1256: -- Bug 1199703 : update ar_payment_schedules.gl_date when receipt is confirmed
1257: l_receipt_ps_rec.gl_date := p_closed_gl_date;
1258:
1259: -- call utility handler routine to update payment schedule record:
1260:

Line 1923: | ar_payment_schedules. |

1919: | |
1920: | 01-SEP-95 OSTEINME created |
1921: | 08-NOV-01 Debbie Jancis Modified for mrc trigger elimination project |
1922: | added calls to ar_mrc_engine for updates to |
1923: | ar_payment_schedules. |
1924: +===========================================================================*/
1925:
1926:
1927: PROCEDURE reverse_application_to_ps(

Line 1933: ar_payment_schedules.selected_for_receipt_batch_id%TYPE

1929: ar_receivable_applications.receivable_application_id%TYPE,
1930: p_confirm_gl_date IN DATE,
1931: p_confirm_date IN DATE,
1932: p_batch_id IN
1933: ar_payment_schedules.selected_for_receipt_batch_id%TYPE
1934: ) IS
1935:
1936: l_ar_ps_key_value_list gl_ca_utility_pkg.r_key_value_arr;
1937:

Line 1943: ar_payment_schedules ps

1939:
1940: arp_standard.debug('arp_confirmation.reverse_application_to_ps()+');
1941:
1942: UPDATE
1943: ar_payment_schedules ps
1944: SET (
1945: status,
1946: gl_date_closed,
1947: actual_date_closed,

Line 1996: ar_payment_schedules ps2,

1992: trunc(sysdate),
1993: FND_GLOBAL.user_id
1994: FROM
1995: ar_receivable_applications ra,
1996: ar_payment_schedules ps2,
1997: ar_adjustments adj2,
1998: ar_receivable_applications ra2
1999: WHERE
2000: ra.receivable_application_id = p_ra_id

Line 2042: p_table_name => 'AR_PAYMENT_SCHEDULES',

2038: +---------------------------------*/
2039:
2040: ar_mrc_engine.maintain_mrc_data(
2041: p_event_mode => 'UPDATE',
2042: p_table_name => 'AR_PAYMENT_SCHEDULES',
2043: p_mode => 'BATCH',
2044: p_key_value_list => l_ar_ps_key_value_list);
2045:
2046: arp_standard.debug('arp_confirmation.reverse_application_to_ps()-');

Line 2672: l_receipt_ps_rec ar_payment_schedules%ROWTYPE;

2668: p_closed_date DATE,
2669: p_closed_gl_date DATE
2670: ) IS
2671:
2672: l_receipt_ps_rec ar_payment_schedules%ROWTYPE;
2673: l_dummy NUMBER;
2674:
2675: BEGIN
2676:

Line 2682: FROM ar_payment_schedules

2678: -- Fetch receipt's payment schedule record:
2679:
2680: SELECT *
2681: INTO l_receipt_ps_rec
2682: FROM ar_payment_schedules
2683: WHERE cash_receipt_id = p_cr_rec.cash_receipt_id;
2684:
2685:
2686: -- set confirmed flag to 'N' to mark receipt as unconfirmed: