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 401: AR_BILLS_MAINTAIN_LIB_PVT.get_doc_seq ( 222 ,

397: /*-----------------------------------------------+
398: | Document Sequence Routine |
399: +-----------------------------------------------*/
400:
401: AR_BILLS_MAINTAIN_LIB_PVT.get_doc_seq ( 222 ,
402: l_trx_rec ,
403: arp_global.set_of_books_id ,
404: 'M' );
405:

Line 412: AR_BILLS_MAINTAIN_LIB_PVT.Complete_Acc_Required (p_customer_trx_id);

408: +------------------------------------------------*/
409:
410: IF (AR_BILLS_MAINTAIN_STATUS_PUB.is_acceptance_required(l_trx_rec.cust_trx_type_id))
411: THEN
412: AR_BILLS_MAINTAIN_LIB_PVT.Complete_Acc_Required (p_customer_trx_id);
413: l_trh_rec.postable_flag := 'N' ;
414: l_trh_rec.current_accounted_flag := 'N' ;
415: ELSE
416: AR_BILLS_MAINTAIN_LIB_PVT.Complete_OR_Accept (l_trh_rec);

Line 416: AR_BILLS_MAINTAIN_LIB_PVT.Complete_OR_Accept (l_trh_rec);

412: AR_BILLS_MAINTAIN_LIB_PVT.Complete_Acc_Required (p_customer_trx_id);
413: l_trh_rec.postable_flag := 'N' ;
414: l_trh_rec.current_accounted_flag := 'N' ;
415: ELSE
416: AR_BILLS_MAINTAIN_LIB_PVT.Complete_OR_Accept (l_trh_rec);
417: l_trh_rec.postable_flag := 'Y' ;
418: l_trh_rec.current_accounted_flag := 'Y' ;
419: END IF;
420:

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

700: | BR UnCompletion |
701: +------------------------------------------------*/
702:
703:
704: AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Assignments_Adjustment (l_trh_rec, l_acceptance_flag);
705:
706:
707: /*-----------------------------------------------+
708: | Update the Complete Flag in the BR Header |

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

997: /*-----------------------------------------------+
998: | Data Defaulting |
999: +-----------------------------------------------*/
1000:
1001: AR_BILLS_MAINTAIN_LIB_PVT.Default_Action_Dates (l_trx_date, l_gl_date);
1002:
1003:
1004: /*-----------------------------------------------+
1005: | Data Validation |

Line 1022: AR_BILLS_MAINTAIN_LIB_PVT.Complete_OR_Accept (l_trh_rec);

1018: /*-----------------------------------------------+
1019: | BR Acceptance |
1020: +------------------------------------------------*/
1021:
1022: AR_BILLS_MAINTAIN_LIB_PVT.Complete_OR_Accept (l_trh_rec);
1023:
1024:
1025: /*-----------------------------------------------+
1026: | Insertion in Transaction History Table |

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

1274: +-----------------------------------------------*/
1275:
1276: AR_BILLS_CREATION_LIB_PVT.Get_Payment_Schedule_Id (p_customer_trx_id, l_ps_rec.payment_schedule_id);
1277:
1278: AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (l_ps_rec.payment_schedule_id, 'USER' , p_customer_trx_id);
1279:
1280:
1281:
1282: /*----------------------------------------------+

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

1544: +-----------------------------------------------*/
1545:
1546: AR_BILLS_CREATION_LIB_PVT.Get_Payment_Schedule_Id (p_customer_trx_id, l_ps_rec.payment_schedule_id);
1547:
1548: AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (l_ps_rec.payment_schedule_id, NULL, NULL);
1549:
1550:
1551: /*----------------------------------------------+
1552: | Update the Hold Flag in the BR Header |

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

1786: /*----------------------------------------------+
1787: | Updates the Payment Schedule of the BR |
1788: +-----------------------------------------------*/
1789:
1790: AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (p_ps_id, 'REMITTANCE' , p_batch_id);
1791:
1792:
1793: /*----------------------------------------------+
1794: | Insert a Transaction History Record |

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

1948: /*----------------------------------------------+
1949: | Updates the Payment Schedule of the BR |
1950: +-----------------------------------------------*/
1951:
1952: AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (p_ps_id, NULL, NULL);
1953:
1954:
1955: /*----------------------------------------------+
1956: | Insert a Transaction History Record |

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

2108: /*----------------------------------------------+
2109: | Updates the Payment Schedule of the BR |
2110: +-----------------------------------------------*/
2111:
2112: AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (p_ps_id, NULL, NULL);
2113:
2114:
2115:
2116: /*------------------------------------------------------+

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

2285:
2286: l_action := C_FACTORE_RECOURSE;
2287: l_trh_rec.postable_flag := 'Y';
2288: l_trh_rec.current_accounted_flag:= 'Y';
2289: AR_BILLS_MAINTAIN_LIB_PVT.Factore_Recourse (l_batch_rec, l_ps_rec, l_trh_rec);
2290:
2291:
2292: ELSIF (l_batch_rec.remit_method_code = C_FACTORING AND l_batch_rec.with_recourse_flag = 'N')
2293: THEN

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

2296: +-----------------------------------------------*/
2297:
2298: l_action := C_FACTORE;
2299: l_trh_rec.postable_flag := 'N';
2300: AR_BILLS_MAINTAIN_LIB_PVT.Factore_Without_Recourse (l_batch_rec, l_ps_rec);
2301: AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (p_ps_id, NULL , NULL);
2302:
2303: /*----------------------------------------------+
2304: | Insert the First Transaction History Record |

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

2297:
2298: l_action := C_FACTORE;
2299: l_trh_rec.postable_flag := 'N';
2300: AR_BILLS_MAINTAIN_LIB_PVT.Factore_Without_Recourse (l_batch_rec, l_ps_rec);
2301: AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (p_ps_id, NULL , NULL);
2302:
2303: /*----------------------------------------------+
2304: | Insert the First Transaction History Record |
2305: +-----------------------------------------------*/

Line 2394: AR_BILLS_MAINTAIN_LIB_PVT.Link_Application_History (l_trh_rec);

2390:
2391: IF (l_batch_rec.remit_method_code = C_FACTORING AND l_batch_rec.with_recourse_flag = 'N')
2392: THEN
2393:
2394: AR_BILLS_MAINTAIN_LIB_PVT.Link_Application_History (l_trh_rec);
2395:
2396: END IF;
2397:
2398:

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

2582: /*-----------------------------------------------+
2583: | Data Defaulting |
2584: +-----------------------------------------------*/
2585:
2586: AR_BILLS_MAINTAIN_LIB_PVT.Default_Action_Dates (l_trx_date, l_gl_date);
2587:
2588:
2589: /*-----------------------------------------------+
2590: | Data Validation |

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

2614: l_trh_rec.postable_flag := 'Y';
2615: l_trh_rec.current_accounted_flag:= 'Y';
2616: END IF;
2617:
2618: AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Assignments_Adjustment (l_trh_rec, l_acceptance_flag);
2619:
2620:
2621: /*----------------------------------------------+
2622: | Insert the Transaction History Record |

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

2910: /*-----------------------------------------------+
2911: | Data Defaulting |
2912: +-----------------------------------------------*/
2913:
2914: AR_BILLS_MAINTAIN_LIB_PVT.Default_Action_Dates (l_trx_date, l_gl_date);
2915:
2916:
2917: /*-----------------------------------------------+
2918: | Data Validation |

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

2931: /*-----------------------------------------------+
2932: | BR Unpaid |
2933: +------------------------------------------------*/
2934:
2935: AR_BILLS_MAINTAIN_LIB_PVT.Unpaid (l_trh_rec, l_ps_rec.payment_schedule_id, l_trx_rec.remittance_batch_id, p_unpaid_reason);
2936:
2937:
2938: /*----------------------------------------------+
2939: | Set the Unpaid Flag to 'Y' in the BR Header |

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

3219: /*-----------------------------------------------+
3220: | Data Defaulting |
3221: +-----------------------------------------------*/
3222:
3223: AR_BILLS_MAINTAIN_LIB_PVT.Default_Action_Dates (l_trx_date, l_gl_date);
3224:
3225:
3226: /*----------------------------------------------+
3227: | Data Validation |

Line 3260: AR_BILLS_MAINTAIN_LIB_PVT.Create_Adjustment (

3256: | Create an adjustment with a status W : |
3257: | Waiting for approval |
3258: +-----------------------------------------------*/
3259:
3260: AR_BILLS_MAINTAIN_LIB_PVT.Create_Adjustment (
3261: l_trh_rec ,
3262: p_customer_trx_id ,
3263: l_ps_rec ,
3264: l_ps_rec.amount_due_original ,

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

3271: | Updates the Payment Schedule of the BR |
3272: | with the Adjustment Information |
3273: +-----------------------------------------------*/
3274:
3275: AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (l_ps_rec.payment_schedule_id, 'ADJUSTMENT', new_adj_id);
3276:
3277: ELSE
3278:
3279: /*----------------------------------------------+

Line 3296: AR_BILLS_MAINTAIN_LIB_PVT.Create_Adjustment (

3292: | Create an adjustment with a status A : |
3293: | Approved |
3294: +-----------------------------------------------*/
3295:
3296: AR_BILLS_MAINTAIN_LIB_PVT.Create_Adjustment (
3297: l_trh_rec ,
3298: p_customer_trx_id ,
3299: l_ps_rec ,
3300: l_ps_rec.amount_due_original ,

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

3840:
3841: l_trx_date := trunc(p_restatement_date);
3842: l_gl_date := trunc(p_restatement_gl_date);
3843:
3844: AR_BILLS_MAINTAIN_LIB_PVT.Default_Action_Dates (l_trx_date, l_gl_date);
3845:
3846:
3847: /*----------------------------------------------+
3848: | Data validation |

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

4119:
4120: l_trx_date := trunc(p_recall_date);
4121: l_gl_date := trunc(p_recall_gl_date);
4122:
4123: AR_BILLS_MAINTAIN_LIB_PVT.Default_Action_Dates (l_trx_date, l_gl_date);
4124:
4125:
4126: /*----------------------------------------------+
4127: | Data Validation |

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

4150: /*----------------------------------------------+
4151: | Reverse the receipt applied to STD |
4152: +-----------------------------------------------*/
4153:
4154: AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_STD (l_trh_rec.customer_trx_id, l_cash_receipt_id, l_receivable_application_id);
4155: AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Receipt (l_trh_rec, l_cash_receipt_id, 'PAYMENT REVERSAL', C_BR_FACTORED_RECOURSE);
4156: l_trh_rec.postable_flag := 'Y';
4157: l_trh_rec.current_accounted_flag := 'Y';
4158:

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

4151: | Reverse the receipt applied to STD |
4152: +-----------------------------------------------*/
4153:
4154: AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_STD (l_trh_rec.customer_trx_id, l_cash_receipt_id, l_receivable_application_id);
4155: AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Receipt (l_trh_rec, l_cash_receipt_id, 'PAYMENT REVERSAL', C_BR_FACTORED_RECOURSE);
4156: l_trh_rec.postable_flag := 'Y';
4157: l_trh_rec.current_accounted_flag := 'Y';
4158:
4159: ELSIF (l_trh_rec.status = C_ENDORSED)

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

4163: | Reject the adjustment created during the |
4164: | endorsement. Status = 'R' (Reject) |
4165: +-----------------------------------------------*/
4166:
4167: AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Adjustment (p_customer_trx_id, l_adj_id);
4168: AR_BILLS_MAINTAIN_LIB_PVT.Modify_Adjustment (l_adj_id, 'R');
4169: l_trh_rec.postable_flag := 'N';
4170: l_trh_rec.current_accounted_flag := 'N';
4171: END IF;

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

4164: | endorsement. Status = 'R' (Reject) |
4165: +-----------------------------------------------*/
4166:
4167: AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Adjustment (p_customer_trx_id, l_adj_id);
4168: AR_BILLS_MAINTAIN_LIB_PVT.Modify_Adjustment (l_adj_id, 'R');
4169: l_trh_rec.postable_flag := 'N';
4170: l_trh_rec.current_accounted_flag := 'N';
4171: END IF;
4172:

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

4176: | on the BR Payment Schedule |
4177: +-----------------------------------------------*/
4178:
4179: AR_BILLS_CREATION_LIB_PVT.Get_Payment_Schedule_Id (p_customer_trx_id, l_ps_rec.payment_schedule_id);
4180: AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (l_ps_rec.payment_schedule_id, NULL , NULL);
4181:
4182:
4183: /*----------------------------------------------+
4184: | Insert the Transaction History Record |

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

4446:
4447: l_trx_date := trunc(p_risk_eliminate_date);
4448: l_gl_date := trunc(p_risk_eliminate_gl_date);
4449:
4450: AR_BILLS_MAINTAIN_LIB_PVT.Default_Action_Dates (l_trx_date, l_gl_date);
4451:
4452: AR_BILLS_CREATION_LIB_PVT.Get_Payment_Schedule_Id (p_customer_trx_id, l_ps_rec.payment_schedule_id);
4453:
4454: -- Modified for bug # 2712726

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

4481: | approval is unapplied from Short Term Debt |
4482: | and applied to the Bills Receivables |
4483: +-----------------------------------------------*/
4484:
4485: AR_BILLS_MAINTAIN_LIB_PVT.Unapply_STD (l_trh_rec, C_BR_FACTORED_RECOURSE, l_cash_receipt_id);
4486: AR_BILLS_MAINTAIN_LIB_PVT.Apply_Receipt (l_trh_rec, l_ps_rec, l_cash_receipt_id, C_BR_FACTORED_RECOURSE);
4487:
4488: ELSIF (l_trh_rec.status = C_ENDORSED)
4489: THEN

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

4482: | and applied to the Bills Receivables |
4483: +-----------------------------------------------*/
4484:
4485: AR_BILLS_MAINTAIN_LIB_PVT.Unapply_STD (l_trh_rec, C_BR_FACTORED_RECOURSE, l_cash_receipt_id);
4486: AR_BILLS_MAINTAIN_LIB_PVT.Apply_Receipt (l_trh_rec, l_ps_rec, l_cash_receipt_id, C_BR_FACTORED_RECOURSE);
4487:
4488: ELSIF (l_trh_rec.status = C_ENDORSED)
4489: THEN
4490: IF NOT (AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Matured (l_ps_rec.due_date))

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

4510: | The unapproved adjustment created during the|
4511: | endorsment is approved |
4512: +-----------------------------------------------*/
4513:
4514: AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Adjustment (p_customer_trx_id, l_adj_id);
4515: AR_BILLS_MAINTAIN_LIB_PVT.Approve_Adjustment (l_adj_id, l_move_deferred_tax);
4516: END IF;
4517:
4518:

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

4511: | endorsment is approved |
4512: +-----------------------------------------------*/
4513:
4514: AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Adjustment (p_customer_trx_id, l_adj_id);
4515: AR_BILLS_MAINTAIN_LIB_PVT.Approve_Adjustment (l_adj_id, l_move_deferred_tax);
4516: END IF;
4517:
4518:
4519: /*-----------------------------------------------+

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

4520: | Remove the Remittance or adjustment tags |
4521: | on the BR Payment Schedule |
4522: +-----------------------------------------------*/
4523:
4524: AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (l_ps_rec.payment_schedule_id, NULL , NULL);
4525:
4526:
4527: /*----------------------------------------------+
4528: | Insert the Transaction History Record |

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

4811: /*----------------------------------------------+
4812: | Data defaulting |
4813: +-----------------------------------------------*/
4814:
4815: AR_BILLS_MAINTAIN_LIB_PVT.Default_Action_Dates (l_trx_date, l_gl_date);
4816:
4817:
4818: /*----------------------------------------------+
4819: | Data validation |

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

4839: | Unapply the receipt from the BR and apply |
4840: | it to short term debt |
4841: +-----------------------------------------------*/
4842:
4843: AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Receipt (l_trh_rec.customer_trx_id, l_cash_receipt_id);
4844: AR_BILLS_MAINTAIN_LIB_PVT.Unapply_Receipt (l_trh_rec, l_ps_rec.payment_schedule_id, l_cash_receipt_id, C_RISK_UNELIMINATED);
4845: 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);
4846:
4847: /*-----------------------------------------------+

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

4840: | it to short term debt |
4841: +-----------------------------------------------*/
4842:
4843: AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Receipt (l_trh_rec.customer_trx_id, l_cash_receipt_id);
4844: AR_BILLS_MAINTAIN_LIB_PVT.Unapply_Receipt (l_trh_rec, l_ps_rec.payment_schedule_id, l_cash_receipt_id, C_RISK_UNELIMINATED);
4845: 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);
4846:
4847: /*-----------------------------------------------+
4848: | Put the Remittance tags |

Line 4845: 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);

4841: +-----------------------------------------------*/
4842:
4843: AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Receipt (l_trh_rec.customer_trx_id, l_cash_receipt_id);
4844: AR_BILLS_MAINTAIN_LIB_PVT.Unapply_Receipt (l_trh_rec, l_ps_rec.payment_schedule_id, l_cash_receipt_id, C_RISK_UNELIMINATED);
4845: 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);
4846:
4847: /*-----------------------------------------------+
4848: | Put the Remittance tags |
4849: | on the BR Payment Schedule |

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

4848: | Put the Remittance tags |
4849: | on the BR Payment Schedule |
4850: +-----------------------------------------------*/
4851:
4852: AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (l_ps_rec.payment_schedule_id, 'REMITTANCE' , l_trx_rec.remittance_batch_id);
4853:
4854:
4855: ELSIF (l_trh_prev_rec.status = C_ENDORSED)
4856: THEN

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

