DBA Data[Home] [Help]

APPS.PA_PROJ_TASK_STRUC_PUB dependencies on PA_PLSQL_DATATYPES

Line 12865: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */

12861: -- Changes added by skannoji
12862: -- Added code for doosan customer
12863: Declare
12864: /* Bug #: 3305199 SMukka */
12865: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
12866: /* src_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
12867: /* dest_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
12868: src_versions_tab SYSTEM.pa_num_tbl_type;
12869: dest_versions_tab SYSTEM.pa_num_tbl_type;

Line 12866: /* src_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */

12862: -- Added code for doosan customer
12863: Declare
12864: /* Bug #: 3305199 SMukka */
12865: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
12866: /* src_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
12867: /* dest_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
12868: src_versions_tab SYSTEM.pa_num_tbl_type;
12869: dest_versions_tab SYSTEM.pa_num_tbl_type;
12870: Begin

Line 12867: /* dest_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */

12863: Declare
12864: /* Bug #: 3305199 SMukka */
12865: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
12866: /* src_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
12867: /* dest_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
12868: src_versions_tab SYSTEM.pa_num_tbl_type;
12869: dest_versions_tab SYSTEM.pa_num_tbl_type;
12870: Begin
12871: Select Element_Version_ID, attribute15 BULK COLLECT

Line 13505: l_child_indicator_tbl PA_PLSQL_DATATYPES.Char1TabTyp;

13501: l_disp_seq NUMBER;
13502:
13503: -- Bug 3075609. The following plsql table will indicate at any point of time if the parent
13504: -- contains a task which has progress enabled.
13505: l_child_indicator_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
13506:
13507: -- Bug 3075609. This is a table of task versions for which atleast one of its child has changed
13508: -- its parent. That a child task has moved out of this branch. This local variable will be indexed
13509: -- with the task version ids so that eliminating duplicates is easy.

Line 13510: l_affected_parents_tbl PA_PLSQL_DATATYPES.Char1TabTyp;

13506:
13507: -- Bug 3075609. This is a table of task versions for which atleast one of its child has changed
13508: -- its parent. That a child task has moved out of this branch. This local variable will be indexed
13509: -- with the task version ids so that eliminating duplicates is easy.
13510: l_affected_parents_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
13511:
13512: l_dummy_char VARCHAR2(1);
13513: l_dummy_number NUMBER;
13514:

Line 16548: l_prog_entry_enable_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;

16544: TYPE obj_rel_id_tbl is table of pa_object_relationships.object_relationship_id%TYPE
16545: INDEX BY BINARY_INTEGER;
16546:
16547: l_parent_version_id pa_proj_element_versions.element_version_id%TYPE;
16548: l_prog_entry_enable_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
16549: l_obj_rel_id_tbl obj_rel_id_tbl;
16550: l_plsql_max_array_size CONSTANT NUMBER := 200; -- limiting the max fetch size
16551: l_task_weightage_tbl weighting_percentage_tbl;
16552: l_weightage_set_flag VARCHAR2(1);

Line 21533: l_Strings_Tab PA_PLSQL_DATATYPES.Char240TabTyp;

21529: X_Msg_Count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
21530: X_Msg_Data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
21531: )
21532: IS
21533: l_Strings_Tab PA_PLSQL_DATATYPES.Char240TabTyp;
21534: l_begin NUMBER;
21535: l_End NUMBER;
21536: l_Col1 NUMBER;
21537: l_Col2 VARCHAR2(10);