DBA Data[Home] [Help]

APPS.PA_BURDEN_COSTING dependencies on PA_PLSQL_DATATYPES

Line 173: l_eiid_tbl PA_PLSQL_DATATYPES.NUMTabTyp;

169: l_bom_labor_resource_id PA_COMMITMENT_TXNS.bom_equipment_resource_id%type default null;
170: l_bom_equipment_resource_id PA_COMMITMENT_TXNS.bom_labor_resource_id%type default null;
171:
172: /* Local variables added for 5980459 */
173: l_eiid_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
174: l_task_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
175: l_org_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
176: l_exp_item_date_tbl PA_PLSQL_DATATYPES.dateTabTyp;
177: l_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

Line 174: l_task_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;

170: l_bom_equipment_resource_id PA_COMMITMENT_TXNS.bom_labor_resource_id%type default null;
171:
172: /* Local variables added for 5980459 */
173: l_eiid_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
174: l_task_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
175: l_org_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
176: l_exp_item_date_tbl PA_PLSQL_DATATYPES.dateTabTyp;
177: l_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
178: l_status_tbl PA_PLSQL_DATATYPES.Char30tabTyp ;

Line 175: l_org_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;

171:
172: /* Local variables added for 5980459 */
173: l_eiid_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
174: l_task_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
175: l_org_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
176: l_exp_item_date_tbl PA_PLSQL_DATATYPES.dateTabTyp;
177: l_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
178: l_status_tbl PA_PLSQL_DATATYPES.Char30tabTyp ;
179: l_compiled_multiplier_tbl PA_PLSQL_DATATYPES.NUMtabTyp;

Line 176: l_exp_item_date_tbl PA_PLSQL_DATATYPES.dateTabTyp;

172: /* Local variables added for 5980459 */
173: l_eiid_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
174: l_task_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
175: l_org_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
176: l_exp_item_date_tbl PA_PLSQL_DATATYPES.dateTabTyp;
177: l_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
178: l_status_tbl PA_PLSQL_DATATYPES.Char30tabTyp ;
179: l_compiled_multiplier_tbl PA_PLSQL_DATATYPES.NUMtabTyp;
180: l_compiled_set_id_tbl PA_PLSQL_DATATYPES.NUMtabTyp;

Line 177: l_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

173: l_eiid_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
174: l_task_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
175: l_org_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
176: l_exp_item_date_tbl PA_PLSQL_DATATYPES.dateTabTyp;
177: l_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
178: l_status_tbl PA_PLSQL_DATATYPES.Char30tabTyp ;
179: l_compiled_multiplier_tbl PA_PLSQL_DATATYPES.NUMtabTyp;
180: l_compiled_set_id_tbl PA_PLSQL_DATATYPES.NUMtabTyp;
181: l_stage_tbl PA_PLSQL_DATATYPES.Char30tabTyp;

Line 178: l_status_tbl PA_PLSQL_DATATYPES.Char30tabTyp ;

174: l_task_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
175: l_org_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
176: l_exp_item_date_tbl PA_PLSQL_DATATYPES.dateTabTyp;
177: l_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
178: l_status_tbl PA_PLSQL_DATATYPES.Char30tabTyp ;
179: l_compiled_multiplier_tbl PA_PLSQL_DATATYPES.NUMtabTyp;
180: l_compiled_set_id_tbl PA_PLSQL_DATATYPES.NUMtabTyp;
181: l_stage_tbl PA_PLSQL_DATATYPES.Char30tabTyp;
182: reason PA_PLSQL_DATATYPES.Char30TabTyp;

Line 179: l_compiled_multiplier_tbl PA_PLSQL_DATATYPES.NUMtabTyp;

175: l_org_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
176: l_exp_item_date_tbl PA_PLSQL_DATATYPES.dateTabTyp;
177: l_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
178: l_status_tbl PA_PLSQL_DATATYPES.Char30tabTyp ;
179: l_compiled_multiplier_tbl PA_PLSQL_DATATYPES.NUMtabTyp;
180: l_compiled_set_id_tbl PA_PLSQL_DATATYPES.NUMtabTyp;
181: l_stage_tbl PA_PLSQL_DATATYPES.Char30tabTyp;
182: reason PA_PLSQL_DATATYPES.Char30TabTyp;
183:

Line 180: l_compiled_set_id_tbl PA_PLSQL_DATATYPES.NUMtabTyp;

