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: x_pass_line VARCHAR2(10); -- bug 12988510
599:

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: x_pass_line VARCHAR2(10); -- bug 12988510
599:
600: BEGIN

Line 642: QP_ATTR_MAPPING_PUB.Build_Contexts (

638: p_shipment_rec => p_hd_shipment_rec);
639: */
640:
641: -- bug 12988510, using overloaded funtion of build context which passes p_check_line_flag, p_pricing_event and returns x_pass_line
642: QP_ATTR_MAPPING_PUB.Build_Contexts (
643: P_REQUEST_TYPE_CODE => l_request_type,
644: P_PRICING_TYPE => 'H',
645: p_check_line_flag => 'N',
646: p_pricing_event => l_pricing_event,

Line 670: QP_ATTR_MAPPING_PUB.Build_Contexts (

666: p_qte_line_dtl_rec => p_qte_line_dtl_rec,
667: p_shipment_rec => p_ln_shipment_rec);
668:
669: -- bug 12988510, using overloaded funtion of build context which passes p_check_line_flag, p_pricing_event and returns x_pass_line
670: QP_ATTR_MAPPING_PUB.Build_Contexts (
671: P_REQUEST_TYPE_CODE => l_request_type,
672: P_PRICING_TYPE => 'L',
673: p_check_line_flag => 'N',
674: p_pricing_event => l_pricing_event,

Line 723: QP_ATTR_MAPPING_PUB.Build_Contexts (

719: p_qte_line_dtl_rec => p_qte_line_dtl_rec,
720: p_shipment_rec => p_ln_shipment_rec);
721:
722: -- bug 12988510, using overloaded funtion of build context which passes p_check_line_flag, p_pricing_event and returns x_pass_line
723: QP_ATTR_MAPPING_PUB.Build_Contexts (
724: P_REQUEST_TYPE_CODE => l_request_type,
725: P_PRICING_TYPE => 'L',
726: p_check_line_flag => 'N',
727: p_pricing_event => l_pricing_event,

Line 1445: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

1441: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1442: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1443: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1444: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1445: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1446: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1447: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1448: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1449: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

Line 1446: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

1442: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1443: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1444: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1445: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1446: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1447: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1448: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1449: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1450: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;

Line 1447: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

1443: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1444: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1445: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1446: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1447: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1448: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1449: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1450: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1451: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

Line 1448: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

1444: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1445: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1446: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1447: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1448: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1449: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1450: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1451: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1452: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;