APPS.IBE_M_PRICING_PVT dependencies on QP_UTIL_PUB

Line 34: l_pricelist_id_tbl QP_UTIL_PUB.PRICE_LIST_TBL;

30: p_search_value IN VARCHAR2,
31: x_pricelist_csr OUT NOCOPY pricing_cur_type
32: )
33: IS
34: l_pricelist_id_tbl QP_UTIL_PUB.PRICE_LIST_TBL;
35: idx BINARY_INTEGER := 0;
36: l_stmt VARCHAR2(1000);
37: l_count NUMBER;
38: l_tmp_str VARCHAR2(2000);

Line 48: QP_UTIL_PUB.GET_PRICE_LIST(l_currency_code=>p_currency_code,

44: l_tmp_str := '';
45: l_query_str := '';
46: l_key_str := 'PRC_LIST_IDS';
47:
48: QP_UTIL_PUB.GET_PRICE_LIST(l_currency_code=>p_currency_code,
49: l_pricing_effective_date=>sysdate,
50: l_agreement_id=>null,
51: l_price_list_tbl=>l_pricelist_id_tbl);
52:

Line 119: QP_UTIL_PUB.GET_PRICE_LIST_CURRENCY(p_price_list_id => null,x_sql_string => l_query_statement);

115: IS
116: l_query_statement VARCHAR2(1000);
117:
118: BEGIN
119: QP_UTIL_PUB.GET_PRICE_LIST_CURRENCY(p_price_list_id => null,x_sql_string => l_query_statement);
120: if p_search_by = 'currName' then
121: open x_currency_csr FOR 'SELECT currency_code, name FROM('||l_query_statement||')WHERE LOWER(name) like :p_search_value' USING p_search_value;
122: else
123: open x_currency_csr FOR 'SELECT currency_code, name FROM(' ||l_query_statement|| ')WHERE LOWER(currency_code) like :p_search_value' USING p_search_value;