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_PROCESS_UTIL

Line 55: g_cost_budget_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'COST_BUDGET_TYPE_CODE');

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');
58: g_revenue_forecast_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'REVENUE_FORECAST_TYPE_CODE');
59: g_cost_budget_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'COST_BUDGET_CURR_RULE');

Line 56: g_cost_forecast_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'COST_FORECAST_TYPE_CODE');

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');
58: g_revenue_forecast_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'REVENUE_FORECAST_TYPE_CODE');
59: g_cost_budget_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'COST_BUDGET_CURR_RULE');
60: g_cost_forecast_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'COST_FORECAST_CURR_RULE');

Line 57: g_revenue_budget_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'REVENUE_BUDGET_TYPE_CODE');

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');
58: g_revenue_forecast_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'REVENUE_FORECAST_TYPE_CODE');
59: g_cost_budget_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'COST_BUDGET_CURR_RULE');
60: g_cost_forecast_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'COST_FORECAST_CURR_RULE');
61: g_revenue_budget_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'REVENUE_BUDGET_CURR_RULE');

Line 58: g_revenue_forecast_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'REVENUE_FORECAST_TYPE_CODE');

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');
58: g_revenue_forecast_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'REVENUE_FORECAST_TYPE_CODE');
59: g_cost_budget_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'COST_BUDGET_CURR_RULE');
60: g_cost_forecast_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'COST_FORECAST_CURR_RULE');
61: g_revenue_budget_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'REVENUE_BUDGET_CURR_RULE');
62: g_revenue_forecast_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'REVENUE_FORECAST_CURR_RULE');

Line 59: g_cost_budget_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'COST_BUDGET_CURR_RULE');

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');
58: g_revenue_forecast_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'REVENUE_FORECAST_TYPE_CODE');
59: g_cost_budget_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'COST_BUDGET_CURR_RULE');
60: g_cost_forecast_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'COST_FORECAST_CURR_RULE');
61: g_revenue_budget_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'REVENUE_BUDGET_CURR_RULE');
62: g_revenue_forecast_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'REVENUE_FORECAST_CURR_RULE');
63: g_pa_period_flag := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'PA_PERIOD_FLAG');

Line 60: g_cost_forecast_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'COST_FORECAST_CURR_RULE');

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');
58: g_revenue_forecast_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'REVENUE_FORECAST_TYPE_CODE');
59: g_cost_budget_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'COST_BUDGET_CURR_RULE');
60: g_cost_forecast_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'COST_FORECAST_CURR_RULE');
61: g_revenue_budget_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'REVENUE_BUDGET_CURR_RULE');
62: g_revenue_forecast_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'REVENUE_FORECAST_CURR_RULE');
63: g_pa_period_flag := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'PA_PERIOD_FLAG');
64: g_gl_period_flag := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'GL_PERIOD_FLAG');

Line 61: g_revenue_budget_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'REVENUE_BUDGET_CURR_RULE');

57: g_revenue_budget_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'REVENUE_BUDGET_TYPE_CODE');
58: g_revenue_forecast_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'REVENUE_FORECAST_TYPE_CODE');
59: g_cost_budget_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'COST_BUDGET_CURR_RULE');
60: g_cost_forecast_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'COST_FORECAST_CURR_RULE');
61: g_revenue_budget_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'REVENUE_BUDGET_CURR_RULE');
62: g_revenue_forecast_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'REVENUE_FORECAST_CURR_RULE');
63: g_pa_period_flag := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'PA_PERIOD_FLAG');
64: g_gl_period_flag := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'GL_PERIOD_FLAG');
65:

Line 62: g_revenue_forecast_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'REVENUE_FORECAST_CURR_RULE');

58: g_revenue_forecast_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'REVENUE_FORECAST_TYPE_CODE');
59: g_cost_budget_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'COST_BUDGET_CURR_RULE');
60: g_cost_forecast_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'COST_FORECAST_CURR_RULE');
61: g_revenue_budget_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'REVENUE_BUDGET_CURR_RULE');
62: g_revenue_forecast_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'REVENUE_FORECAST_CURR_RULE');
63: g_pa_period_flag := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'PA_PERIOD_FLAG');
64: g_gl_period_flag := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'GL_PERIOD_FLAG');
65:
66: g_cost_fp_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process, 'COST_FP_TYPE_ID');

Line 63: g_pa_period_flag := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'PA_PERIOD_FLAG');

59: g_cost_budget_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'COST_BUDGET_CURR_RULE');
60: g_cost_forecast_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'COST_FORECAST_CURR_RULE');
61: g_revenue_budget_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'REVENUE_BUDGET_CURR_RULE');
62: g_revenue_forecast_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'REVENUE_FORECAST_CURR_RULE');
63: g_pa_period_flag := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'PA_PERIOD_FLAG');
64: g_gl_period_flag := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'GL_PERIOD_FLAG');
65:
66: g_cost_fp_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process, 'COST_FP_TYPE_ID');
67: g_rev_fp_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process, 'REVENUE_FP_TYPE_ID');

Line 64: g_gl_period_flag := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'GL_PERIOD_FLAG');

60: g_cost_forecast_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'COST_FORECAST_CURR_RULE');
61: g_revenue_budget_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'REVENUE_BUDGET_CURR_RULE');
62: g_revenue_forecast_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'REVENUE_FORECAST_CURR_RULE');
63: g_pa_period_flag := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'PA_PERIOD_FLAG');
64: g_gl_period_flag := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'GL_PERIOD_FLAG');
65:
66: g_cost_fp_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process, 'COST_FP_TYPE_ID');
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');

Line 66: g_cost_fp_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process, 'COST_FP_TYPE_ID');

62: g_revenue_forecast_curr_rule := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'REVENUE_FORECAST_CURR_RULE');
63: g_pa_period_flag := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'PA_PERIOD_FLAG');
64: g_gl_period_flag := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'GL_PERIOD_FLAG');
65:
66: g_cost_fp_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process, 'COST_FP_TYPE_ID');
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:

Line 67: g_rev_fp_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process, 'REVENUE_FP_TYPE_ID');

63: g_pa_period_flag := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'PA_PERIOD_FLAG');
64: g_gl_period_flag := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'GL_PERIOD_FLAG');
65:
66: g_cost_fp_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process, 'COST_FP_TYPE_ID');
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);

Line 68: g_cost_forecast_fp_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process, 'COST_FORECAST_FP_TYPE_ID');

64: g_gl_period_flag := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'GL_PERIOD_FLAG');
65:
66: g_cost_fp_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process, 'COST_FP_TYPE_ID');
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:

Line 69: g_rev_forecast_fp_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process, 'REVENUE_FORECAST_FP_TYPE_ID');

65:
66: g_cost_fp_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process, 'COST_FP_TYPE_ID');
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;

Line 92: pji_process_util.set_process_parameter(

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',
95: pji_utils.get_setup_parameter('COST_BUDGET_TYPE_CODE')
96: );

Line 98: pji_process_util.set_process_parameter(

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,
100: 'COST_FORECAST_TYPE_CODE',
101: pji_utils.get_setup_parameter('COST_FORECAST_TYPE_CODE')
102: );

Line 104: pji_process_util.set_process_parameter(

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,
106: 'REVENUE_BUDGET_TYPE_CODE',
107: pji_utils.get_setup_parameter('REVENUE_BUDGET_TYPE_CODE')
108: );

Line 110: pji_process_util.set_process_parameter(

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,
112: 'REVENUE_FORECAST_TYPE_CODE',
113: pji_utils.get_setup_parameter('REVENUE_FORECAST_TYPE_CODE')
114: );

Line 116: pji_process_util.set_process_parameter(

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,
118: 'COST_BUDGET_CURR_RULE',
119: pji_utils.get_setup_parameter('COST_BUDGET_CONV_RULE')
120: );

Line 122: pji_process_util.set_process_parameter(

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,
124: 'COST_FORECAST_CURR_RULE',
125: pji_utils.get_setup_parameter('COST_FORECAST_CONV_RULE')
126: );

Line 128: pji_process_util.set_process_parameter(

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,
130: 'REVENUE_BUDGET_CURR_RULE',
131: pji_utils.get_setup_parameter('REVENUE_BUDGET_CONV_RULE')
132: );

Line 134: pji_process_util.set_process_parameter(

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,
136: 'REVENUE_FORECAST_CURR_RULE',
137: pji_utils.get_setup_parameter('REVENUE_FORECAST_CONV_RULE')
138: );

Line 140: pji_process_util.set_process_parameter(

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,
142: 'PA_PERIOD_FLAG',
143: pji_utils.get_setup_parameter('PA_PERIOD_FLAG')
144: );

Line 146: pji_process_util.set_process_parameter(

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,
148: 'GL_PERIOD_FLAG',
149: pji_utils.get_setup_parameter('GL_PERIOD_FLAG')
150: );

Line 152: pji_process_util.set_process_parameter(

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,
154: 'COST_FP_TYPE_ID',
155: pji_utils.get_setup_parameter('COST_FP_TYPE_ID')
156: );

Line 158: pji_process_util.set_process_parameter(

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,
160: 'REVENUE_FP_TYPE_ID',
161: pji_utils.get_setup_parameter('REVENUE_FP_TYPE_ID')
162: );

Line 164: pji_process_util.set_process_parameter(

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,
166: 'COST_FORECAST_FP_TYPE_ID',
167: pji_utils.get_setup_parameter('COST_FORECAST_FP_TYPE_ID')
168: );

Line 170: pji_process_util.set_process_parameter(

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,
172: 'REVENUE_FORECAST_FP_TYPE_ID',
173: pji_utils.get_setup_parameter('REVENUE_FORECAST_FP_TYPE_ID')
174: );

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 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 232: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

228: begin
229:
230: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
231:
232: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
233: (l_process,'PJI_FM_PLAN_EXTR.UPDATE_PLAN_ORG_INFO(p_worker_id);')) then
234: return;
235: end if;
236:

Line 287: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

283: ) between cal_gl.start_date and cal_gl.end_date
284: )
285: ;
286:
287: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
288: (l_process, 'PJI_FM_PLAN_EXTR.UPDATE_PLAN_ORG_INFO(p_worker_id);');
289:
290: commit;
291:

Line 308: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

304: begin
305:
306: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
307:
308: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
309: (l_process,'PJI_FM_PLAN_EXTR.EXTRACT_PLAN_VERSIONS(p_worker_id);')) then
310: return;
311: end if;
312:

Line 464: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

460: and bv.fin_plan_type_id is null
461: and map.project_id = pln.project_id (+)
462: and pln.project_id is null;
463:
464: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
465: (l_process, 'PJI_FM_PLAN_EXTR.EXTRACT_PLAN_VERSIONS(p_worker_id);');
466:
467: commit;
468:

Line 486: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

482: begin
483:
484: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
485:
486: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
487: (l_process,'PJI_FM_PLAN_EXTR.EXTRACT_BATCH_PLAN(p_worker_id);')) then
488: return;
489: end if;
490:

Line 493: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

489: end if;
490:
491: l_degree := BIS_COMMON_PARAMETERS.GET_DEGREE_OF_PARALLELISM();
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'

Line 672: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

668: , -1
669: ) <= fii_time.period_id
670: ;
671:
672: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
673: (l_process, 'PJI_FM_PLAN_EXTR.EXTRACT_BATCH_PLAN(p_worker_id);');
674:
675: commit;
676:

Line 693: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

689: begin
690:
691: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
692:
693: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
694: (l_process,'PJI_FM_PLAN_EXTR.SPREAD_ENT_PLANS(p_worker_id);')) then
695: return;
696: end if;
697:

Line 850: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

846: , orginfo.projfunc_currency_mau
847: , orginfo.en_calendar_max_date
848: ;
849:
850: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
851: (l_process, 'PJI_FM_PLAN_EXTR.SPREAD_ENT_PLANS(p_worker_id);');
852:
853: commit;
854:

Line 873: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

869: begin
870:
871: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
872:
873: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
874: (l_process, 'PJI_FM_PLAN_EXTR.PLAN_CURR_CONV_TABLE(p_worker_id);')) then
875: return;
876: end if;
877:

Line 920: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

916: worker_id = p_worker_id and
917: time_dangling_flag is null
918: ) tmp;
919:
920: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
921: (l_process, 'PJI_FM_PLAN_EXTR.PLAN_CURR_CONV_TABLE(p_worker_id);');
922:
923: commit;
924:

Line 941: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

937: begin
938:
939: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
940:
941: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
942: (l_process,'PJI_FM_PLAN_EXTR.CONVERT_TO_GLOBAL_CURRENCY(p_worker_id);')) then
943: return;
944: end if;
945:

