DBA Data[Home] [Help]

APPS.ASO_PRICING_INT dependencies on QP_ATTR_MAPPING_PUB

Line 401: RETURN QP_Attr_Mapping_PUB.t_MultiRecord

397:
398: END Get_Customer_Class;
399:
400: FUNCTION Get_Account_Type (p_cust_account_id IN NUMBER)
401: RETURN QP_Attr_Mapping_PUB.t_MultiRecord
402: IS
403:
404: TYPE t_cursor IS REF CURSOR;
405:

Line 406: x_account_type_ids QP_Attr_Mapping_PUB.t_MultiRecord;

402: IS
403:
404: TYPE t_cursor IS REF CURSOR;
405:
406: x_account_type_ids QP_Attr_Mapping_PUB.t_MultiRecord;
407: l_account_type_id VARCHAR2(30);
408: v_count NUMBER := 1;
409: l_acct_type_cursor t_cursor;
410: BEGIN

Line 580: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

576: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
577: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
578: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
579: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
580: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
581: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
582: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
583: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
584: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

Line 581: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

577: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
578: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
579: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
580: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
581: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
582: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
583: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
584: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
585: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

Line 595: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

591: l_message_text VARCHAR2(2000);
592: lx_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
593: lv_return_status VARCHAR2(1);
594: i BINARY_INTEGER;
595: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
596: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
597:
598: BEGIN
599: -- Standard Start of API savepoint

Line 596: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

592: lx_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
593: lv_return_status VARCHAR2(1);
594: i BINARY_INTEGER;
595: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
596: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
597:
598: BEGIN
599: -- Standard Start of API savepoint
600: SAVEPOINT PRICING_ITEM_PVT;

Line 638: QP_ATTR_MAPPING_PUB.Build_Contexts (

634: /* ASO_PRICING_INT.G_HEADER_REC := ASO_PRICING_CORE_PVT.Set_Global_Rec (
635: p_qte_header_rec => p_qte_header_rec,
636: p_shipment_rec => p_hd_shipment_rec);
637: */
638: QP_ATTR_MAPPING_PUB.Build_Contexts (
639: P_REQUEST_TYPE_CODE => l_request_type,
640: P_PRICING_TYPE => 'H',
641: X_PRICE_CONTEXTS_RESULT_TBL => l_hd_pricing_contexts_tbl,
642: X_QUAL_CONTEXTS_RESULT_TBL => l_hd_qual_contexts_tbl);

Line 662: QP_ATTR_MAPPING_PUB.Build_Contexts (

658: p_qte_line_rec => p_qte_line_rec,
659: p_qte_line_dtl_rec => p_qte_line_dtl_rec,
660: p_shipment_rec => p_ln_shipment_rec);
661:
662: QP_ATTR_MAPPING_PUB.Build_Contexts (
663: P_REQUEST_TYPE_CODE => l_request_type,
664: P_PRICING_TYPE => 'L',
665: X_PRICE_CONTEXTS_RESULT_TBL => l_pricing_contexts_tbl,
666: X_QUAL_CONTEXTS_RESULT_TBL => l_qual_contexts_tbl);

Line 711: QP_ATTR_MAPPING_PUB.Build_Contexts (

707: p_qte_line_rec => p_qte_line_rec,
708: p_qte_line_dtl_rec => p_qte_line_dtl_rec,
709: p_shipment_rec => p_ln_shipment_rec);
710:
711: QP_ATTR_MAPPING_PUB.Build_Contexts (
712: P_REQUEST_TYPE_CODE => l_request_type,
713: P_PRICING_TYPE => 'L',
714: X_PRICE_CONTEXTS_RESULT_TBL => l_pricing_contexts_tbl,
715: X_QUAL_CONTEXTS_RESULT_TBL => l_qual_contexts_tbl);

Line 1430: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

1426: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1427: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1428: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1429: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1430: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1431: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1432: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1433: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1434: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

Line 1431: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

1427: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1428: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1429: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1430: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1431: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1432: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1433: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1434: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1435: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;

Line 1432: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

1428: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1429: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1430: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1431: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1432: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1433: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1434: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1435: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1436: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

Line 1433: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

1429: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1430: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1431: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1432: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1433: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1434: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1435: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1436: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1437: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;