APPS.OE_VERIFY_PAYMENT_PUB dependencies on OE_ORDER_PUB

Line 45: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

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

Line 52: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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