18: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM
19:
20: ,p_line_index IN NUMBER
21: ,p_request_type_code IN VARCHAR2
22: ,px_req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
23: ,px_req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.qual_TBL_TYPE
24: );
25:
26: Procedure getReqHeaderAttrAndQual(
19:
20: ,p_line_index IN NUMBER
21: ,p_request_type_code IN VARCHAR2
22: ,px_req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
23: ,px_req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.qual_TBL_TYPE
24: );
25:
26: Procedure getReqHeaderAttrAndQual(
27: p_party_id IN NUMBER := FND_API.G_MISS_NUM
32: --,p_model_id IN NUMBER := FND_API.G_MISS_NUM
33:
34: ,p_line_index IN NUMBER
35: ,p_request_type_code IN VARCHAR2
36: ,px_req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
37: ,px_req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.qual_TBL_TYPE
38: );
39:
40: -- 2.a [using qp] get price of one item base on price_list_id
33:
34: ,p_line_index IN NUMBER
35: ,p_request_type_code IN VARCHAR2
36: ,px_req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
37: ,px_req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.qual_TBL_TYPE
38: );
39:
40: -- 2.a [using qp] get price of one item base on price_list_id
41: PROCEDURE GetPrice(
396: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
397: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
398: ,p_currency_code IN VARCHAR2
399: ,p_minisite_id IN NUMBER := NULL
400: ,p_item_tbl IN QP_PREQ_GRP.NUMBER_TYPE
401: ,p_uom_code_tbl IN OUT NOCOPY QP_PREQ_GRP.VARCHAR_TYPE
402: ,p_model_id_tbl IN JTF_NUMBER_TABLE
403: ,p_line_quantity_tbl IN OUT NOCOPY QP_PREQ_GRP.NUMBER_TYPE
404: ,p_parentIndex_tbl IN QP_PREQ_GRP.NUMBER_TYPE
397: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
398: ,p_currency_code IN VARCHAR2
399: ,p_minisite_id IN NUMBER := NULL
400: ,p_item_tbl IN QP_PREQ_GRP.NUMBER_TYPE
401: ,p_uom_code_tbl IN OUT NOCOPY QP_PREQ_GRP.VARCHAR_TYPE
402: ,p_model_id_tbl IN JTF_NUMBER_TABLE
403: ,p_line_quantity_tbl IN OUT NOCOPY QP_PREQ_GRP.NUMBER_TYPE
404: ,p_parentIndex_tbl IN QP_PREQ_GRP.NUMBER_TYPE
405: ,p_childIndex_tbl IN QP_PREQ_GRP.NUMBER_TYPE
399: ,p_minisite_id IN NUMBER := NULL
400: ,p_item_tbl IN QP_PREQ_GRP.NUMBER_TYPE
401: ,p_uom_code_tbl IN OUT NOCOPY QP_PREQ_GRP.VARCHAR_TYPE
402: ,p_model_id_tbl IN JTF_NUMBER_TABLE
403: ,p_line_quantity_tbl IN OUT NOCOPY QP_PREQ_GRP.NUMBER_TYPE
404: ,p_parentIndex_tbl IN QP_PREQ_GRP.NUMBER_TYPE
405: ,p_childIndex_tbl IN QP_PREQ_GRP.NUMBER_TYPE
406: ,p_request_type_code IN VARCHAR2 := 'ASO'
407: ,p_pricing_event IN VARCHAR2
400: ,p_item_tbl IN QP_PREQ_GRP.NUMBER_TYPE
401: ,p_uom_code_tbl IN OUT NOCOPY QP_PREQ_GRP.VARCHAR_TYPE
402: ,p_model_id_tbl IN JTF_NUMBER_TABLE
403: ,p_line_quantity_tbl IN OUT NOCOPY QP_PREQ_GRP.NUMBER_TYPE
404: ,p_parentIndex_tbl IN QP_PREQ_GRP.NUMBER_TYPE
405: ,p_childIndex_tbl IN QP_PREQ_GRP.NUMBER_TYPE
406: ,p_request_type_code IN VARCHAR2 := 'ASO'
407: ,p_pricing_event IN VARCHAR2
408: ,x_price_csr OUT NOCOPY PRICE_REFCURSOR_TYPE
401: ,p_uom_code_tbl IN OUT NOCOPY QP_PREQ_GRP.VARCHAR_TYPE
402: ,p_model_id_tbl IN JTF_NUMBER_TABLE
403: ,p_line_quantity_tbl IN OUT NOCOPY QP_PREQ_GRP.NUMBER_TYPE
404: ,p_parentIndex_tbl IN QP_PREQ_GRP.NUMBER_TYPE
405: ,p_childIndex_tbl IN QP_PREQ_GRP.NUMBER_TYPE
406: ,p_request_type_code IN VARCHAR2 := 'ASO'
407: ,p_pricing_event IN VARCHAR2
408: ,x_price_csr OUT NOCOPY PRICE_REFCURSOR_TYPE
409: ,x_line_index_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100