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;
241: End create_iby_payment;
242:
243:
244:
245: PROCEDURE create_payment_row(p_payment_rec IN aso_quote_pub.payment_rec_type,
246: x_payment_rec OUT NOCOPY aso_quote_pub.payment_rec_type,
247: x_return_status OUT NOCOPY varchar2,
248: x_msg_count OUT NOCOPY number,
249: x_msg_data OUT NOCOPY varchar2)
242:
243:
244:
245: PROCEDURE create_payment_row(p_payment_rec IN aso_quote_pub.payment_rec_type,
246: x_payment_rec OUT NOCOPY aso_quote_pub.payment_rec_type,
247: x_return_status OUT NOCOPY varchar2,
248: x_msg_count OUT NOCOPY number,
249: x_msg_data OUT NOCOPY varchar2)
250: IS
254: lx_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
255: lx_assign_id number;
256: lx_entity_id number;
257: l_trxn_attribs IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
258: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;
259: l_api_name varchar2(1000) := 'create_payment_row';
260: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
261: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
262: lx_channel_attrib_uses IBY_FNDCPT_SETUP_PUB.PmtChannel_AttribUses_rec_type;
256: lx_entity_id number;
257: l_trxn_attribs IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
258: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;
259: l_api_name varchar2(1000) := 'create_payment_row';
260: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
261: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
262: lx_channel_attrib_uses IBY_FNDCPT_SETUP_PUB.PmtChannel_AttribUses_rec_type;
263: l_payment_ref_number varchar2(240);
264:
257: l_trxn_attribs IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
258: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;
259: l_api_name varchar2(1000) := 'create_payment_row';
260: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
261: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
262: lx_channel_attrib_uses IBY_FNDCPT_SETUP_PUB.PmtChannel_AttribUses_rec_type;
263: l_payment_ref_number varchar2(240);
264:
265: Cursor c_get_payer_id ( p_assignment_id NUMBER) is
661: End create_payment_row;
662:
663:
664:
665: PROCEDURE update_payment_row(p_payment_rec IN aso_quote_pub.payment_rec_type,
666: x_payment_rec OUT NOCOPY aso_quote_pub.payment_rec_type,
667: x_return_status OUT NOCOPY varchar2,
668: x_msg_count OUT NOCOPY number,
669: x_msg_data OUT NOCOPY varchar2) is
662:
663:
664:
665: PROCEDURE update_payment_row(p_payment_rec IN aso_quote_pub.payment_rec_type,
666: x_payment_rec OUT NOCOPY aso_quote_pub.payment_rec_type,
667: x_return_status OUT NOCOPY varchar2,
668: x_msg_count OUT NOCOPY number,
669: x_msg_data OUT NOCOPY varchar2) is
670:
675: lx_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
676: lx_assign_id number;
677: lx_entity_id number;
678: l_trxn_attribs IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
679: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;
680: l_db_payment_rec aso_quote_pub.payment_rec_type;
681: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
682: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
683: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
676: lx_assign_id number;
677: lx_entity_id number;
678: l_trxn_attribs IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
679: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;
680: l_db_payment_rec aso_quote_pub.payment_rec_type;
681: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
682: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
683: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
684: l_card_instrument IBY_FNDCPT_SETUP_PUB.CreditCard_rec_type;
677: lx_entity_id number;
678: l_trxn_attribs IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
679: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;
680: l_db_payment_rec aso_quote_pub.payment_rec_type;
681: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
682: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
683: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
684: l_card_instrument IBY_FNDCPT_SETUP_PUB.CreditCard_rec_type;
685: lx_channel_attrib_uses IBY_FNDCPT_SETUP_PUB.PmtChannel_AttribUses_rec_type;
678: l_trxn_attribs IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
679: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;
680: l_db_payment_rec aso_quote_pub.payment_rec_type;
681: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
682: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
683: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
684: l_card_instrument IBY_FNDCPT_SETUP_PUB.CreditCard_rec_type;
685: lx_channel_attrib_uses IBY_FNDCPT_SETUP_PUB.PmtChannel_AttribUses_rec_type;
686: l_payment_ref_number varchar2(240);
679: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;
680: l_db_payment_rec aso_quote_pub.payment_rec_type;
681: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
682: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
683: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
684: l_card_instrument IBY_FNDCPT_SETUP_PUB.CreditCard_rec_type;
685: lx_channel_attrib_uses IBY_FNDCPT_SETUP_PUB.PmtChannel_AttribUses_rec_type;
686: l_payment_ref_number varchar2(240);
687: l_shared_cart_scenario varchar2(1) := 'N';
687: l_shared_cart_scenario varchar2(1) := 'N';
688: l_orig_party_id number;
689:
690: /*** Start : Code Added for Bug 8712439 for HTML Quoting PA-DSS update issue ***/
691: lc_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;
692: /*** End : Code Added for Bug 8712439 for HTML Quoting PA-DSS update issue ***/
693:
694:
695: Cursor c_get_payer_id ( p_assignment_id NUMBER) is
1580: ,X_RETURN_STATUS => X_RETURN_STATUS);
1581: end update_payment_row;
1582:
1583:
1584: PROCEDURE delete_payment_row(p_payment_rec IN aso_quote_pub.payment_rec_type,
1585: x_return_status OUT NOCOPY varchar2,
1586: x_msg_count OUT NOCOPY number,
1587: x_msg_data OUT NOCOPY varchar2)
1588: IS
1588: IS
1589:
1590: L_API_NAME varchar2(1000) := 'delete_payment_row';
1591: l_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
1592: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;
1593: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1594: lx_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1595: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1596: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1589:
1590: L_API_NAME varchar2(1000) := 'delete_payment_row';
1591: l_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
1592: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;
1593: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1594: lx_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1595: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1596: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1597:
1591: l_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
1592: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;
1593: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1594: lx_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1595: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1596: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1597:
1598:
1599: Cursor c_get_payer_from_trxn(p_trxn_extension_id number) is
1592: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;
1593: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1594: lx_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1595: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1596: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1597:
1598:
1599: Cursor c_get_payer_from_trxn(p_trxn_extension_id number) is
1600: select a.party_id