Line 1060: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

1056: and tmp.time_dangling_flag is null
1057: and rates.time_id > 0
1058: ;
1059:
1060: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
1061: (l_process, 'PJI_FM_PLAN_EXTR.CONVERT_TO_GLOBAL_CURRENCY(p_worker_id);');
1062:
1063: commit;
1064:

Line 1081: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

1077: begin
1078:
1079: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1080:
1081: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
1082: (l_process,'PJI_FM_PLAN_EXTR.CONVERT_TO_GLOBAL2_CURRENCY(p_worker_id);')) then
1083: return;
1084: end if;
1085:

Line 1200: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

1196: and tmp.time_dangling_flag is null
1197: and rates.time_id > 0
1198: ;
1199:
1200: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
1201: (l_process, 'PJI_FM_PLAN_EXTR.CONVERT_TO_GLOBAL2_CURRENCY(p_worker_id);');
1202:
1203: commit;
1204:

Line 1221: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

1217: begin
1218:
1219: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1220:
1221: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
1222: (l_process,'PJI_FM_PLAN_EXTR.CONVERT_TO_PA_PERIODS(p_worker_id);')) then
1223: return;
1224: end if;
1225:

Line 1372: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

1368: ;
1369:
1370: end if;
1371:
1372: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
1373: (l_process, 'PJI_FM_PLAN_EXTR.CONVERT_TO_PA_PERIODS(p_worker_id);');
1374:
1375: commit;
1376:

Line 1393: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

1389: begin
1390:
1391: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1392:
1393: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
1394: (l_process,'PJI_FM_PLAN_EXTR.CONVERT_TO_GL_PERIODS(p_worker_id);')) then
1395: return;
1396: end if;
1397:

Line 1544: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

1540: ;
1541:
1542: end if;
1543:
1544: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
1545: (l_process, 'PJI_FM_PLAN_EXTR.CONVERT_TO_GL_PERIODS(p_worker_id);');
1546:
1547: commit;
1548:

Line 1565: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

1561: begin
1562:
1563: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1564:
1565: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
1566: (l_process,'PJI_FM_PLAN_EXTR.CONVERT_TO_ENT_PERIODS(p_worker_id);')) then
1567: return;
1568: end if;
1569:

Line 1709: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

1705: and tmp.rate_dangling_flag is null
1706: and tmp.rate2_dangling_flag is null
1707: ;
1708:
1709: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
1710: (l_process, 'PJI_FM_PLAN_EXTR.CONVERT_TO_ENT_PERIODS(p_worker_id);');
1711:
1712: commit;
1713:

Line 1730: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

1726: begin
1727:
1728: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1729:
1730: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
1731: (l_process,'PJI_FM_PLAN_EXTR.CONVERT_TO_ENTW_PERIODS(p_worker_id);')) then
1732: return;
1733: end if;
1734:

Line 1874: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

1870: and tmp.rate_dangling_flag is null
1871: and tmp.rate2_dangling_flag is null
1872: ;
1873:
1874: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
1875: (l_process, 'PJI_FM_PLAN_EXTR.CONVERT_TO_ENTW_PERIODS(p_worker_id);');
1876:
1877: commit;
1878:

Line 1895: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

1891: begin
1892:
1893: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1894:
1895: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
1896: (l_process,'PJI_FM_PLAN_EXTR.DANGLING_PLAN_VERSIONS(p_worker_id);')) then
1897: return;
1898: end if;
1899:

Line 1945: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

1941: or tmp.RATE2_DANGLING_FLAG is not null)
1942: and tmp.project_org_id = orginfo.org_id
1943: ;
1944:
1945: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
1946: (l_process, 'PJI_FM_PLAN_EXTR.DANGLING_PLAN_VERSIONS(p_worker_id);');
1947:
1948: commit;
1949:

Line 1973: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

1969: begin
1970:
1971: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1972:
1973: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
1974: (l_process,'PJI_FM_PLAN_EXTR.SUMMARIZE_EXTRACT(p_worker_id);')) then
1975: return;
1976: end if;
1977:

Line 2239: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

2235: tmp1.PERIOD_NAME,
2236: tmp1.START_DATE,
2237: tmp1.END_DATE;
2238:
2239: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
2240: (l_process, 'PJI_FM_PLAN_EXTR.SUMMARIZE_EXTRACT(p_worker_id);');
2241:
2242: commit;
2243:

Line 2260: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

2256: begin
2257:
2258: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
2259:
2260: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
2261: (l_process,'PJI_FM_PLAN_EXTR.EXTRACT_UPDATED_VERSIONS(p_worker_id);')) then
2262: return;
2263: end if;
2264:

Line 2372: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

2368: , tmp.BATCH_MAP_ROWID
2369: ) tmp
2370: ;
2371:
2372: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
2373: (l_process, 'PJI_FM_PLAN_EXTR.EXTRACT_UPDATED_VERSIONS(p_worker_id);');
2374:
2375: commit;
2376:

Line 2391: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,

2387: begin
2388:
2389: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
2390:
2391: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,
2392: 'PJI_FM_PLAN_EXTR.UPDATE_BATCH_VERSIONS_PRE(p_worker_id);')) then
2393: return;
2394: end if;
2395:

Line 2412: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

2408: PJI_FM_EXTR_PLNVER2
2409: where
2410: WORKER_ID = p_worker_id;
2411:
2412: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
2413: 'PJI_FM_PLAN_EXTR.UPDATE_BATCH_VERSIONS_PRE(p_worker_id);');
2414:
2415: commit;
2416:

Line 2435: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,

2431: begin
2432:
2433: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
2434:
2435: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,
2436: 'PJI_FM_PLAN_EXTR.UPDATE_BATCH_VERSIONS(p_worker_id);')) then
2437: return;
2438: end if;
2439:

Line 2440: l_parallel_processes := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

2436: 'PJI_FM_PLAN_EXTR.UPDATE_BATCH_VERSIONS(p_worker_id);')) then
2437: return;
2438: end if;
2439:
2440: l_parallel_processes := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2441: (PJI_RM_SUM_MAIN.g_process, 'PARALLEL_PROCESSES');
2442:
2443: select count(*)
2444: into l_leftover_batches

Line 2560: PJI_PROCESS_UTIL.SLEEP(1); -- so the CPU is not bombarded

2556: l_helper_batch_id := -1;
2557:
2558: else
2559:
2560: PJI_PROCESS_UTIL.SLEEP(1); -- so the CPU is not bombarded
2561:
2562: end if;
2563:
2564: end if;

Line 2580: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

2576: end loop;
2577:
2578: if (l_helper_batch_id <> -2) then
2579:
2580: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
2581: 'PJI_FM_PLAN_EXTR.UPDATE_BATCH_VERSIONS(p_worker_id);');
2582:
2583: end if;
2584:

Line 2601: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,

2597: begin
2598:
2599: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
2600:
2601: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,
2602: 'PJI_FM_PLAN_EXTR.UPDATE_BATCH_VERSIONS_POST(p_worker_id);')) then
2603: return;
2604: end if;
2605:

Line 2606: PJI_PROCESS_UTIL.TRUNC_INT_TABLE('PJI',

2602: 'PJI_FM_PLAN_EXTR.UPDATE_BATCH_VERSIONS_POST(p_worker_id);')) then
2603: return;
2604: end if;
2605:
2606: PJI_PROCESS_UTIL.TRUNC_INT_TABLE('PJI',
2607: 'PJI_HELPER_BATCH_MAP',
2608: 'NORMAL',
2609: null);
2610:

Line 2611: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

2607: 'PJI_HELPER_BATCH_MAP',
2608: 'NORMAL',
2609: null);
2610:
2611: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
2612: 'PJI_FM_PLAN_EXTR.UPDATE_BATCH_VERSIONS_POST(p_worker_id);');
2613:
2614: commit;
2615:

Line 2630: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

2626: begin
2627:
2628: l_process := PJI_RM_SUM_MAIN.g_process || p_worker_id;
2629:
2630: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
2631: (
2632: l_process,
2633: 'PJI_FM_PLAN_EXTR.UPDATE_BATCH_STATUSES(p_worker_id);'
2634: )) then

Line 2667: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

2663: PROJECT_ID
2664: from PJI_PJI_PROJ_BATCH_MAP
2665: where WORKER_ID = p_worker_id);
2666:
2667: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
2668: (
2669: l_process,
2670: 'PJI_FM_PLAN_EXTR.UPDATE_BATCH_STATUSES(p_worker_id);'
2671: );