DBA Data[Home] [Help]

APPS.ARP_PS_PKG dependencies on AR_PAYMENT_SCHEDULES

Line 28: PROCEDURE dump_debug (p_ps_rec IN ar_payment_schedules%ROWTYPE);

24: pg_set_of_books_id number;
25:
26: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
27:
28: PROCEDURE dump_debug (p_ps_rec IN ar_payment_schedules%ROWTYPE);
29:
30: /*===========================================================================+
31: | PROCEDURE |
32: | set_to_dummy |

Line 62: PROCEDURE set_to_dummy( p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE ) IS

58: | staged_dunning_level |
59: | into the table handlers. |
60: |20-Jun-02 Sahana Bug2427456 : Added global attribute columns |
61: +===========================================================================*/
62: PROCEDURE set_to_dummy( p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE ) IS
63: BEGIN
64: IF PG_DEBUG in ('Y', 'C') THEN
65: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.set_to_dummy' );
66: END IF;

Line 199: | This function inserts a row into AR_PAYMENT_SCHEDULES table |

195: | PROCEDURE |
196: | insert_p |
197: | |
198: | DESCRIPTION |
199: | This function inserts a row into AR_PAYMENT_SCHEDULES table |
200: | |
201: | SCOPE - PUBLIC |
202: | |
203: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 230: | to ar_payment_schedules |

226: | staged_dunning_level |
227: | into the table handlers. |
228: | 04-Feb-2001 Debbie Jancis Modified for MRC Trigger Replacement project |
229: | added calls to ar_mrc_engine for inserts |
230: | to ar_payment_schedules |
231: |20-Jun-02 Sahana Bug2427456 : Added global attribute columns |
232: +===========================================================================*/
233: PROCEDURE insert_p( p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE,
234: p_ps_id OUT NOCOPY ar_payment_schedules.payment_schedule_id%TYPE ) IS

Line 233: PROCEDURE insert_p( p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE,

229: | added calls to ar_mrc_engine for inserts |
230: | to ar_payment_schedules |
231: |20-Jun-02 Sahana Bug2427456 : Added global attribute columns |
232: +===========================================================================*/
233: PROCEDURE insert_p( p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE,
234: p_ps_id OUT NOCOPY ar_payment_schedules.payment_schedule_id%TYPE ) IS
235: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
236: BEGIN
237: IF PG_DEBUG in ('Y', 'C') THEN

Line 234: p_ps_id OUT NOCOPY ar_payment_schedules.payment_schedule_id%TYPE ) IS

230: | to ar_payment_schedules |
231: |20-Jun-02 Sahana Bug2427456 : Added global attribute columns |
232: +===========================================================================*/
233: PROCEDURE insert_p( p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE,
234: p_ps_id OUT NOCOPY ar_payment_schedules.payment_schedule_id%TYPE ) IS
235: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
236: BEGIN
237: IF PG_DEBUG in ('Y', 'C') THEN
238: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.insert_p()+');

Line 235: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;

231: |20-Jun-02 Sahana Bug2427456 : Added global attribute columns |
232: +===========================================================================*/
233: PROCEDURE insert_p( p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE,
234: p_ps_id OUT NOCOPY ar_payment_schedules.payment_schedule_id%TYPE ) IS
235: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
236: BEGIN
237: IF PG_DEBUG in ('Y', 'C') THEN
238: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.insert_p()+');
239: END IF;

Line 241: SELECT ar_payment_schedules_s.nextval

237: IF PG_DEBUG in ('Y', 'C') THEN
238: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.insert_p()+');
239: END IF;
240:
241: SELECT ar_payment_schedules_s.nextval
242: INTO l_ps_id
243: FROM dual;
244:
245: p_ps_rec.created_by := FND_GLOBAL.user_id;

