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 1205: l_uom_hour := nvl(fnd_profile.value('JTF_AM_TASK_HOUR'), 'HR');

1201: JTF_ASSIGN_PUB.g_resource_avail.delete;
1202:
1203:
1204: /* to handle the conversion of duration to hour */
1205: l_uom_hour := nvl(fnd_profile.value('JTF_AM_TASK_HOUR'), 'HR');
1206:
1207:
1208:
1209: if(nvl(p_effort_uom, l_uom_hour) <> l_uom_hour)

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

3914: END IF;
3915:
3916: -- Get the Profile value to determine the order of preferred resources
3917:
3918: --l_pref_res_order := FND_PROFILE.VALUE_SPECIFIC ( 'JTF_AM_PREF_RES_ORDER' ); --Commented out by SBARAT on 12/10/2004, Bug-3830061
3919: l_pref_res_order := FND_PROFILE.VALUE ( 'JTF_AM_PREF_RES_ORDER' ); --Added by SBARAT on 12/10/2004, Bug-3830061
3920:
3921:
3922: IF ( p_contracts_preferred_engineer = 'Y' OR

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

3915:
3916: -- Get the Profile value to determine the order of preferred resources
3917:
3918: --l_pref_res_order := FND_PROFILE.VALUE_SPECIFIC ( 'JTF_AM_PREF_RES_ORDER' ); --Commented out by SBARAT on 12/10/2004, Bug-3830061
3919: l_pref_res_order := FND_PROFILE.VALUE ( 'JTF_AM_PREF_RES_ORDER' ); --Added by SBARAT on 12/10/2004, Bug-3830061
3920:
3921:
3922: IF ( p_contracts_preferred_engineer = 'Y' OR
3923: p_ib_preferred_engineer = 'Y') THEN

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

4613:
4614: -- Logic for getting resources belonging to group id passed in
4615: -- get the profile value to see if you have to filter by group membership
4616: -- to fix bug 2789319 on 3rd april 2003
4617: --l_group_filter := nvl(FND_PROFILE.VALUE_SPECIFIC ('JTF_AM_GROUP_MEMBER_FILTER'), 'YES'); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
4618: l_group_filter := nvl(FND_PROFILE.VALUE ('JTF_AM_GROUP_MEMBER_FILTER'), 'YES'); -- Added by SBARAT on 12/10/2004, Bug-3830061
4619:
4620:
4621: IF(l_group_filter = 'YES')

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

4614: -- Logic for getting resources belonging to group id passed in
4615: -- get the profile value to see if you have to filter by group membership
4616: -- to fix bug 2789319 on 3rd april 2003
4617: --l_group_filter := nvl(FND_PROFILE.VALUE_SPECIFIC ('JTF_AM_GROUP_MEMBER_FILTER'), 'YES'); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
4618: l_group_filter := nvl(FND_PROFILE.VALUE ('JTF_AM_GROUP_MEMBER_FILTER'), 'YES'); -- Added by SBARAT on 12/10/2004, Bug-3830061
4619:
4620:
4621: IF(l_group_filter = 'YES')
4622: THEN

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

5324:
5325:
5326: /* Getting the Profile values defined for the Assignment Manager */
5327:
5328: l_contracts_profile := FND_PROFILE.VALUE ( 'ACTIVATE_CONTRACTS_PREFERRED_ENGINEERS' );
5329: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' );
5330: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' );
5331: l_ib_profile := FND_PROFILE.VALUE ( 'ACTIVATE_IB_PREFERRED_ENGINEERS');
5332: l_usage := fnd_profile.value ( 'JTF_AM_USAGE');

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

5325:
5326: /* Getting the Profile values defined for the Assignment Manager */
5327:
5328: l_contracts_profile := FND_PROFILE.VALUE ( 'ACTIVATE_CONTRACTS_PREFERRED_ENGINEERS' );
5329: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' );
5330: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' );
5331: l_ib_profile := FND_PROFILE.VALUE ( 'ACTIVATE_IB_PREFERRED_ENGINEERS');
5332: l_usage := fnd_profile.value ( 'JTF_AM_USAGE');
5333:

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

5326: /* Getting the Profile values defined for the Assignment Manager */
5327:
5328: l_contracts_profile := FND_PROFILE.VALUE ( 'ACTIVATE_CONTRACTS_PREFERRED_ENGINEERS' );
5329: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' );
5330: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' );
5331: l_ib_profile := FND_PROFILE.VALUE ( 'ACTIVATE_IB_PREFERRED_ENGINEERS');
5332: l_usage := fnd_profile.value ( 'JTF_AM_USAGE');
5333:
5334: /* Assigning the DEFAULT values for the Parameters */

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

5327:
5328: l_contracts_profile := FND_PROFILE.VALUE ( 'ACTIVATE_CONTRACTS_PREFERRED_ENGINEERS' );
5329: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' );
5330: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' );
5331: l_ib_profile := FND_PROFILE.VALUE ( 'ACTIVATE_IB_PREFERRED_ENGINEERS');
5332: l_usage := fnd_profile.value ( 'JTF_AM_USAGE');
5333:
5334: /* Assigning the DEFAULT values for the Parameters */
5335:

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

5328: l_contracts_profile := FND_PROFILE.VALUE ( 'ACTIVATE_CONTRACTS_PREFERRED_ENGINEERS' );
5329: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' );
5330: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' );
5331: l_ib_profile := FND_PROFILE.VALUE ( 'ACTIVATE_IB_PREFERRED_ENGINEERS');
5332: l_usage := fnd_profile.value ( 'JTF_AM_USAGE');
5333:
5334: /* Assigning the DEFAULT values for the Parameters */
5335:
5336: IF (p_auto_select_flag IS NULL) THEN

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

5383:
5384:
5385: /* To handle the conversion of duration to hour */
5386:
5387: l_uom_hour := nvl(fnd_profile.value('JTF_AM_TASK_HOUR'), 'HR');
5388: IF(nvl(p_effort_uom, l_uom_hour) <> l_uom_hour)
5389: THEN
5390: l_effort_duration := inv_convert.inv_um_convert(
5391: item_id => NULL,

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

5507: END IF;
5508:
5509: -- Get the Profile value to determine the order of preferred resources
5510:
5511: l_pref_res_order := FND_PROFILE.VALUE ( 'JTF_AM_PREF_RES_ORDER' );
5512:
5513:
5514: IF ( p_contracts_preferred_engineer = 'Y' OR
5515: p_ib_preferred_engineer = 'Y') THEN

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

5953:
5954: -- Logic for getting resources belonging to group id passed in
5955: -- get the profile value to see if you have to filter by group membership
5956:
5957: l_group_filter := nvl(FND_PROFILE.VALUE ('JTF_AM_GROUP_MEMBER_FILTER'), 'YES');
5958:
5959: IF(l_group_filter = 'YES')
5960: THEN
5961: IF((p_dr_rec.squal_num17 is not null) )

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

6706:
6707:
6708: /* Getting the Auto Select Profile value defined for the Assignment Manager */
6709:
6710: --l_auto_select_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_AUTO_SELECT' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
6711: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
6712:
6713:
6714:

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

6707:
6708: /* Getting the Auto Select Profile value defined for the Assignment Manager */
6709:
6710: --l_auto_select_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_AUTO_SELECT' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
6711: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
6712:
6713:
6714:
6715: /* Assigning the DEFAULT value to the Auto Select Parameter */

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

7074: -- to further filter the resources
7075:
7076: /* Getting the Workflow Profile value defined for the Assignment Manager */
7077:
7078: --l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
7079: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
7080:
7081: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
7082: FROM dual;

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

7075:
7076: /* Getting the Workflow Profile value defined for the Assignment Manager */
7077:
7078: --l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
7079: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
7080:
7081: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
7082: FROM dual;
7083:

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

7391:
7392:
7393: /* Getting the Auto Select Profile value defined for the Assignment Manager */
7394:
7395: --l_auto_select_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_AUTO_SELECT' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
7396: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
7397:
7398:
7399:

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

7392:
7393: /* Getting the Auto Select Profile value defined for the Assignment Manager */
7394:
7395: --l_auto_select_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_AUTO_SELECT' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
7396: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
7397:
7398:
7399:
7400: /* Assigning the DEFAULT value to the Auto Select Parameter */

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

7662: -- to further filter the resources
7663:
7664: /* Getting the Workflow Profile value defined for the Assignment Manager */
7665:
7666: --l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
7667: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
7668:
7669: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
7670: FROM dual;

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

7663:
7664: /* Getting the Workflow Profile value defined for the Assignment Manager */
7665:
7666: --l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
7667: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
7668:
7669: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
7670: FROM dual;
7671:

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

7916:
7917:
7918: /* Getting the Auto Select Profile value defined for the Assignment Manager */
7919:
7920: --l_auto_select_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_AUTO_SELECT' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
7921: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
7922:
7923:
7924:

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

7917:
7918: /* Getting the Auto Select Profile value defined for the Assignment Manager */
7919:
7920: --l_auto_select_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_AUTO_SELECT' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
7921: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
7922:
7923:
7924:
7925: /* Assigning the DEFAULT value to the Auto Select Parameter */

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

8274: -- to further filter the resources
8275:
8276: /* Getting the Workflow Profile value defined for the Assignment Manager */
8277:
8278: --l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
8279: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
8280:
8281: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
8282: FROM dual;

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

8275:
8276: /* Getting the Workflow Profile value defined for the Assignment Manager */
8277:
8278: --l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
8279: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
8280:
8281: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
8282: FROM dual;
8283:

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

8594:
8595:
8596: /* Getting the Auto Select Profile value defined for the Assignment Manager */
8597:
8598: --l_auto_select_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_AUTO_SELECT' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
8599: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
8600:
8601:
8602:

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

8595:
8596: /* Getting the Auto Select Profile value defined for the Assignment Manager */
8597:
8598: --l_auto_select_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_AUTO_SELECT' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
8599: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
8600:
8601:
8602:
8603: /* Assigning the DEFAULT value to the Auto Select Parameter */

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

8922: -- to further filter the resources
8923:
8924: /* Getting the Workflow Profile value defined for the Assignment Manager */
8925:
8926: --l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
8927: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
8928:
8929: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
8930: FROM dual;

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

8923:
8924: /* Getting the Workflow Profile value defined for the Assignment Manager */
8925:
8926: --l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
8927: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
8928:
8929: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
8930: FROM dual;
8931:

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

9762:
9763:
9764: /* Getting the Auto Select Profile value defined for the Assignment Manager */
9765:
9766: --l_auto_select_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_AUTO_SELECT' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
9767: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
9768:
9769:
9770:

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

9763:
9764: /* Getting the Auto Select Profile value defined for the Assignment Manager */
9765:
9766: --l_auto_select_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_AUTO_SELECT' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
9767: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
9768:
9769:
9770:
9771: /* Assigning the DEFAULT value to the Auto Select Parameter */

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

10443:
10444:
10445: /* Getting the Workflow Profile value defined for the Assignment Manager */
10446:
10447: --l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
10448: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
10449:
10450:
10451: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key

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

10444:
10445: /* Getting the Workflow Profile value defined for the Assignment Manager */
10446:
10447: --l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
10448: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
10449:
10450:
10451: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
10452: FROM dual;

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

10892:
10893: /**************Start of commenting out by SBARAT on 12/10/2004, Bug-3830061***************/
10894:
10895: /*
10896: l_contracts_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_CONTRACTS_PREFERRED_ENGINEERS' );
10897: l_auto_select_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_AUTO_SELECT' );
10898: l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' );
10899: l_ib_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_IB_PREFERRED_ENGINEERS');
10900: */

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

10893: /**************Start of commenting out by SBARAT on 12/10/2004, Bug-3830061***************/
10894:
10895: /*
10896: l_contracts_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_CONTRACTS_PREFERRED_ENGINEERS' );
10897: l_auto_select_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_AUTO_SELECT' );
10898: l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' );
10899: l_ib_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_IB_PREFERRED_ENGINEERS');
10900: */
10901:

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

10894:
10895: /*
10896: l_contracts_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_CONTRACTS_PREFERRED_ENGINEERS' );
10897: l_auto_select_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_AUTO_SELECT' );
10898: l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' );
10899: l_ib_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_IB_PREFERRED_ENGINEERS');
10900: */
10901:
10902: /**************End of commenting out by SBARAT on 12/10/2004, Bug-3830061**************/

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

10895: /*
10896: l_contracts_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_CONTRACTS_PREFERRED_ENGINEERS' );
10897: l_auto_select_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_AUTO_SELECT' );
10898: l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' );
10899: l_ib_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_IB_PREFERRED_ENGINEERS');
10900: */
10901:
10902: /**************End of commenting out by SBARAT on 12/10/2004, Bug-3830061**************/
10903:

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

10902: /**************End of commenting out by SBARAT on 12/10/2004, Bug-3830061**************/
10903:
10904: /**************Start of addition by SBARAT on 12/10/2004, Bug-3830061****************/
10905:
10906: l_contracts_profile := FND_PROFILE.VALUE ( 'ACTIVATE_CONTRACTS_PREFERRED_ENGINEERS' );
10907: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' );
10908: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' );
10909: l_ib_profile := FND_PROFILE.VALUE ( 'ACTIVATE_IB_PREFERRED_ENGINEERS');
10910:

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

10903:
10904: /**************Start of addition by SBARAT on 12/10/2004, Bug-3830061****************/
10905:
10906: l_contracts_profile := FND_PROFILE.VALUE ( 'ACTIVATE_CONTRACTS_PREFERRED_ENGINEERS' );
10907: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' );
10908: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' );
10909: l_ib_profile := FND_PROFILE.VALUE ( 'ACTIVATE_IB_PREFERRED_ENGINEERS');
10910:
10911: /**************End of addition by SBARAT on 12/10/2004, Bug-3830061****************/

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

10904: /**************Start of addition by SBARAT on 12/10/2004, Bug-3830061****************/
10905:
10906: l_contracts_profile := FND_PROFILE.VALUE ( 'ACTIVATE_CONTRACTS_PREFERRED_ENGINEERS' );
10907: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' );
10908: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' );
10909: l_ib_profile := FND_PROFILE.VALUE ( 'ACTIVATE_IB_PREFERRED_ENGINEERS');
10910:
10911: /**************End of addition by SBARAT on 12/10/2004, Bug-3830061****************/
10912:

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

10905:
10906: l_contracts_profile := FND_PROFILE.VALUE ( 'ACTIVATE_CONTRACTS_PREFERRED_ENGINEERS' );
10907: l_auto_select_profile := FND_PROFILE.VALUE ( 'ACTIVATE_AUTO_SELECT' );
10908: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' );
10909: l_ib_profile := FND_PROFILE.VALUE ( 'ACTIVATE_IB_PREFERRED_ENGINEERS');
10910:
10911: /**************End of addition by SBARAT on 12/10/2004, Bug-3830061****************/
10912:
10913: -- get the profile value for usage

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

10910:
10911: /**************End of addition by SBARAT on 12/10/2004, Bug-3830061****************/
10912:
10913: -- get the profile value for usage
10914: l_usage := fnd_profile.value('JTF_AM_USAGE');
10915:
10916: /* Assigning the DEFAULT values for the Parameters */
10917:
10918:

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

10972: END IF;
10973:
10974:
10975: /* to handle the conversion of duration to hour */
10976: l_uom_hour := nvl(fnd_profile.value('JTF_AM_TASK_HOUR'), 'HR');
10977:
10978:
10979: --Commented out by SBARAT on 21/04/2005 for Bug-4300801
10980: --It was causing double conversion since same conversion is being done

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

11499: end;
11500:
11501: -- ================code added for bug 6453896==========================
11502: -- =============== This code is added for sorting table based on territory ranking===========
11503: l_sort_profile := nvl(fnd_profile.value('JTF_AM_SORT_TERR_RANK'),'N');
11504: If l_sort_profile ='Y'
11505: then
11506: t_assign_resources_tbl :=x_assign_resources_tbl;
11507: x_assign_resources_tbl.delete;

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

11779: End;
11780:
11781: -- ================code added for bug 6453896==========================
11782: -- =============== This code is added for sorting table based on territory ranking===========
11783: l_sort_profile := nvl(fnd_profile.value('JTF_AM_SORT_TERR_RANK'),'N');
11784: If l_sort_profile ='Y'
11785: then
11786: t_assign_resources_tbl :=x_assign_resources_tbl;
11787: x_assign_resources_tbl.delete;