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.PJI_FM_PLAN_MAINT_T_PVT dependencies on PJI_UTILS

Line 1410: l_per_analysis_flag := PJI_UTILS.GET_SETUP_PARAMETER('PER_ANALYSIS_FLAG');

1406: IF P_PA_DEBUG_MODE = 'Y' THEN
1407: pa_debug.write('EXTRACT_PLAN_AMOUNTS_PRIRBS: ' || g_module_name,'Inside EXTRACT_PLAN_AMOUNTS_PRIRBS' ,1);
1408: END IF;
1409: /* Added for bug 8708651
1410: l_per_analysis_flag := PJI_UTILS.GET_SETUP_PARAMETER('PER_ANALYSIS_FLAG');
1411: Commented for bug 9048716 */
1412:
1413: INSERT_NTP_CAL_RECORD ( x_max_plnver_id => l_max_plnver_id );
1414:

Line 1847: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

1843: ,
1844: (
1845: select 4 INVERT_ID from dual union all
1846: select 8 INVERT_ID from dual union all
1847: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
1848: ) invert
1849: ) collapse_bl
1850: ---- End of second inline view 'collapse_bl' ..........
1851: GROUP BY

Line 2952: select 1 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR1_FLAG') = 'Y' union all /* Added for bug 8708651 */

2948: ) spread_bl
2949: ---- end of third inline view 'spread_bl'...........
2950: ,
2951: (
2952: select 1 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR1_FLAG') = 'Y' union all /* Added for bug 8708651 */
2953: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
2954: select 4 INVERT_ID from dual union all
2955: select 8 INVERT_ID from dual union all
2956: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

Line 2953: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all

2949: ---- end of third inline view 'spread_bl'...........
2950: ,
2951: (
2952: select 1 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR1_FLAG') = 'Y' union all /* Added for bug 8708651 */
2953: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
2954: select 4 INVERT_ID from dual union all
2955: select 8 INVERT_ID from dual union all
2956: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
2957: ) invert

Line 2956: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

2952: select 1 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR1_FLAG') = 'Y' union all /* Added for bug 8708651 */
2953: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
2954: select 4 INVERT_ID from dual union all
2955: select 8 INVERT_ID from dual union all
2956: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
2957: ) invert
2958: ) collapse_bl
2959: ---- End of second inline view 'collapse_bl' ..........
2960: GROUP BY

Line 3987: select 1 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR1_FLAG') = 'Y' union all /* Added for bug 8708651 */

3983: ) spread_bl
3984: ---- end of third inline view 'spread_bl'...........
3985: ,
3986: (
3987: select 1 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR1_FLAG') = 'Y' union all /* Added for bug 8708651 */
3988: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
3989: select 4 INVERT_ID from dual union all
3990: select 8 INVERT_ID from dual union all
3991: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

Line 3988: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all

3984: ---- end of third inline view 'spread_bl'...........
3985: ,
3986: (
3987: select 1 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR1_FLAG') = 'Y' union all /* Added for bug 8708651 */
3988: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
3989: select 4 INVERT_ID from dual union all
3990: select 8 INVERT_ID from dual union all
3991: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
3992: ) invert

Line 3991: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

3987: select 1 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR1_FLAG') = 'Y' union all /* Added for bug 8708651 */
3988: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
3989: select 4 INVERT_ID from dual union all
3990: select 8 INVERT_ID from dual union all
3991: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
3992: ) invert
3993: ) collapse_bl -- WHERE wbs_element_id = 7474 -- and rbs_element_id = 10266 -- and budget_version_id = 2909
3994: ---- End of second inline view 'collapse_bl' ..........
3995: GROUP BY