Line 249: INSERT INTO ar_payment_schedules (

245: p_ps_rec.created_by := FND_GLOBAL.user_id;
246: p_ps_rec.last_updated_by := FND_GLOBAL.user_id;
247: -- p_ps_rec.created_from := 'XXXXXXX';
248: --
249: INSERT INTO ar_payment_schedules (
250: payment_schedule_id,
251: acctd_amount_due_remaining,
252: amount_due_original,
253: amount_due_remaining,

Line 516: p_table_name => 'AR_PAYMENT_SCHEDULES',

512: END IF;
513:
514: ar_mrc_engine.maintain_mrc_data(
515: p_event_mode => 'INSERT',
516: p_table_name => 'AR_PAYMENT_SCHEDULES',
517: p_mode => 'SINGLE',
518: p_key_value => p_ps_id);
519:
520: IF PG_DEBUG in ('Y', 'C') THEN

Line 537: | This function updates a row into AR_PAYMENT_SCHEDULES table |

533: | PROCEDURE |
534: | update_p |
535: | |
536: | DESCRIPTION |
537: | This function updates a row into AR_PAYMENT_SCHEDULES table |
538: | New update_p that does need a PS row to be fetched before upddating |
539: | |
540: | SCOPE - PUBLIC |
541: | |

Line 567: PROCEDURE update_p( p_ps_rec IN ar_payment_schedules%ROWTYPE,

563: | into the table handlers. |
564: | 04-Feb-2001 Debbie Jancis Modified for MRC trigger replacement project |
565: | 20-Jun-02 Sahana Bug2427456 : Added global attribute columns |
566: +===========================================================================*/
567: PROCEDURE update_p( p_ps_rec IN ar_payment_schedules%ROWTYPE,
568: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE ) IS
569: /*Adding cursor as part of bug fix 5129946*/
570: CURSOR get_existing_ps (p_ps_id IN NUMBER) IS
571: SELECT payment_schedule_id,

Line 568: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE ) IS

564: | 04-Feb-2001 Debbie Jancis Modified for MRC trigger replacement project |
565: | 20-Jun-02 Sahana Bug2427456 : Added global attribute columns |
566: +===========================================================================*/
567: PROCEDURE update_p( p_ps_rec IN ar_payment_schedules%ROWTYPE,
568: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE ) IS
569: /*Adding cursor as part of bug fix 5129946*/
570: CURSOR get_existing_ps (p_ps_id IN NUMBER) IS
571: SELECT payment_schedule_id,
572: amount_in_dispute,

Line 575: FROM ar_payment_schedules

571: SELECT payment_schedule_id,
572: amount_in_dispute,
573: amount_due_remaining,
574: dispute_date
575: FROM ar_payment_schedules
576: WHERE payment_schedule_id = p_ps_id;
577: l_old_dispute_date DATE;
578: l_new_dispute_date DATE;
579: l_old_dispute_amount NUMBER;

Line 633: UPDATE ar_payment_schedules SET

629: l_last_update_login);
630: END IF;
631: END IF;--IF get_existing_ps%ROWCOUNT>0 THEN
632: CLOSE get_existing_ps;
633: UPDATE ar_payment_schedules SET
634: acctd_amount_due_remaining =
635: DECODE( p_ps_rec.acctd_amount_due_remaining,
636: AR_NUMBER_DUMMY, acctd_amount_due_remaining,
637: p_ps_rec.acctd_amount_due_remaining ),

Line 1020: p_table_name => 'AR_PAYMENT_SCHEDULES',

1016: END IF;
1017:
1018: ar_mrc_engine.maintain_mrc_data(
1019: p_event_mode => 'UPDATE',
1020: p_table_name => 'AR_PAYMENT_SCHEDULES',
1021: p_mode => 'SINGLE',
1022: p_key_value => p_ps_rec.payment_schedule_id);
1023:
1024: IF PG_DEBUG in ('Y', 'C') THEN

Line 1041: | This function updates a row into AR_PAYMENT_SCHEDULES table |

1037: | PROCEDURE |
1038: | update_p |
1039: | |
1040: | DESCRIPTION |
1041: | This function updates a row into AR_PAYMENT_SCHEDULES table |
1042: | Old update_p that needs a PS row to be fetched before upddating |
1043: | |
1044: | SCOPE - PUBLIC |
1045: | |

Line 1071: PROCEDURE update_p( p_ps_rec IN ar_payment_schedules%ROWTYPE ) IS

1067: | into the table handlers. |
1068: | 04-Feb-2001 Debbie Jancis Modified for MRC trigger replacement |
1069: | 20-Jun-02 Sahana Bug2427456 : Added global attribute columns |
1070: +===========================================================================*/
1071: PROCEDURE update_p( p_ps_rec IN ar_payment_schedules%ROWTYPE ) IS
1072: /*Adding cursor as part of bug fix 5129946*/
1073: CURSOR get_existing_ps (p_ps_id IN NUMBER) IS
1074: SELECT payment_schedule_id,
1075: amount_in_dispute,

Line 1078: FROM ar_payment_schedules

1074: SELECT payment_schedule_id,
1075: amount_in_dispute,
1076: amount_due_remaining,
1077: dispute_date
1078: FROM ar_payment_schedules
1079: WHERE payment_schedule_id = p_ps_id;
1080: l_old_dispute_date DATE;
1081: l_new_dispute_date DATE;
1082: l_old_dispute_amount NUMBER;

Line 1125: UPDATE ar_payment_schedules SET

1121: l_last_update_login);
1122: END IF;
1123: END IF;--IF get_existing_ps%ROWCOUNT>0 THEN
1124: CLOSE get_existing_ps;
1125: UPDATE ar_payment_schedules SET
1126: acctd_amount_due_remaining =
1127: p_ps_rec.acctd_amount_due_remaining,
1128: amount_due_original = p_ps_rec.amount_due_original,
1129: amount_due_remaining = p_ps_rec.amount_due_remaining,

