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_EXTR dependencies on PJI_UTILS

Line 53: pji_utils.write2log('Entering PJI_FM_PLAN_EXTR.GET_SYSTEM_SETTINGS',TRUE,3);

49: begin
50:
51: -- Cache setup settings in global variables.
52:
53: pji_utils.write2log('Entering PJI_FM_PLAN_EXTR.GET_SYSTEM_SETTINGS',TRUE,3);
54:
55: g_cost_budget_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'COST_BUDGET_TYPE_CODE');
56: g_cost_forecast_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'COST_FORECAST_TYPE_CODE');
57: g_revenue_budget_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'REVENUE_BUDGET_TYPE_CODE');

Line 71: pji_utils.write2log('Completed PJI_FM_PLAN_EXTR.GET_SYSTEM_SETTINGS',TRUE,3);

67: g_rev_fp_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process, 'REVENUE_FP_TYPE_ID');
68: g_cost_forecast_fp_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process, 'COST_FORECAST_FP_TYPE_ID');
69: g_rev_forecast_fp_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process, 'REVENUE_FORECAST_FP_TYPE_ID');
70:
71: pji_utils.write2log('Completed PJI_FM_PLAN_EXTR.GET_SYSTEM_SETTINGS',TRUE,3);
72:
73: end get_system_settings;
74:
75: -- -----------------------------------------------------

Line 90: pji_utils.write2log('Entering PJI_FM_PLAN_EXTR.INIT_GLOBAL_PARAMETERS',TRUE,3);

86: -- pickup these changes in the middle of summarization run.
87: -- We get plan settings once from PJI setup table and
88: -- store them as process variables.
89:
90: pji_utils.write2log('Entering PJI_FM_PLAN_EXTR.INIT_GLOBAL_PARAMETERS',TRUE,3);
91:
92: pji_process_util.set_process_parameter(
93: PJI_RM_SUM_MAIN.g_process,
94: 'COST_BUDGET_TYPE_CODE',

Line 95: pji_utils.get_setup_parameter('COST_BUDGET_TYPE_CODE')

91:
92: pji_process_util.set_process_parameter(
93: PJI_RM_SUM_MAIN.g_process,
94: 'COST_BUDGET_TYPE_CODE',
95: pji_utils.get_setup_parameter('COST_BUDGET_TYPE_CODE')
96: );
97:
98: pji_process_util.set_process_parameter(
99: PJI_RM_SUM_MAIN.g_process,

Line 101: pji_utils.get_setup_parameter('COST_FORECAST_TYPE_CODE')

97:
98: pji_process_util.set_process_parameter(
99: PJI_RM_SUM_MAIN.g_process,
100: 'COST_FORECAST_TYPE_CODE',
101: pji_utils.get_setup_parameter('COST_FORECAST_TYPE_CODE')
102: );
103:
104: pji_process_util.set_process_parameter(
105: PJI_RM_SUM_MAIN.g_process,

Line 107: pji_utils.get_setup_parameter('REVENUE_BUDGET_TYPE_CODE')

103:
104: pji_process_util.set_process_parameter(
105: PJI_RM_SUM_MAIN.g_process,
106: 'REVENUE_BUDGET_TYPE_CODE',
107: pji_utils.get_setup_parameter('REVENUE_BUDGET_TYPE_CODE')
108: );
109:
110: pji_process_util.set_process_parameter(
111: PJI_RM_SUM_MAIN.g_process,

Line 113: pji_utils.get_setup_parameter('REVENUE_FORECAST_TYPE_CODE')

109:
110: pji_process_util.set_process_parameter(
111: PJI_RM_SUM_MAIN.g_process,
112: 'REVENUE_FORECAST_TYPE_CODE',
113: pji_utils.get_setup_parameter('REVENUE_FORECAST_TYPE_CODE')
114: );
115:
116: pji_process_util.set_process_parameter(
117: PJI_RM_SUM_MAIN.g_process,

Line 119: pji_utils.get_setup_parameter('COST_BUDGET_CONV_RULE')

115:
116: pji_process_util.set_process_parameter(
117: PJI_RM_SUM_MAIN.g_process,
118: 'COST_BUDGET_CURR_RULE',
119: pji_utils.get_setup_parameter('COST_BUDGET_CONV_RULE')
120: );
121:
122: pji_process_util.set_process_parameter(
123: PJI_RM_SUM_MAIN.g_process,

Line 125: pji_utils.get_setup_parameter('COST_FORECAST_CONV_RULE')

121:
122: pji_process_util.set_process_parameter(
123: PJI_RM_SUM_MAIN.g_process,
124: 'COST_FORECAST_CURR_RULE',
125: pji_utils.get_setup_parameter('COST_FORECAST_CONV_RULE')
126: );
127:
128: pji_process_util.set_process_parameter(
129: PJI_RM_SUM_MAIN.g_process,

Line 131: pji_utils.get_setup_parameter('REVENUE_BUDGET_CONV_RULE')

127:
128: pji_process_util.set_process_parameter(
129: PJI_RM_SUM_MAIN.g_process,
130: 'REVENUE_BUDGET_CURR_RULE',
131: pji_utils.get_setup_parameter('REVENUE_BUDGET_CONV_RULE')
132: );
133:
134: pji_process_util.set_process_parameter(
135: PJI_RM_SUM_MAIN.g_process,

Line 137: pji_utils.get_setup_parameter('REVENUE_FORECAST_CONV_RULE')

133:
134: pji_process_util.set_process_parameter(
135: PJI_RM_SUM_MAIN.g_process,
136: 'REVENUE_FORECAST_CURR_RULE',
137: pji_utils.get_setup_parameter('REVENUE_FORECAST_CONV_RULE')
138: );
139:
140: pji_process_util.set_process_parameter(
141: PJI_RM_SUM_MAIN.g_process,

Line 143: pji_utils.get_setup_parameter('PA_PERIOD_FLAG')

139:
140: pji_process_util.set_process_parameter(
141: PJI_RM_SUM_MAIN.g_process,
142: 'PA_PERIOD_FLAG',
143: pji_utils.get_setup_parameter('PA_PERIOD_FLAG')
144: );
145:
146: pji_process_util.set_process_parameter(
147: PJI_RM_SUM_MAIN.g_process,

Line 149: pji_utils.get_setup_parameter('GL_PERIOD_FLAG')

145:
146: pji_process_util.set_process_parameter(
147: PJI_RM_SUM_MAIN.g_process,
148: 'GL_PERIOD_FLAG',
149: pji_utils.get_setup_parameter('GL_PERIOD_FLAG')
150: );
151:
152: pji_process_util.set_process_parameter(
153: PJI_RM_SUM_MAIN.g_process,

Line 155: pji_utils.get_setup_parameter('COST_FP_TYPE_ID')

151:
152: pji_process_util.set_process_parameter(
153: PJI_RM_SUM_MAIN.g_process,
154: 'COST_FP_TYPE_ID',
155: pji_utils.get_setup_parameter('COST_FP_TYPE_ID')
156: );
157:
158: pji_process_util.set_process_parameter(
159: PJI_RM_SUM_MAIN.g_process,

Line 161: pji_utils.get_setup_parameter('REVENUE_FP_TYPE_ID')

157:
158: pji_process_util.set_process_parameter(
159: PJI_RM_SUM_MAIN.g_process,
160: 'REVENUE_FP_TYPE_ID',
161: pji_utils.get_setup_parameter('REVENUE_FP_TYPE_ID')
162: );
163:
164: pji_process_util.set_process_parameter(
165: PJI_RM_SUM_MAIN.g_process,

Line 167: pji_utils.get_setup_parameter('COST_FORECAST_FP_TYPE_ID')

163:
164: pji_process_util.set_process_parameter(
165: PJI_RM_SUM_MAIN.g_process,
166: 'COST_FORECAST_FP_TYPE_ID',
167: pji_utils.get_setup_parameter('COST_FORECAST_FP_TYPE_ID')
168: );
169:
170: pji_process_util.set_process_parameter(
171: PJI_RM_SUM_MAIN.g_process,

Line 173: pji_utils.get_setup_parameter('REVENUE_FORECAST_FP_TYPE_ID')

169:
170: pji_process_util.set_process_parameter(
171: PJI_RM_SUM_MAIN.g_process,
172: 'REVENUE_FORECAST_FP_TYPE_ID',
173: pji_utils.get_setup_parameter('REVENUE_FORECAST_FP_TYPE_ID')
174: );
175:
176:
177: pji_utils.write2log('Completed PJI_FM_PLAN_EXTR.INIT_GLOBAL_PARAMETERS',TRUE,3);

Line 177: pji_utils.write2log('Completed PJI_FM_PLAN_EXTR.INIT_GLOBAL_PARAMETERS',TRUE,3);

173: pji_utils.get_setup_parameter('REVENUE_FORECAST_FP_TYPE_ID')
174: );
175:
176:
177: pji_utils.write2log('Completed PJI_FM_PLAN_EXTR.INIT_GLOBAL_PARAMETERS',TRUE,3);
178:
179: end init_global_parameters;
180:
181:

Line 190: pji_utils.write2log('Entering PJI_FM_PLAN_EXTR.CLEANUP',TRUE, 3);

186: procedure cleanup(p_worker_id number) is
187:
188: begin
189:
190: pji_utils.write2log('Entering PJI_FM_PLAN_EXTR.CLEANUP',TRUE, 3);
191:
192:
193: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_EXTR_PLNVER1', 'NORMAL',null);
194: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_EXTR_PLAN', 'NORMAL',null);

Line 193: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_EXTR_PLNVER1', 'NORMAL',null);

189:
190: pji_utils.write2log('Entering PJI_FM_PLAN_EXTR.CLEANUP',TRUE, 3);
191:
192:
193: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_EXTR_PLNVER1', 'NORMAL',null);
194: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_EXTR_PLAN', 'NORMAL',null);
195: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_EXTR_PLNVER2', 'NORMAL',null);
196: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_AGGR_PLN', 'NORMAL',null);
197:

Line 194: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_EXTR_PLAN', 'NORMAL',null);

190: pji_utils.write2log('Entering PJI_FM_PLAN_EXTR.CLEANUP',TRUE, 3);
191:
192:
193: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_EXTR_PLNVER1', 'NORMAL',null);
194: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_EXTR_PLAN', 'NORMAL',null);
195: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_EXTR_PLNVER2', 'NORMAL',null);
196: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_AGGR_PLN', 'NORMAL',null);
197:
198:

Line 195: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_EXTR_PLNVER2', 'NORMAL',null);

191:
192:
193: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_EXTR_PLNVER1', 'NORMAL',null);
194: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_EXTR_PLAN', 'NORMAL',null);
195: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_EXTR_PLNVER2', 'NORMAL',null);
196: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_AGGR_PLN', 'NORMAL',null);
197:
198:
199: pji_utils.write2log('Completed PJI_FM_PLAN_EXTR.CLEANUP',TRUE, 3);

Line 196: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_AGGR_PLN', 'NORMAL',null);

192:
193: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_EXTR_PLNVER1', 'NORMAL',null);
194: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_EXTR_PLAN', 'NORMAL',null);
195: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_EXTR_PLNVER2', 'NORMAL',null);
196: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_AGGR_PLN', 'NORMAL',null);
197:
198:
199: pji_utils.write2log('Completed PJI_FM_PLAN_EXTR.CLEANUP',TRUE, 3);
200:

Line 199: pji_utils.write2log('Completed PJI_FM_PLAN_EXTR.CLEANUP',TRUE, 3);

195: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_EXTR_PLNVER2', 'NORMAL',null);
196: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_AGGR_PLN', 'NORMAL',null);
197:
198:
199: pji_utils.write2log('Completed PJI_FM_PLAN_EXTR.CLEANUP',TRUE, 3);
200:
201: end cleanup;
202:
203: -- -----------------------------------------------------

Line 211: pji_utils.write2log('Entering PJI_FM_PLAN_EXTR.CLEANUP_LOG',TRUE, 3);

207: procedure cleanup_log is
208:
209: begin
210:
211: pji_utils.write2log('Entering PJI_FM_PLAN_EXTR.CLEANUP_LOG',TRUE, 3);
212:
213: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_EXTR_PLN_LOG', 'NORMAL',null);
214:
215: pji_utils.write2log('Completed PJI_FM_PLAN_EXTR.CLEANUP_LOG',TRUE, 3);

Line 213: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_EXTR_PLN_LOG', 'NORMAL',null);

209: begin
210:
211: pji_utils.write2log('Entering PJI_FM_PLAN_EXTR.CLEANUP_LOG',TRUE, 3);
212:
213: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_EXTR_PLN_LOG', 'NORMAL',null);
214:
215: pji_utils.write2log('Completed PJI_FM_PLAN_EXTR.CLEANUP_LOG',TRUE, 3);
216:
217: end cleanup_log;

Line 215: pji_utils.write2log('Completed PJI_FM_PLAN_EXTR.CLEANUP_LOG',TRUE, 3);

211: pji_utils.write2log('Entering PJI_FM_PLAN_EXTR.CLEANUP_LOG',TRUE, 3);
212:
213: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_EXTR_PLN_LOG', 'NORMAL',null);
214:
215: pji_utils.write2log('Completed PJI_FM_PLAN_EXTR.CLEANUP_LOG',TRUE, 3);
216:
217: end cleanup_log;
218:
219:

Line 496: ownname => pji_utils.get_pji_schema_name

492:
493: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
494: 'CURRENT_BATCH') = 1) then
495: FND_STATS.GATHER_TABLE_STATS(
496: ownname => pji_utils.get_pji_schema_name
497: , tabname => 'PJI_FM_EXTR_PLNVER1'
498: , percent => 10
499: , degree => l_degree
500: );

Line 878: l_mau := PJI_UTILS.GET_MAU_PRIMARY;

874: (l_process, 'PJI_FM_PLAN_EXTR.PLAN_CURR_CONV_TABLE(p_worker_id);')) then
875: return;
876: end if;
877:
878: l_mau := PJI_UTILS.GET_MAU_PRIMARY;
879: l_mau2 := PJI_UTILS.GET_MAU_SECONDARY;
880:
881: insert /*+ append */ into PJI_FM_AGGR_DLY_RATES -- for curr conv
882: (

Line 879: l_mau2 := PJI_UTILS.GET_MAU_SECONDARY;

875: return;
876: end if;
877:
878: l_mau := PJI_UTILS.GET_MAU_PRIMARY;
879: l_mau2 := PJI_UTILS.GET_MAU_SECONDARY;
880:
881: insert /*+ append */ into PJI_FM_AGGR_DLY_RATES -- for curr conv
882: (
883: WORKER_ID,

Line 895: PJI_UTILS.GET_GLOBAL_RATE_PRIMARY(tmp.pf_currency_code,

891: select
892: -1 worker_id,
893: tmp.pf_currency_code pf_currency_code,
894: to_char(tmp.curr_date,'J') time_id,
895: PJI_UTILS.GET_GLOBAL_RATE_PRIMARY(tmp.pf_currency_code,
896: tmp.curr_date) rate,
897: l_mau mau,
898: PJI_UTILS.GET_GLOBAL_RATE_SECONDARY(tmp.pf_currency_code,
899: tmp.curr_date) rate,

Line 898: PJI_UTILS.GET_GLOBAL_RATE_SECONDARY(tmp.pf_currency_code,

894: to_char(tmp.curr_date,'J') time_id,
895: PJI_UTILS.GET_GLOBAL_RATE_PRIMARY(tmp.pf_currency_code,
896: tmp.curr_date) rate,
897: l_mau mau,
898: PJI_UTILS.GET_GLOBAL_RATE_SECONDARY(tmp.pf_currency_code,
899: tmp.curr_date) rate,
900: l_mau2 mau2
901: from
902: (

Line 1987: l_g1_currency_code := PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY;

1983: l_g2_currency_flag
1984: from
1985: PJI_SYSTEM_SETTINGS;
1986:
1987: l_g1_currency_code := PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY;
1988: l_g2_currency_code := PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY;
1989:
1990: insert /*+ append parallel(pln_i) */ into PJI_FM_AGGR_PLN pln_i
1991: (

Line 1988: l_g2_currency_code := PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY;

1984: from
1985: PJI_SYSTEM_SETTINGS;
1986:
1987: l_g1_currency_code := PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY;
1988: l_g2_currency_code := PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY;
1989:
1990: insert /*+ append parallel(pln_i) */ into PJI_FM_AGGR_PLN pln_i
1991: (
1992: WORKER_ID,

Line 2679: g_global_start_date := to_date(PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE'),PJI_RM_SUM_MAIN.g_date_mask);

2675: end UPDATE_BATCH_STATUSES;
2676:
2677:
2678: begin -- this protion is executed whenever the package is initialized
2679: g_global_start_date := to_date(PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE'),PJI_RM_SUM_MAIN.g_date_mask);
2680:
2681:
2682: begin
2683: select ent_period_id,name,start_date,end_date