1 PACKAGE OE_PrePayment_UTIL AUTHID CURRENT_USER AS
2 /* $Header: OEXUPPYS.pls 120.3 2005/10/14 15:27:36 lkxu noship $ */
3
4 G_DO_PREPAYMENT VARCHAR2(1) := NULL;
5 G_OM_H_INSTALLED VARCHAR2(1) := NULL;
6
7 TYPE Payment_Term_Rec_Type IS RECORD
8 ( payment_term_id NUMBER := FND_API.G_MISS_NUM
9 , is_prepaid_order VARCHAR2(1) := NULL
10 );
11
12 TYPE Payment_Term_Tbl_Type IS TABLE OF Payment_Term_Rec_Type
13 INDEX BY BINARY_INTEGER;
14
15 G_Payment_Term_Rec Payment_Term_Rec_Type;
16 G_Payment_Term_Tbl Payment_Term_Tbl_Type;
17
18 -- This procedure is used by the validation template PREPAY defined for processing constraints
19 PROCEDURE Is_Prepaid(p_application_id IN NUMBER,
20 p_entity_short_name in VARCHAR2,
21 p_validation_entity_short_name in VARCHAR2,
22 p_validation_tmplt_short_name in VARCHAR2,
23 p_record_set_tmplt_short_name in VARCHAR2,
24 p_scope in VARCHAR2,
25 p_result OUT NOCOPY NUMBER );
26
27
28 -- This procedure returns the prepayment attributes info given the header_id
29 PROCEDURE Get_PrePayment_Info
30 ( p_header_id IN NUMBER
31 , x_payment_set_id OUT NOCOPY NUMBER
32
33 , x_prepaid_amount OUT NOCOPY NUMBER
34
35 );
36
37 -- This procedure is used by the concurrent program Process Pending Payments
38 PROCEDURE PendProcessPayments_Conc_Prog
39 ( errbuf OUT NOCOPY VARCHAR2
40
41 ,retcode OUT NOCOPY NUMBER
42 ,p_operating_unit IN NUMBER --MOAC Changes
43 ,p_ppp_hold IN VARCHAR2
44 ,p_epay_failure_hold IN VARCHAR2
45 ,p_epay_server_failure_hold IN VARCHAR2
46 ,p_payment_authorization_hold IN VARCHAR2
47 ,p_order_type_id IN NUMBER
48 ,p_order_number_from IN NUMBER
49 ,p_order_number_to IN NUMBER
50 ,p_customer_number_from IN VARCHAR2
51 ,p_customer_number_to IN VARCHAR2
52 ,p_debug_level IN NUMBER
53 ,p_customer_class_code IN VARCHAR2
54 ,p_credit_card_number IN VARCHAR2
55 ,p_credit_card_type IN VARCHAR2
56 ,p_bill_to_org_id IN NUMBER
57 ,p_booked_date_since IN VARCHAR2
58 );
59
60 /*-------------------------------------------------------------------
61 Function Is_Prepaid_Order
62 Returns 'Y' if the Order is being paid using a Credit Card AND
63 the payment term is of prepayment type.
64 ---------------------------------------------------------------------*/
65 FUNCTION Is_Prepaid_Order
66 ( p_header_rec IN OE_Order_PUB.Header_Rec_Type )
67 RETURN VARCHAR2;
68
69 -- overloading the function so that it also takes header_id.
70 FUNCTION Is_Prepaid_Order
71 ( p_header_id IN NUMBER )
72 RETURN VARCHAR2;
73
74 FUNCTION IS_MULTIPLE_PAYMENTS_ENABLED RETURN BOOLEAN;
75
76 FUNCTION Is_MultiPayments_Order
77 ( p_header_id IN NUMBER )
78 RETURN VARCHAR2;
79
80 Procedure UPLOAD_COMMITMENT(
81 p_line_id in number,
82 p_action in varchar2,
83 x_return_status out nocopy varchar2,
84 x_msg_count out nocopy number,
85 x_msg_data out nocopy varchar2);
86
87 FUNCTION get_downpayment_amount( p_header_id in number,
88 p_term_id in number := NULL,
89 p_curr_code in varchar2 := NULL,
90 p_order_total in number := NULL)
91 return number;
92
93 -- This procedure is used by the validation template TPREPAY defined for processing constraint used by PAYMENT_TERM
94 PROCEDURE Is_Prepaid_for_payment_term(p_application_id IN NUMBER,
95 p_entity_short_name in VARCHAR2,
96 p_validation_entity_short_name in VARCHAR2,
97 p_validation_tmplt_short_name in VARCHAR2,
98 p_record_set_tmplt_short_name in VARCHAR2,
99 p_scope in VARCHAR2,
100 p_result OUT NOCOPY NUMBER );
101
102 --pnpl start
103 FUNCTION Get_Installment_Options(p_org_id IN NUMBER DEFAULT NULL) RETURN VARCHAR2;
104
105 FUNCTION Is_Pay_Now_Line (p_line_id IN NUMBER) RETURN BOOLEAN;
106 --pnpl end
107
108
109 END OE_Prepayment_UTIL;