DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_UTIL dependencies on FND_APPLICATION

Line 325: FROM fnd_application

321: --Get application id for the appl corresponding to pricing perspective
322: BEGIN
323: SELECT application_id
324: INTO l_application_id
325: FROM fnd_application
326: WHERE application_short_name =
327: p_pb_input_header_rec.pricing_perspective_code;
328: EXCEPTION
329: WHEN OTHERS THEN

Line 564: FROM fnd_application

560: --Get application id for the appl corresponding to pricing perspective
561: BEGIN
562: SELECT application_id
563: INTO l_application_id
564: FROM fnd_application
565: WHERE application_short_name =
566: p_pb_input_header_rec.pricing_perspective_code;
567: EXCEPTION
568: WHEN OTHERS THEN

Line 2366: FROM fnd_application

2362: --Get application id for the appl corresponding to pricing perspective
2363: BEGIN
2364: SELECT application_id
2365: INTO l_application_id
2366: FROM fnd_application
2367: WHERE application_short_name =
2368: p_pb_input_header_rec.pricing_perspective_code;
2369: EXCEPTION
2370: l_application_id := NULL;

Line 3984: FROM fnd_application

3980: /*
3981: BEGIN
3982: SELECT application_short_name
3983: INTO l_application_code
3984: FROM fnd_application
3985: WHERE application_id = fnd_global.resp_appl_id; --Responsibility of user
3986: EXCEPTION
3987: WHEN OTHERS THEN
3988: l_application_code := 'QP';

Line 4047: FROM fnd_application a

4043:
4044: -- get pricing perspective application id based on pricing perspective code
4045: SELECT a.application_id
4046: INTO l_pricing_perspective_appl_id
4047: FROM fnd_application a
4048: WHERE a.application_short_name = l_pricing_perspective_code;
4049: IF l_debug = FND_API.G_TRUE THEN
4050: QP_PREQ_GRP.engine_debug(l_routine || ':l_pricing_perspective_appl_id=' || l_pricing_perspective_appl_id);
4051: END IF;

Line 4065: FROM fnd_responsibility r, fnd_application a

4061:
4062: -- get application id and short name based on responsibility
4063: SELECT a.application_id, a.application_short_name
4064: INTO l_resp_appl_id, l_resp_appl_name
4065: FROM fnd_responsibility r, fnd_application a
4066: WHERE r.responsibility_id = l_resp_id
4067: AND a.application_id = r.application_id;
4068: IF l_debug = FND_API.G_TRUE THEN
4069: QP_PREQ_GRP.engine_debug(l_routine || ':l_resp_appl_id=' || l_resp_appl_id || ',l_resp_appl_name=' || l_resp_appl_name);