4860: | endorsement and create a new unapproved |
4861: | adjustment |
4862: +-----------------------------------------------*/
4863:
4864: AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Adjustment (l_trh_rec.customer_trx_id, l_adj_id);
4865:
4866: SELECT receivables_trx_id
4867: INTO l_receivables_trx_id
4868: FROM ar_adjustments

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

4867: INTO l_receivables_trx_id
4868: FROM ar_adjustments
4869: WHERE adjustment_id = l_adj_id;
4870:
4871: AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Adjustment (l_adj_id, l_trh_rec, C_RISK_UNELIMINATED);
4872:
4873: AR_BILLS_MAINTAIN_LIB_PVT.Create_Adjustment (
4874: l_trh_rec ,
4875: p_customer_trx_id ,

Line 4873: AR_BILLS_MAINTAIN_LIB_PVT.Create_Adjustment (

4869: WHERE adjustment_id = l_adj_id;
4870:
4871: AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Adjustment (l_adj_id, l_trh_rec, C_RISK_UNELIMINATED);
4872:
4873: AR_BILLS_MAINTAIN_LIB_PVT.Create_Adjustment (
4874: l_trh_rec ,
4875: p_customer_trx_id ,
4876: l_ps_rec ,
4877: l_ps_rec.amount_due_original ,

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

4884: | Updates the Payment Schedule of the BR |
4885: | with the Adjustment Information |
4886: +-----------------------------------------------*/
4887:
4888: AR_BILLS_MAINTAIN_LIB_PVT.update_reserved_columns (l_ps_rec.payment_schedule_id, 'ADJUSTMENT', l_new_adj_id);
4889:
4890:
4891: END IF;
4892: