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_RM_SUM_MAIN

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 83: -- This procedure is called from PJI_RM_SUM_MAIN.INIT_PROCESS.

79: procedure init_global_parameters is
80:
81: begin
82:
83: -- This procedure is called from PJI_RM_SUM_MAIN.INIT_PROCESS.
84: -- Since users may make changes in setup form at any given
85: -- point in time we need to make sure that we do not
86: -- pickup these changes in the middle of summarization run.
87: -- We get plan settings once from PJI setup table and

Line 93: PJI_RM_SUM_MAIN.g_process,

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: );
97:

Line 99: PJI_RM_SUM_MAIN.g_process,

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: );
103:

Line 105: PJI_RM_SUM_MAIN.g_process,

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: );
109:

Line 111: PJI_RM_SUM_MAIN.g_process,

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: );
115:

Line 117: PJI_RM_SUM_MAIN.g_process,

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: );
121:

Line 123: PJI_RM_SUM_MAIN.g_process,

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: );
127:

Line 129: PJI_RM_SUM_MAIN.g_process,

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: );
133:

Line 135: PJI_RM_SUM_MAIN.g_process,

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: );
139:

Line 141: PJI_RM_SUM_MAIN.g_process,

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: );
145:

Line 147: PJI_RM_SUM_MAIN.g_process,

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: );
151:

Line 153: PJI_RM_SUM_MAIN.g_process,

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: );
157:

Line 159: PJI_RM_SUM_MAIN.g_process,

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: );
163:

Line 165: PJI_RM_SUM_MAIN.g_process,

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: );
169:

Line 171: PJI_RM_SUM_MAIN.g_process,

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: );
175:

Line 230: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

226: l_process varchar2(30);
227:
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;

Line 306: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

302: l_process varchar2(30);
303:
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;

Line 484: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

480: l_degree number;
481:
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;

Line 566: , PJI_RM_SUM_MAIN.g_null)

562: , -1, orginfo.gl_first_period_name
563: , fii_time.period_name)
564: , decode(sign(bl.end_date - g_ent_start_date)
565: , -1, g_ent_start_period_name
566: , PJI_RM_SUM_MAIN.g_null)
567: ) period_name
568: , decode(vers.time_phased_type_code
569: , 'P', decode(sign(fii_time.end_date - to_date(orginfo.pa_first_end_date,'J'))
570: , -1, to_date(orginfo.pa_first_start_date,'J')

Line 633: , PJI_RM_SUM_MAIN.g_null period_name

629: , pa_resource_assignments ra
630: , pa_budget_lines bl
631: , ( select -1 calendar_id
632: , -1 period_id
633: , PJI_RM_SUM_MAIN.g_null period_name
634: , null start_date
635: , null end_date
636: from dual
637: union all

Line 663: , PJI_RM_SUM_MAIN.g_null

659: , bl.period_name)
660: , 'G', decode(sign(bl.end_date - to_date(orginfo.gl_first_end_date,'J'))
661: , -1, orginfo.gl_first_period_name
662: , bl.period_name)
663: , PJI_RM_SUM_MAIN.g_null
664: ) = fii_time.period_name
665: and decode(vers.time_phased_type_code
666: , 'P', orginfo.pa_first_period_id
667: , 'G', orginfo.gl_first_period_id

Line 691: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

687: l_process varchar2(30);
688:
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;

Line 871: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

867: l_mau2 number;
868:
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;

Line 939: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

935: l_process varchar2(30);
936:
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;

Line 1079: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

1075: l_process varchar2(30);
1076:
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;

Line 1219: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

1215: l_process varchar2(30);
1216:
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;

Line 1391: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

1387: l_process varchar2(30);
1388:
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;

Line 1563: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

1559: l_process varchar2(30);
1560:
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;

Line 1728: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

1724: l_process varchar2(30);
1725:
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;

Line 1778: , PJI_RM_SUM_MAIN.g_null period_name

1774: , tmp.version_id
1775: , tmp.plan_type_code
1776: , tmp.currency_type currency_type
1777: , entw.week_id period_id
1778: , PJI_RM_SUM_MAIN.g_null period_name
1779: , entw.start_date start_date
1780: , entw.end_date end_date
1781: , round((nvl(case when (tmp.start_date <= entw.start_date) and
1782: (tmp.end_date >= entw.end_date)

Line 1893: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

1889: l_process varchar2(30);
1890:
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;

Line 1971: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

1967:
1968:
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;

Line 2258: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

2254: l_process varchar2(30);
2255:
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;

Line 2287: , ceil(ROWNUM / PJI_RM_SUM_MAIN.g_commit_threshold)

2283: , tmp.REVENUE_BUDGET_C_VERSION
2284: , tmp.REVENUE_BUDGET_CO_VERSION
2285: , tmp.COST_FORECAST_C_VERSION
2286: , tmp.REVENUE_FORECAST_C_VERSION
2287: , ceil(ROWNUM / PJI_RM_SUM_MAIN.g_commit_threshold)
2288: from
2289: (
2290: SELECT tmp.BATCH_MAP_ROWID BATCH_MAP_ROWID
2291: , tmp.PROJECT_ID PROJECT_ID

Line 2389: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

2385: l_process varchar2(30);
2386:
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;

Line 2433: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

2429: l_parallel_processes number;
2430:
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;

Line 2441: (PJI_RM_SUM_MAIN.g_process, 'PARALLEL_PROCESSES');

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
2445: from PJI_HELPER_BATCH_MAP

Line 2547: where PROCESS_NAME like PJI_RM_SUM_MAIN.g_process|| to_char(x) and

2543: for x in 2 .. l_parallel_processes loop
2544:
2545: update PJI_SYSTEM_PRC_STATUS
2546: set STEP_STATUS = 'C'
2547: where PROCESS_NAME like PJI_RM_SUM_MAIN.g_process|| to_char(x) and
2548: STEP_NAME =
2549: 'PJI_FM_PLAN_EXTR.UPDATE_BATCH_VERSIONS(p_worker_id);' and
2550: START_DATE is null;
2551:

Line 2599: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

2595: l_process varchar2(30);
2596:
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;

Line 2628: l_process := PJI_RM_SUM_MAIN.g_process || p_worker_id;

2624: l_process varchar2(30);
2625:
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,

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

Line 2689: select week_id,PJI_RM_SUM_MAIN.g_null,start_date,end_date

2685: from fii_time_ent_period
2686: where g_global_start_date between start_date AND end_date
2687: ;
2688:
2689: select week_id,PJI_RM_SUM_MAIN.g_null,start_date,end_date
2690: into g_entw_start_period_id,g_entw_start_period_name,g_entw_start_date,g_entw_end_date
2691: from fii_time_week
2692: where g_global_start_date between start_date AND end_date
2693: ;