APPS.OE_VERIFY_PAYMENT_PUB dependencies on OE_ORDER_PUB

Line 42: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

38: -- Function returns 'Y' if the rule identified by calling action
39: -- has been defined at the Order Type setup else returns 'N'.
40:
41: FUNCTION Check_Rule_Defined
42: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
43: , p_calling_action IN VARCHAR2 )
44: RETURN VARCHAR2 ;
45:
46: -- Returns 'Y' if the Order is being paid using a Credit Card

Line 49: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type )

45:
46: -- Returns 'Y' if the Order is being paid using a Credit Card
47:
48: FUNCTION Is_Electronic_Payment
49: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type )
50: RETURN VARCHAR2 ;
51:
52: -- Returns 'Y' if there is specific Credit Card Hold applied on the order.
53:

Line 85: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type -- Order Header Record

81:
82: -- Main Procedure called for all Electronic Payment Processing.
83:
84: PROCEDURE Payment_Request
85: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type -- Order Header Record
86: , p_trxn_type IN VARCHAR2 -- E Payment Transaction Type
87: , p_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER -- Message Count
88: , p_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 -- Messages
89: , p_result_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2 -- PASS, FAIL, RISK

Line 101: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type -- Header Record Type

97:
98: -- Authorizes a Credit Card Payment Request for an Order.
99:
100: PROCEDURE Authorize_Payment
101: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type -- Header Record Type
102: , p_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER -- Message Count
103: , p_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 -- Messages
104: , p_result_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2 -- PASS, FAIL, RISK
105: , p_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 -- Success or Failure

Line 116: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type -- Order Header Record

112: -- 4. Flag to indicate if Reauthorization is required or Not
113: -- 5. Flag to indicate if the Current Transaction is Automatic or Manual
114:
115: PROCEDURE Check_Reauthorize_Order
116: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type -- Order Header Record
117: , p_void_trxn_id OUT NOCOPY /* file.sql.39 change */ NUMBER -- ID of Trxn to be voided
118: , p_outbound_total OUT NOCOPY /* file.sql.39 change */ NUMBER -- Total of outbound lines in the order
119: , p_reauthorize_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2 -- Reauthorize or not 'Y', 'N'
120: );

Line 125: ( p_header_rec IN OE_Order_Pub.Header_Rec_Type ) -- Order Header Record

121:
122: -- Returns FALSE if one of the Attributes required for Auhtorization is missing
123:
124: FUNCTION Validate_Required_Attributes
125: ( p_header_rec IN OE_Order_Pub.Header_Rec_Type ) -- Order Header Record
126: RETURN BOOLEAN;
127:
128: -- Returns Primary Payment Method for the Customer
129:

Line 131: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type -- Header Record Type

127:
128: -- Returns Primary Payment Method for the Customer
129:
130: FUNCTION Get_Primary_Pay_Method
131: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type -- Header Record Type
132: ) RETURN NUMBER;
133:
134: -- Returns Payment Method Details for a given Receipt Method Id
135:

Line 161: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type -- Order Header Record

157:
158: -- Returns 'Y' if this authorization was taken through iPayment else 'N'.
159:
160: PROCEDURE Fetch_Authorization_Trxn
161: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type -- Order Header Record
162: , p_trxn_id OUT NOCOPY /* file.sql.39 change */ NUMBER -- iPayment Transaction ID
163: , p_automatic_auth OUT NOCOPY /* file.sql.39 change */ VARCHAR2 -- 'Y' or 'N'
164: );
165:

Line 169: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type -- Order Header Record

165:
166: -- Fetches the Current Authorization Transaction for the Order
167:
168: PROCEDURE Fetch_Current_Auth
169: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type -- Order Header Record
170: , p_line_id IN NUMBER DEFAULT NULL
171: , p_auth_code IN VARCHAR2 DEFAULT NULL
172: , p_auth_date IN DATE DEFAULT NULL
173: , p_trxn_id OUT NOCOPY /* file.sql.39 change */ NUMBER -- Transaction ID

Line 180: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type -- Order Header Record

176:
177: -- Fetches the Last Authorization Transaction for the Order
178:
179: PROCEDURE Fetch_Last_Auth
180: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type -- Order Header Record
181: , p_trxn_id OUT NOCOPY /* file.sql.39 change */ NUMBER -- Transaction ID
182: , p_tangible_id OUT NOCOPY /* file.sql.39 change */ VARCHAR2 -- Unique Tangible ID
183: , p_auth_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2 -- CC Approval Code
184: , p_trxn_date OUT NOCOPY /* file.sql.39 change */ DATE -- CC Approval Date

Line 208: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type -- Order Header Record

204: ( p_header_id IN NUMBER)
205: RETURN NUMBER ;
206:
207: PROCEDURE Authorize_MultiPayments
208: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type -- Order Header Record
209: , p_line_id IN NUMBER DEFAULT null --bug3524209
210: , p_calling_action IN VARCHAR2
211: --comm rej, p_reject_on_auth_failure IN VARCHAR2 DEFAULT NULL --R12 CC Encryption
212: --comm rej, p_reject_on_risk_failure IN VARCHAR2 DEFAULT NULL