176: l_exp_item_date_tbl PA_PLSQL_DATATYPES.dateTabTyp;
177: l_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
178: l_status_tbl PA_PLSQL_DATATYPES.Char30tabTyp ;
179: l_compiled_multiplier_tbl PA_PLSQL_DATATYPES.NUMtabTyp;
180: l_compiled_set_id_tbl PA_PLSQL_DATATYPES.NUMtabTyp;
181: l_stage_tbl PA_PLSQL_DATATYPES.Char30tabTyp;
182: reason PA_PLSQL_DATATYPES.Char30TabTyp;
183:
184: /* SOM Bug# 5743708 */

Line 181: l_stage_tbl PA_PLSQL_DATATYPES.Char30tabTyp;

177: l_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
178: l_status_tbl PA_PLSQL_DATATYPES.Char30tabTyp ;
179: l_compiled_multiplier_tbl PA_PLSQL_DATATYPES.NUMtabTyp;
180: l_compiled_set_id_tbl PA_PLSQL_DATATYPES.NUMtabTyp;
181: l_stage_tbl PA_PLSQL_DATATYPES.Char30tabTyp;
182: reason PA_PLSQL_DATATYPES.Char30TabTyp;
183:
184: /* SOM Bug# 5743708 */
185: l_person_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

Line 182: reason PA_PLSQL_DATATYPES.Char30TabTyp;

178: l_status_tbl PA_PLSQL_DATATYPES.Char30tabTyp ;
179: l_compiled_multiplier_tbl PA_PLSQL_DATATYPES.NUMtabTyp;
180: l_compiled_set_id_tbl PA_PLSQL_DATATYPES.NUMtabTyp;
181: l_stage_tbl PA_PLSQL_DATATYPES.Char30tabTyp;
182: reason PA_PLSQL_DATATYPES.Char30TabTyp;
183:
184: /* SOM Bug# 5743708 */
185: l_person_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
186: l_incur_per_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;

Line 185: l_person_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

181: l_stage_tbl PA_PLSQL_DATATYPES.Char30tabTyp;
182: reason PA_PLSQL_DATATYPES.Char30TabTyp;
183:
184: /* SOM Bug# 5743708 */
185: l_person_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
186: l_incur_per_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
187:
188: l_cp_structure_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
189: l_cost_base_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

Line 186: l_incur_per_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;

182: reason PA_PLSQL_DATATYPES.Char30TabTyp;
183:
184: /* SOM Bug# 5743708 */
185: l_person_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
186: l_incur_per_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
187:
188: l_cp_structure_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
189: l_cost_base_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
190: l_cp_structure VARCHAR2(30);

Line 188: l_cp_structure_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

184: /* SOM Bug# 5743708 */
185: l_person_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
186: l_incur_per_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
187:
188: l_cp_structure_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
189: l_cost_base_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
190: l_cp_structure VARCHAR2(30);
191: l_cost_base VARCHAR2(30);
192: /* EOM Bug# 5743708 */

Line 189: l_cost_base_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

185: l_person_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
186: l_incur_per_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
187:
188: l_cp_structure_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
189: l_cost_base_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
190: l_cp_structure VARCHAR2(30);
191: l_cost_base VARCHAR2(30);
192: /* EOM Bug# 5743708 */
193:

Line 3201: l_eid_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*2933915*/

3197: IS
3198: l_program_id NUMBER;
3199: l_program_application_id NUMBER;
3200: l_profile_set_size NUMBER ;
3201: l_eid_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*2933915*/
3202: l_line_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*2933915*/
3203: l_prev_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*2933915*/
3204: l_run_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*2933915*/
3205:

Line 3202: l_line_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*2933915*/

3198: l_program_id NUMBER;
3199: l_program_application_id NUMBER;
3200: l_profile_set_size NUMBER ;
3201: l_eid_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*2933915*/
3202: l_line_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*2933915*/
3203: l_prev_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*2933915*/
3204: l_run_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*2933915*/
3205:
3206:

Line 3203: l_prev_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*2933915*/

3199: l_program_application_id NUMBER;
3200: l_profile_set_size NUMBER ;
3201: l_eid_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*2933915*/
3202: l_line_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*2933915*/
3203: l_prev_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*2933915*/
3204: l_run_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*2933915*/
3205:
3206:
3207:

Line 3204: l_run_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*2933915*/

3200: l_profile_set_size NUMBER ;
3201: l_eid_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*2933915*/
3202: l_line_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*2933915*/
3203: l_prev_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*2933915*/
3204: l_run_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*2933915*/
3205:
3206:
3207:
3208: BEGIN