Line 4536: /* l_per_analysis_flag := PJI_UTILS.GET_SETUP_PARAMETER('PER_ANALYSIS_FLAG'); /* Added for bug 8708651

4532: FROM PJI_FM_EXTR_PLNVER3_T;
4533:
4534: BEGIN
4535:
4536: /* l_per_analysis_flag := PJI_UTILS.GET_SETUP_PARAMETER('PER_ANALYSIS_FLAG'); /* Added for bug 8708651
4537: Commented for bug 9048716*/
4538:
4539: print_time('........RETRIEVE_DELTA_SLICE : Begin.' );
4540:

Line 4973: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

4969: ,
4970: (
4971: select 4 INVERT_ID from dual union all
4972: select 8 INVERT_ID from dual union all
4973: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
4974: ) invert
4975: ) collapse_bl
4976: ---- End of second inline view 'collapse_bl' ..........
4977: GROUP BY

Line 5164: PJI_UTILS.g_max_roll_days := 1500; /5155692 /

5160: WHERE worker_id = g_worker_id;
5161: -- Removed pa_resource_assignments join and Added joins with pji_org_extr_info
5162: -- for bug 4149422
5163: -- SQL for getting rates for time phased budgets.
5164: PJI_UTILS.g_max_roll_days := 1500; /*5155692 */
5165:
5166: INSERT INTO PJI_FM_AGGR_DLY_RATES_T (
5167: WORKER_ID ,
5168: PF_CURRENCY_CODE ,

Line 5177: PJI_UTILS.GET_GLOBAL_RATE_PRIMARY (temp.projfunc_currency_code

5173: MAU2)
5174: SELECT worker_id,
5175: projfunc_currency_code,
5176: time_id,
5177: PJI_UTILS.GET_GLOBAL_RATE_PRIMARY (temp.projfunc_currency_code
5178: , DECODE ( g_currency_conversion_rule
5179: , 'S'
5180: , temp.start_date
5181: , 'E'

Line 5185: DECODE ( PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG'),

5181: , 'E'
5182: , temp.end_date ))
5183: rate1,
5184: l_gl1_mau mau1,
5185: DECODE ( PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG'),
5186: 'Y',
5187: PJI_UTILS.GET_GLOBAL_RATE_SECONDARY (temp.projfunc_currency_code,
5188: DECODE ( g_currency_conversion_rule
5189: , 'S'

Line 5187: PJI_UTILS.GET_GLOBAL_RATE_SECONDARY (temp.projfunc_currency_code,

5183: rate1,
5184: l_gl1_mau mau1,
5185: DECODE ( PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG'),
5186: 'Y',
5187: PJI_UTILS.GET_GLOBAL_RATE_SECONDARY (temp.projfunc_currency_code,
5188: DECODE ( g_currency_conversion_rule
5189: , 'S'
5190: , temp.start_date
5191: , 'E'

Line 5267: PJI_UTILS.g_max_roll_days := NULL; /5155692 /

5263: AND ver.time_phased_type_code = 'N'
5264: AND ver.project_id = ppa.project_id
5265: ) temp;
5266:
5267: PJI_UTILS.g_max_roll_days := NULL; /*5155692 */
5268:
5269: /* See if any line with negative rate was derived. If so then update the
5270: corresponding line in ver3 as rate dangling*/
5271:

Line 6628: l_per_analysis_flag := PJI_UTILS.GET_SETUP_PARAMETER('PER_ANALYSIS_FLAG');

6624:
6625: BEGIN
6626:
6627: /* Added for bug 9048716 starts */
6628: l_per_analysis_flag := PJI_UTILS.GET_SETUP_PARAMETER('PER_ANALYSIS_FLAG');
6629:
6630: if l_per_analysis_flag = 'N' then
6631:
6632: DELETE FROM PJI_FP_AGGR_PJP1_T

Line 7291: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

7287: ,
7288: (
7289: SELECT 4 INVERT_ID FROM dual UNION ALL
7290: SELECT 8 INVERT_ID FROM dual UNION ALL
7291: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
7292: ) invert
7293: ) collapse_bl
7294: ---- End of second inline view 'collapse_bl' ..........
7295: GROUP BY