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.AR_BILLS_MAINTAIN_PUB dependencies on AR_BILLS_MAINTAIN_LIB_PVT

Line 390: AR_BILLS_MAINTAIN_LIB_PVT.get_doc_seq ( 222 ,

386: /*-----------------------------------------------+
387: | Document Sequence Routine |
388: +-----------------------------------------------*/
389:
390: AR_BILLS_MAINTAIN_LIB_PVT.get_doc_seq ( 222 ,
391: l_trx_rec ,
392: arp_global.set_of_books_id ,
393: 'M' );
394:

Line 401: AR_BILLS_MAINTAIN_LIB_PVT.Complete_Acc_Required (p_customer_trx_id);

397: +------------------------------------------------*/
398:
399: IF (AR_BILLS_MAINTAIN_STATUS_PUB.is_acceptance_required(l_trx_rec.cust_trx_type_id))
400: THEN
401: AR_BILLS_MAINTAIN_LIB_PVT.Complete_Acc_Required (p_customer_trx_id);
402: l_trh_rec.postable_flag := 'N' ;
403: l_trh_rec.current_accounted_flag := 'N' ;
404: ELSE
405: AR_BILLS_MAINTAIN_LIB_PVT.Complete_OR_Accept (l_trh_rec);

Line 405: AR_BILLS_MAINTAIN_LIB_PVT.Complete_OR_Accept (l_trh_rec);

401: AR_BILLS_MAINTAIN_LIB_PVT.Complete_Acc_Required (p_customer_trx_id);
402: l_trh_rec.postable_flag := 'N' ;
403: l_trh_rec.current_accounted_flag := 'N' ;
404: ELSE
405: AR_BILLS_MAINTAIN_LIB_PVT.Complete_OR_Accept (l_trh_rec);
406: l_trh_rec.postable_flag := 'Y' ;
407: l_trh_rec.current_accounted_flag := 'Y' ;
408: END IF;
409:

Line 693: AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Assignments_Adjustment (l_trh_rec, l_acceptance_flag);

689: | BR UnCompletion |
690: +------------------------------------------------*/
691:
692:
693: AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Assignments_Adjustment (l_trh_rec, l_acceptance_flag);
694:
695:
696: /*-----------------------------------------------+
697: | Update the Complete Flag in the BR Header |

Line 990: AR_BILLS_MAINTAIN_LIB_PVT.Default_Action_Dates (l_trx_date, l_gl_date);

986: /*-----------------------------------------------+
987: | Data Defaulting |
988: +-----------------------------------------------*/
989:
990: AR_BILLS_MAINTAIN_LIB_PVT.Default_Action_Dates (l_trx_date, l_gl_date);
991:
992:
993: /*-----------------------------------------------+
994: | Data Validation |

Line 1011: AR_BILLS_MAINTAIN_LIB_PVT.Complete_OR_Accept (l_trh_rec);

1007: /*-----------------------------------------------+
1008: | BR Acceptance |
1009: +------------------------------------------------*/
1010:
1011: AR_BILLS_MAINTAIN_LIB_PVT.Complete_OR_Accept (l_trh_rec);
1012:
1013:
1014: /*-----------------------------------------------+
1015: | Insertion in Transaction History Table |

Line 1267: AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (l_ps_rec.payment_schedule_id, 'USER' , p_customer_trx_id);

1263: +-----------------------------------------------*/
1264:
1265: AR_BILLS_CREATION_LIB_PVT.Get_Payment_Schedule_Id (p_customer_trx_id, l_ps_rec.payment_schedule_id);
1266:
1267: AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (l_ps_rec.payment_schedule_id, 'USER' , p_customer_trx_id);
1268:
1269:
1270:
1271: /*----------------------------------------------+

Line 1537: AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (l_ps_rec.payment_schedule_id, NULL, NULL);

1533: +-----------------------------------------------*/
1534:
1535: AR_BILLS_CREATION_LIB_PVT.Get_Payment_Schedule_Id (p_customer_trx_id, l_ps_rec.payment_schedule_id);
1536:
1537: AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (l_ps_rec.payment_schedule_id, NULL, NULL);
1538:
1539:
1540: /*----------------------------------------------+
1541: | Update the Hold Flag in the BR Header |

Line 1779: AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (p_ps_id, 'REMITTANCE' , p_batch_id);

1775: /*----------------------------------------------+
1776: | Updates the Payment Schedule of the BR |
1777: +-----------------------------------------------*/
1778:
1779: AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (p_ps_id, 'REMITTANCE' , p_batch_id);
1780:
1781:
1782: /*----------------------------------------------+
1783: | Insert a Transaction History Record |

Line 1941: AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (p_ps_id, NULL, NULL);

1937: /*----------------------------------------------+
1938: | Updates the Payment Schedule of the BR |
1939: +-----------------------------------------------*/
1940:
1941: AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (p_ps_id, NULL, NULL);
1942:
1943:
1944: /*----------------------------------------------+
1945: | Insert a Transaction History Record |

Line 2101: AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (p_ps_id, NULL, NULL);

2097: /*----------------------------------------------+
2098: | Updates the Payment Schedule of the BR |
2099: +-----------------------------------------------*/
2100:
2101: AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (p_ps_id, NULL, NULL);
2102:
2103:
2104:
2105: /*------------------------------------------------------+

Line 2278: AR_BILLS_MAINTAIN_LIB_PVT.Factore_Recourse (l_batch_rec, l_ps_rec, l_trh_rec);

2274:
2275: l_action := C_FACTORE_RECOURSE;
2276: l_trh_rec.postable_flag := 'Y';
2277: l_trh_rec.current_accounted_flag:= 'Y';
2278: AR_BILLS_MAINTAIN_LIB_PVT.Factore_Recourse (l_batch_rec, l_ps_rec, l_trh_rec);
2279:
2280:
2281: ELSIF (l_batch_rec.remit_method_code = C_FACTORING AND l_batch_rec.with_recourse_flag = 'N')
2282: THEN

Line 2289: AR_BILLS_MAINTAIN_LIB_PVT.Factore_Without_Recourse (l_batch_rec, l_ps_rec);

2285: +-----------------------------------------------*/
2286:
2287: l_action := C_FACTORE;
2288: l_trh_rec.postable_flag := 'N';
2289: AR_BILLS_MAINTAIN_LIB_PVT.Factore_Without_Recourse (l_batch_rec, l_ps_rec);
2290: AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (p_ps_id, NULL , NULL);
2291:
2292: /*----------------------------------------------+
2293: | Insert the First Transaction History Record |

Line 2290: AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (p_ps_id, NULL , NULL);

2286:
2287: l_action := C_FACTORE;
2288: l_trh_rec.postable_flag := 'N';
2289: AR_BILLS_MAINTAIN_LIB_PVT.Factore_Without_Recourse (l_batch_rec, l_ps_rec);
2290: AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (p_ps_id, NULL , NULL);
2291:
2292: /*----------------------------------------------+
2293: | Insert the First Transaction History Record |
2294: +-----------------------------------------------*/

Line 2383: AR_BILLS_MAINTAIN_LIB_PVT.Link_Application_History (l_trh_rec);

2379:
2380: IF (l_batch_rec.remit_method_code = C_FACTORING AND l_batch_rec.with_recourse_flag = 'N')
2381: THEN
2382:
2383: AR_BILLS_MAINTAIN_LIB_PVT.Link_Application_History (l_trh_rec);
2384:
2385: END IF;
2386:
2387:

Line 2575: AR_BILLS_MAINTAIN_LIB_PVT.Default_Action_Dates (l_trx_date, l_gl_date);

2571: /*-----------------------------------------------+
2572: | Data Defaulting |
2573: +-----------------------------------------------*/
2574:
2575: AR_BILLS_MAINTAIN_LIB_PVT.Default_Action_Dates (l_trx_date, l_gl_date);
2576:
2577:
2578: /*-----------------------------------------------+
2579: | Data Validation |

Line 2607: AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Assignments_Adjustment (l_trh_rec, l_acceptance_flag);

2603: l_trh_rec.postable_flag := 'Y';
2604: l_trh_rec.current_accounted_flag:= 'Y';
2605: END IF;
2606:
2607: AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Assignments_Adjustment (l_trh_rec, l_acceptance_flag);
2608:
2609:
2610: /*----------------------------------------------+
2611: | Insert the Transaction History Record |

Line 2903: AR_BILLS_MAINTAIN_LIB_PVT.Default_Action_Dates (l_trx_date, l_gl_date);

2899: /*-----------------------------------------------+
2900: | Data Defaulting |
2901: +-----------------------------------------------*/
2902:
2903: AR_BILLS_MAINTAIN_LIB_PVT.Default_Action_Dates (l_trx_date, l_gl_date);
2904:
2905:
2906: /*-----------------------------------------------+
2907: | Data Validation |

Line 2924: AR_BILLS_MAINTAIN_LIB_PVT.Unpaid (l_trh_rec, l_ps_rec.payment_schedule_id, l_trx_rec.remittance_batch_id, p_unpaid_reason);

2920: /*-----------------------------------------------+
2921: | BR Unpaid |
2922: +------------------------------------------------*/
2923:
2924: AR_BILLS_MAINTAIN_LIB_PVT.Unpaid (l_trh_rec, l_ps_rec.payment_schedule_id, l_trx_rec.remittance_batch_id, p_unpaid_reason);
2925:
2926:
2927: /*----------------------------------------------+
2928: | Set the Unpaid Flag to 'Y' in the BR Header |

Line 3212: AR_BILLS_MAINTAIN_LIB_PVT.Default_Action_Dates (l_trx_date, l_gl_date);

3208: /*-----------------------------------------------+
3209: | Data Defaulting |
3210: +-----------------------------------------------*/
3211:
3212: AR_BILLS_MAINTAIN_LIB_PVT.Default_Action_Dates (l_trx_date, l_gl_date);
3213:
3214:
3215: /*----------------------------------------------+
3216: | Data Validation |

Line 3249: AR_BILLS_MAINTAIN_LIB_PVT.Create_Adjustment (

3245: | Create an adjustment with a status W : |
3246: | Waiting for approval |
3247: +-----------------------------------------------*/
3248:
3249: AR_BILLS_MAINTAIN_LIB_PVT.Create_Adjustment (
3250: l_trh_rec ,
3251: p_customer_trx_id ,
3252: l_ps_rec ,
3253: l_ps_rec.amount_due_original ,

Line 3264: AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (l_ps_rec.payment_schedule_id, 'ADJUSTMENT', new_adj_id);

3260: | Updates the Payment Schedule of the BR |
3261: | with the Adjustment Information |
3262: +-----------------------------------------------*/
3263:
3264: AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (l_ps_rec.payment_schedule_id, 'ADJUSTMENT', new_adj_id);
3265:
3266: ELSE
3267:
3268: /*----------------------------------------------+

Line 3285: AR_BILLS_MAINTAIN_LIB_PVT.Create_Adjustment (

3281: | Create an adjustment with a status A : |
3282: | Approved |
3283: +-----------------------------------------------*/
3284:
3285: AR_BILLS_MAINTAIN_LIB_PVT.Create_Adjustment (
3286: l_trh_rec ,
3287: p_customer_trx_id ,
3288: l_ps_rec ,
3289: l_ps_rec.amount_due_original ,

Line 3833: AR_BILLS_MAINTAIN_LIB_PVT.Default_Action_Dates (l_trx_date, l_gl_date);

3829:
3830: l_trx_date := trunc(p_restatement_date);
3831: l_gl_date := trunc(p_restatement_gl_date);
3832:
3833: AR_BILLS_MAINTAIN_LIB_PVT.Default_Action_Dates (l_trx_date, l_gl_date);
3834:
3835:
3836: /*----------------------------------------------+
3837: | Data validation |

Line 4112: AR_BILLS_MAINTAIN_LIB_PVT.Default_Action_Dates (l_trx_date, l_gl_date);

4108:
4109: l_trx_date := trunc(p_recall_date);
4110: l_gl_date := trunc(p_recall_gl_date);
4111:
4112: AR_BILLS_MAINTAIN_LIB_PVT.Default_Action_Dates (l_trx_date, l_gl_date);
4113:
4114:
4115: /*----------------------------------------------+
4116: | Data Validation |

Line 4143: AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_STD (l_trh_rec.customer_trx_id, l_cash_receipt_id, l_receivable_application_id);

4139: /*----------------------------------------------+
4140: | Reverse the receipt applied to STD |
4141: +-----------------------------------------------*/
4142:
4143: AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_STD (l_trh_rec.customer_trx_id, l_cash_receipt_id, l_receivable_application_id);
4144: AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Receipt (l_trh_rec, l_cash_receipt_id, 'PAYMENT REVERSAL', C_BR_FACTORED_RECOURSE);
4145: l_trh_rec.postable_flag := 'Y';
4146: l_trh_rec.current_accounted_flag := 'Y';
4147:

Line 4144: AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Receipt (l_trh_rec, l_cash_receipt_id, 'PAYMENT REVERSAL', C_BR_FACTORED_RECOURSE);

4140: | Reverse the receipt applied to STD |
4141: +-----------------------------------------------*/
4142:
4143: AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_STD (l_trh_rec.customer_trx_id, l_cash_receipt_id, l_receivable_application_id);
4144: AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Receipt (l_trh_rec, l_cash_receipt_id, 'PAYMENT REVERSAL', C_BR_FACTORED_RECOURSE);
4145: l_trh_rec.postable_flag := 'Y';
4146: l_trh_rec.current_accounted_flag := 'Y';
4147:
4148: ELSIF (l_trh_rec.status = C_ENDORSED)

Line 4156: AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Adjustment (p_customer_trx_id, l_adj_id);

4152: | Reject the adjustment created during the |
4153: | endorsement. Status = 'R' (Reject) |
4154: +-----------------------------------------------*/
4155:
4156: AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Adjustment (p_customer_trx_id, l_adj_id);
4157: AR_BILLS_MAINTAIN_LIB_PVT.Modify_Adjustment (l_adj_id, 'R');
4158: l_trh_rec.postable_flag := 'N';
4159: l_trh_rec.current_accounted_flag := 'N';
4160: END IF;

Line 4157: AR_BILLS_MAINTAIN_LIB_PVT.Modify_Adjustment (l_adj_id, 'R');

4153: | endorsement. Status = 'R' (Reject) |
4154: +-----------------------------------------------*/
4155:
4156: AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Adjustment (p_customer_trx_id, l_adj_id);
4157: AR_BILLS_MAINTAIN_LIB_PVT.Modify_Adjustment (l_adj_id, 'R');
4158: l_trh_rec.postable_flag := 'N';
4159: l_trh_rec.current_accounted_flag := 'N';
4160: END IF;
4161:

Line 4169: AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (l_ps_rec.payment_schedule_id, NULL , NULL);

4165: | on the BR Payment Schedule |
4166: +-----------------------------------------------*/
4167:
4168: AR_BILLS_CREATION_LIB_PVT.Get_Payment_Schedule_Id (p_customer_trx_id, l_ps_rec.payment_schedule_id);
4169: AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (l_ps_rec.payment_schedule_id, NULL , NULL);
4170:
4171:
4172: /*----------------------------------------------+
4173: | Insert the Transaction History Record |

Line 4439: AR_BILLS_MAINTAIN_LIB_PVT.Default_Action_Dates (l_trx_date, l_gl_date);

4435:
4436: l_trx_date := trunc(p_risk_eliminate_date);
4437: l_gl_date := trunc(p_risk_eliminate_gl_date);
4438:
4439: AR_BILLS_MAINTAIN_LIB_PVT.Default_Action_Dates (l_trx_date, l_gl_date);
4440:
4441: AR_BILLS_CREATION_LIB_PVT.Get_Payment_Schedule_Id (p_customer_trx_id, l_ps_rec.payment_schedule_id);
4442:
4443: -- Modified for bug # 2712726

Line 4474: AR_BILLS_MAINTAIN_LIB_PVT.Unapply_STD (l_trh_rec, C_BR_FACTORED_RECOURSE, l_cash_receipt_id);

4470: | approval is unapplied from Short Term Debt |
4471: | and applied to the Bills Receivables |
4472: +-----------------------------------------------*/
4473:
4474: AR_BILLS_MAINTAIN_LIB_PVT.Unapply_STD (l_trh_rec, C_BR_FACTORED_RECOURSE, l_cash_receipt_id);
4475: AR_BILLS_MAINTAIN_LIB_PVT.Apply_Receipt (l_trh_rec, l_ps_rec, l_cash_receipt_id, C_BR_FACTORED_RECOURSE);
4476:
4477: ELSIF (l_trh_rec.status = C_ENDORSED)
4478: THEN

Line 4475: AR_BILLS_MAINTAIN_LIB_PVT.Apply_Receipt (l_trh_rec, l_ps_rec, l_cash_receipt_id, C_BR_FACTORED_RECOURSE);

4471: | and applied to the Bills Receivables |
4472: +-----------------------------------------------*/
4473:
4474: AR_BILLS_MAINTAIN_LIB_PVT.Unapply_STD (l_trh_rec, C_BR_FACTORED_RECOURSE, l_cash_receipt_id);
4475: AR_BILLS_MAINTAIN_LIB_PVT.Apply_Receipt (l_trh_rec, l_ps_rec, l_cash_receipt_id, C_BR_FACTORED_RECOURSE);
4476:
4477: ELSIF (l_trh_rec.status = C_ENDORSED)
4478: THEN
4479: IF NOT (AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Matured (l_ps_rec.due_date))

Line 4503: AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Adjustment (p_customer_trx_id, l_adj_id);

4499: | The unapproved adjustment created during the|
4500: | endorsment is approved |
4501: +-----------------------------------------------*/
4502:
4503: AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Adjustment (p_customer_trx_id, l_adj_id);
4504: AR_BILLS_MAINTAIN_LIB_PVT.Approve_Adjustment (l_adj_id, l_move_deferred_tax);
4505: END IF;
4506:
4507:

Line 4504: AR_BILLS_MAINTAIN_LIB_PVT.Approve_Adjustment (l_adj_id, l_move_deferred_tax);

4500: | endorsment is approved |
4501: +-----------------------------------------------*/
4502:
4503: AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Adjustment (p_customer_trx_id, l_adj_id);
4504: AR_BILLS_MAINTAIN_LIB_PVT.Approve_Adjustment (l_adj_id, l_move_deferred_tax);
4505: END IF;
4506:
4507:
4508: /*-----------------------------------------------+

Line 4513: AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (l_ps_rec.payment_schedule_id, NULL , NULL);

4509: | Remove the Remittance or adjustment tags |
4510: | on the BR Payment Schedule |
4511: +-----------------------------------------------*/
4512:
4513: AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (l_ps_rec.payment_schedule_id, NULL , NULL);
4514:
4515:
4516: /*----------------------------------------------+
4517: | Insert the Transaction History Record |

Line 4804: AR_BILLS_MAINTAIN_LIB_PVT.Default_Action_Dates (l_trx_date, l_gl_date);

4800: /*----------------------------------------------+
4801: | Data defaulting |
4802: +-----------------------------------------------*/
4803:
4804: AR_BILLS_MAINTAIN_LIB_PVT.Default_Action_Dates (l_trx_date, l_gl_date);
4805:
4806:
4807: /*----------------------------------------------+
4808: | Data validation |

Line 4832: AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Receipt (l_trh_rec.customer_trx_id, l_cash_receipt_id);

4828: | Unapply the receipt from the BR and apply |
4829: | it to short term debt |
4830: +-----------------------------------------------*/
4831:
4832: AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Receipt (l_trh_rec.customer_trx_id, l_cash_receipt_id);
4833: AR_BILLS_MAINTAIN_LIB_PVT.Unapply_Receipt (l_trh_rec, l_ps_rec.payment_schedule_id, l_cash_receipt_id, C_RISK_UNELIMINATED);
4834: AR_BILLS_MAINTAIN_LIB_PVT.Apply_STD (p_customer_trx_id, l_cash_receipt_id, l_trh_rec.trx_date, l_trh_rec.gl_date);
4835:
4836: /*-----------------------------------------------+

Line 4833: AR_BILLS_MAINTAIN_LIB_PVT.Unapply_Receipt (l_trh_rec, l_ps_rec.payment_schedule_id, l_cash_receipt_id, C_RISK_UNELIMINATED);

4829: | it to short term debt |
4830: +-----------------------------------------------*/
4831:
4832: AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Receipt (l_trh_rec.customer_trx_id, l_cash_receipt_id);
4833: AR_BILLS_MAINTAIN_LIB_PVT.Unapply_Receipt (l_trh_rec, l_ps_rec.payment_schedule_id, l_cash_receipt_id, C_RISK_UNELIMINATED);
4834: AR_BILLS_MAINTAIN_LIB_PVT.Apply_STD (p_customer_trx_id, l_cash_receipt_id, l_trh_rec.trx_date, l_trh_rec.gl_date);
4835:
4836: /*-----------------------------------------------+
4837: | Put the Remittance tags |

Line 4834: AR_BILLS_MAINTAIN_LIB_PVT.Apply_STD (p_customer_trx_id, l_cash_receipt_id, l_trh_rec.trx_date, l_trh_rec.gl_date);

4830: +-----------------------------------------------*/
4831:
4832: AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Receipt (l_trh_rec.customer_trx_id, l_cash_receipt_id);
4833: AR_BILLS_MAINTAIN_LIB_PVT.Unapply_Receipt (l_trh_rec, l_ps_rec.payment_schedule_id, l_cash_receipt_id, C_RISK_UNELIMINATED);
4834: AR_BILLS_MAINTAIN_LIB_PVT.Apply_STD (p_customer_trx_id, l_cash_receipt_id, l_trh_rec.trx_date, l_trh_rec.gl_date);
4835:
4836: /*-----------------------------------------------+
4837: | Put the Remittance tags |
4838: | on the BR Payment Schedule |

Line 4841: AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (l_ps_rec.payment_schedule_id, 'REMITTANCE' , l_trx_rec.remittance_batch_id);

4837: | Put the Remittance tags |
4838: | on the BR Payment Schedule |
4839: +-----------------------------------------------*/
4840:
4841: AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (l_ps_rec.payment_schedule_id, 'REMITTANCE' , l_trx_rec.remittance_batch_id);
4842:
4843:
4844: ELSIF (l_trh_prev_rec.status = C_ENDORSED)
4845: THEN

Line 4853: AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Adjustment (l_trh_rec.customer_trx_id, l_adj_id);

4849: | endorsement and create a new unapproved |
4850: | adjustment |
4851: +-----------------------------------------------*/
4852:
4853: AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Adjustment (l_trh_rec.customer_trx_id, l_adj_id);
4854:
4855: SELECT receivables_trx_id
4856: INTO l_receivables_trx_id
4857: FROM ar_adjustments

Line 4860: AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Adjustment (l_adj_id, l_trh_rec, C_RISK_UNELIMINATED);

4856: INTO l_receivables_trx_id
4857: FROM ar_adjustments
4858: WHERE adjustment_id = l_adj_id;
4859:
4860: AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Adjustment (l_adj_id, l_trh_rec, C_RISK_UNELIMINATED);
4861:
4862: AR_BILLS_MAINTAIN_LIB_PVT.Create_Adjustment (
4863: l_trh_rec ,
4864: p_customer_trx_id ,

Line 4862: AR_BILLS_MAINTAIN_LIB_PVT.Create_Adjustment (

4858: WHERE adjustment_id = l_adj_id;
4859:
4860: AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Adjustment (l_adj_id, l_trh_rec, C_RISK_UNELIMINATED);
4861:
4862: AR_BILLS_MAINTAIN_LIB_PVT.Create_Adjustment (
4863: l_trh_rec ,
4864: p_customer_trx_id ,
4865: l_ps_rec ,
4866: l_ps_rec.amount_due_original ,

Line 4877: AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (l_ps_rec.payment_schedule_id, 'ADJUSTMENT', l_new_adj_id);

4873: | Updates the Payment Schedule of the BR |
4874: | with the Adjustment Information |
4875: +-----------------------------------------------*/
4876:
4877: AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (l_ps_rec.payment_schedule_id, 'ADJUSTMENT', l_new_adj_id);
4878:
4879:
4880: END IF;
4881: