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 103: arp_ps_pkg.fetch_p( p_app_rec.ps_id, l_ps_rec );

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

Line 248: arp_ps_pkg.update_p( l_ps_rec );

244: NVL( l_ps_rec.discount_taken_unearned, 0 ) +
245: NVL( p_app_rec.unearned_discount_taken, 0 );
246: END IF;
247:
248: arp_ps_pkg.update_p( l_ps_rec );
249:
250: IF PG_DEBUG in ('Y', 'C') THEN
251: arp_debug.debug( 'arp_ps_util.update_reverse_actions()-' );
252: 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_debug.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 401: arp_ps_pkg.fetch_p( p_ps_id, l_ps_rec );

397: p_apply_date, p_gl_date );
398: ELSE
399: validate_args_upd_rel_cols( p_ps_id, p_amount_applied,
400: p_apply_date, p_gl_date );
401: arp_ps_pkg.fetch_p( p_ps_id, l_ps_rec );
402: END IF;
403: --
404: -- Call acctd. amount package, to calculate new ADR, acctd_ADR and
405: -- acctd. amount applied. The acctd. amount applied directly updates OUT NOCOPY

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

525: -- Do not CALL the table handler as this will cause the mrc
526: -- data to be updated. The mrc data is needed for processing
527: -- Receivable applications information. Instead we will do
528: -- a direct update of changed columns.
529: -- arp_ps_pkg.update_p( l_ps_rec );
530: --
531: /* Bug fix 3583503
532: gl_date and receipt_confirmed_flag also needs to be updated */
533: /* Bug fix 3721519

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

530: --
531: /* Bug fix 3583503
532: gl_date and receipt_confirmed_flag also needs to be updated */
533: /* Bug fix 3721519
534: The WHO columns should be updated as in arp_ps_pkg.update_p */
535:
536: /* Bug 5569488, do not update payment schedule if the receipt requires
537: confirmation. Added the If condition */
538: IF NVL(l_ps_rec.receipt_confirmed_flag,'Y') <> 'N' THEN

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

681: | receivable charges |
682: | |
683: | EXTERNAL PROCEDURES/FUNCTION |
684: | arp_util.calc_acctd_amount and arp_debug.debug |
685: | arp_ps_pkg.fetch_p and arp_ps_pkg.update_p |
686: | |
687: | NOTES - Also Calls populate_closed_dates. This procedure is in this file. |
688: | |
689: | HISTORY - Created By - Ganesh Vaidee - 08/24/1995 |

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

823: | receivable charges |
824: | |
825: | EXTERNAL PROCEDURES/FUNCTION |
826: | arp_util.calc_acctd_amount and arp_debug.debug |
827: | arp_ps_pkg.fetch_p and arp_ps_pkg.update_p |
828: | |
829: | NOTES - Also Calls populate_closed_dates. This procedure is in this file. |
830: | |
831: | HISTORY - Created By - Ganesh Vaidee - 08/24/1995 |

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

957: p_amount_applied,
958: p_discount_taken_earned,
959: p_discount_taken_unearned,
960: p_apply_date, p_gl_date );
961: arp_ps_pkg.fetch_p( p_ps_id, l_ps_rec );
962: END IF;
963:
964: -- Bug 13543605. Extracting the value of overapplication flag of the transaction.
965: BEGIN

Line 1323: arp_ps_pkg.update_p( l_ps_rec );

1319: from ar_payment_schedules_all
1320: where cash_receipt_id = p_ps_rec.cash_receipt_id ;
1321: END IF ;
1322: IF NVL(l_receipt_confirmed_flag,'Y') <> 'N' THEN
1323: arp_ps_pkg.update_p( l_ps_rec );
1324: END IF ;
1325: --
1326:
1327: -- Populate out variables( 'applied and 'accounted' )

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

1470: | table |
1471: | |
1472: | EXTERNAL PROCEDURES/FUNCTION |
1473: | arp_util.calc_acctd_amount and arp_debug.debug |
1474: | arp_ps_pkg.fetch_p and arp_ps_pkg.update_p |
1475: | |
1476: | NOTES - Also Calls populate_closed_dates. This procedure is in this file. |
1477: | |
1478: | HISTORY - Created By - Ganesh Vaidee - 08/24/1995 |

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

1528: p_apply_date, p_gl_date );
1529: ELSE
1530: validate_args_upd_rel_cols( p_ps_id, p_amount_applied,
1531: p_apply_date, p_gl_date );
1532: arp_ps_pkg.fetch_p( p_ps_id, l_ps_rec );
1533: END IF;
1534: --
1535: -- Call acctd. amount package to get acctd. amounts. and new ADR.
1536: -- Note: This procedure populates the OUT NOCOPY variable

Line 1603: arp_ps_pkg.update_p( l_ps_rec );

1599: arp_ps_util.populate_closed_dates( p_gl_date, p_apply_date, 'CM', l_ps_rec );
1600: --
1601: -- Update PS record
1602: --
1603: arp_ps_pkg.update_p( l_ps_rec );
1604: --
1605: IF PG_DEBUG in ('Y', 'C') THEN
1606: arp_debug.debug( 'arp_ps_util.update_cm_related_columns()-' );
1607: END IF;

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

1648: | p_freight_adjusted - freight adjusted - In case of INVOICE adj.|
1649: | |
1650: | EXTERNAL PROCEDURES/FUNCTION |
1651: | arp_util.calc_acctd_amount and arp_debug.debug |
1652: | arp_ps_pkg.fetch_p and arp_ps_pkg.update_p |
1653: | |
1654: | NOTES - Also Calls populate_closed_dates. This procedure is in this file. |
1655: | At present this is an overloaded procedure |
1656: |

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

1741: validate_args_upd_adj_rel_cols( l_ps_rec.payment_schedule_id,
1742: p_apply_date, p_gl_date );
1743: ELSE
1744: validate_args_upd_adj_rel_cols( p_ps_id, p_apply_date, p_gl_date );
1745: arp_ps_pkg.fetch_p( p_ps_id, l_ps_rec );
1746: END IF;
1747:
1748:
1749: IF ( p_type = 'INVOICE' ) THEN

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

2064: | p_amount_adjusted_pending - Amount adjsuted pending if any. |
2065: | |
2066: | EXTERNAL PROCEDURES/FUNCTION |
2067: | arp_util.calc_acctd_amount and arp_debug.debug |
2068: | arp_ps_pkg.fetch_p and arp_ps_pkg.update_p |
2069: | |
2070: | NOTES - Also Calls populate_closed_dates. This procedure is in this file. |
2071: | |
2072: | HISTORY - Created By - Ganesh Vaidee - 08/24/1995 |

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

2133: p_tax_adjusted, p_freight_adjusted,
2134: p_charges_adjusted,
2135: p_amount_adjusted_pending,
2136: p_apply_date, p_gl_date );
2137: arp_ps_pkg.fetch_p( p_ps_id, l_ps_rec );
2138: END IF;
2139: --
2140:
2141: l_amount_adjusted := NVL( p_line_adjusted, 0 ) +

Line 2211: arp_ps_pkg.update_p( l_ps_rec );

2207: arp_ps_util.populate_closed_dates( p_gl_date, p_apply_date, 'ADJ', l_ps_rec );
2208: --
2209: -- Update PS record
2210: --
2211: arp_ps_pkg.update_p( l_ps_rec );
2212: --
2213:
2214: --ajay assigning back the value to p_ps_rec as it has been made a IN OUT
2215: p_ps_rec := l_ps_rec;