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.CS_CF_UPG_PKG dependencies on FND_PROFILE_OPTIONS

Line 355: FROM fnd_profile_option_values b, fnd_profile_options a

351: b.level_value,
352: b.level_value_application_id,
353: b.profile_option_value,
354: 1 "PRIORITY"
355: FROM fnd_profile_option_values b, fnd_profile_options a
356: WHERE b.level_id = 10003
357: AND b.level_value = respId
358: AND b.level_value_application_id = respApplId
359: AND a.profile_option_id = b.profile_option_id

Line 382: FROM fnd_profile_option_values b, fnd_profile_options a

378: b.level_value,
379: b.level_value_application_id,
380: b.profile_option_value,
381: 2 "PRIORITY"
382: FROM fnd_profile_option_values b, fnd_profile_options a
383: WHERE b.level_id = 10002
384: AND b.level_value = respApplId
385: AND a.profile_option_id = b.profile_option_id
386: AND b.application_id = 672

Line 408: FROM fnd_profile_option_values b, fnd_profile_options a

404: b.level_value,
405: b.level_value_application_id,
406: b.profile_option_value,
407: 3 "PRIORITY"
408: FROM fnd_profile_option_values b, fnd_profile_options a
409: WHERE b.level_id = 10001
410: AND a.profile_option_id = b.profile_option_id
411: AND b.application_id = 672
412: AND a.profile_option_name in ('IBU_A_SR_ACCOUNT_OPTION',

Line 433: l_profile_option_name FND_PROFILE_OPTIONS.profile_option_name%TYPE;

429:
430: l_count NUMBER := p_respTable.COUNT;
431: l_index NUMBER := 0;
432: l_index2 NUMBER := 0;
433: l_profile_option_name FND_PROFILE_OPTIONS.profile_option_name%TYPE;
434: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE;
435: l_level_value_application_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE;
436: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;
437: l_priority NUMBER := 0;

Line 513: l_profileOptionName FND_PROFILE_OPTIONS.profile_option_name%TYPE;

509: p_respApplId IN FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE)
510: IS
511: l_count NUMBER := p_ProfileTable.COUNT;
512: l_index NUMBER := 0;
513: l_profileOptionName FND_PROFILE_OPTIONS.profile_option_name%TYPE;
514: l_profileOptionValue FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;
515: l_newPrimaryContactRegionCode VARCHAR2(30) := 'IBU_CF_SR_10_G';
516: l_newAddressRegionCode VARCHAR2(30) := 'IBU_CF_SR_20_G';
517: l_newUpdateAddressRegionCode VARCHAR2(30) := 'IBU_CF_SR_25_G';

Line 1768: FROM fnd_profile_option_values b, fnd_profile_options a

1764: b.level_value,
1765: b.level_value_application_id,
1766: b.profile_option_value,
1767: 1 "PRIORITY"
1768: FROM fnd_profile_option_values b, fnd_profile_options a
1769: WHERE b.level_id = 10002
1770: AND b.level_value = applId
1771: AND a.profile_option_id = b.profile_option_id
1772: AND a.application_id = 672

Line 1794: FROM fnd_profile_option_values b, fnd_profile_options a

1790: b.level_value,
1791: b.level_value_application_id,
1792: b.profile_option_value,
1793: 2 "PRIORITY"
1794: FROM fnd_profile_option_values b, fnd_profile_options a
1795: WHERE b.level_id = 10001
1796: AND a.profile_option_id = b.profile_option_id
1797: AND a.application_id = 672
1798: AND a.profile_option_name in ('IBU_A_SR_ACCOUNT_OPTION',

Line 1818: l_profile_option_name FND_PROFILE_OPTIONS.profile_option_name%TYPE;

1814:
1815: l_count NUMBER := p_applTable.COUNT;
1816: l_index NUMBER := 0;
1817: l_index2 NUMBER := 0;
1818: l_profile_option_name FND_PROFILE_OPTIONS.profile_option_name%TYPE;
1819: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE;
1820: l_level_value_application_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE;
1821: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;
1822: l_priority NUMBER := 0;

Line 1900: l_profileOptionName FND_PROFILE_OPTIONS.profile_option_name%TYPE;

1896: IS
1897:
1898: l_count NUMBER := p_ProfileTable.COUNT;
1899: l_index NUMBER := 0;
1900: l_profileOptionName FND_PROFILE_OPTIONS.profile_option_name%TYPE;
1901: l_profileOptionValue FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;
1902: l_newPrimaryContactRegionCode VARCHAR2(30) := 'IBU_CF_SR_10_G';
1903: l_newAddressRegionCode VARCHAR2(30) := 'IBU_CF_SR_20_G';
1904: l_newUpdateAddressRegionCode VARCHAR2(30) := 'IBU_CF_SR_25_G';

Line 3125: l_profileOptionName FND_PROFILE_OPTIONS.profile_option_name%TYPE;

3121: p_ApplId IN NUMBER)
3122: IS
3123: l_count NUMBER := p_ProfileTable.COUNT;
3124: l_index NUMBER := 0;
3125: l_profileOptionName FND_PROFILE_OPTIONS.profile_option_name%TYPE;
3126: l_profileOptionValue FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;
3127: l_newPrimaryContactRegionCode VARCHAR2(30) := 'IBU_CF_SR_10_G';
3128: l_newAddressRegionCode VARCHAR2(30) := 'IBU_CF_SR_20_G';
3129: l_newUpdateAddressRegionCode VARCHAR2(30) := 'IBU_CF_SR_25_G';

