APPS.AZW_UTIL dependencies on FND_PROFILE

Line 311: fnd_profile.get('GEMMS_DEFAULT_ORGN', opm_id);

307: opm_id varchar2(30);
308:
309: BEGIN
310:
311: fnd_profile.get('GEMMS_DEFAULT_ORGN', opm_id);
312:
313: --select organization_id, orgn_name
314: --from sy_orgn_mst
315: --where orgn_code = opm_id;

Line 409: fnd_profile.get('PER_BUSINESS_GROUP_ID', context);

405: );
406:
407: --Get the current context value
408: if(context_type = 'BG') then
409: fnd_profile.get('PER_BUSINESS_GROUP_ID', context);
410: bg_id := to_number(context);
411: resp_ctxt_id := bg_id;
412: select name into context
413: from per_business_groups

Line 416: fnd_profile.get('ORG_ID', context);

412: select name into context
413: from per_business_groups
414: where BUSINESS_GROUP_ID = bg_id;
415: elsif (context_type = 'OU') then
416: fnd_profile.get('ORG_ID', context);
417: ou_id := to_number(context);
418: resp_ctxt_id := ou_id;
419: select name into context
420: from HR_OPERATING_UNITS

Line 423: fnd_profile.get('GL_SET_OF_BKS_ID', context);

419: select name into context
420: from HR_OPERATING_UNITS
421: where ORGANIZATION_ID = ou_id;
422: elsif (context_type = 'SOB') then
423: fnd_profile.get('GL_SET_OF_BKS_ID', context);
424: resp_ctxt_id := to_number(context);
425: fnd_profile.get('GL_SET_OF_BKS_NAME', context);
426:
427: elsif (context_type = 'OPMCOM' OR context_type = 'OPMORG') then

Line 425: fnd_profile.get('GL_SET_OF_BKS_NAME', context);

421: where ORGANIZATION_ID = ou_id;
422: elsif (context_type = 'SOB') then
423: fnd_profile.get('GL_SET_OF_BKS_ID', context);
424: resp_ctxt_id := to_number(context);
425: fnd_profile.get('GL_SET_OF_BKS_NAME', context);
426:
427: elsif (context_type = 'OPMCOM' OR context_type = 'OPMORG') then
428: validate_opm_context(context_type, context, resp_ctxt_id);
429: