DBA Data[Home] [Help]

APPS.IBE_PRICE_PVT dependencies on QP_PREQ_GRP

Line 22: ,px_req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE

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(

Line 23: ,px_req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.qual_TBL_TYPE

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

Line 36: ,px_req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE

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

Line 37: ,px_req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.qual_TBL_TYPE

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(

Line 400: ,p_item_tbl IN QP_PREQ_GRP.NUMBER_TYPE

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

Line 401: ,p_uom_code_tbl IN OUT NOCOPY QP_PREQ_GRP.VARCHAR_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

Line 403: ,p_line_quantity_tbl IN OUT NOCOPY 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

Line 404: ,p_parentIndex_tbl IN QP_PREQ_GRP.NUMBER_TYPE

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

Line 405: ,p_childIndex_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
409: ,x_line_index_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100