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 4017: FROM fnd_application

4013: /*
4014: BEGIN
4015: SELECT application_short_name
4016: INTO l_application_code
4017: FROM fnd_application
4018: WHERE application_id = fnd_global.resp_appl_id; --Responsibility of user
4019: EXCEPTION
4020: WHEN OTHERS THEN
4021: l_application_code := 'QP';

Line 4080: FROM fnd_application a

4076:
4077: -- get pricing perspective application id based on pricing perspective code
4078: SELECT a.application_id
4079: INTO l_pricing_perspective_appl_id
4080: FROM fnd_application a
4081: WHERE a.application_short_name = l_pricing_perspective_code;
4082: IF l_debug = FND_API.G_TRUE THEN
4083: QP_PREQ_GRP.engine_debug(l_routine || ':l_pricing_perspective_appl_id=' || l_pricing_perspective_appl_id);
4084: END IF;

Line 4098: FROM fnd_responsibility r, fnd_application a

4094:
4095: -- get application id and short name based on responsibility
4096: SELECT a.application_id, a.application_short_name
4097: INTO l_resp_appl_id, l_resp_appl_name
4098: FROM fnd_responsibility r, fnd_application a
4099: WHERE r.responsibility_id = l_resp_id
4100: AND a.application_id = r.application_id;
4101: IF l_debug = FND_API.G_TRUE THEN
4102: QP_PREQ_GRP.engine_debug(l_routine || ':l_resp_appl_id=' || l_resp_appl_id || ',l_resp_appl_name=' || l_resp_appl_name);