DBA Data[Home] [Help]

APPS.ARP_PROCESS_APPLICATION dependencies on ARP_PS_UTIL

Line 1231: | arp_ps_util.get_closed_dates Calculate and get closed dates |

1227: | SCOPE - PRIVATE |
1228: | |
1229: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1230: | ARCUPSS.pls |
1231: | arp_ps_util.get_closed_dates Calculate and get closed dates |
1232: | update Payment Schedule table |
1233: | |
1234: | ARGUMENTS : IN: |
1235: | p_ra_rec - Receivables application record |

Line 1263: | arp_ps_util.update_reverse_actions

1259: | instead of "AR_APP" which is not correct
1260: | for the Credit Memo case.
1261: | The value of AR_APP was causing incorrect
1262: | processing in
1263: | arp_ps_util.update_reverse_actions
1264: | for the Credit Memo case.
1265: | 15-Mar-97 Karen Lawrance Bug fix #493379. Set values for lines, tax
1266: | freight and charges for the Credit Memo
1267: | case. Should not be negative like the

Line 1308: arp_ps_util.get_closed_dates( p_ra_rec.applied_payment_schedule_id,

1304: --------------------------------------------------------------------------
1305:
1306: -- Determine gl_date_closed and actual_date_closed for the transaction payment
1307: -- schedule.
1308: arp_ps_util.get_closed_dates( p_ra_rec.applied_payment_schedule_id,
1309: p_reversal_gl_date,
1310: p_reversal_date,
1311: l_gl_date_closed,
1312: l_actual_date_closed, 'INV' );

Line 1351: arp_ps_util.update_reverse_actions(l_app_rec, NULL, NULL);

1347: /* 06-JUL-2000 J Rautiainen BR Implementation
1348: * Transaction payment schedule not updated for activity application */
1349: IF p_ra_rec.status NOT IN ('OTHER ACC', 'ACTIVITY') THEN
1350:
1351: arp_ps_util.update_reverse_actions(l_app_rec, NULL, NULL);
1352:
1353: END IF;
1354:
1355: --------------------------------------------------------------------------

Line 1398: arp_ps_util.get_closed_dates( l_app_rec.ps_id,

1394: ' / ' || p_reversal_date);
1395:
1396: /* 9313440 - get actual_date_closed and gl_date_closed
1397: for the CM based on its own PS row */
1398: arp_ps_util.get_closed_dates( l_app_rec.ps_id,
1399: p_reversal_gl_date,
1400: p_reversal_date,
1401: l_gl_date_closed,
1402: l_actual_date_closed, 'CM' );

Line 1422: arp_ps_util.get_closed_dates( l_app_rec.ps_id,

1418:
1419: arp_debug.debug('pmt proposed dates (gl/act):' || p_reversal_gl_date ||
1420: ' / ' || p_reversal_date);
1421:
1422: arp_ps_util.get_closed_dates( l_app_rec.ps_id,
1423: p_reversal_gl_date,
1424: p_reversal_date,
1425: l_gl_date_closed,
1426: l_actual_date_closed, 'CASH' );

Line 1438: arp_ps_util.update_reverse_actions(l_app_rec, NULL, NULL);

1434:
1435: --
1436: -- Call the payment schedule utility package to update the source.
1437: --
1438: arp_ps_util.update_reverse_actions(l_app_rec, NULL, NULL);
1439:
1440: IF PG_DEBUG in ('Y', 'C') THEN
1441: arp_debug.debug( 'arp_process_application.reversal_update_ps_recs()-');
1442: END IF;

Line 2763: | arp_ps_util.get_closed_dates - Calculate and get closed dates |

2759: | arp_process_chargeback.reverse_chargeback - Procedure to reverse |
2760: | a chargeback |
2761: | arp_process_adjustments.reverse_adjustments- Procedure to reverse |
2762: | a adjustment |
2763: | arp_ps_util.get_closed_dates - Calculate and get closed dates |
2764: | |
2765: | ARGUMENTS : IN: |
2766: | p_ra_id - receivable application id |
2767: | p_cr_id - Cash receipt Id |

Line 3044: arp_ps_util.get_closed_dates( l_ps_id,

3040: END IF;
3041: --
3042: -- Get closed dates to update payment schedule table
3043: --
3044: arp_ps_util.get_closed_dates( l_ps_id,
3045: p_reversal_gl_date, p_reversal_date,
3046: l_app_rec.gl_date_closed,
3047: l_app_rec.actual_date_closed, 'PMT' );
3048: --

Line 3056: arp_ps_util.update_reverse_actions( l_app_rec, NULL, NULL );

3052: --
3053: IF PG_DEBUG in ('Y', 'C') THEN
3054: arp_debug.debug( 'before update_reverse_actions in app_delete' );
3055: END IF;
3056: arp_ps_util.update_reverse_actions( l_app_rec, NULL, NULL );
3057: --
3058: IF PG_DEBUG in ('Y', 'C') THEN
3059: arp_debug.debug( 'arp_process_application.reverse_action()-' );
3060: END IF;

Line 3148: | arp_ps_util.update_invoice_related_columns |

3144: | |
3145: | SCOPE - PUBLIC |
3146: | |
3147: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED - |
3148: | arp_ps_util.update_invoice_related_columns |
3149: | arp_ps_util.update_cm_related_columns |
3150: | |
3151: | ARGUMENTS : IN: |
3152: | p_receipt_ps_id - PS Id of the receipt |

Line 3149: | arp_ps_util.update_cm_related_columns |

3145: | SCOPE - PUBLIC |
3146: | |
3147: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED - |
3148: | arp_ps_util.update_invoice_related_columns |
3149: | arp_ps_util.update_cm_related_columns |
3150: | |
3151: | ARGUMENTS : IN: |
3152: | p_receipt_ps_id - PS Id of the receipt |
3153: | p_invoice_ps_id - PS Id of the transaction |

Line 3801: arp_ps_util.update_receipt_related_columns(

3797: FROM ar_payment_schedules ps
3798: WHERE ps.payment_schedule_id = p_invoice_ps_id;
3799: -- Bug 6924942 - End
3800:
3801: arp_ps_util.update_receipt_related_columns(
3802: p_receipt_ps_id,
3803: nvl(p_amount_applied_from, p_amount_applied),
3804: p_apply_date,
3805: p_gl_date,

Line 3940: arp_ps_util.update_invoice_related_columns(

3936: IF NULL_VAR.cash_receipt_id IS NULL AND NVL(p_called_from,'NONE') = 'AUTORECAPI' THEN
3937: NULL_VAR.cash_receipt_id := l_rec_ra_rec.cash_receipt_id ;
3938: END IF ;
3939:
3940: arp_ps_util.update_invoice_related_columns(
3941: 'CASH',
3942: p_invoice_ps_id,
3943: p_amount_applied,
3944: p_earned_discount_taken,

Line 4584: | arp_ps_util.update_invoice_related_columns |

4580: | |
4581: | SCOPE - PUBLIC |
4582: | |
4583: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - |
4584: | arp_ps_util.update_invoice_related_columns |
4585: | arp_ps_util.update_cm_related_columns |
4586: | |
4587: | ARGUMENTS : IN: |
4588: | p_cm_ps_id - PS Id of the Credit Memo |

Line 4585: | arp_ps_util.update_cm_related_columns |

4581: | SCOPE - PUBLIC |
4582: | |
4583: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - |
4584: | arp_ps_util.update_invoice_related_columns |
4585: | arp_ps_util.update_cm_related_columns |
4586: | |
4587: | ARGUMENTS : IN: |
4588: | p_cm_ps_id - PS Id of the Credit Memo |
4589: | p_invoice_ps_id - PS Id of the transaction |

Line 4824: arp_ps_util.update_invoice_related_columns(

4820: l_inv_ra_rec.applied_customer_trx_id,
4821: l_inv_ra_rec.code_combination_id,
4822: l_source_type);
4823:
4824: arp_ps_util.update_invoice_related_columns(
4825: 'CM',
4826: p_invoice_ps_id,
4827: p_amount_applied,
4828: NULL, /* Earned discount taken */

Line 5009: arp_ps_util.update_cm_related_columns(

5005: FROM RA_CUSTOMER_TRX
5006: WHERE CUSTOMER_TRX_ID=l_inv_ra_rec.customer_trx_id;
5007:
5008: IF l_upgrade_flag = 'R12_MERGE' THEN
5009: arp_ps_util.update_cm_related_columns(
5010: p_cm_ps_id,
5011: p_amount_applied,
5012: l_inv_ra_rec.line_applied,
5013: l_inv_ra_rec.tax_applied,

Line 5021: arp_ps_util.update_cm_related_columns(

5017: p_gl_date,
5018: l_inv_ra_rec.acctd_amount_applied_from,
5019: l_cm_ps_rec );
5020: ELSE
5021: arp_ps_util.update_cm_related_columns(
5022: p_cm_ps_id,
5023: p_amount_applied,
5024: g_line_applied,
5025: g_tax_applied,

Line 6133: arp_ps_util.update_receipt_related_columns(

6129:
6130: CLOSE activity_c;
6131:
6132: /* Update the cash receipt in the payment schedule table. */
6133: arp_ps_util.update_receipt_related_columns(
6134: p_receipt_ps_id,
6135: p_amount_applied,
6136: p_apply_date,
6137: p_gl_date,

Line 8829: arp_ps_util.update_cm_related_columns(

8825: -- Get customer_trx_id of CM, from PS table. Pass the selected row
8826: -- to update_cm_related_columns procedure.
8827: --
8828: --
8829: arp_ps_util.update_cm_related_columns(
8830: p_cm_ps_id,
8831: p_amount_applied,
8832: l_inv_ra_rec.line_applied,
8833: l_inv_ra_rec.tax_applied,

Line 9305: arp_ps_util.update_reverse_actions( l_app_rec, NULL, NULL );

9301: l_app_rec.freight_applied := -l_adj_rec.freight_adjusted;
9302: l_app_rec.receivables_charges_applied := -l_adj_rec.receivables_charges_adjusted;
9303: l_app_rec.ps_id := l_adj_rec.payment_schedule_id;
9304:
9305: arp_ps_util.update_reverse_actions( l_app_rec, NULL, NULL );
9306:
9307: Update ra_customer_Trx
9308: set initial_customer_trx_id = NULL
9309: where customer_Trx_id = p_cm_cust_trx_id