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.ARP_PS_UTIL dependencies on ARP_PS_PKG

Line 63: | arp_ps_pkg.update_p - Update a row in AR_PAYMENT_SCHEDULES table |

59: | |
60: | SCOPE - PUBLIC |
61: | |
62: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - |
63: | arp_ps_pkg.update_p - Update a row in AR_PAYMENT_SCHEDULES table |
64: | arp_ps_pkg.fetch_p - fetch a row in AR_PAYMENT_SCHEDULES table |
65: | |
66: | ARGUMENTS : IN: |
67: | p_app_rec - Application Record structure |

Line 64: | arp_ps_pkg.fetch_p - fetch a row in AR_PAYMENT_SCHEDULES table |

60: | SCOPE - PUBLIC |
61: | |
62: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - |
63: | arp_ps_pkg.update_p - Update a row in AR_PAYMENT_SCHEDULES table |
64: | arp_ps_pkg.fetch_p - fetch a row in AR_PAYMENT_SCHEDULES table |
65: | |
66: | ARGUMENTS : IN: |
67: | p_app_rec - Application Record structure |
68: | p_module_name _ Name of module that called this procedure|

Line 104: arp_ps_pkg.fetch_p( p_app_rec.ps_id, l_ps_rec );

100:
101: --
102: -- Update payment schedule table
103: --
104: arp_ps_pkg.fetch_p( p_app_rec.ps_id, l_ps_rec );
105:
106: l_ps_rec.amount_due_remaining := NVL( l_ps_rec.amount_due_remaining, 0) -
107: NVL( p_app_rec.amount_applied, 0 ) -
108: NVL( p_app_rec.earned_discount_taken, 0 ) -

Line 249: arp_ps_pkg.update_p( l_ps_rec );

245: NVL( l_ps_rec.discount_taken_unearned, 0 ) +
246: NVL( p_app_rec.unearned_discount_taken, 0 );
247: END IF;
248:
249: arp_ps_pkg.update_p( l_ps_rec );
250:
251: IF PG_DEBUG in ('Y', 'C') THEN
252: arp_util.debug('val_update_rev_actions: ' || 'arp_ps_util.update_reverse_actions()-' );
253: END IF;

Line 336: | arp_ps_pkg.fetch_p and arp_ps_pkg.update_p |

332: | populate acctd_amount_applied_from in AR_RA table |
333: | |
334: | EXTERNAL PROCEDURES/FUNCTION |
335: | arp_util.calc_acctd_amount and arp_util.debug |
336: | arp_ps_pkg.fetch_p and arp_ps_pkg.update_p |
337: | |
338: | NOTES - Also Calls populate_closed_dates. This procedure is in this file. |
339: | |
340: | HISTORY - Created By - Ganesh Vaidee - 08/24/1995 |

Line 383: arp_ps_pkg.fetch_p( p_ps_id, l_ps_rec );

379: p_apply_date, p_gl_date );
380: ELSE
381: validate_args_upd_rel_cols( p_ps_id, p_amount_applied,
382: p_apply_date, p_gl_date );
383: arp_ps_pkg.fetch_p( p_ps_id, l_ps_rec );
384: END IF;
385: --
386: -- Call acctd. amount package, to calculate new ADR, acctd_ADR and
387: -- acctd. amount applied. The acctd. amount applied directly updates OUT NOCOPY

Line 429: -- arp_ps_pkg.update_p( l_ps_rec );

425: -- Do not CALL the table handler as this will cause the mrc
426: -- data to be updated. The mrc data is needed for processing
427: -- Receivable applications information. Instead we will do
428: -- a direct update of changed columns.
429: -- arp_ps_pkg.update_p( l_ps_rec );
430: --
431: /* Bug fix 3583503
432: gl_date and receipt_confirmed_flag also needs to be updated */
433: /* Bug fix 3721519

Line 434: The WHO columns should be updated as in arp_ps_pkg.update_p */

430: --
431: /* Bug fix 3583503
432: gl_date and receipt_confirmed_flag also needs to be updated */
433: /* Bug fix 3721519
434: The WHO columns should be updated as in arp_ps_pkg.update_p */
435:
436: /* Bug 5569488, do not update payment schedule if the receipt requires
437: confirmation. Added the If condition */
438: IF NVL(l_ps_rec.receipt_confirmed_flag,'Y') <> 'N' THEN

Line 580: | arp_ps_pkg.fetch_p and arp_ps_pkg.update_p |

576: | receivable charges |
577: | |
578: | EXTERNAL PROCEDURES/FUNCTION |
579: | arp_util.calc_acctd_amount and arp_util.debug |
580: | arp_ps_pkg.fetch_p and arp_ps_pkg.update_p |
581: | |
582: | NOTES - Also Calls populate_closed_dates. This procedure is in this file. |
583: | |
584: | HISTORY - Created By - Ganesh Vaidee - 08/24/1995 |

Line 722: | arp_ps_pkg.fetch_p and arp_ps_pkg.update_p |

718: | receivable charges |
719: | |
720: | EXTERNAL PROCEDURES/FUNCTION |
721: | arp_util.calc_acctd_amount and arp_util.debug |
722: | arp_ps_pkg.fetch_p and arp_ps_pkg.update_p |
723: | |
724: | NOTES - Also Calls populate_closed_dates. This procedure is in this file. |
725: | |
726: | HISTORY - Created By - Ganesh Vaidee - 08/24/1995 |

