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.

[Home] [Help]

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 3760: p_value => fnd_global.user_id,

3756: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',
3757: p_value => l_event_key,
3758: p_parameterlist => l_send_syct_parameter_list);
3759: wf_event.AddParameterToList(p_name => 'USER_ID',
3760: p_value => fnd_global.user_id,
3761: p_parameterlist => l_send_syct_parameter_list);
3762: wf_event.AddParameterToList(p_name => 'APPLICATION_ID',
3763: p_value => fnd_global.resp_appl_id,
3764: p_parameterlist => l_send_syct_parameter_list);

Line 3763: p_value => fnd_global.resp_appl_id,

3759: wf_event.AddParameterToList(p_name => 'USER_ID',
3760: p_value => fnd_global.user_id,
3761: p_parameterlist => l_send_syct_parameter_list);
3762: wf_event.AddParameterToList(p_name => 'APPLICATION_ID',
3763: p_value => fnd_global.resp_appl_id,
3764: p_parameterlist => l_send_syct_parameter_list);
3765: wf_event.AddParameterToList(p_name => 'RESPONSIBILITY_ID',
3766: p_value => fnd_global.resp_id,
3767: p_parameterlist => l_send_syct_parameter_list);

Line 3766: p_value => fnd_global.resp_id,

3762: wf_event.AddParameterToList(p_name => 'APPLICATION_ID',
3763: p_value => fnd_global.resp_appl_id,
3764: p_parameterlist => l_send_syct_parameter_list);
3765: wf_event.AddParameterToList(p_name => 'RESPONSIBILITY_ID',
3766: p_value => fnd_global.resp_id,
3767: p_parameterlist => l_send_syct_parameter_list);
3768: wf_event.AddParameterToList(p_name => 'ORG_ID',
3769: p_value => l_inv_org_id,
3770: p_parameterlist => l_send_syct_parameter_list);

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

3975: QP_PREQ_GRP.engine_debug('set org using dbms_application_info.set_client_info');
3976: END IF;
3977: ELSE
3978: -- Set the database session context
3979: FND_GLOBAL.Apps_Initialize(l_user_id, l_resp_id, l_resp_appl_id);
3980: /*
3981: BEGIN
3982: SELECT application_short_name
3983: INTO l_application_code

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

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

Line 4033: fnd_global.apps_initialize(l_user_id,

4029: FROM fnd_user
4030: WHERE user_name = upper(p_user_name);
4031:
4032: -- get pricing perpective based on user
4033: fnd_global.apps_initialize(l_user_id,
4034: null,
4035: null);
4036: l_pricing_perspective_code := FND_PROFILE.VALUE('QP_EXT_DEFAULT_PRICING_PERSPECTIVE');
4037: QP_PREQ_GRP.Set_QP_Debug;

Line 4054: fnd_global.apps_initialize(l_user_id,

4050: QP_PREQ_GRP.engine_debug(l_routine || ':l_pricing_perspective_appl_id=' || l_pricing_perspective_appl_id);
4051: END IF;
4052:
4053: -- get responsibility based on pricing perspective
4054: fnd_global.apps_initialize(l_user_id,
4055: null,
4056: l_pricing_perspective_appl_id);
4057: l_resp_id := FND_PROFILE.VALUE('QP_XML_RESP');
4058: IF l_debug = FND_API.G_TRUE THEN

Line 4073: fnd_global.apps_initialize(l_user_id,

4069: QP_PREQ_GRP.engine_debug(l_routine || ':l_resp_appl_id=' || l_resp_appl_id || ',l_resp_appl_name=' || l_resp_appl_name);
4070: END IF;
4071:
4072: -- set context
4073: fnd_global.apps_initialize(l_user_id,
4074: l_resp_id,
4075: l_resp_appl_id);
4076: MO_GLOBAL.Init('QP');
4077:

Line 4126: LAST_UPDATED_BY = FND_GLOBAL.USER_ID

4122: GENERATION_TIME_CODE = p_generation_time_code,
4123: GEN_SCHEDULE_DATE = p_gen_schedule_date,
4124: REQUEST_ORIGINATION_CODE = 'XML',
4125: LAST_UPDATE_DATE = SYSDATE,
4126: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
4127: WHERE pb_input_header_id = l_pb_input_header_id;
4128:
4129: x_pb_input_header_id := l_pb_input_header_id;
4130: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4239: l_user_id := fnd_global.user_id;

4235:
4236: IF l_context_tbl.count > 0 THEN
4237: --Insert the Input criteria into input lines tables
4238: l_sysdate := sysdate;
4239: l_user_id := fnd_global.user_id;
4240: l_login_id := fnd_global.login_id;
4241: BEGIN
4242: FORALL k IN l_context_tbl.FIRST..l_context_tbl.LAST
4243: INSERT INTO qp_pb_input_lines

Line 4240: l_login_id := fnd_global.login_id;

4236: IF l_context_tbl.count > 0 THEN
4237: --Insert the Input criteria into input lines tables
4238: l_sysdate := sysdate;
4239: l_user_id := fnd_global.user_id;
4240: l_login_id := fnd_global.login_id;
4241: BEGIN
4242: FORALL k IN l_context_tbl.FIRST..l_context_tbl.LAST
4243: INSERT INTO qp_pb_input_lines
4244: (pb_input_line_id, pb_input_header_id,