DBA Data[Home] [Help]

APPS.ASO_PAYMENT_INT dependencies on ASO_QUOTE_PUB

Line 63: PROCEDURE create_iby_payment(p_payment_rec IN aso_quote_pub.payment_rec_type,

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,

Line 64: db_payment_rec IN aso_quote_pub.payment_rec_type := aso_quote_pub.G_MISS_PAYMENT_REC,

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,

Line 66: x_payment_rec OUT NOCOPY aso_quote_pub.payment_rec_type,

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

Line 78: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;

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:

Line 80: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

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:

Line 81: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

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;

Line 245: PROCEDURE create_payment_row(p_payment_rec IN aso_quote_pub.payment_rec_type,

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)

Line 246: x_payment_rec OUT NOCOPY aso_quote_pub.payment_rec_type,

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

Line 258: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;

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;

Line 260: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_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:

Line 261: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

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

Line 665: PROCEDURE update_payment_row(p_payment_rec IN aso_quote_pub.payment_rec_type,

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

Line 666: x_payment_rec OUT NOCOPY aso_quote_pub.payment_rec_type,

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:

Line 679: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;

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;

Line 680: l_db_payment_rec aso_quote_pub.payment_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;

Line 681: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_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;

Line 682: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_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);

Line 683: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_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);
687: l_shared_cart_scenario varchar2(1) := 'N';

Line 691: lc_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;

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

Line 1584: PROCEDURE delete_payment_row(p_payment_rec IN aso_quote_pub.payment_rec_type,

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

Line 1592: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;

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;

Line 1593: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_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:

Line 1595: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

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

Line 1596: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_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
1600: select a.party_id