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.PA_FP_CI_MERGE dependencies on PA_PLANNING_RESOURCE_UTILS

Line 4550: PA_PLANNING_RESOURCE_UTILS.get_resource_defaults (

4546: END IF;
4547:
4548:
4549: IF l_da_resource_list_members_tab.COUNT > 0 THEN
4550: PA_PLANNING_RESOURCE_UTILS.get_resource_defaults (
4551: P_resource_list_members => l_da_resource_list_members_tab,
4552: P_project_id => l_project_id,
4553: X_resource_class_flag => l_da_resource_class_flag_tab,
4554: X_resource_class_code => l_da_resource_class_code_tab,

Line 4977: PA_PLANNING_RESOURCE_UTILS.get_resource_defaults (

4973: END IF;
4974: END LOOP;
4975:
4976: IF l_da_resource_list_members_tab.COUNT > 0 THEN
4977: PA_PLANNING_RESOURCE_UTILS.get_resource_defaults (
4978: P_resource_list_members => l_da_resource_list_members_tab,
4979: P_project_id => l_project_id,
4980: X_resource_class_flag => l_da_resource_class_flag_tab,
4981: X_resource_class_code => l_da_resource_class_code_tab,

Line 14002: nvl(pa_planning_resource_utils.get_rate_based_flag(pcdc.resource_list_member_id), 'N') = 'Y')

13998: and pra.resource_list_member_id = pcdc.resource_list_member_id
13999: and prac.txn_currency_code = pcdc.currency_code
14000: and prac.resource_assignment_id = pra.resource_assignment_id
14001: and ((prac.total_quantity is not null and
14002: nvl(pa_planning_resource_utils.get_rate_based_flag(pcdc.resource_list_member_id), 'N') = 'Y')
14003: OR
14004: (prac.total_txn_raw_cost is not null and
14005: nvl(pa_planning_resource_utils.get_rate_based_flag(pcdc.resource_list_member_id), 'N') = 'N')))
14006: where ci_id =l_ci_id_to

Line 14005: nvl(pa_planning_resource_utils.get_rate_based_flag(pcdc.resource_list_member_id), 'N') = 'N')))

14001: and ((prac.total_quantity is not null and
14002: nvl(pa_planning_resource_utils.get_rate_based_flag(pcdc.resource_list_member_id), 'N') = 'Y')
14003: OR
14004: (prac.total_txn_raw_cost is not null and
14005: nvl(pa_planning_resource_utils.get_rate_based_flag(pcdc.resource_list_member_id), 'N') = 'N')))
14006: where ci_id =l_ci_id_to
14007: and ((pcdc.quantity is not null and
14008: nvl(pa_planning_resource_utils.get_rate_based_flag(pcdc.resource_list_member_id), 'N') = 'Y')
14009: OR

Line 14008: nvl(pa_planning_resource_utils.get_rate_based_flag(pcdc.resource_list_member_id), 'N') = 'Y')

14004: (prac.total_txn_raw_cost is not null and
14005: nvl(pa_planning_resource_utils.get_rate_based_flag(pcdc.resource_list_member_id), 'N') = 'N')))
14006: where ci_id =l_ci_id_to
14007: and ((pcdc.quantity is not null and
14008: nvl(pa_planning_resource_utils.get_rate_based_flag(pcdc.resource_list_member_id), 'N') = 'Y')
14009: OR
14010: (pcdc.raw_cost is not null and
14011: nvl(pa_planning_resource_utils.get_rate_based_flag(pcdc.resource_list_member_id), 'N') = 'N'));
14012:

Line 14011: nvl(pa_planning_resource_utils.get_rate_based_flag(pcdc.resource_list_member_id), 'N') = 'N'));

14007: and ((pcdc.quantity is not null and
14008: nvl(pa_planning_resource_utils.get_rate_based_flag(pcdc.resource_list_member_id), 'N') = 'Y')
14009: OR
14010: (pcdc.raw_cost is not null and
14011: nvl(pa_planning_resource_utils.get_rate_based_flag(pcdc.resource_list_member_id), 'N') = 'N'));
14012:
14013: update pa_ci_direct_cost_details pcdc
14014: set (resource_assignment_id, effective_from, effective_to) =
14015: (select prac.resource_assignment_id,

Line 14025: nvl(pa_planning_resource_utils.get_rate_based_flag(pcdc.resource_list_member_id), 'N') = 'Y'))

14021: and pra.resource_list_member_id = pcdc.resource_list_member_id
14022: and prac.txn_currency_code = pcdc.currency_code
14023: and prac.resource_assignment_id = pra.resource_assignment_id
14024: and (prac.total_quantity is null and
14025: nvl(pa_planning_resource_utils.get_rate_based_flag(pcdc.resource_list_member_id), 'N') = 'Y'))
14026: where ci_id =l_ci_id_to
14027: and (pcdc.quantity is null and
14028: nvl(pa_planning_resource_utils.get_rate_based_flag(pcdc.resource_list_member_id), 'N') = 'Y');
14029:

Line 14028: nvl(pa_planning_resource_utils.get_rate_based_flag(pcdc.resource_list_member_id), 'N') = 'Y');

14024: and (prac.total_quantity is null and
14025: nvl(pa_planning_resource_utils.get_rate_based_flag(pcdc.resource_list_member_id), 'N') = 'Y'))
14026: where ci_id =l_ci_id_to
14027: and (pcdc.quantity is null and
14028: nvl(pa_planning_resource_utils.get_rate_based_flag(pcdc.resource_list_member_id), 'N') = 'Y');
14029:
14030: end if; --> l_task_id_tbl.count > 0
14031: end if;
14032: