DBA Data[Home] [Help]

APPS.PA_SCHEDULE_OBJECTS_PVT dependencies on PA_VARCHAR2_30_TBL_TYPE

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

363: l_update_flag_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
364:
365: l_child_update_required VARCHAR2(1);
366: l_parent_update_required VARCHAR2(1);
367: l_parent_rowid_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
368: L_CHILD_OBJECT_IDS_TAB SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
369: L_PARENT_OBJECT_IDS_TAB SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
370: l_parent_object_types_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
371: l_child_object_types_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

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

366: l_parent_update_required VARCHAR2(1);
367: l_parent_rowid_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
368: L_CHILD_OBJECT_IDS_TAB SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
369: L_PARENT_OBJECT_IDS_TAB SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
370: l_parent_object_types_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
371: l_child_object_types_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
372: l_parent_start_date_tab1 SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
373: l_parent_start_date_tab2 SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
374: l_parent_start_date_tab3 SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

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

367: l_parent_rowid_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
368: L_CHILD_OBJECT_IDS_TAB SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
369: L_PARENT_OBJECT_IDS_TAB SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
370: l_parent_object_types_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
371: l_child_object_types_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
372: l_parent_start_date_tab1 SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
373: l_parent_start_date_tab2 SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
374: l_parent_start_date_tab3 SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
375: l_parent_start_date_tab4 SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

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

414: l_child_duration_tab6 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
415:
416:
417: l_object_ids_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
418: l_object_types_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
419: l_count_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
420: l_sum_tab1 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
421: l_sum_tab2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
422: l_sum_tab3 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

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

428: l_task_status_tab3 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
429: l_task_status_tab4 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
430: l_task_status_tab5 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
431: l_task_status_tab6 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
432: l_perc_comp_deriv_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
433: l_bac_value_tab1 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
434: l_bac_value_tab2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
435: l_bac_value_tab3 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
436: l_bac_value_tab4 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

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

515: L_SP_EQPMT_ETC_EFFORT_TAB5 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
516: L_SP_EQPMT_ETC_EFFORT_TAB6 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
517:
518: l_temp_object_ids_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
519: l_temp_object_types_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
520: l_temp_dirty_flag_tab1 SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
521: l_temp_dirty_flag_tab2 SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
522: l_temp_dirty_flag_tab3 SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
523: l_temp_dirty_flag_tab4 SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

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

524: l_temp_dirty_flag_tab5 SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
525: l_temp_dirty_flag_tab6 SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
526:
527: l_int_object_ids_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
528: l_int_object_types_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
529: l_int_dirty_flag_tab1 SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
530: l_int_dirty_flag_tab2 SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
531: l_int_dirty_flag_tab3 SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
532: l_int_dirty_flag_tab4 SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();