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.

[Home] [Help]

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 498: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

494: Procedure Refund_Request
495: This procedure calls AR API to submit refund request for the amount specified.
496: ----------------------------------------------------------------------------*/
497: PROCEDURE Refund_Request
498: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
499: , p_amount IN NUMBER
500: , p_payment_set_id IN NUMBER
501: , x_msg_count OUT NOCOPY NUMBER
502: , x_msg_data OUT NOCOPY VARCHAR2

Line 594: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

590: This is the main procedure for PrePayment. It is called from
591: OE_Verify_Payment_PUB.Verify_Payment for those prepaid orders.
592: ----------------------------------------------------------------------------*/
593: PROCEDURE Process_PrePayment_Order
594: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
595: , p_calling_action IN VARCHAR2
596: , p_delayed_request IN VARCHAR2
597: , x_msg_count OUT NOCOPY NUMBER
598: , x_msg_data OUT NOCOPY VARCHAR2

Line 613: l_header_rec OE_Order_PUB.Header_Rec_Type := p_header_rec;

609: AND header_id = p_header_id;
610:
611:
612: l_calling_action VARCHAR2(30) := p_calling_action;
613: l_header_rec OE_Order_PUB.Header_Rec_Type := p_header_rec;
614: l_pending_amount NUMBER := 0;
615: l_create_receipt VARCHAR2(1) := 'N';
616: l_request_refund VARCHAR2(1) := 'N';
617: l_apply_ppp_hold VARCHAR2(1) := 'N';

Line 1816: l_header_rec OE_ORDER_PUB.Header_Rec_Type;

1812: , x_msg_data OUT NOCOPY VARCHAR2
1813: , x_return_status OUT NOCOPY VARCHAR2
1814: ) IS
1815:
1816: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
1817: l_line_id NUMBER;
1818: l_payment_set_id NUMBER := NULL;
1819: l_bank_acct_id NUMBER := NULL;
1820: l_bank_acct_uses_id NUMBER := NULL;

Line 1825: l_header_payment_rec OE_Order_PUB.Header_Payment_Rec_Type;

1821: l_application_ref_id NUMBER := p_header_id;
1822: l_application_ref_num NUMBER;
1823: l_payment_response_error_code VARCHAR2(80);
1824: l_approval_code VARCHAR2(80);
1825: l_header_payment_rec OE_Order_PUB.Header_Payment_Rec_Type;
1826: l_insert VARCHAR2(1) := 'N';
1827: l_status NUMBER;
1828: l_msg_count NUMBER := 0;
1829: l_msg_data VARCHAR2(2000) := NULL;

Line 2645: l_line_payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;

2641: ,x_msg_count OUT NOCOPY NUMBER
2642: ,x_msg_data OUT NOCOPY VARCHAR2
2643: ) IS
2644:
2645: l_line_payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
2646: l_x_old_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
2647: l_from_line_payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
2648: l_control_rec OE_GLOBALS.Control_Rec_Type;
2649: l_return_status VARCHAR2(2000);

Line 2646: l_x_old_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;

2642: ,x_msg_data OUT NOCOPY VARCHAR2
2643: ) IS
2644:
2645: l_line_payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
2646: l_x_old_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
2647: l_from_line_payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
2648: l_control_rec OE_GLOBALS.Control_Rec_Type;
2649: l_return_status VARCHAR2(2000);
2650: i NUMBER;

Line 2647: l_from_line_payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;

2643: ) IS
2644:
2645: l_line_payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
2646: l_x_old_Line_Payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
2647: l_from_line_payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
2648: l_control_rec OE_GLOBALS.Control_Rec_Type;
2649: l_return_status VARCHAR2(2000);
2650: i NUMBER;
2651: j NUMBER;

Line 2879: l_line_payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;

2875: AND ar.applied_payment_schedule_id = -7
2876: AND ar.payment_set_id = p_payment_set_id;
2877: **/
2878:
2879: l_line_payment_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
2880: l_receipt_status VARCHAR2(30);
2881: l_payment_type_code VARCHAR2(30);
2882: l_payment_set_id NUMBER;
2883: l_payment_not_assured VARCHAR2(1) := 'N';

Line 3655: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

3651: line_payment_type varchar2(30) := NULL;
3652:
3653:
3654: l_control_rec OE_GLOBALS.Control_Rec_Type;
3655: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3656: l_x_Old_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3657: l_commitment_id number;
3658: line_commitment_id number;
3659: l_pmt_changed varchar2(1) := 'N';

