DBA Data[Home] [Help]

APPS.DPP_ITEMCOST_PVT dependencies on FND_PROFILE

Line 279: l_bg_process_mode := nvl(fnd_profile.value('DPP_ACCT_GEN_USE_WORKFLOW'),'N');

275: IF G_DEBUG THEN
276: DPP_UTILITY_PVT.debug_message('After mandatory checks:'||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));
277: END IF;
278:
279: l_bg_process_mode := nvl(fnd_profile.value('DPP_ACCT_GEN_USE_WORKFLOW'),'N');
280:
281: --Get the user name for the last updated by user
282: BEGIN
283: SELECT user_name

Line 304: FROM fnd_profile_options fpo,

300: --Getting a valid Price Protection Responsibility at the User Level Profile Options
301: BEGIN
302: SELECT frv.responsibility_id
303: INTO l_responsibility_id
304: FROM fnd_profile_options fpo,
305: fnd_profile_option_values fpov,
306: fnd_responsibility_vl frv,
307: fnd_user_resp_groups_direct furgd
308: WHERE fpo.profile_option_name IN ('ORG_ID', 'DEFAULT_ORG_ID')

Line 305: fnd_profile_option_values fpov,

301: BEGIN
302: SELECT frv.responsibility_id
303: INTO l_responsibility_id
304: FROM fnd_profile_options fpo,
305: fnd_profile_option_values fpov,
306: fnd_responsibility_vl frv,
307: fnd_user_resp_groups_direct furgd
308: WHERE fpo.profile_option_name IN ('ORG_ID', 'DEFAULT_ORG_ID')
309: AND fpo.profile_option_id = fpov.profile_option_id

Line 328: FROM fnd_profile_options fpo,

324: l_responsibility_id := -1;
325: BEGIN
326: SELECT frv.responsibility_id
327: INTO l_responsibility_id
328: FROM fnd_profile_options fpo,
329: fnd_profile_option_values fpov,
330: fnd_responsibility_vl frv,
331: fnd_user_resp_groups_direct furgd,
332: per_security_profiles psp

Line 329: fnd_profile_option_values fpov,

325: BEGIN
326: SELECT frv.responsibility_id
327: INTO l_responsibility_id
328: FROM fnd_profile_options fpo,
329: fnd_profile_option_values fpov,
330: fnd_responsibility_vl frv,
331: fnd_user_resp_groups_direct furgd,
332: per_security_profiles psp
333: WHERE fpo.profile_option_name = 'XLA_MO_SECURITY_PROFILE_LEVEL'

Line 390: FROM fnd_profile_options fpo,

386: IF l_responsibility_id = -1 THEN
387: BEGIN
388: SELECT frv.responsibility_id
389: INTO l_responsibility_id
390: FROM fnd_profile_options fpo,
391: fnd_profile_option_values fpov,
392: fnd_responsibility_vl frv,
393: fnd_user_resp_groups_direct furgd
394: WHERE fpo.profile_option_name IN ('ORG_ID', 'DEFAULT_ORG_ID')

Line 391: fnd_profile_option_values fpov,

387: BEGIN
388: SELECT frv.responsibility_id
389: INTO l_responsibility_id
390: FROM fnd_profile_options fpo,
391: fnd_profile_option_values fpov,
392: fnd_responsibility_vl frv,
393: fnd_user_resp_groups_direct furgd
394: WHERE fpo.profile_option_name IN ('ORG_ID', 'DEFAULT_ORG_ID')
395: AND fpo.profile_option_id = fpov.profile_option_id

Line 414: FROM fnd_profile_options fpo,

410: l_responsibility_id := -1;
411: BEGIN
412: SELECT frv.responsibility_id
413: INTO l_responsibility_id
414: FROM fnd_profile_options fpo,
415: fnd_profile_option_values fpov,
416: fnd_responsibility_vl frv,
417: fnd_user_resp_groups_direct furgd,
418: per_security_profiles psp

Line 415: fnd_profile_option_values fpov,

411: BEGIN
412: SELECT frv.responsibility_id
413: INTO l_responsibility_id
414: FROM fnd_profile_options fpo,
415: fnd_profile_option_values fpov,
416: fnd_responsibility_vl frv,
417: fnd_user_resp_groups_direct furgd,
418: per_security_profiles psp
419: WHERE fpo.profile_option_name = 'XLA_MO_SECURITY_PROFILE_LEVEL'