Line 1273: p_table_name => 'AR_PAYMENT_SCHEDULES',

1269: END IF;
1270:
1271: ar_mrc_engine.maintain_mrc_data(
1272: p_event_mode => 'UPDATE',
1273: p_table_name => 'AR_PAYMENT_SCHEDULES',
1274: p_mode => 'SINGLE',
1275: p_key_value => p_ps_rec.payment_schedule_id);
1276:
1277: IF PG_DEBUG in ('Y', 'C') THEN

Line 1295: | This function deletes a row from AR_PAYMENT_SCHEDULES table |

1291: | PROCEDURE |
1292: | delete_p |
1293: | |
1294: | DESCRIPTION |
1295: | This function deletes a row from AR_PAYMENT_SCHEDULES table |
1296: | |
1297: | SCOPE - PUBLIC |
1298: | |
1299: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 1315: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE ) IS

1311: | 04-Feb-2001 Debbie Jancis Modified for MRC trigger replacement |
1312: | |
1313: +===========================================================================*/
1314: PROCEDURE delete_p(
1315: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE ) IS
1316: BEGIN
1317: IF PG_DEBUG in ('Y', 'C') THEN
1318: arp_standard.debug('dump_debug: ' || '>>>>>>> arp_ps_pkg.delete_p' );
1319: END IF;

Line 1320: DELETE FROM ar_payment_schedules

1316: BEGIN
1317: IF PG_DEBUG in ('Y', 'C') THEN
1318: arp_standard.debug('dump_debug: ' || '>>>>>>> arp_ps_pkg.delete_p' );
1319: END IF;
1320: DELETE FROM ar_payment_schedules
1321: WHERE payment_schedule_id = p_ps_id;
1322:
1323: /*---------------------------------+
1324: | Calling central MRC library |

Line 1333: p_table_name => 'AR_PAYMENT_SCHEDULES',

1329: END IF;
1330:
1331: ar_mrc_engine.maintain_mrc_data(
1332: p_event_mode => 'DELETE',
1333: p_table_name => 'AR_PAYMENT_SCHEDULES',
1334: p_mode => 'SINGLE',
1335: p_key_value => p_ps_id);
1336:
1337: --

Line 1355: | This function deletes rows from AR_PAYMENT_SCHEDULES table |

1351: | PROCEDURE |
1352: | delete_f_ct_id |
1353: | |
1354: | DESCRIPTION |
1355: | This function deletes rows from AR_PAYMENT_SCHEDULES table |
1356: | based on the ct_id |
1357: | SCOPE - PUBLIC |
1358: | |
1359: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 1378: DELETE FROM ar_payment_schedules

1374: BEGIN
1375: IF PG_DEBUG in ('Y', 'C') THEN
1376: arp_standard.debug('dump_debug: ' || '>>>>>>> arp_ps_pkg.delete_f_ct_id' );
1377: END IF;
1378: DELETE FROM ar_payment_schedules
1379: WHERE customer_trx_id = p_ct_id
1380: RETURNING payment_schedule_id
1381: BULK COLLECT INTO l_ps_key_value_list;
1382:

Line 1393: p_table_name => 'AR_PAYMENT_SCHEDULES',

1389: arp_standard.debug('dump_debug: ' || 'calling mrc engine for delete of ps');
1390: END IF;
1391: ar_mrc_engine.maintain_mrc_data(
1392: p_event_mode => 'DELETE',
1393: p_table_name => 'AR_PAYMENT_SCHEDULES',
1394: p_mode => 'BATCH',
1395: p_key_value_list => l_ps_key_value_list);
1396: --
1397: IF PG_DEBUG in ('Y', 'C') THEN

Line 1414: | This function fetches a row from AR_PAYMENT_SCHEDULES table |

1410: | PROCEDURE |
1411: | fetch_p |
1412: | |
1413: | DESCRIPTION |
1414: | This function fetches a row from AR_PAYMENT_SCHEDULES table |
1415: | |
1416: | SCOPE - PUBLIC |
1417: | |
1418: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 1432: PROCEDURE fetch_p( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

1428: | |
1429: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
1430: | |
1431: +===========================================================================*/
1432: PROCEDURE fetch_p( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
1433: p_ps_rec OUT NOCOPY ar_payment_schedules%ROWTYPE ) IS
1434: BEGIN
1435: IF PG_DEBUG in ('Y', 'C') THEN
1436: arp_standard.debug('dump_debug: ' || '>>>>>>> arp_ps_pkg.fetch_p' );

