APPS.IBE_M_PRICING_PVT dependencies on QP_UTIL_PUB

Line 26: procedure parseInputTable (p_inTable IN QP_UTIL_PUB.PRICE_LIST_TBL,

22: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IBE_M_PRICING_PVT';
23: G_FILE_NAME CONSTANT VARCHAR2(12):= 'IBEVMPLB.pls';
24:
25: -- bug 14789352
26: procedure parseInputTable (p_inTable IN QP_UTIL_PUB.PRICE_LIST_TBL,
27: p_Type IN VARCHAR2,
28: p_keyString IN VARCHAR2,
29: p_number IN NUMBER,
30: x_QueryString OUT NOCOPY VARCHAR2)

Line 69: l_pricelist_id_tbl QP_UTIL_PUB.PRICE_LIST_TBL;

65: p_search_value IN VARCHAR2,
66: x_pricelist_csr OUT NOCOPY pricing_cur_type
67: )
68: IS
69: l_pricelist_id_tbl QP_UTIL_PUB.PRICE_LIST_TBL;
70: idx BINARY_INTEGER := 0;
71: l_stmt VARCHAR2(1000);
72: l_count NUMBER;
73: /* Commented and added by amaheshw on 10.jan.11 Bug 10217112

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

83: l_tmp_str := '';
84: l_query_str := '';
85: l_key_str := 'PRC_LIST_IDS';
86:
87: QP_UTIL_PUB.GET_PRICE_LIST(l_currency_code=>p_currency_code,
88: l_pricing_effective_date=>sysdate,
89: l_agreement_id=>null,
90: l_price_list_tbl=>l_pricelist_id_tbl);
91:

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

172: IS
173: l_query_statement VARCHAR2(1000);
174:
175: BEGIN
176: QP_UTIL_PUB.GET_PRICE_LIST_CURRENCY(p_price_list_id => null,x_sql_string => l_query_statement);
177: if p_search_by = 'currName' then
178: open x_currency_csr FOR 'SELECT currency_code, name FROM('||l_query_statement||')WHERE LOWER(name) like :p_search_value' USING p_search_value;
179: else
180: 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;