Line 4382: FROM fnd_profile_option_values b, fnd_profile_options a

4378: b.level_value,
4379: b.level_value_application_id,
4380: b.profile_option_value,
4381: 1 "PRIORITY"
4382: FROM fnd_profile_option_values b, fnd_profile_options a
4383: WHERE b.level_id = 10003
4384: AND b.level_value = respId
4385: AND b.level_value_application_id = respApplId
4386: AND a.profile_option_id = b.profile_option_id

Line 4395: FROM fnd_profile_option_values b, fnd_profile_options a

4391: b.level_value,
4392: b.level_value_application_id,
4393: b.profile_option_value,
4394: 2 "PRIORITY"
4395: FROM fnd_profile_option_values b, fnd_profile_options a
4396: WHERE b.level_id = 10002
4397: AND b.level_value = respApplId
4398: AND a.profile_option_id = b.profile_option_id
4399: AND b.application_id = 672

Line 4407: FROM fnd_profile_option_values b, fnd_profile_options a

4403: b.level_value,
4404: b.level_value_application_id,
4405: b.profile_option_value,
4406: 3 "PRIORITY"
4407: FROM fnd_profile_option_values b, fnd_profile_options a
4408: WHERE b.level_id = 10001
4409: AND a.profile_option_id = b.profile_option_id
4410: AND b.application_id = 672
4411: AND a.profile_option_name in ('IBU_A_SR_KB_OPTION')

Line 4417: l_profile_option_name FND_PROFILE_OPTIONS.profile_option_name%TYPE;

4413:
4414: l_count NUMBER := p_respTable.COUNT;
4415: l_index NUMBER := 0;
4416: l_index2 NUMBER := 0;
4417: l_profile_option_name FND_PROFILE_OPTIONS.profile_option_name%TYPE;
4418: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE;
4419: l_level_value_application_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE;
4420: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;
4421: l_priority NUMBER := 0;

Line 4497: l_profileOptionName FND_PROFILE_OPTIONS.profile_option_name%TYPE;

4493: p_respApplId IN FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE)
4494: IS
4495: l_count NUMBER := p_ProfileTable.COUNT;
4496: l_index NUMBER := 0;
4497: l_profileOptionName FND_PROFILE_OPTIONS.profile_option_name%TYPE;
4498: l_profileOptionValue FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;
4499:
4500: l_respId VARCHAR2(10) := to_char(p_respId);
4501: l_respApplId VARCHAR2(10) := to_char(p_respApplId);

Line 4559: FROM fnd_profile_option_values b, fnd_profile_options a

4555: b.level_value,
4556: b.level_value_application_id,
4557: b.profile_option_value,
4558: 1 "PRIORITY"
4559: FROM fnd_profile_option_values b, fnd_profile_options a
4560: WHERE b.level_id = 10002
4561: AND b.level_value = applId
4562: AND a.profile_option_id = b.profile_option_id
4563: AND b.application_id = 672

Line 4571: FROM fnd_profile_option_values b, fnd_profile_options a

4567: b.level_value,
4568: b.level_value_application_id,
4569: b.profile_option_value,
4570: 2 "PRIORITY"
4571: FROM fnd_profile_option_values b, fnd_profile_options a
4572: WHERE b.level_id = 10001
4573: AND a.profile_option_id = b.profile_option_id
4574: AND b.application_id = 672
4575: AND a.profile_option_name in ('IBU_A_SR_KB_OPTION')

Line 4581: l_profile_option_name FND_PROFILE_OPTIONS.profile_option_name%TYPE;

4577:
4578: l_count NUMBER := p_applTable.COUNT;
4579: l_index NUMBER := 0;
4580: l_index2 NUMBER := 0;
4581: l_profile_option_name FND_PROFILE_OPTIONS.profile_option_name%TYPE;
4582: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE;
4583: l_level_value_application_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE;
4584: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;
4585: l_priority NUMBER := 0;

Line 4658: l_profileOptionName FND_PROFILE_OPTIONS.profile_option_name%TYPE;

4654: p_applId IN NUMBER)
4655: IS
4656: l_count NUMBER := p_ProfileTable.COUNT;
4657: l_index NUMBER := 0;
4658: l_profileOptionName FND_PROFILE_OPTIONS.profile_option_name%TYPE;
4659: l_profileOptionValue FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;
4660:
4661: l_applId VARCHAR2(10) := to_char(p_applId);
4662:

Line 4708: l_profileOptionName FND_PROFILE_OPTIONS.profile_option_name%TYPE;

4704: IS
4705:
4706: l_count NUMBER := p_siteProfilesTable.COUNT;
4707: l_index NUMBER := 0;
4708: l_profileOptionName FND_PROFILE_OPTIONS.profile_option_name%TYPE;
4709: l_profileOptionValue FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;
4710:
4711: l_examineKBOption BOOLEAN := TRUE;
4712: l_source_context_type_id NUMBER := 0;