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.OE_PREPAYMENT_PVT dependencies on OE_ORDER_PUB

Line 165: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type)

161: Returns the pending amount to be processed
162: ---------------------------------------------------------------------*/
163:
164: FUNCTION Calculate_Pending_Amount
165: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type)
166: RETURN NUMBER
167: IS
168: l_prepaid_amount NUMBER := 0;
169: l_pending_amount NUMBER := 0;

Line 232: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

228: Procedure Create_Receipt
229: This procedure calls AR API to create a new receipt for the amount specified.
230: ----------------------------------------------------------------------------*/
231: PROCEDURE Create_Receipt
232: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
233: , p_amount IN NUMBER
234: , p_receipt_method_id IN NUMBER
235: , p_bank_acct_id IN NUMBER
236: , p_bank_acct_uses_id IN NUMBER

Line 467: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

463: Procedure Refund_Request
464: This procedure calls AR API to submit refund request for the amount specified.
465: ----------------------------------------------------------------------------*/
466: PROCEDURE Refund_Request
467: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
468: , p_amount IN NUMBER
469: , p_payment_set_id IN NUMBER
470: , x_msg_count OUT NOCOPY NUMBER
471: , x_msg_data OUT NOCOPY VARCHAR2

Line 563: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

559: This is the main procedure for PrePayment. It is called from
560: OE_Verify_Payment_PUB.Verify_Payment for those prepaid orders.
561: ----------------------------------------------------------------------------*/
562: PROCEDURE Process_PrePayment_Order
563: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
564: , p_calling_action IN VARCHAR2
565: , p_delayed_request IN VARCHAR2
566: , x_msg_count OUT NOCOPY NUMBER
567: , x_msg_data OUT NOCOPY VARCHAR2

Line 582: l_header_rec OE_Order_PUB.Header_Rec_Type := p_header_rec;

578: AND header_id = p_header_id;
579:
580:
581: l_calling_action VARCHAR2(30) := p_calling_action;
582: l_header_rec OE_Order_PUB.Header_Rec_Type := p_header_rec;
583: l_pending_amount NUMBER := 0;
584: l_create_receipt VARCHAR2(1) := 'N';
585: l_request_refund VARCHAR2(1) := 'N';
586: l_apply_ppp_hold VARCHAR2(1) := 'N';

Line 1767: l_header_rec OE_ORDER_PUB.Header_Rec_Type;

1763: , x_msg_data OUT NOCOPY VARCHAR2
1764: , x_return_status OUT NOCOPY VARCHAR2
1765: ) IS
1766:
1767: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
1768: l_line_id NUMBER;
1769: l_payment_set_id NUMBER := NULL;
1770: l_bank_acct_id NUMBER := NULL;
1771: l_bank_acct_uses_id NUMBER := NULL;

Line 1776: l_header_payment_rec OE_Order_PUB.Header_Payment_Rec_Type;

1772: l_application_ref_id NUMBER := p_header_id;
1773: l_application_ref_num NUMBER;
1774: l_payment_response_error_code VARCHAR2(80);
1775: l_approval_code VARCHAR2(80);
1776: l_header_payment_rec OE_Order_PUB.Header_Payment_Rec_Type;
1777: l_insert VARCHAR2(1) := 'N';
1778: l_status NUMBER;
1779: l_msg_count NUMBER := 0;
1780: l_msg_data VARCHAR2(2000) := NULL;

Line 2513: l_line_payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;

2509: ,x_msg_count OUT NOCOPY NUMBER
2510: ,x_msg_data OUT NOCOPY VARCHAR2
2511: ) IS
2512:
2513: l_line_payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
2514: l_x_old_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
2515: l_from_line_payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
2516: l_control_rec OE_GLOBALS.Control_Rec_Type;
2517: l_return_status VARCHAR2(2000);

Line 2514: l_x_old_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;

2510: ,x_msg_data OUT NOCOPY VARCHAR2
2511: ) IS
2512:
2513: l_line_payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
2514: l_x_old_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
2515: l_from_line_payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
2516: l_control_rec OE_GLOBALS.Control_Rec_Type;
2517: l_return_status VARCHAR2(2000);
2518: i NUMBER;

Line 2515: l_from_line_payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;

2511: ) IS
2512:
2513: l_line_payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
2514: l_x_old_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
2515: l_from_line_payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
2516: l_control_rec OE_GLOBALS.Control_Rec_Type;
2517: l_return_status VARCHAR2(2000);
2518: i NUMBER;
2519: j NUMBER;

Line 2747: l_line_payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;

2743: AND ar.applied_payment_schedule_id = -7
2744: AND ar.payment_set_id = p_payment_set_id;
2745: **/
2746:
2747: l_line_payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
2748: l_receipt_status VARCHAR2(30);
2749: l_payment_type_code VARCHAR2(30);
2750: l_payment_set_id NUMBER;
2751: l_payment_not_assured VARCHAR2(1) := 'N';

Line 3521: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

3517: line_payment_type varchar2(30) := NULL;
3518:
3519:
3520: l_control_rec OE_GLOBALS.Control_Rec_Type;
3521: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3522: l_x_Old_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3523: l_commitment_id number;
3524: line_commitment_id number;
3525: l_pmt_changed varchar2(1) := 'N';

Line 3522: l_x_Old_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

3518:
3519:
3520: l_control_rec OE_GLOBALS.Control_Rec_Type;
3521: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3522: l_x_Old_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3523: l_commitment_id number;
3524: line_commitment_id number;
3525: l_pmt_changed varchar2(1) := 'N';
3526: --bug3733877 start

Line 3532: l_old_header_rec OE_Order_Pub.Header_Rec_Type;

3528: l_max_payment_number NUMBER := 0;
3529: --bug3733877 end
3530: --bug3781675 start
3531: l_inv_payment_number NUMBER;
3532: l_old_header_rec OE_Order_Pub.Header_Rec_Type;
3533: l_header_rec OE_Order_Pub.Header_Rec_Type;
3534: l_index NUMBER;
3535: --bug3781675 end
3536:

Line 3533: l_header_rec OE_Order_Pub.Header_Rec_Type;

3529: --bug3733877 end
3530: --bug3781675 start
3531: l_inv_payment_number NUMBER;
3532: l_old_header_rec OE_Order_Pub.Header_Rec_Type;
3533: l_header_rec OE_Order_Pub.Header_Rec_Type;
3534: l_index NUMBER;
3535: --bug3781675 end
3536:
3537: --bug3906851

Line 3916: l_x_Header_Payment_tbl(1):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;

3912: l_control_rec.clear_api_cache := FALSE;
3913: l_control_rec.clear_api_requests := FALSE;
3914:
3915: -- Load IN parameters if any exist
3916: l_x_Header_Payment_tbl(1):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;
3917: l_x_old_Header_Payment_Tbl(1):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;
3918: l_x_Header_Payment_tbl(1).header_id := p_header_id;
3919:
3920: --bug3781675 adding an IF-ELSE condition for create and update operations

Line 3917: l_x_old_Header_Payment_Tbl(1):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;

3913: l_control_rec.clear_api_requests := FALSE;
3914:
3915: -- Load IN parameters if any exist
3916: l_x_Header_Payment_tbl(1):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;
3917: l_x_old_Header_Payment_Tbl(1):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;
3918: l_x_Header_Payment_tbl(1).header_id := p_header_id;
3919:
3920: --bug3781675 adding an IF-ELSE condition for create and update operations
3921: IF nvl(l_invoice_payment_exists,'N') = 'N' THEN

Line 3989: l_x_Header_Payment_tbl(2):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;

3985: if nvl(l_prepayment_flag, 'N') = 'Y' AND
3986: --bug3733877 Adding the following condition so that the prepayment record is inserted only when p_count = 0
3987: p_count = 0 THEN
3988:
3989: l_x_Header_Payment_tbl(2):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;
3990: l_x_old_Header_Payment_Tbl(2):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;
3991: l_x_Header_Payment_tbl(2).header_id := p_header_id;
3992: l_x_Header_Payment_tbl(2).payment_number := l_max_payment_number+2; --bug3733877
3993:

Line 3990: l_x_old_Header_Payment_Tbl(2):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;

3986: --bug3733877 Adding the following condition so that the prepayment record is inserted only when p_count = 0
3987: p_count = 0 THEN
3988:
3989: l_x_Header_Payment_tbl(2):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;
3990: l_x_old_Header_Payment_Tbl(2):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;
3991: l_x_Header_Payment_tbl(2).header_id := p_header_id;
3992: l_x_Header_Payment_tbl(2).payment_number := l_max_payment_number+2; --bug3733877
3993:
3994: -- Defaulting of flex values is currently done by the form.

Line 4088: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

4084: Procedure Create_Refund
4085: This procedure calls AR Refund Wrapper API to create refund for prepayments.
4086: ----------------------------------------------------------------------------*/
4087: PROCEDURE Create_Refund
4088: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
4089: , p_refund_amount IN NUMBER
4090: , p_payment_set_id IN NUMBER
4091: , p_bank_account_id IN NUMBER
4092: , p_receipt_method_id IN NUMBER

Line 4255: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

4251:
4252: END Create_Refund;
4253:
4254: PROCEDURE Process_Payment_Refund
4255: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
4256: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
4257: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
4258: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
4259: ) IS

Line 4928: l_line_tbl oe_order_pub.line_tbl_type;

4924: AND nvl(invoice_interface_status_code,'NO') <> 'YES';
4925:
4926: l_pay_now_total_detail_tbl AR_VIEW_TERM_GRP.amounts_table;
4927: l_pay_now_total_summary_rec AR_VIEW_TERM_GRP.summary_amounts_rec;
4928: l_line_tbl oe_order_pub.line_tbl_type;
4929: i pls_integer;
4930: --bug5223078 start
4931: j pls_integer;
4932: l_hdr_term_id NUMBER;