618: l_epayment_failure_hold VARCHAR2(1) := 'N';
619: l_ppp_hold_exists VARCHAR2(1) := 'N';
620: l_process_payment VARCHAR2(1) := 'N';
621: l_hold_exists VARCHAR2(1);
622: l_hold_source_rec OE_Holds_PVT.Hold_Source_REC_type;
623: l_threshold_amount NUMBER := 0;
624: l_bank_acct_id NUMBER;
625: l_bank_acct_uses_id NUMBER;
626: l_payment_response_error_code VARCHAR2(80);
1325: l_msg_count NUMBER := 0;
1326: l_msg_data VARCHAR2(2000);
1327: l_return_status VARCHAR2(30);
1328:
1329: l_hold_source_rec OE_Holds_PVT.Hold_Source_REC_type;
1330:
1331: --
1332: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1333: --
1462: l_msg_count NUMBER := 0;
1463: l_msg_data VARCHAR2(2000);
1464: l_return_status VARCHAR2(30);
1465: l_release_reason VARCHAR2(30);
1466: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
1467: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
1468:
1469: --
1470: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1463: l_msg_data VARCHAR2(2000);
1464: l_return_status VARCHAR2(30);
1465: l_release_reason VARCHAR2(30);
1466: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
1467: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
1468:
1469: --
1470: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1471: --
1666: l_msg_count NUMBER := 0;
1667: l_msg_data VARCHAR2(2000);
1668: l_return_status VARCHAR2(30);
1669: l_release_reason VARCHAR2(30);
1670: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
1671: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
1672:
1673: --
1674: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1667: l_msg_data VARCHAR2(2000);
1668: l_return_status VARCHAR2(30);
1669: l_release_reason VARCHAR2(30);
1670: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
1671: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
1672:
1673: --
1674: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1675: --