APPS.OKC_PRICE_PUB dependencies on QP_ATTR_MAPPING_PUB

Line 905: p_pricing_contexts_tbl IN QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,

901:
902: -- This Procedure will return the attributes sourced using QP dimension mapping
903:
904: Procedure Load_Sourced_Pattrs(p_service_line_index IN NUMBER,
905: p_pricing_contexts_tbl IN QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
906: px_Req_line_attr_tbl IN OUT nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE) IS
907:
908: BEGIN
909: --- Load the pricing attributes of service item

Line 1092: p_pricing_contexts_tbl IN QP_ATTR_MAPPING_PUB.CONTEXTS_RESULT_TBL_TYPE,

1088: p_cp_Line_tbl IN OKC_PRICE_PUB.G_SLINE_TBL_TYPE,
1089: p_get_pb_tbl_flag IN Varchar2,
1090: p_price_list_id IN Number,
1091: p_modifier_list_id IN Number,
1092: p_pricing_contexts_tbl IN QP_ATTR_MAPPING_PUB.CONTEXTS_RESULT_TBL_TYPE,
1093: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
1094: px_Req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
1095: px_req_related_lines_tbl IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
1096: px_req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE) IS

Line 1266: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

1262: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1263: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1264: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1265: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1266: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1267: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1268: i Number;
1269:
1270: Begin

Line 1267: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

1263: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1264: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1265: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1266: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1267: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1268: i Number;
1269:
1270: Begin
1271: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 1276: QP_Attr_Mapping_PUB.Build_Contexts(p_request_type_code => OKC_PRICE_PUB.G_REQUEST_TYPE_CODE,

1272: G_CONTROL_REC.pricing_event := OKC_PRICE_PUB.G_PRICING_EVENT;
1273: G_CONTROL_REC.calculate_flag := 'Y';
1274: G_CONTROL_REC.simulation_flag := 'N';
1275:
1276: QP_Attr_Mapping_PUB.Build_Contexts(p_request_type_code => OKC_PRICE_PUB.G_REQUEST_TYPE_CODE,
1277: p_pricing_type => 'L',
1278: x_price_contexts_result_tbl => l_pricing_contexts_Tbl,
1279: x_qual_contexts_result_tbl => l_qualifier_Contexts_Tbl);
1280:

Line 2100: l_temp_tbl QP_Attr_Mapping_PUB.t_MultiRecord;

2096: /*--------Begin Added by Jomy--------*/
2097: Procedure Get_Customer_Info(p_cust_id NUMBER)
2098: IS
2099: v_count NUMBER := 1;
2100: l_temp_tbl QP_Attr_Mapping_PUB.t_MultiRecord;
2101: i pls_integer;
2102: BEGIN
2103: G_Customer_Info.customer_id := p_cust_id;
2104: -- Getting info from OKX_CUSTOMER_ACCOUNTS_V

Line 2174: RETURN QP_Attr_Mapping_PUB.t_MultiRecord

2170: (
2171: p_inventory_item_id IN NUMBER,
2172: p_org_id IN NUMBER
2173: )
2174: RETURN QP_Attr_Mapping_PUB.t_MultiRecord
2175: IS
2176:
2177: x_category_ids QP_Attr_Mapping_PUB.t_MultiRecord;
2178:

Line 2177: x_category_ids QP_Attr_Mapping_PUB.t_MultiRecord;

2173: )
2174: RETURN QP_Attr_Mapping_PUB.t_MultiRecord
2175: IS
2176:
2177: x_category_ids QP_Attr_Mapping_PUB.t_MultiRecord;
2178:
2179: BEGIN
2180: -- Bug 2304008 skekkar
2181: SELECT ic.id1

Line 2223: FUNCTION Get_Account_Type (p_cust_id IN NUMBER) RETURN QP_Attr_Mapping_PUB.t_MultiRecord

2219: return G_Customer_Info.customer_class_code;
2220: END IF;
2221: END Get_Customer_Class;
2222: ---***-- END Get_Customer_Class ---************************
2223: FUNCTION Get_Account_Type (p_cust_id IN NUMBER) RETURN QP_Attr_Mapping_PUB.t_MultiRecord
2224: IS
2225: BEGIN
2226: IF p_cust_id = G_Customer_Info.customer_id THEN
2227: RETURN G_Customer_Info.account_types;

Line 2341: FUNCTION Get_Site_Use (p_rul_tbl IN GLOBAL_RPRLE_TBL_TYPE) RETURN QP_Attr_Mapping_PUB.t_MultiRecord

2337: ---******************************
2338: /*End Added by Jomy*/
2339: -----attribute mapping functions added by smhanda-------------------------------
2340:
2341: FUNCTION Get_Site_Use (p_rul_tbl IN GLOBAL_RPRLE_TBL_TYPE) RETURN QP_Attr_Mapping_PUB.t_MultiRecord
2342: IS
2343:
2344: x_site_use_info QP_Attr_Mapping_PUB.t_MultiRecord;
2345: l_ship_to_org_id number :=null;

Line 2344: x_site_use_info QP_Attr_Mapping_PUB.t_MultiRecord;

2340:
2341: FUNCTION Get_Site_Use (p_rul_tbl IN GLOBAL_RPRLE_TBL_TYPE) RETURN QP_Attr_Mapping_PUB.t_MultiRecord
2342: IS
2343:
2344: x_site_use_info QP_Attr_Mapping_PUB.t_MultiRecord;
2345: l_ship_to_org_id number :=null;
2346: l_invoice_to_org_id number :=null;
2347: i pls_integer :=0;
2348: BEGIN