Line 476: FROM fnd_profile_options fpo,

472: IF l_responsibility_id = -1 THEN
473: BEGIN
474: SELECT frv.responsibility_id
475: INTO l_responsibility_id
476: FROM fnd_profile_options fpo,
477: fnd_profile_option_values fpov,
478: fnd_responsibility_vl frv,
479: fnd_user_resp_groups_direct furgd
480: WHERE fpo.profile_option_name IN ('ORG_ID', 'DEFAULT_ORG_ID')

Line 477: fnd_profile_option_values fpov,

473: BEGIN
474: SELECT frv.responsibility_id
475: INTO l_responsibility_id
476: FROM fnd_profile_options fpo,
477: fnd_profile_option_values fpov,
478: fnd_responsibility_vl frv,
479: fnd_user_resp_groups_direct furgd
480: WHERE fpo.profile_option_name IN ('ORG_ID', 'DEFAULT_ORG_ID')
481: AND fpo.profile_option_id = fpov.profile_option_id

Line 500: FROM fnd_profile_options fpo,

496: l_responsibility_id := -1;
497: BEGIN
498: SELECT frv.responsibility_id
499: INTO l_responsibility_id
500: FROM fnd_profile_options fpo,
501: fnd_profile_option_values fpov,
502: fnd_responsibility_vl frv,
503: fnd_user_resp_groups_direct furgd,
504: per_security_profiles psp

Line 501: fnd_profile_option_values fpov,

497: BEGIN
498: SELECT frv.responsibility_id
499: INTO l_responsibility_id
500: FROM fnd_profile_options fpo,
501: fnd_profile_option_values fpov,
502: fnd_responsibility_vl frv,
503: fnd_user_resp_groups_direct furgd,
504: per_security_profiles psp
505: WHERE fpo.profile_option_name = 'XLA_MO_SECURITY_PROFILE_LEVEL'

Line 562: FROM fnd_profile_options fpo,

558: IF l_responsibility_id = -1 THEN
559: BEGIN
560: SELECT frv.responsibility_id
561: INTO l_responsibility_id
562: FROM fnd_profile_options fpo,
563: fnd_profile_option_values fpov,
564: fnd_responsibility_vl frv,
565: fnd_user_resp_groups_direct furgd
566: WHERE fpo.profile_option_name IN ('ORG_ID', 'DEFAULT_ORG_ID')

Line 563: fnd_profile_option_values fpov,

559: BEGIN
560: SELECT frv.responsibility_id
561: INTO l_responsibility_id
562: FROM fnd_profile_options fpo,
563: fnd_profile_option_values fpov,
564: fnd_responsibility_vl frv,
565: fnd_user_resp_groups_direct furgd
566: WHERE fpo.profile_option_name IN ('ORG_ID', 'DEFAULT_ORG_ID')
567: AND fpo.profile_option_id = fpov.profile_option_id

Line 587: FROM fnd_profile_options fpo,

583: BEGIN
584:
585: SELECT frv.responsibility_id
586: INTO l_responsibility_id
587: FROM fnd_profile_options fpo,
588: fnd_profile_option_values fpov,
589: fnd_responsibility_vl frv,
590: fnd_user_resp_groups_direct furgd,
591: per_security_profiles psp

Line 588: fnd_profile_option_values fpov,

584:
585: SELECT frv.responsibility_id
586: INTO l_responsibility_id
587: FROM fnd_profile_options fpo,
588: fnd_profile_option_values fpov,
589: fnd_responsibility_vl frv,
590: fnd_user_resp_groups_direct furgd,
591: per_security_profiles psp
592: WHERE fpo.profile_option_name = 'XLA_MO_SECURITY_PROFILE_LEVEL'

Line 689: l_debug_flag := fnd_profile.value('ACCOUNT_GENERATOR:DEBUG_MODE');

685: hr_operating_units hr
686: WHERE hr.set_of_books_id = sob.set_of_books_id
687: AND hr.organization_id = l_txn_hdr_rec.org_id;
688:
689: l_debug_flag := fnd_profile.value('ACCOUNT_GENERATOR:DEBUG_MODE');
690:
691: IF G_DEBUG THEN
692: DPP_UTILITY_PVT.debug_message('Debug Flag: ' || l_debug_flag );
693: END IF;