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

Line 62: l_return_value := FND_PROFILE.SAVE('IBU_REGION_FIELD_CONFIG_OPTION', 'CUSTOM', 'SITE');

58: ELSE
59: -- Update the profile to set to CUSTOM
60: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Upgrade_Main', 'Saving profile to CUSTOM');
61:
62: l_return_value := FND_PROFILE.SAVE('IBU_REGION_FIELD_CONFIG_OPTION', 'CUSTOM', 'SITE');
63: IF NOT(l_return_value) THEN
64: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Upgrade_Main', 'Saving profile to CUSTOM was unsuccessful');
65:
66: RAISE PROGRAM_ERROR;

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 434: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE;

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;
438:

Line 435: l_level_value_application_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE;

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;
438:
439: l_ProfileTable CS_CF_UPG_UTL_PKG.ProfileTable;

Line 436: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;

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;
438:
439: l_ProfileTable CS_CF_UPG_UTL_PKG.ProfileTable;
440:

Line 508: p_respId IN FND_PROFILE_OPTION_VALUES.level_value%TYPE,

504: * of ak regions, based on the list of
505: * profiles that are customized at the resp level
506: */
507: PROCEDURE Clone_Regions_For_Resp(p_ProfileTable IN CS_CF_UPG_UTL_PKG.ProfileTable,
508: p_respId IN FND_PROFILE_OPTION_VALUES.level_value%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;

Line 509: p_respApplId IN FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE)