Line 856: arp_ps_pkg.fetch_p( p_ps_id, l_ps_rec );

852: p_amount_applied,
853: p_discount_taken_earned,
854: p_discount_taken_unearned,
855: p_apply_date, p_gl_date );
856: arp_ps_pkg.fetch_p( p_ps_id, l_ps_rec );
857: END IF;
858: --
859: -- Init. temp. variables
860: --

Line 1196: arp_ps_pkg.update_p( l_ps_rec );

1192: from ar_payment_schedules_all
1193: where cash_receipt_id = p_ps_rec.cash_receipt_id ;
1194: END IF ;
1195: IF NVL(l_receipt_confirmed_flag,'Y') <> 'N' THEN
1196: arp_ps_pkg.update_p( l_ps_rec );
1197: END IF ;
1198: --
1199:
1200: -- Populate out variables( 'applied and 'accounted' )

Line 1344: | arp_ps_pkg.fetch_p and arp_ps_pkg.update_p |

1340: | table |
1341: | |
1342: | EXTERNAL PROCEDURES/FUNCTION |
1343: | arp_util.calc_acctd_amount and arp_util.debug |
1344: | arp_ps_pkg.fetch_p and arp_ps_pkg.update_p |
1345: | |
1346: | NOTES - Also Calls populate_closed_dates. This procedure is in this file. |
1347: | |
1348: | HISTORY - Created By - Ganesh Vaidee - 08/24/1995 |

Line 1402: arp_ps_pkg.fetch_p( p_ps_id, l_ps_rec );

1398: p_apply_date, p_gl_date );
1399: ELSE
1400: validate_args_upd_rel_cols( p_ps_id, p_amount_applied,
1401: p_apply_date, p_gl_date );
1402: arp_ps_pkg.fetch_p( p_ps_id, l_ps_rec );
1403: END IF;
1404: --
1405: -- Call acctd. amount package to get acctd. amounts. and new ADR.
1406: -- Note: This procedure populates the OUT NOCOPY variable

Line 1473: arp_ps_pkg.update_p( l_ps_rec );

1469: arp_ps_util.populate_closed_dates( p_gl_date, p_apply_date, 'CM', l_ps_rec );
1470: --
1471: -- Update PS record
1472: --
1473: arp_ps_pkg.update_p( l_ps_rec );
1474: --
1475: IF PG_DEBUG in ('Y', 'C') THEN
1476: arp_util.debug( 'arp_ps_util.update_cm_related_columns()-' );
1477: END IF;

Line 1522: | arp_ps_pkg.fetch_p and arp_ps_pkg.update_p |

1518: | p_freight_adjusted - freight adjusted - In case of INVOICE adj.|
1519: | |
1520: | EXTERNAL PROCEDURES/FUNCTION |
1521: | arp_util.calc_acctd_amount and arp_util.debug |
1522: | arp_ps_pkg.fetch_p and arp_ps_pkg.update_p |
1523: | |
1524: | NOTES - Also Calls populate_closed_dates. This procedure is in this file. |
1525: | At present this is an overloaded procedure |
1526: |

Line 1615: arp_ps_pkg.fetch_p( p_ps_id, l_ps_rec );

1611: validate_args_upd_adj_rel_cols( l_ps_rec.payment_schedule_id,
1612: p_apply_date, p_gl_date );
1613: ELSE
1614: validate_args_upd_adj_rel_cols( p_ps_id, p_apply_date, p_gl_date );
1615: arp_ps_pkg.fetch_p( p_ps_id, l_ps_rec );
1616: END IF;
1617:
1618:
1619: IF ( p_type = 'INVOICE' ) THEN

Line 1938: | arp_ps_pkg.fetch_p and arp_ps_pkg.update_p |

1934: | p_amount_adjusted_pending - Amount adjsuted pending if any. |
1935: | |
1936: | EXTERNAL PROCEDURES/FUNCTION |
1937: | arp_util.calc_acctd_amount and arp_util.debug |
1938: | arp_ps_pkg.fetch_p and arp_ps_pkg.update_p |
1939: | |
1940: | NOTES - Also Calls populate_closed_dates. This procedure is in this file. |
1941: | |
1942: | HISTORY - Created By - Ganesh Vaidee - 08/24/1995 |

Line 2007: arp_ps_pkg.fetch_p( p_ps_id, l_ps_rec );

2003: p_tax_adjusted, p_freight_adjusted,
2004: p_charges_adjusted,
2005: p_amount_adjusted_pending,
2006: p_apply_date, p_gl_date );
2007: arp_ps_pkg.fetch_p( p_ps_id, l_ps_rec );
2008: END IF;
2009: --
2010:
2011: l_amount_adjusted := NVL( p_line_adjusted, 0 ) +

Line 2081: arp_ps_pkg.update_p( l_ps_rec );

2077: arp_ps_util.populate_closed_dates( p_gl_date, p_apply_date, 'ADJ', l_ps_rec );
2078: --
2079: -- Update PS record
2080: --
2081: arp_ps_pkg.update_p( l_ps_rec );
2082: --
2083:
2084: --ajay assigning back the value to p_ps_rec as it has been made a IN OUT
2085: p_ps_rec := l_ps_rec;