59:
60: END Get_payment_term_id;
61:
62:
63: PROCEDURE create_iby_payment(p_payment_rec IN aso_quote_pub.payment_rec_type,
64: db_payment_rec IN aso_quote_pub.payment_rec_type := aso_quote_pub.G_MISS_PAYMENT_REC,
65: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
66: x_payment_rec OUT NOCOPY aso_quote_pub.payment_rec_type,
67: x_return_status OUT NOCOPY varchar2,
60: END Get_payment_term_id;
61:
62:
63: PROCEDURE create_iby_payment(p_payment_rec IN aso_quote_pub.payment_rec_type,
64: db_payment_rec IN aso_quote_pub.payment_rec_type := aso_quote_pub.G_MISS_PAYMENT_REC,
65: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
66: x_payment_rec OUT NOCOPY aso_quote_pub.payment_rec_type,
67: x_return_status OUT NOCOPY varchar2,
68: x_msg_count OUT NOCOPY number,
62:
63: PROCEDURE create_iby_payment(p_payment_rec IN aso_quote_pub.payment_rec_type,
64: db_payment_rec IN aso_quote_pub.payment_rec_type := aso_quote_pub.G_MISS_PAYMENT_REC,
65: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
66: x_payment_rec OUT NOCOPY aso_quote_pub.payment_rec_type,
67: x_return_status OUT NOCOPY varchar2,
68: x_msg_count OUT NOCOPY number,
69: x_msg_data OUT NOCOPY varchar2)
70: IS
74: lx_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
75: lx_assign_id number;
76: lx_entity_id number;
77: l_trxn_attribs IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
78: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;
79: l_api_name varchar2(1000) := 'create_iby_payment';
80: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
81: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
82:
76: lx_entity_id number;
77: l_trxn_attribs IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
78: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;
79: l_api_name varchar2(1000) := 'create_iby_payment';
80: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
81: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
82:
83: Begin
84:
77: l_trxn_attribs IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
78: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;
79: l_api_name varchar2(1000) := 'create_iby_payment';
80: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
81: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
82:
83: Begin
84:
85: SAVEPOINT CREATE_IBY_PAYMENT_INT;
233: End create_iby_payment;
234:
235:
236:
237: PROCEDURE create_payment_row(p_payment_rec IN aso_quote_pub.payment_rec_type,
238: x_payment_rec OUT NOCOPY aso_quote_pub.payment_rec_type,
239: x_return_status OUT NOCOPY varchar2,
240: x_msg_count OUT NOCOPY number,
241: x_msg_data OUT NOCOPY varchar2)
234:
235:
236:
237: PROCEDURE create_payment_row(p_payment_rec IN aso_quote_pub.payment_rec_type,
238: x_payment_rec OUT NOCOPY aso_quote_pub.payment_rec_type,
239: x_return_status OUT NOCOPY varchar2,
240: x_msg_count OUT NOCOPY number,
241: x_msg_data OUT NOCOPY varchar2)
242: IS
246: lx_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
247: lx_assign_id number;
248: lx_entity_id number;
249: l_trxn_attribs IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
250: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;
251: l_api_name varchar2(1000) := 'create_payment_row';
252: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
253: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
254: lx_channel_attrib_uses IBY_FNDCPT_SETUP_PUB.PmtChannel_AttribUses_rec_type;
248: lx_entity_id number;
249: l_trxn_attribs IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
250: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;
251: l_api_name varchar2(1000) := 'create_payment_row';
252: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
253: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
254: lx_channel_attrib_uses IBY_FNDCPT_SETUP_PUB.PmtChannel_AttribUses_rec_type;
255: l_payment_ref_number varchar2(240);
256:
249: l_trxn_attribs IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
250: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;
251: l_api_name varchar2(1000) := 'create_payment_row';
252: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
253: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
254: lx_channel_attrib_uses IBY_FNDCPT_SETUP_PUB.PmtChannel_AttribUses_rec_type;
255: l_payment_ref_number varchar2(240);
256:
257: Cursor c_get_payer_id ( p_assignment_id NUMBER) is
653: End create_payment_row;
654:
655:
656:
657: PROCEDURE update_payment_row(p_payment_rec IN aso_quote_pub.payment_rec_type,
658: x_payment_rec OUT NOCOPY aso_quote_pub.payment_rec_type,
659: x_return_status OUT NOCOPY varchar2,
660: x_msg_count OUT NOCOPY number,
661: x_msg_data OUT NOCOPY varchar2) is
654:
655:
656:
657: PROCEDURE update_payment_row(p_payment_rec IN aso_quote_pub.payment_rec_type,
658: x_payment_rec OUT NOCOPY aso_quote_pub.payment_rec_type,
659: x_return_status OUT NOCOPY varchar2,
660: x_msg_count OUT NOCOPY number,
661: x_msg_data OUT NOCOPY varchar2) is
662:
667: lx_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
668: lx_assign_id number;
669: lx_entity_id number;
670: l_trxn_attribs IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
671: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;
672: l_db_payment_rec aso_quote_pub.payment_rec_type;
673: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
674: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
675: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
668: lx_assign_id number;
669: lx_entity_id number;
670: l_trxn_attribs IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
671: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;
672: l_db_payment_rec aso_quote_pub.payment_rec_type;
673: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
674: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
675: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
676: l_card_instrument IBY_FNDCPT_SETUP_PUB.CreditCard_rec_type;
669: lx_entity_id number;
670: l_trxn_attribs IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
671: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;
672: l_db_payment_rec aso_quote_pub.payment_rec_type;
673: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
674: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
675: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
676: l_card_instrument IBY_FNDCPT_SETUP_PUB.CreditCard_rec_type;
677: lx_channel_attrib_uses IBY_FNDCPT_SETUP_PUB.PmtChannel_AttribUses_rec_type;
670: l_trxn_attribs IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
671: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;
672: l_db_payment_rec aso_quote_pub.payment_rec_type;
673: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
674: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
675: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
676: l_card_instrument IBY_FNDCPT_SETUP_PUB.CreditCard_rec_type;
677: lx_channel_attrib_uses IBY_FNDCPT_SETUP_PUB.PmtChannel_AttribUses_rec_type;
678: l_payment_ref_number varchar2(240);
671: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;
672: l_db_payment_rec aso_quote_pub.payment_rec_type;
673: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
674: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
675: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
676: l_card_instrument IBY_FNDCPT_SETUP_PUB.CreditCard_rec_type;
677: lx_channel_attrib_uses IBY_FNDCPT_SETUP_PUB.PmtChannel_AttribUses_rec_type;
678: l_payment_ref_number varchar2(240);
679: l_shared_cart_scenario varchar2(1) := 'N';
1482: ,X_RETURN_STATUS => X_RETURN_STATUS);
1483: end update_payment_row;
1484:
1485:
1486: PROCEDURE delete_payment_row(p_payment_rec IN aso_quote_pub.payment_rec_type,
1487: x_return_status OUT NOCOPY varchar2,
1488: x_msg_count OUT NOCOPY number,
1489: x_msg_data OUT NOCOPY varchar2)
1490: IS
1490: IS
1491:
1492: L_API_NAME varchar2(1000) := 'delete_payment_row';
1493: l_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
1494: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;
1495: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1496: lx_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1497: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1498: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1491:
1492: L_API_NAME varchar2(1000) := 'delete_payment_row';
1493: l_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
1494: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;
1495: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1496: lx_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1497: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1498: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1499:
1493: l_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
1494: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;
1495: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1496: lx_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1497: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1498: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1499:
1500:
1501: Cursor c_get_payer_from_trxn(p_trxn_extension_id number) is
1494: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;
1495: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1496: lx_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1497: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1498: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1499:
1500:
1501: Cursor c_get_payer_from_trxn(p_trxn_extension_id number) is
1502: select a.party_id