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.JTF_ASSIGN_PUB dependencies on FND_PROFILE

Line 951: l_uom_hour := nvl(fnd_profile.value('JTF_AM_TASK_HOUR'), 'HR');

947:
948: -- Added by SBARAT on 21/04/2005 for Bug-4300801
949: -- This conversion is done only before calling JTF_CALENDAR_PUB
950: /* to handle the conversion of duration to hour */
951: l_uom_hour := nvl(fnd_profile.value('JTF_AM_TASK_HOUR'), 'HR');
952: if(nvl(p_effort_uom, l_uom_hour) <> l_uom_hour)
953: then
954: l_effort_duration := inv_convert.inv_um_convert(
955: item_id => NULL,

Line 1195: l_uom_hour := nvl(fnd_profile.value('JTF_AM_TASK_HOUR'), 'HR');

1191: l_resources_tbl.delete;
1192: JTF_ASSIGN_PUB.g_resource_avail.delete;
1193:
1194: /* to handle the conversion of duration to hour */
1195: l_uom_hour := nvl(fnd_profile.value('JTF_AM_TASK_HOUR'), 'HR');
1196: if(nvl(p_effort_uom, l_uom_hour) <> l_uom_hour)
1197: then
1198: l_effort_duration := inv_convert.inv_um_convert(
1199: item_id => NULL,

Line 3874: --l_pref_res_order := FND_PROFILE.VALUE_SPECIFIC ( 'JTF_AM_PREF_RES_ORDER' ); --Commented out by SBARAT on 12/10/2004, Bug-3830061

3870: END IF;
3871:
3872: -- Get the Profile value to determine the order of preferred resources
3873:
3874: --l_pref_res_order := FND_PROFILE.VALUE_SPECIFIC ( 'JTF_AM_PREF_RES_ORDER' ); --Commented out by SBARAT on 12/10/2004, Bug-3830061
3875: l_pref_res_order := FND_PROFILE.VALUE ( 'JTF_AM_PREF_RES_ORDER' ); --Added by SBARAT on 12/10/2004, Bug-3830061
3876:
3877:
3878: IF ( p_contracts_preferred_engineer = 'Y' OR

Line 3875: l_pref_res_order := FND_PROFILE.VALUE ( 'JTF_AM_PREF_RES_ORDER' ); --Added by SBARAT on 12/10/2004, Bug-3830061

3871:
3872: -- Get the Profile value to determine the order of preferred resources
3873:
3874: --l_pref_res_order := FND_PROFILE.VALUE_SPECIFIC ( 'JTF_AM_PREF_RES_ORDER' ); --Commented out by SBARAT on 12/10/2004, Bug-3830061
3875: l_pref_res_order := FND_PROFILE.VALUE ( 'JTF_AM_PREF_RES_ORDER' ); --Added by SBARAT on 12/10/2004, Bug-3830061
3876:
3877:
3878: IF ( p_contracts_preferred_engineer = 'Y' OR
3879: p_ib_preferred_engineer = 'Y') THEN

Line 4553: --l_group_filter := nvl(FND_PROFILE.VALUE_SPECIFIC ('JTF_AM_GROUP_MEMBER_FILTER'), 'YES'); -- Commented out by SBARAT on 12/10/2004, Bug-3830061

4549:
4550: -- Logic for getting resources belonging to group id passed in
4551: -- get the profile value to see if you have to filter by group membership
4552: -- to fix bug 2789319 on 3rd april 2003
4553: --l_group_filter := nvl(FND_PROFILE.VALUE_SPECIFIC ('JTF_AM_GROUP_MEMBER_FILTER'), 'YES'); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
4554: l_group_filter := nvl(FND_PROFILE.VALUE ('JTF_AM_GROUP_MEMBER_FILTER'), 'YES'); -- Added by SBARAT on 12/10/2004, Bug-3830061
4555:
4556:
4557: IF(l_group_filter = 'YES')

Line 4554: l_group_filter := nvl(FND_PROFILE.VALUE ('JTF_AM_GROUP_MEMBER_FILTER'), 'YES'); -- Added by SBARAT on 12/10/2004, Bug-3830061

4550: -- Logic for getting resources belonging to group id passed in
4551: -- get the profile value to see if you have to filter by group membership
4552: -- to fix bug 2789319 on 3rd april 2003
4553: --l_group_filter := nvl(FND_PROFILE.VALUE_SPECIFIC ('JTF_AM_GROUP_MEMBER_FILTER'), 'YES'); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
4554: l_group_filter := nvl(FND_PROFILE.VALUE ('JTF_AM_GROUP_MEMBER_FILTER'), 'YES'); -- Added by SBARAT on 12/10/2004, Bug-3830061
4555:
4556:
4557: IF(l_group_filter = 'YES')
4558: THEN

Line 5264: l_contracts_profile := FND_PROFILE.VALUE ( 'ACTIVATE_CONTRACTS_PREFERRED_ENGINEERS' );

5260:
5261:
5262: /* Getting the Profile values defined for the Assignment Manager */
5263:
5264: l_contracts_profile := FND_PROFILE.VALUE ( 'ACTIVATE_CONTRACTS_PREFERRED_ENGINEERS' );
5265: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' );
5266: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' );
5267: l_ib_profile := FND_PROFILE.VALUE ( 'ACTIVATE_IB_PREFERRED_ENGINEERS');
5268: l_usage := fnd_profile.value ( 'JTF_AM_USAGE');

Line 5265: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' );

5261:
5262: /* Getting the Profile values defined for the Assignment Manager */
5263:
5264: l_contracts_profile := FND_PROFILE.VALUE ( 'ACTIVATE_CONTRACTS_PREFERRED_ENGINEERS' );
5265: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' );
5266: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' );
5267: l_ib_profile := FND_PROFILE.VALUE ( 'ACTIVATE_IB_PREFERRED_ENGINEERS');
5268: l_usage := fnd_profile.value ( 'JTF_AM_USAGE');
5269:

Line 5266: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' );

5262: /* Getting the Profile values defined for the Assignment Manager */
5263:
5264: l_contracts_profile := FND_PROFILE.VALUE ( 'ACTIVATE_CONTRACTS_PREFERRED_ENGINEERS' );
5265: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' );
5266: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' );
5267: l_ib_profile := FND_PROFILE.VALUE ( 'ACTIVATE_IB_PREFERRED_ENGINEERS');
5268: l_usage := fnd_profile.value ( 'JTF_AM_USAGE');
5269:
5270: /* Assigning the DEFAULT values for the Parameters */

Line 5267: l_ib_profile := FND_PROFILE.VALUE ( 'ACTIVATE_IB_PREFERRED_ENGINEERS');

5263:
5264: l_contracts_profile := FND_PROFILE.VALUE ( 'ACTIVATE_CONTRACTS_PREFERRED_ENGINEERS' );
5265: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' );
5266: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' );
5267: l_ib_profile := FND_PROFILE.VALUE ( 'ACTIVATE_IB_PREFERRED_ENGINEERS');
5268: l_usage := fnd_profile.value ( 'JTF_AM_USAGE');
5269:
5270: /* Assigning the DEFAULT values for the Parameters */
5271:

Line 5268: l_usage := fnd_profile.value ( 'JTF_AM_USAGE');

5264: l_contracts_profile := FND_PROFILE.VALUE ( 'ACTIVATE_CONTRACTS_PREFERRED_ENGINEERS' );
5265: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' );
5266: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' );
5267: l_ib_profile := FND_PROFILE.VALUE ( 'ACTIVATE_IB_PREFERRED_ENGINEERS');
5268: l_usage := fnd_profile.value ( 'JTF_AM_USAGE');
5269:
5270: /* Assigning the DEFAULT values for the Parameters */
5271:
5272: IF (p_auto_select_flag IS NULL) THEN

Line 5323: l_uom_hour := nvl(fnd_profile.value('JTF_AM_TASK_HOUR'), 'HR');

5319:
5320:
5321: /* To handle the conversion of duration to hour */
5322:
5323: l_uom_hour := nvl(fnd_profile.value('JTF_AM_TASK_HOUR'), 'HR');
5324: IF(nvl(p_effort_uom, l_uom_hour) <> l_uom_hour)
5325: THEN
5326: l_effort_duration := inv_convert.inv_um_convert(
5327: item_id => NULL,

Line 5447: l_pref_res_order := FND_PROFILE.VALUE ( 'JTF_AM_PREF_RES_ORDER' );

5443: END IF;
5444:
5445: -- Get the Profile value to determine the order of preferred resources
5446:
5447: l_pref_res_order := FND_PROFILE.VALUE ( 'JTF_AM_PREF_RES_ORDER' );
5448:
5449:
5450: IF ( p_contracts_preferred_engineer = 'Y' OR
5451: p_ib_preferred_engineer = 'Y') THEN

Line 5893: l_group_filter := nvl(FND_PROFILE.VALUE ('JTF_AM_GROUP_MEMBER_FILTER'), 'YES');

5889:
5890: -- Logic for getting resources belonging to group id passed in
5891: -- get the profile value to see if you have to filter by group membership
5892:
5893: l_group_filter := nvl(FND_PROFILE.VALUE ('JTF_AM_GROUP_MEMBER_FILTER'), 'YES');
5894:
5895: IF(l_group_filter = 'YES')
5896: THEN
5897: IF((p_dr_rec.squal_num17 is not null) )

Line 6646: --l_auto_select_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_AUTO_SELECT' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061

6642:
6643:
6644: /* Getting the Auto Select Profile value defined for the Assignment Manager */
6645:
6646: --l_auto_select_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_AUTO_SELECT' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
6647: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
6648:
6649:
6650:

Line 6647: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' ); -- Added by SBARAT on 12/10/2004, Bug-3830061

6643:
6644: /* Getting the Auto Select Profile value defined for the Assignment Manager */
6645:
6646: --l_auto_select_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_AUTO_SELECT' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
6647: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
6648:
6649:
6650:
6651: /* Assigning the DEFAULT value to the Auto Select Parameter */

Line 7014: --l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061

7010: -- to further filter the resources
7011:
7012: /* Getting the Workflow Profile value defined for the Assignment Manager */
7013:
7014: --l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
7015: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
7016:
7017: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
7018: FROM dual;

Line 7015: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' ); -- Added by SBARAT on 12/10/2004, Bug-3830061

7011:
7012: /* Getting the Workflow Profile value defined for the Assignment Manager */
7013:
7014: --l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
7015: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
7016:
7017: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
7018: FROM dual;
7019:

Line 7331: --l_auto_select_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_AUTO_SELECT' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061

7327:
7328:
7329: /* Getting the Auto Select Profile value defined for the Assignment Manager */
7330:
7331: --l_auto_select_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_AUTO_SELECT' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
7332: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
7333:
7334:
7335:

Line 7332: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' ); -- Added by SBARAT on 12/10/2004, Bug-3830061

7328:
7329: /* Getting the Auto Select Profile value defined for the Assignment Manager */
7330:
7331: --l_auto_select_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_AUTO_SELECT' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
7332: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
7333:
7334:
7335:
7336: /* Assigning the DEFAULT value to the Auto Select Parameter */

Line 7602: --l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061

7598: -- to further filter the resources
7599:
7600: /* Getting the Workflow Profile value defined for the Assignment Manager */
7601:
7602: --l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
7603: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
7604:
7605: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
7606: FROM dual;

Line 7603: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' ); -- Added by SBARAT on 12/10/2004, Bug-3830061

7599:
7600: /* Getting the Workflow Profile value defined for the Assignment Manager */
7601:
7602: --l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
7603: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
7604:
7605: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
7606: FROM dual;
7607:

Line 7856: --l_auto_select_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_AUTO_SELECT' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061

7852:
7853:
7854: /* Getting the Auto Select Profile value defined for the Assignment Manager */
7855:
7856: --l_auto_select_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_AUTO_SELECT' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
7857: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
7858:
7859:
7860:

Line 7857: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' ); -- Added by SBARAT on 12/10/2004, Bug-3830061

7853:
7854: /* Getting the Auto Select Profile value defined for the Assignment Manager */
7855:
7856: --l_auto_select_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_AUTO_SELECT' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
7857: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
7858:
7859:
7860:
7861: /* Assigning the DEFAULT value to the Auto Select Parameter */

Line 8214: --l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061

8210: -- to further filter the resources
8211:
8212: /* Getting the Workflow Profile value defined for the Assignment Manager */
8213:
8214: --l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
8215: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
8216:
8217: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
8218: FROM dual;

Line 8215: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' ); -- Added by SBARAT on 12/10/2004, Bug-3830061

8211:
8212: /* Getting the Workflow Profile value defined for the Assignment Manager */
8213:
8214: --l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
8215: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
8216:
8217: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
8218: FROM dual;
8219:

Line 8534: --l_auto_select_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_AUTO_SELECT' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061

8530:
8531:
8532: /* Getting the Auto Select Profile value defined for the Assignment Manager */
8533:
8534: --l_auto_select_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_AUTO_SELECT' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
8535: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
8536:
8537:
8538:

Line 8535: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' ); -- Added by SBARAT on 12/10/2004, Bug-3830061

8531:
8532: /* Getting the Auto Select Profile value defined for the Assignment Manager */
8533:
8534: --l_auto_select_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_AUTO_SELECT' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
8535: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
8536:
8537:
8538:
8539: /* Assigning the DEFAULT value to the Auto Select Parameter */

Line 8862: --l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061

8858: -- to further filter the resources
8859:
8860: /* Getting the Workflow Profile value defined for the Assignment Manager */
8861:
8862: --l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
8863: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
8864:
8865: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
8866: FROM dual;

Line 8863: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' ); -- Added by SBARAT on 12/10/2004, Bug-3830061

8859:
8860: /* Getting the Workflow Profile value defined for the Assignment Manager */
8861:
8862: --l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
8863: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
8864:
8865: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
8866: FROM dual;
8867:

Line 9702: --l_auto_select_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_AUTO_SELECT' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061

9698:
9699:
9700: /* Getting the Auto Select Profile value defined for the Assignment Manager */
9701:
9702: --l_auto_select_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_AUTO_SELECT' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
9703: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
9704:
9705:
9706:

Line 9703: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' ); -- Added by SBARAT on 12/10/2004, Bug-3830061

9699:
9700: /* Getting the Auto Select Profile value defined for the Assignment Manager */
9701:
9702: --l_auto_select_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_AUTO_SELECT' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
9703: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
9704:
9705:
9706:
9707: /* Assigning the DEFAULT value to the Auto Select Parameter */

Line 10383: --l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061

10379:
10380:
10381: /* Getting the Workflow Profile value defined for the Assignment Manager */
10382:
10383: --l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
10384: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
10385:
10386:
10387: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key

Line 10384: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' ); -- Added by SBARAT on 12/10/2004, Bug-3830061

10380:
10381: /* Getting the Workflow Profile value defined for the Assignment Manager */
10382:
10383: --l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
10384: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
10385:
10386:
10387: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
10388: FROM dual;

Line 10826: l_contracts_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_CONTRACTS_PREFERRED_ENGINEERS' );

10822:
10823: /**************Start of commenting out by SBARAT on 12/10/2004, Bug-3830061***************/
10824:
10825: /*
10826: l_contracts_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_CONTRACTS_PREFERRED_ENGINEERS' );
10827: l_auto_select_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_AUTO_SELECT' );
10828: l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' );
10829: l_ib_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_IB_PREFERRED_ENGINEERS');
10830: */

Line 10827: l_auto_select_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_AUTO_SELECT' );

10823: /**************Start of commenting out by SBARAT on 12/10/2004, Bug-3830061***************/
10824:
10825: /*
10826: l_contracts_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_CONTRACTS_PREFERRED_ENGINEERS' );
10827: l_auto_select_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_AUTO_SELECT' );
10828: l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' );
10829: l_ib_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_IB_PREFERRED_ENGINEERS');
10830: */
10831:

Line 10828: l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' );

10824:
10825: /*
10826: l_contracts_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_CONTRACTS_PREFERRED_ENGINEERS' );
10827: l_auto_select_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_AUTO_SELECT' );
10828: l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' );
10829: l_ib_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_IB_PREFERRED_ENGINEERS');
10830: */
10831:
10832: /**************End of commenting out by SBARAT on 12/10/2004, Bug-3830061**************/

Line 10829: l_ib_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_IB_PREFERRED_ENGINEERS');

10825: /*
10826: l_contracts_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_CONTRACTS_PREFERRED_ENGINEERS' );
10827: l_auto_select_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_AUTO_SELECT' );
10828: l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' );
10829: l_ib_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_IB_PREFERRED_ENGINEERS');
10830: */
10831:
10832: /**************End of commenting out by SBARAT on 12/10/2004, Bug-3830061**************/
10833:

Line 10836: l_contracts_profile := FND_PROFILE.VALUE ( 'ACTIVATE_CONTRACTS_PREFERRED_ENGINEERS' );

10832: /**************End of commenting out by SBARAT on 12/10/2004, Bug-3830061**************/
10833:
10834: /**************Start of addition by SBARAT on 12/10/2004, Bug-3830061****************/
10835:
10836: l_contracts_profile := FND_PROFILE.VALUE ( 'ACTIVATE_CONTRACTS_PREFERRED_ENGINEERS' );
10837: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' );
10838: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' );
10839: l_ib_profile := FND_PROFILE.VALUE ( 'ACTIVATE_IB_PREFERRED_ENGINEERS');
10840:

Line 10837: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' );

10833:
10834: /**************Start of addition by SBARAT on 12/10/2004, Bug-3830061****************/
10835:
10836: l_contracts_profile := FND_PROFILE.VALUE ( 'ACTIVATE_CONTRACTS_PREFERRED_ENGINEERS' );
10837: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' );
10838: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' );
10839: l_ib_profile := FND_PROFILE.VALUE ( 'ACTIVATE_IB_PREFERRED_ENGINEERS');
10840:
10841: /**************End of addition by SBARAT on 12/10/2004, Bug-3830061****************/

Line 10838: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' );

10834: /**************Start of addition by SBARAT on 12/10/2004, Bug-3830061****************/
10835:
10836: l_contracts_profile := FND_PROFILE.VALUE ( 'ACTIVATE_CONTRACTS_PREFERRED_ENGINEERS' );
10837: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' );
10838: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' );
10839: l_ib_profile := FND_PROFILE.VALUE ( 'ACTIVATE_IB_PREFERRED_ENGINEERS');
10840:
10841: /**************End of addition by SBARAT on 12/10/2004, Bug-3830061****************/
10842:

Line 10839: l_ib_profile := FND_PROFILE.VALUE ( 'ACTIVATE_IB_PREFERRED_ENGINEERS');

10835:
10836: l_contracts_profile := FND_PROFILE.VALUE ( 'ACTIVATE_CONTRACTS_PREFERRED_ENGINEERS' );
10837: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' );
10838: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' );
10839: l_ib_profile := FND_PROFILE.VALUE ( 'ACTIVATE_IB_PREFERRED_ENGINEERS');
10840:
10841: /**************End of addition by SBARAT on 12/10/2004, Bug-3830061****************/
10842:
10843: -- get the profile value for usage

Line 10844: l_usage := fnd_profile.value('JTF_AM_USAGE');

10840:
10841: /**************End of addition by SBARAT on 12/10/2004, Bug-3830061****************/
10842:
10843: -- get the profile value for usage
10844: l_usage := fnd_profile.value('JTF_AM_USAGE');
10845:
10846: /* Assigning the DEFAULT values for the Parameters */
10847:
10848:

Line 10906: l_uom_hour := nvl(fnd_profile.value('JTF_AM_TASK_HOUR'), 'HR');

10902: END IF;
10903:
10904:
10905: /* to handle the conversion of duration to hour */
10906: l_uom_hour := nvl(fnd_profile.value('JTF_AM_TASK_HOUR'), 'HR');
10907:
10908:
10909: --Commented out by SBARAT on 21/04/2005 for Bug-4300801
10910: --It was causing double conversion since same conversion is being done

Line 11425: l_sort_profile := nvl(fnd_profile.value('JTF_AM_SORT_TERR_RANK'),'N');

11421: end;
11422:
11423: -- ================code added for bug 6453896==========================
11424: -- =============== This code is added for sorting table based on territory ranking===========
11425: l_sort_profile := nvl(fnd_profile.value('JTF_AM_SORT_TERR_RANK'),'N');
11426: If l_sort_profile ='Y'
11427: then
11428: t_assign_resources_tbl :=x_assign_resources_tbl;
11429: x_assign_resources_tbl.delete;

Line 11705: l_sort_profile := nvl(fnd_profile.value('JTF_AM_SORT_TERR_RANK'),'N');

11701: End;
11702:
11703: -- ================code added for bug 6453896==========================
11704: -- =============== This code is added for sorting table based on territory ranking===========
11705: l_sort_profile := nvl(fnd_profile.value('JTF_AM_SORT_TERR_RANK'),'N');
11706: If l_sort_profile ='Y'
11707: then
11708: t_assign_resources_tbl :=x_assign_resources_tbl;
11709: x_assign_resources_tbl.delete;