DBA Data[Home] [Help]

APPS.IBE_CATALOG_PVT dependencies on IBE_PRICE_PVT

Line 2178: x_price_csr OUT NOCOPY IBE_PRICE_PVT.PRICE_REFCURSOR_TYPE,

2174: p_currency_code IN VARCHAR2,
2175: p_price_request_type IN VARCHAR2,
2176: p_price_event IN VARCHAR2,
2177: p_minisite_id IN NUMBER := NULL,
2178: x_price_csr OUT NOCOPY IBE_PRICE_PVT.PRICE_REFCURSOR_TYPE,
2179: x_line_index_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2180: x_return_status OUT NOCOPY VARCHAR2,
2181: x_return_status_text OUT NOCOPY VARCHAR2
2182: )

Line 2307: IBE_UTIL.debug('Calling IBE_PRICE_PVT.PRICE_REQUEST...');

2303: END LOOP;
2304: END IF;
2305:
2306: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2307: IBE_UTIL.debug('Calling IBE_PRICE_PVT.PRICE_REQUEST...');
2308: END IF;
2309: IBE_PRICE_PVT.PRICE_REQUEST(
2310: p_price_list_id => p_price_list_id,
2311: p_currency_code => p_currency_code,

Line 2309: IBE_PRICE_PVT.PRICE_REQUEST(

2305:
2306: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2307: IBE_UTIL.debug('Calling IBE_PRICE_PVT.PRICE_REQUEST...');
2308: END IF;
2309: IBE_PRICE_PVT.PRICE_REQUEST(
2310: p_price_list_id => p_price_list_id,
2311: p_currency_code => p_currency_code,
2312: p_item_tbl => l_itmid_tbl,
2313: p_uom_code_tbl => l_uom_code_tbl,

Line 2328: IBE_UTIL.debug('Return from IBE_PRICE_PVT.PRICE_REQUEST');

2324: x_return_status_text=> x_return_status_text);
2325:
2326: l_end_time := DBMS_UTILITY.GET_TIME;
2327: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2328: IBE_UTIL.debug('Return from IBE_PRICE_PVT.PRICE_REQUEST');
2329: IBE_UTIL.debug('IBE_CATALOG_PVT.FETCH_PRICE(-), elapsed time (s) ='||(l_end_time-l_start_time)/100);
2330: END IF;
2331: --end API body
2332:

Line 2366: x_price_csr OUT NOCOPY IBE_PRICE_PVT.PRICE_REFCURSOR_TYPE,

2362: x_category_id_csr OUT NOCOPY IBE_CATALOG_REFCURSOR_CSR_TYPE,
2363: x_configurable OUT NOCOPY VARCHAR2,
2364: x_model_bundle_flag OUT NOCOPY VARCHAR2,
2365: x_uom_csr OUT NOCOPY IBE_CATALOG_REFCURSOR_CSR_TYPE,
2366: x_price_csr OUT NOCOPY IBE_PRICE_PVT.PRICE_REFCURSOR_TYPE,
2367: x_line_index_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2368: x_price_status_code OUT NOCOPY VARCHAR2,
2369: x_price_status_text OUT NOCOPY VARCHAR2
2370:

Line 2680: x_price_csr OUT NOCOPY IBE_PRICE_PVT.PRICE_REFCURSOR_TYPE,

2676: p_currency_code IN VARCHAR2,
2677: p_price_request_type IN VARCHAR2,
2678: p_price_event IN VARCHAR2,
2679: p_minisite_id IN NUMBER := NULL,
2680: x_price_csr OUT NOCOPY IBE_PRICE_PVT.PRICE_REFCURSOR_TYPE,
2681: x_line_index_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2682: x_return_status OUT NOCOPY VARCHAR2,
2683: x_return_status_text OUT NOCOPY VARCHAR2
2684:

Line 2825: IBE_PRICE_PVT.PRICE_REQUEST(

2821: END IF;
2822:
2823: -- pricing
2824:
2825: IBE_PRICE_PVT.PRICE_REQUEST(
2826: p_price_list_id => p_price_list_id,
2827: p_currency_code => p_currency_code,
2828: p_item_tbl => l_itmid_tbl,
2829: p_uom_code_tbl => l_uom_code_tbl,

Line 2883: x_price_csr OUT NOCOPY IBE_PRICE_PVT.PRICE_REFCURSOR_TYPE,

2879: p_minisite_id IN NUMBER := NULL,
2880: x_category_id_tbl OUT NOCOPY JTF_NUMBER_TABLE,
2881: x_configurable_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2882: x_model_bundle_flag_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2883: x_price_csr OUT NOCOPY IBE_PRICE_PVT.PRICE_REFCURSOR_TYPE,
2884: x_line_index_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2885: x_price_status_code OUT NOCOPY VARCHAR2,
2886: x_price_status_text OUT NOCOPY VARCHAR2
2887: