eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_PRICE_BOOK_UTIL dependencies on FND_GLOBAL

Line 28: l_user_id := fnd_global.user_id;

24: l_price_book_line_id_tbl NUMBER_TYPE;
25:
26: BEGIN
27:
28: l_user_id := fnd_global.user_id;
29: l_login_id := fnd_global.conc_login_id;
30:
31: --The following assignments in a loop is required since the database(including
32: --10g) does not support the use of a record's attribute in a DML with FORALL.

Line 29: l_login_id := fnd_global.conc_login_id;

25:
26: BEGIN
27:
28: l_user_id := fnd_global.user_id;
29: l_login_id := fnd_global.conc_login_id;
30:
31: --The following assignments in a loop is required since the database(including
32: --10g) does not support the use of a record's attribute in a DML with FORALL.
33: IF p_price_book_messages_tbl.COUNT > 0 THEN

Line 237: l_user_id := fnd_global.user_id;

233: l_sold_to_org_id NUMBER;
234:
235: BEGIN
236:
237: l_user_id := fnd_global.user_id;
238: l_resp_appl_id := fnd_global.resp_appl_id;
239:
240: IF p_pb_input_header_rec.pricing_perspective_code IS NULL THEN
241: BEGIN

Line 238: l_resp_appl_id := fnd_global.resp_appl_id;

234:
235: BEGIN
236:
237: l_user_id := fnd_global.user_id;
238: l_resp_appl_id := fnd_global.resp_appl_id;
239:
240: IF p_pb_input_header_rec.pricing_perspective_code IS NULL THEN
241: BEGIN
242: SELECT customer_id

Line 336: fnd_global.apps_initialize(l_user_id,

332:
333: --Set the apps context for the pricing perspective application so that
334: --profile options at the application level are retrieved for this
335: --application and not QP.
336: fnd_global.apps_initialize(l_user_id,
337: fnd_global.resp_id,
338: l_application_id);
339:
340: --No defaulting reqd for columns that do not impact Delta price book creation

Line 337: fnd_global.resp_id,

333: --Set the apps context for the pricing perspective application so that
334: --profile options at the application level are retrieved for this
335: --application and not QP.
336: fnd_global.apps_initialize(l_user_id,
337: fnd_global.resp_id,
338: l_application_id);
339:
340: --No defaulting reqd for columns that do not impact Delta price book creation
341: IF nvl(p_pb_input_header_rec.price_book_type_code, 'F') <> 'D' THEN

Line 456: fnd_global.apps_initialize(l_user_id,

452: p_pb_input_header_rec.pub_output_document_type := 'PDF';
453: END IF;
454:
455: --reset the application_id back to the original appl id
456: fnd_global.apps_initialize(l_user_id,
457: fnd_global.resp_id,
458: l_resp_appl_id);
459:
460: END Default_PB_Input_Criteria;

Line 457: fnd_global.resp_id,

453: END IF;
454:
455: --reset the application_id back to the original appl id
456: fnd_global.apps_initialize(l_user_id,
457: fnd_global.resp_id,
458: l_resp_appl_id);
459:
460: END Default_PB_Input_Criteria;
461:

Line 507: l_user_id := fnd_global.user_id;

503: l_valueset_id NUMBER;
504:
505: BEGIN
506:
507: l_user_id := fnd_global.user_id;
508: l_resp_appl_id := fnd_global.resp_appl_id;
509:
510: --If generating price book
511: IF nvl(p_pb_input_header_rec.publish_existing_pb_flag, 'N') <> 'Y' THEN

Line 508: l_resp_appl_id := fnd_global.resp_appl_id;

504:
505: BEGIN
506:
507: l_user_id := fnd_global.user_id;
508: l_resp_appl_id := fnd_global.resp_appl_id;
509:
510: --If generating price book
511: IF nvl(p_pb_input_header_rec.publish_existing_pb_flag, 'N') <> 'Y' THEN
512: --Check if org_id is not null and valid. Else return, do not proceed.

Line 607: fnd_global.apps_initialize(l_user_id,

603:
604: --Set the application id corresponding to the pricing perspective so that
605: --profile options at the application level are retrieved for this
606: --application and not QP.
607: fnd_global.apps_initialize(l_user_id,
608: fnd_global.resp_id,
609: l_application_id);
610:
611: l_request_type_code :=

Line 608: fnd_global.resp_id,

604: --Set the application id corresponding to the pricing perspective so that
605: --profile options at the application level are retrieved for this
606: --application and not QP.
607: fnd_global.apps_initialize(l_user_id,
608: fnd_global.resp_id,
609: l_application_id);
610:
611: l_request_type_code :=
612: fnd_profile.value('QP_PRICING_PERSPECTIVE_REQUEST_TYPE');

Line 2273: fnd_global.apps_initialize(l_user_id,

2269:
2270: END IF; --Publish existing price book. No generation.
2271:
2272: --reset the application_id back to the original appl id
2273: fnd_global.apps_initialize(l_user_id,
2274: fnd_global.resp_id,
2275: l_resp_appl_id);
2276:
2277: IF x_return_status = 'E' THEN

Line 2274: fnd_global.resp_id,

2270: END IF; --Publish existing price book. No generation.
2271:
2272: --reset the application_id back to the original appl id
2273: fnd_global.apps_initialize(l_user_id,
2274: fnd_global.resp_id,
2275: l_resp_appl_id);
2276:
2277: IF x_return_status = 'E' THEN
2278: Insert_Price_Book_Messages (l_price_book_messages_tbl);

Line 2359: l_user_id := fnd_global.user_id;

2355: l_count NUMBER;
2356:
2357: BEGIN
2358:
2359: l_user_id := fnd_global.user_id;
2360:
2361: /*Not required since request type code is already available in input header rec
2362: --Get application id for the appl corresponding to pricing perspective
2363: BEGIN

Line 2442: fnd_global.conc_login_id

2438: sysdate,
2439: l_user_id,
2440: sysdate,
2441: l_user_id,
2442: fnd_global.conc_login_id
2443: ) RETURNING price_book_header_id INTO l_price_book_header_id;
2444:
2445: INSERT INTO qp_price_book_headers_tl (
2446: price_book_header_id,

Line 2465: fnd_global.conc_login_id,

2461: sysdate,
2462: l_user_id,
2463: sysdate,
2464: l_user_id,
2465: fnd_global.conc_login_id,
2466: l.language_code,
2467: userenv('LANG')
2468: FROM FND_LANGUAGES L
2469: WHERE L.INSTALLED_FLAG in ('I','B')

Line 3793: p_value => fnd_global.user_id,

3789: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',
3790: p_value => l_event_key,
3791: p_parameterlist => l_send_syct_parameter_list);
3792: wf_event.AddParameterToList(p_name => 'USER_ID',
3793: p_value => fnd_global.user_id,
3794: p_parameterlist => l_send_syct_parameter_list);
3795: wf_event.AddParameterToList(p_name => 'APPLICATION_ID',
3796: p_value => fnd_global.resp_appl_id,
3797: p_parameterlist => l_send_syct_parameter_list);

Line 3796: p_value => fnd_global.resp_appl_id,

3792: wf_event.AddParameterToList(p_name => 'USER_ID',
3793: p_value => fnd_global.user_id,
3794: p_parameterlist => l_send_syct_parameter_list);
3795: wf_event.AddParameterToList(p_name => 'APPLICATION_ID',
3796: p_value => fnd_global.resp_appl_id,
3797: p_parameterlist => l_send_syct_parameter_list);
3798: wf_event.AddParameterToList(p_name => 'RESPONSIBILITY_ID',
3799: p_value => fnd_global.resp_id,
3800: p_parameterlist => l_send_syct_parameter_list);

Line 3799: p_value => fnd_global.resp_id,

3795: wf_event.AddParameterToList(p_name => 'APPLICATION_ID',
3796: p_value => fnd_global.resp_appl_id,
3797: p_parameterlist => l_send_syct_parameter_list);
3798: wf_event.AddParameterToList(p_name => 'RESPONSIBILITY_ID',
3799: p_value => fnd_global.resp_id,
3800: p_parameterlist => l_send_syct_parameter_list);
3801: wf_event.AddParameterToList(p_name => 'ORG_ID',
3802: p_value => l_inv_org_id,
3803: p_parameterlist => l_send_syct_parameter_list);

Line 4012: FND_GLOBAL.Apps_Initialize(l_user_id, l_resp_id, l_resp_appl_id);

4008: QP_PREQ_GRP.engine_debug('set org using dbms_application_info.set_client_info');
4009: END IF;
4010: ELSE
4011: -- Set the database session context
4012: FND_GLOBAL.Apps_Initialize(l_user_id, l_resp_id, l_resp_appl_id);
4013: /*
4014: BEGIN
4015: SELECT application_short_name
4016: INTO l_application_code

Line 4018: WHERE application_id = fnd_global.resp_appl_id; --Responsibility of user

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';
4022: END;

Line 4066: fnd_global.apps_initialize(l_user_id,

4062: FROM fnd_user
4063: WHERE user_name = upper(p_user_name);
4064:
4065: -- get pricing perpective based on user
4066: fnd_global.apps_initialize(l_user_id,
4067: null,
4068: null);
4069: l_pricing_perspective_code := FND_PROFILE.VALUE('QP_EXT_DEFAULT_PRICING_PERSPECTIVE');
4070: QP_PREQ_GRP.Set_QP_Debug;

Line 4087: fnd_global.apps_initialize(l_user_id,

4083: QP_PREQ_GRP.engine_debug(l_routine || ':l_pricing_perspective_appl_id=' || l_pricing_perspective_appl_id);
4084: END IF;
4085:
4086: -- get responsibility based on pricing perspective
4087: fnd_global.apps_initialize(l_user_id,
4088: null,
4089: l_pricing_perspective_appl_id);
4090: l_resp_id := FND_PROFILE.VALUE('QP_XML_RESP');
4091: IF l_debug = FND_API.G_TRUE THEN

Line 4106: fnd_global.apps_initialize(l_user_id,

4102: QP_PREQ_GRP.engine_debug(l_routine || ':l_resp_appl_id=' || l_resp_appl_id || ',l_resp_appl_name=' || l_resp_appl_name);
4103: END IF;
4104:
4105: -- set context
4106: fnd_global.apps_initialize(l_user_id,
4107: l_resp_id,
4108: l_resp_appl_id);
4109: MO_GLOBAL.Init('QP');
4110:

Line 4159: LAST_UPDATED_BY = FND_GLOBAL.USER_ID

4155: GENERATION_TIME_CODE = p_generation_time_code,
4156: GEN_SCHEDULE_DATE = p_gen_schedule_date,
4157: REQUEST_ORIGINATION_CODE = 'XML',
4158: LAST_UPDATE_DATE = SYSDATE,
4159: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
4160: WHERE pb_input_header_id = l_pb_input_header_id;
4161:
4162: x_pb_input_header_id := l_pb_input_header_id;
4163: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4272: l_user_id := fnd_global.user_id;

4268:
4269: IF l_context_tbl.count > 0 THEN
4270: --Insert the Input criteria into input lines tables
4271: l_sysdate := sysdate;
4272: l_user_id := fnd_global.user_id;
4273: l_login_id := fnd_global.login_id;
4274: BEGIN
4275: FORALL k IN l_context_tbl.FIRST..l_context_tbl.LAST
4276: INSERT INTO qp_pb_input_lines

Line 4273: l_login_id := fnd_global.login_id;

4269: IF l_context_tbl.count > 0 THEN
4270: --Insert the Input criteria into input lines tables
4271: l_sysdate := sysdate;
4272: l_user_id := fnd_global.user_id;
4273: l_login_id := fnd_global.login_id;
4274: BEGIN
4275: FORALL k IN l_context_tbl.FIRST..l_context_tbl.LAST
4276: INSERT INTO qp_pb_input_lines
4277: (pb_input_line_id, pb_input_header_id,

Line 4687: fnd_global.user_id,

4683: EMPTY_BLOB(),
4684: p_document_content_type,
4685: p_document_name,
4686: sysdate,
4687: fnd_global.user_id,
4688: sysdate,
4689: fnd_global.user_id,
4690: fnd_global.conc_login_id,
4691: l_result

Line 4689: fnd_global.user_id,

4685: p_document_name,
4686: sysdate,
4687: fnd_global.user_id,
4688: sysdate,
4689: fnd_global.user_id,
4690: fnd_global.conc_login_id,
4691: l_result
4692: ) RETURNING DOCUMENT_ID INTO l_doc_id;
4693:

Line 4690: fnd_global.conc_login_id,

4686: sysdate,
4687: fnd_global.user_id,
4688: sysdate,
4689: fnd_global.user_id,
4690: fnd_global.conc_login_id,
4691: l_result
4692: ) RETURNING DOCUMENT_ID INTO l_doc_id;
4693:
4694: UPDATE qp_price_book_headers_b