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 237: PROCEDURE create_payment_row(p_payment_rec IN aso_quote_pub.payment_rec_type,

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)

Line 238: x_payment_rec OUT NOCOPY aso_quote_pub.payment_rec_type,

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

Line 250: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;

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;

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

Line 253: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

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

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

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

Line 658: x_payment_rec OUT NOCOPY aso_quote_pub.payment_rec_type,

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:

Line 671: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;

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;

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

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

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

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

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

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

Line 1494: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;

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;

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

Line 1497: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

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

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