505: * profiles that are customized at the resp level
506: */
507: PROCEDURE Clone_Regions_For_Resp(p_ProfileTable IN CS_CF_UPG_UTL_PKG.ProfileTable,
508: p_respId IN FND_PROFILE_OPTION_VALUES.level_value%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;

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 514: l_profileOptionValue FND_PROFILE_OPTION_VALUES.profile_option_value%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';
518: l_newIdentifyProductRegionCode VARCHAR2(30) := 'IBU_CF_SR_30_G';

Line 542: l_displayBillToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';

538: l_newAllProductRegionCode VARCHAR2(30) := 'IBU_CF_SR_90_G';
539: l_newFilterRegionCode VARCHAR2(30) := 'IBU_CF_SR_410_G';
540:
541:
542: l_displayBillToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
543: l_displayBillToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
544: l_displayShipToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
545: l_displayShipToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
546: l_displayInstalledAtAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';

Line 543: l_displayBillToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';

539: l_newFilterRegionCode VARCHAR2(30) := 'IBU_CF_SR_410_G';
540:
541:
542: l_displayBillToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
543: l_displayBillToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
544: l_displayShipToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
545: l_displayShipToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
546: l_displayInstalledAtAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
547: l_displayIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';

Line 544: l_displayShipToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';

540:
541:
542: l_displayBillToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
543: l_displayBillToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
544: l_displayShipToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
545: l_displayShipToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
546: l_displayInstalledAtAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
547: l_displayIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
548: l_mandatoryIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';

Line 545: l_displayShipToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';

541:
542: l_displayBillToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
543: l_displayBillToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
544: l_displayShipToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
545: l_displayShipToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
546: l_displayInstalledAtAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
547: l_displayIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
548: l_mandatoryIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
549: l_displayAttachment FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

Line 546: l_displayInstalledAtAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';

542: l_displayBillToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
543: l_displayBillToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
544: l_displayShipToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
545: l_displayShipToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
546: l_displayInstalledAtAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
547: l_displayIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
548: l_mandatoryIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
549: l_displayAttachment FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
550: l_displayRegProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

Line 547: l_displayIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';

543: l_displayBillToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
544: l_displayShipToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
545: l_displayShipToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
546: l_displayInstalledAtAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
547: l_displayIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
548: l_mandatoryIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
549: l_displayAttachment FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
550: l_displayRegProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
551: l_displayAllProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

Line 548: l_mandatoryIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';

544: l_displayShipToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
545: l_displayShipToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
546: l_displayInstalledAtAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
547: l_displayIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
548: l_mandatoryIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
549: l_displayAttachment FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
550: l_displayRegProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
551: l_displayAllProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
552: l_enableTemplate FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

Line 549: l_displayAttachment FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

545: l_displayShipToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
546: l_displayInstalledAtAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
547: l_displayIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
548: l_mandatoryIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
549: l_displayAttachment FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
550: l_displayRegProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
551: l_displayAllProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
552: l_enableTemplate FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
553: l_displayTasks FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

Line 550: l_displayRegProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

546: l_displayInstalledAtAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
547: l_displayIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
548: l_mandatoryIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
549: l_displayAttachment FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
550: l_displayRegProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
551: l_displayAllProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
552: l_enableTemplate FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
553: l_displayTasks FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
554: l_mandatoryProblemCode FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

Line 551: l_displayAllProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

547: l_displayIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
548: l_mandatoryIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
549: l_displayAttachment FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
550: l_displayRegProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
551: l_displayAllProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
552: l_enableTemplate FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
553: l_displayTasks FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
554: l_mandatoryProblemCode FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
555:

Line 552: l_enableTemplate FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

548: l_mandatoryIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
549: l_displayAttachment FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
550: l_displayRegProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
551: l_displayAllProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
552: l_enableTemplate FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
553: l_displayTasks FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
554: l_mandatoryProblemCode FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
555:
556:

Line 553: l_displayTasks FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

549: l_displayAttachment FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
550: l_displayRegProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
551: l_displayAllProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
552: l_enableTemplate FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
553: l_displayTasks FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
554: l_mandatoryProblemCode FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
555:
556:
557:

Line 554: l_mandatoryProblemCode FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

550: l_displayRegProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
551: l_displayAllProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
552: l_enableTemplate FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
553: l_displayTasks FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
554: l_mandatoryProblemCode FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
555:
556:
557:
558: l_region_count NUMBER := 0;

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 1819: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE;

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;
1823:

Line 1820: l_level_value_application_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE;

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;
1823:
1824: l_ProfileTable CS_CF_UPG_UTL_PKG.ProfileTable;

Line 1821: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;

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;
1823:
1824: l_ProfileTable CS_CF_UPG_UTL_PKG.ProfileTable;
1825:

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 1901: l_profileOptionValue FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;

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';
1905: l_newIdentifyProductRegionCode VARCHAR2(30) := 'IBU_CF_SR_30_G';

Line 1928: l_displayBillToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';

1924: l_newRegProductRegionCode VARCHAR2(30) := 'IBU_CF_SR_80_G';
1925: l_newAllProductRegionCode VARCHAR2(30) := 'IBU_CF_SR_90_G';
1926: l_newFilterRegionCode VARCHAR2(30) := 'IBU_CF_SR_410_G';
1927:
1928: l_displayBillToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1929: l_displayBillToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1930: l_displayShipToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1931: l_displayShipToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1932: l_displayInstalledAtAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';

Line 1929: l_displayBillToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';

1925: l_newAllProductRegionCode VARCHAR2(30) := 'IBU_CF_SR_90_G';
1926: l_newFilterRegionCode VARCHAR2(30) := 'IBU_CF_SR_410_G';
1927:
1928: l_displayBillToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1929: l_displayBillToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1930: l_displayShipToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1931: l_displayShipToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1932: l_displayInstalledAtAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1933: l_displayIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';

Line 1930: l_displayShipToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';

1926: l_newFilterRegionCode VARCHAR2(30) := 'IBU_CF_SR_410_G';
1927:
1928: l_displayBillToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1929: l_displayBillToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1930: l_displayShipToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1931: l_displayShipToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1932: l_displayInstalledAtAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1933: l_displayIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1934: l_mandatoryIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';

Line 1931: l_displayShipToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';

1927:
1928: l_displayBillToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1929: l_displayBillToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1930: l_displayShipToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1931: l_displayShipToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1932: l_displayInstalledAtAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1933: l_displayIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1934: l_mandatoryIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1935: l_displayAttachment FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

Line 1932: l_displayInstalledAtAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';

1928: l_displayBillToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1929: l_displayBillToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1930: l_displayShipToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1931: l_displayShipToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1932: l_displayInstalledAtAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1933: l_displayIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1934: l_mandatoryIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1935: l_displayAttachment FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1936: l_displayRegProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

Line 1933: l_displayIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';

1929: l_displayBillToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1930: l_displayShipToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1931: l_displayShipToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1932: l_displayInstalledAtAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1933: l_displayIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1934: l_mandatoryIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1935: l_displayAttachment FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1936: l_displayRegProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1937: l_displayAllProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

Line 1934: l_mandatoryIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';

1930: l_displayShipToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1931: l_displayShipToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1932: l_displayInstalledAtAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1933: l_displayIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1934: l_mandatoryIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1935: l_displayAttachment FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1936: l_displayRegProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1937: l_displayAllProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1938: l_enableTemplate FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

Line 1935: l_displayAttachment FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

1931: l_displayShipToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1932: l_displayInstalledAtAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1933: l_displayIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1934: l_mandatoryIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1935: l_displayAttachment FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1936: l_displayRegProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1937: l_displayAllProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1938: l_enableTemplate FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1939: l_displayTasks FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

Line 1936: l_displayRegProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

1932: l_displayInstalledAtAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1933: l_displayIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1934: l_mandatoryIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1935: l_displayAttachment FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1936: l_displayRegProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1937: l_displayAllProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1938: l_enableTemplate FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1939: l_displayTasks FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1940: l_mandatoryProblemCode FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

Line 1937: l_displayAllProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

1933: l_displayIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1934: l_mandatoryIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1935: l_displayAttachment FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1936: l_displayRegProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1937: l_displayAllProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1938: l_enableTemplate FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1939: l_displayTasks FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1940: l_mandatoryProblemCode FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1941:

Line 1938: l_enableTemplate FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

1934: l_mandatoryIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
1935: l_displayAttachment FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1936: l_displayRegProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1937: l_displayAllProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1938: l_enableTemplate FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1939: l_displayTasks FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1940: l_mandatoryProblemCode FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1941:
1942:

Line 1939: l_displayTasks FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

1935: l_displayAttachment FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1936: l_displayRegProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1937: l_displayAllProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1938: l_enableTemplate FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1939: l_displayTasks FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1940: l_mandatoryProblemCode FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1941:
1942:
1943: l_region_count NUMBER := 0;

Line 1940: l_mandatoryProblemCode FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

1936: l_displayRegProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1937: l_displayAllProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1938: l_enableTemplate FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1939: l_displayTasks FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1940: l_mandatoryProblemCode FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1941:
1942:
1943: l_region_count NUMBER := 0;
1944:

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 3126: l_profileOptionValue FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;

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';
3130: l_newIdentifyProductRegionCode VARCHAR2(30) := 'IBU_CF_SR_30_G';

Line 3153: l_displayBillToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';

3149: l_newRegProductRegionCode VARCHAR2(30) := 'IBU_CF_SR_80_G';
3150: l_newAllProductRegionCode VARCHAR2(30) := 'IBU_CF_SR_90_G';
3151: l_newFilterRegionCode VARCHAR2(30) := 'IBU_CF_SR_410_G';
3152:
3153: l_displayBillToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3154: l_displayBillToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3155: l_displayShipToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3156: l_displayShipToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3157: l_displayInstalledAtAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';

Line 3154: l_displayBillToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';

3150: l_newAllProductRegionCode VARCHAR2(30) := 'IBU_CF_SR_90_G';
3151: l_newFilterRegionCode VARCHAR2(30) := 'IBU_CF_SR_410_G';
3152:
3153: l_displayBillToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3154: l_displayBillToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3155: l_displayShipToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3156: l_displayShipToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3157: l_displayInstalledAtAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3158: l_displayIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';

Line 3155: l_displayShipToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';

3151: l_newFilterRegionCode VARCHAR2(30) := 'IBU_CF_SR_410_G';
3152:
3153: l_displayBillToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3154: l_displayBillToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3155: l_displayShipToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3156: l_displayShipToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3157: l_displayInstalledAtAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3158: l_displayIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3159: l_mandatoryIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';

Line 3156: l_displayShipToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';

3152:
3153: l_displayBillToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3154: l_displayBillToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3155: l_displayShipToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3156: l_displayShipToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3157: l_displayInstalledAtAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3158: l_displayIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3159: l_mandatoryIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3160: l_displayAttachment FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

Line 3157: l_displayInstalledAtAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';

3153: l_displayBillToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3154: l_displayBillToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3155: l_displayShipToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3156: l_displayShipToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3157: l_displayInstalledAtAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3158: l_displayIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3159: l_mandatoryIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3160: l_displayAttachment FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3161: l_displayRegProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

Line 3158: l_displayIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';

3154: l_displayBillToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3155: l_displayShipToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3156: l_displayShipToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3157: l_displayInstalledAtAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3158: l_displayIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3159: l_mandatoryIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3160: l_displayAttachment FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3161: l_displayRegProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3162: l_displayAllProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

Line 3159: l_mandatoryIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';

3155: l_displayShipToAddress FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3156: l_displayShipToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3157: l_displayInstalledAtAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3158: l_displayIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3159: l_mandatoryIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3160: l_displayAttachment FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3161: l_displayRegProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3162: l_displayAllProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3163: l_enableTemplate FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

Line 3160: l_displayAttachment FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

3156: l_displayShipToContact FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3157: l_displayInstalledAtAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3158: l_displayIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3159: l_mandatoryIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3160: l_displayAttachment FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3161: l_displayRegProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3162: l_displayAllProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3163: l_enableTemplate FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3164: l_displayTasks FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

Line 3161: l_displayRegProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

3157: l_displayInstalledAtAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3158: l_displayIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3159: l_mandatoryIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3160: l_displayAttachment FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3161: l_displayRegProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3162: l_displayAllProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3163: l_enableTemplate FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3164: l_displayTasks FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3165: l_mandatoryProblemCode FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

Line 3162: l_displayAllProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

3158: l_displayIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3159: l_mandatoryIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3160: l_displayAttachment FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3161: l_displayRegProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3162: l_displayAllProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3163: l_enableTemplate FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3164: l_displayTasks FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3165: l_mandatoryProblemCode FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3166:

Line 3163: l_enableTemplate FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

3159: l_mandatoryIncidentAddr FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := 'N';
3160: l_displayAttachment FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3161: l_displayRegProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3162: l_displayAllProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3163: l_enableTemplate FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3164: l_displayTasks FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3165: l_mandatoryProblemCode FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3166:
3167:

Line 3164: l_displayTasks FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

3160: l_displayAttachment FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3161: l_displayRegProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3162: l_displayAllProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3163: l_enableTemplate FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3164: l_displayTasks FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3165: l_mandatoryProblemCode FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3166:
3167:
3168: l_region_count NUMBER := 0;

Line 3165: l_mandatoryProblemCode FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

3161: l_displayRegProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3162: l_displayAllProducts FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3163: l_enableTemplate FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3164: l_displayTasks FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3165: l_mandatoryProblemCode FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
3166:
3167:
3168: l_region_count NUMBER := 0;
3169:

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 4418: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE;

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;
4422:

Line 4419: l_level_value_application_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE;

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;
4422:
4423: l_ProfileTable CS_CF_UPG_UTL_PKG.ProfileTable;

Line 4420: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;

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;
4422:
4423: l_ProfileTable CS_CF_UPG_UTL_PKG.ProfileTable;
4424:

Line 4492: p_respId IN FND_PROFILE_OPTION_VALUES.level_value%TYPE,

4488: * of flows, based on the list of
4489: * profiles that are customized at the resp level
4490: */
4491: PROCEDURE Clone_Flows_For_Resp(p_ProfileTable IN CS_CF_UPG_UTL_PKG.ProfileTable,
4492: p_respId IN FND_PROFILE_OPTION_VALUES.level_value%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;

Line 4493: p_respApplId IN FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE)

4489: * profiles that are customized at the resp level
4490: */
4491: PROCEDURE Clone_Flows_For_Resp(p_ProfileTable IN CS_CF_UPG_UTL_PKG.ProfileTable,
4492: p_respId IN FND_PROFILE_OPTION_VALUES.level_value%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;

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 4498: l_profileOptionValue FND_PROFILE_OPTION_VALUES.profile_option_value%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);
4502:

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 4582: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE;

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;
4586:

Line 4583: l_level_value_application_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE;

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;
4586:
4587: l_ProfileTable CS_CF_UPG_UTL_PKG.ProfileTable;

Line 4584: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;

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;
4586:
4587: l_ProfileTable CS_CF_UPG_UTL_PKG.ProfileTable;
4588:

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 4659: l_profileOptionValue FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;

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:
4663:

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;

Line 4709: l_profileOptionValue FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;

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;
4713: l_last_updated_by NUMBER;