Line 3656: l_x_Old_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

3652:
3653:
3654: l_control_rec OE_GLOBALS.Control_Rec_Type;
3655: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3656: l_x_Old_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3657: l_commitment_id number;
3658: line_commitment_id number;
3659: l_pmt_changed varchar2(1) := 'N';
3660: --bug3733877 start

Line 3666: l_old_header_rec OE_Order_Pub.Header_Rec_Type;

3662: l_max_payment_number NUMBER := 0;
3663: --bug3733877 end
3664: --bug3781675 start
3665: l_inv_payment_number NUMBER;
3666: l_old_header_rec OE_Order_Pub.Header_Rec_Type;
3667: l_header_rec OE_Order_Pub.Header_Rec_Type;
3668: l_index NUMBER;
3669: --bug3781675 end
3670:

Line 3667: l_header_rec OE_Order_Pub.Header_Rec_Type;

3663: --bug3733877 end
3664: --bug3781675 start
3665: l_inv_payment_number NUMBER;
3666: l_old_header_rec OE_Order_Pub.Header_Rec_Type;
3667: l_header_rec OE_Order_Pub.Header_Rec_Type;
3668: l_index NUMBER;
3669: --bug3781675 end
3670:
3671: --bug3906851

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

4046: l_control_rec.clear_api_cache := FALSE;
4047: l_control_rec.clear_api_requests := FALSE;
4048:
4049: -- Load IN parameters if any exist
4050: l_x_Header_Payment_tbl(1):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;
4051: l_x_old_Header_Payment_Tbl(1):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;
4052: l_x_Header_Payment_tbl(1).header_id := p_header_id;
4053:
4054: --bug3781675 adding an IF-ELSE condition for create and update operations

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

4047: l_control_rec.clear_api_requests := FALSE;
4048:
4049: -- Load IN parameters if any exist
4050: l_x_Header_Payment_tbl(1):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;
4051: l_x_old_Header_Payment_Tbl(1):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;
4052: l_x_Header_Payment_tbl(1).header_id := p_header_id;
4053:
4054: --bug3781675 adding an IF-ELSE condition for create and update operations
4055: IF nvl(l_invoice_payment_exists,'N') = 'N' THEN

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

4119: if nvl(l_prepayment_flag, 'N') = 'Y' AND
4120: --bug3733877 Adding the following condition so that the prepayment record is inserted only when p_count = 0
4121: p_count = 0 THEN
4122:
4123: l_x_Header_Payment_tbl(2):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;
4124: l_x_old_Header_Payment_Tbl(2):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;
4125: l_x_Header_Payment_tbl(2).header_id := p_header_id;
4126: l_x_Header_Payment_tbl(2).payment_number := l_max_payment_number+2; --bug3733877
4127:

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

4120: --bug3733877 Adding the following condition so that the prepayment record is inserted only when p_count = 0
4121: p_count = 0 THEN
4122:
4123: l_x_Header_Payment_tbl(2):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;
4124: l_x_old_Header_Payment_Tbl(2):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;
4125: l_x_Header_Payment_tbl(2).header_id := p_header_id;
4126: l_x_Header_Payment_tbl(2).payment_number := l_max_payment_number+2; --bug3733877
4127:
4128: -- Defaulting of flex values is currently done by the form.

Line 4222: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

4218: Procedure Create_Refund
4219: This procedure calls AR Refund Wrapper API to create refund for prepayments.
4220: ----------------------------------------------------------------------------*/
4221: PROCEDURE Create_Refund
4222: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
4223: , p_refund_amount IN NUMBER
4224: , p_payment_set_id IN NUMBER
4225: , p_bank_account_id IN NUMBER
4226: , p_receipt_method_id IN NUMBER

Line 4389: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

4385:
4386: END Create_Refund;
4387:
4388: PROCEDURE Process_Payment_Refund
4389: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
4390: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
4391: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
4392: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
4393: ) IS

Line 5062: l_line_tbl oe_order_pub.line_tbl_type;

5058: AND nvl(invoice_interface_status_code,'NO') <> 'YES';
5059:
5060: l_pay_now_total_detail_tbl AR_VIEW_TERM_GRP.amounts_table;
5061: l_pay_now_total_summary_rec AR_VIEW_TERM_GRP.summary_amounts_rec;
5062: l_line_tbl oe_order_pub.line_tbl_type;
5063: i pls_integer;
5064: --bug5223078 start
5065: j pls_integer;
5066: l_hdr_term_id NUMBER;