DBA Data[Home] [Help]

APPS.DPP_ITEMCOST_PVT dependencies on FND_PROFILE

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

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

Line 302: FROM fnd_profile_options fpo,

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

Line 303: fnd_profile_option_values fpov,

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

Line 326: FROM fnd_profile_options fpo,

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

Line 327: fnd_profile_option_values fpov,

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

Line 388: FROM fnd_profile_options fpo,

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

Line 389: fnd_profile_option_values fpov,

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

Line 412: FROM fnd_profile_options fpo,

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

Line 413: fnd_profile_option_values fpov,

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

Line 474: FROM fnd_profile_options fpo,

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

Line 475: fnd_profile_option_values fpov,

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

Line 498: FROM fnd_profile_options fpo,

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

Line 499: fnd_profile_option_values fpov,

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

Line 560: FROM fnd_profile_options fpo,

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

Line 561: fnd_profile_option_values fpov,

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

Line 585: FROM fnd_profile_options fpo,

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

Line 586: fnd_profile_option_values fpov,

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

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

683: hr_operating_units hr
684: WHERE hr.set_of_books_id = sob.set_of_books_id
685: AND hr.organization_id = l_txn_hdr_rec.org_id;
686:
687: l_debug_flag := fnd_profile.value('ACCOUNT_GENERATOR:DEBUG_MODE');
688:
689: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Debug Flag: ' || l_debug_flag );
690:
691: END IF;