DBA Data[Home] [Help]

APPS.PA_SCHEDULE_OBJECTS_PVT dependencies on PA_VARCHAR2_30_TBL_TYPE

Line 339: l_parent_rowid_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

335: l_update_flag_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
336:
337: l_child_update_required VARCHAR2(1);
338: l_parent_update_required VARCHAR2(1);
339: l_parent_rowid_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
340: L_CHILD_OBJECT_IDS_TAB SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
341: L_PARENT_OBJECT_IDS_TAB SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
342: l_parent_object_types_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
343: l_child_object_types_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 342: l_parent_object_types_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

338: l_parent_update_required VARCHAR2(1);
339: l_parent_rowid_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
340: L_CHILD_OBJECT_IDS_TAB SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
341: L_PARENT_OBJECT_IDS_TAB SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
342: l_parent_object_types_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
343: l_child_object_types_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
344: l_parent_start_date_tab1 SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
345: l_parent_start_date_tab2 SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
346: l_parent_start_date_tab3 SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 343: l_child_object_types_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

339: l_parent_rowid_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
340: L_CHILD_OBJECT_IDS_TAB SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
341: L_PARENT_OBJECT_IDS_TAB SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
342: l_parent_object_types_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
343: l_child_object_types_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
344: l_parent_start_date_tab1 SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
345: l_parent_start_date_tab2 SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
346: l_parent_start_date_tab3 SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
347: l_parent_start_date_tab4 SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 390: l_object_types_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

386: l_child_duration_tab6 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
387:
388:
389: l_object_ids_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
390: l_object_types_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
391: l_count_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
392: l_sum_tab1 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
393: l_sum_tab2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
394: l_sum_tab3 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 404: l_perc_comp_deriv_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

400: l_task_status_tab3 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
401: l_task_status_tab4 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
402: l_task_status_tab5 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
403: l_task_status_tab6 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
404: l_perc_comp_deriv_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
405: l_bac_value_tab1 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
406: l_bac_value_tab2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
407: l_bac_value_tab3 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
408: l_bac_value_tab4 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 491: l_temp_object_types_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

487: L_SP_EQPMT_ETC_EFFORT_TAB5 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
488: L_SP_EQPMT_ETC_EFFORT_TAB6 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
489:
490: l_temp_object_ids_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
491: l_temp_object_types_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
492: l_temp_dirty_flag_tab1 SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
493: l_temp_dirty_flag_tab2 SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
494: l_temp_dirty_flag_tab3 SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
495: l_temp_dirty_flag_tab4 SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

Line 500: l_int_object_types_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

496: l_temp_dirty_flag_tab5 SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
497: l_temp_dirty_flag_tab6 SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
498:
499: l_int_object_ids_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
500: l_int_object_types_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
501: l_int_dirty_flag_tab1 SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
502: l_int_dirty_flag_tab2 SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
503: l_int_dirty_flag_tab3 SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
504: l_int_dirty_flag_tab4 SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();