DBA Data[Home] [Help]

APPS.IBE_CATALOG_PVT dependencies on IBE_PRICE_PVT

Line 2179: x_price_csr OUT NOCOPY IBE_PRICE_PVT.PRICE_REFCURSOR_TYPE,

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

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

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

Line 2310: IBE_PRICE_PVT.PRICE_REQUEST(

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

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

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

Line 2367: x_price_csr OUT NOCOPY IBE_PRICE_PVT.PRICE_REFCURSOR_TYPE,

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

Line 2681: x_price_csr OUT NOCOPY IBE_PRICE_PVT.PRICE_REFCURSOR_TYPE,

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

Line 2826: IBE_PRICE_PVT.PRICE_REQUEST(

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

Line 2884: x_price_csr OUT NOCOPY IBE_PRICE_PVT.PRICE_REFCURSOR_TYPE,

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