Line 1433: p_ps_rec OUT NOCOPY ar_payment_schedules%ROWTYPE ) IS

1429: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
1430: | |
1431: +===========================================================================*/
1432: PROCEDURE fetch_p( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
1433: p_ps_rec OUT NOCOPY ar_payment_schedules%ROWTYPE ) IS
1434: BEGIN
1435: IF PG_DEBUG in ('Y', 'C') THEN
1436: arp_standard.debug('dump_debug: ' || '>>>>>>> arp_ps_pkg.fetch_p' );
1437: END IF;

Line 1441: FROM ar_payment_schedules

1437: END IF;
1438: --
1439: SELECT *
1440: INTO p_ps_rec
1441: FROM ar_payment_schedules
1442: WHERE payment_schedule_id = p_ps_id;
1443: --
1444: IF PG_DEBUG in ('Y', 'C') THEN
1445: arp_standard.debug('dump_debug: ' || '<<<<<<< arp_ps_pkg.fetch_p' );

Line 1461: | This function fetches a row from AR_PAYMENT_SCHEDULES table |

1457: | PROCEDURE |
1458: | fetch_fk_cr_id |
1459: | |
1460: | DESCRIPTION |
1461: | This function fetches a row from AR_PAYMENT_SCHEDULES table |
1462: | using cash receipt id |
1463: | |
1464: | SCOPE - PUBLIC |
1465: | |

Line 1481: p_ps_rec OUT NOCOPY ar_payment_schedules%ROWTYPE ) IS

1477: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
1478: | |
1479: +===========================================================================*/
1480: PROCEDURE fetch_fk_cr_id( p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1481: p_ps_rec OUT NOCOPY ar_payment_schedules%ROWTYPE ) IS
1482: BEGIN
1483: IF PG_DEBUG in ('Y', 'C') THEN
1484: arp_standard.debug('dump_debug: ' || '>>>>>>> arp_ps_pkg.fetch_p' );
1485: END IF;

Line 1489: FROM ar_payment_schedules

1485: END IF;
1486: --
1487: SELECT *
1488: INTO p_ps_rec
1489: FROM ar_payment_schedules
1490: WHERE cash_receipt_id = p_cr_id;
1491: --
1492: IF PG_DEBUG in ('Y', 'C') THEN
1493: arp_standard.debug('dump_debug: ' || '<<<<<<< arp_ps_pkg.fetch_p' );

Line 1509: | This function locks a row in AR_PAYMENT_SCHEDULES table |

1505: | PROCEDURE |
1506: | lock_p |
1507: | |
1508: | DESCRIPTION |
1509: | This function locks a row in AR_PAYMENT_SCHEDULES table |
1510: | |
1511: | SCOPE - PUBLIC |
1512: | |
1513: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 1533: PROCEDURE lock_p( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE ) IS

1529: | Adding these changes caused Adjustment Form |
1530: | (ARXTWADJ) to behave indifferently. |
1531: | |
1532: +===========================================================================*/
1533: PROCEDURE lock_p( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE ) IS
1534: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
1535: BEGIN
1536: IF PG_DEBUG in ('Y', 'C') THEN
1537: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.lock_p()+' );

Line 1534: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;

1530: | (ARXTWADJ) to behave indifferently. |
1531: | |
1532: +===========================================================================*/
1533: PROCEDURE lock_p( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE ) IS
1534: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
1535: BEGIN
1536: IF PG_DEBUG in ('Y', 'C') THEN
1537: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.lock_p()+' );
1538: END IF;

Line 1542: FROM ar_payment_schedules ps

1538: END IF;
1539:
1540: SELECT ps.payment_schedule_id
1541: INTO l_ps_id
1542: FROM ar_payment_schedules ps
1543: WHERE ps.payment_schedule_id = p_ps_id
1544: FOR UPDATE OF PS.STATUS NOWAIT;
1545:
1546: IF PG_DEBUG in ('Y', 'C') THEN

Line 1565: | This procedure locks the ar_payment_schedules rows identified by |

1561: | PROCEDURE |
1562: | lock_f_ct_id |
1563: | |
1564: | DESCRIPTION |
1565: | This procedure locks the ar_payment_schedules rows identified by |
1566: | p_customer_trx_id parameter. |
1567: | |
1568: | SCOPE - PUBLIC |
1569: | |

Line 1593: FROM ar_payment_schedules

1589: IS
1590:
1591: CURSOR LOCK_C IS
1592: SELECT payment_schedule_id
1593: FROM ar_payment_schedules
1594: WHERE customer_trx_id = p_customer_trx_id
1595: FOR UPDATE OF payment_schedule_id NOWAIT;
1596:
1597:

Line 1623: | This function locks a row in AR_PAYMENT_SCHEDULES table.

1619: | PROCEDURE |
1620: | NOWAITLOCK_P
1621: | |
1622: | DESCRIPTION |
1623: | This function locks a row in AR_PAYMENT_SCHEDULES table.
1624: | If the row is already locked, return normal ORA-00054 error to
1625: | indicate that row was already locked.
1626: | |
1627: | SCOPE - PUBLIC |

Line 1642: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE ) IS

1638: | MODIFICATION HISTORY
1639: | 1/26/1996 Harri Kaukovuo Created
1640: +===========================================================================*/
1641: PROCEDURE nowaitlock_p(
1642: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE ) IS
1643: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
1644: BEGIN
1645: IF PG_DEBUG in ('Y', 'C') THEN
1646: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.nowaitlock_p()+' );

Line 1643: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;

1639: | 1/26/1996 Harri Kaukovuo Created
1640: +===========================================================================*/
1641: PROCEDURE nowaitlock_p(
1642: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE ) IS
1643: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
1644: BEGIN
1645: IF PG_DEBUG in ('Y', 'C') THEN
1646: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.nowaitlock_p()+' );
1647: arp_standard.debug('dump_debug: ' || '-- Locking using payment_schedule_id = '||

Line 1656: FROM ar_payment_schedules ps

1652: IF arp_view_constants.get_ps_selected_in_batch = 'Y' THEN
1653:
1654: SELECT ps.payment_schedule_id
1655: INTO l_ps_id
1656: FROM ar_payment_schedules ps
1657: WHERE ps.payment_schedule_id = p_ps_id
1658: FOR UPDATE OF PS.STATUS NOWAIT;
1659:
1660: ELSE

Line 1664: FROM ar_payment_schedules ps

1660: ELSE
1661:
1662: SELECT ps.payment_schedule_id
1663: INTO l_ps_id
1664: FROM ar_payment_schedules ps
1665: WHERE ps.payment_schedule_id = p_ps_id
1666: AND ps.selected_for_receipt_batch_id IS NULL /* Bug fix 3264536 */
1667: FOR UPDATE OF PS.STATUS NOWAIT;
1668:

Line 1690: | This function locks a row in AR_PAYMENT_SCHEDULES table.

1686: | PROCEDURE |
1687: | NOWAITLOCK_COMPARE_P
1688: | |
1689: | DESCRIPTION |
1690: | This function locks a row in AR_PAYMENT_SCHEDULES table.
1691: | If the row is already locked, return normal ORA-00054 error to
1692: | indicate that row was already locked.
1693: | This procedure will check also that amount_due_remaining is
1694: | not changed.

Line 1726: FROM ar_payment_schedules ps

1722: END IF;
1723:
1724: SELECT ps.payment_schedule_id
1725: INTO l_ps_id
1726: FROM ar_payment_schedules ps
1727: WHERE ps.payment_schedule_id = p_ps_id
1728: AND ps.amount_due_remaining = decode(ps.class,'PMT',ps.amount_due_remaining,p_amount_due_remaining)
1729: FOR UPDATE OF PS.amount_due_remaining NOWAIT;
1730:

Line 1757: p_ps_rec IN ar_payment_schedules%ROWTYPE)

1753:
1754:
1755:
1756: PROCEDURE dump_debug (
1757: p_ps_rec IN ar_payment_schedules%ROWTYPE)
1758: IS
1759: BEGIN
1760: IF PG_DEBUG in ('Y', 'C') THEN
1761: arp_standard.debug ('dump_debug: ' || '-- DUMP OF PARAMETER VALUES:');