DBA Data[Home] [Help]

APPS.PA_PROJ_TASK_STRUC_PUB dependencies on PA_PLSQL_DATATYPES

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

13190: -- Changes added by skannoji
13191: -- Added code for doosan customer
13192: Declare
13193: /* Bug #: 3305199 SMukka */
13194: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
13195: /* src_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
13196: /* dest_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
13197: src_versions_tab SYSTEM.pa_num_tbl_type;
13198: dest_versions_tab SYSTEM.pa_num_tbl_type;

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

13191: -- Added code for doosan customer
13192: Declare
13193: /* Bug #: 3305199 SMukka */
13194: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
13195: /* src_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
13196: /* dest_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
13197: src_versions_tab SYSTEM.pa_num_tbl_type;
13198: dest_versions_tab SYSTEM.pa_num_tbl_type;
13199: Begin

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

13192: Declare
13193: /* Bug #: 3305199 SMukka */
13194: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
13195: /* src_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
13196: /* dest_versions_tab PA_PLSQL_DATATYPES.IdTabTyp; */
13197: src_versions_tab SYSTEM.pa_num_tbl_type;
13198: dest_versions_tab SYSTEM.pa_num_tbl_type;
13199: Begin
13200: Select Element_Version_ID, attribute15 BULK COLLECT

Line 13852: l_child_indicator_tbl PA_PLSQL_DATATYPES.Char1TabTyp;

13848: l_disp_seq NUMBER;
13849:
13850: -- Bug 3075609. The following plsql table will indicate at any point of time if the parent
13851: -- contains a task which has progress enabled.
13852: l_child_indicator_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
13853:
13854: -- Bug 3075609. This is a table of task versions for which atleast one of its child has changed
13855: -- its parent. That a child task has moved out of this branch. This local variable will be indexed
13856: -- with the task version ids so that eliminating duplicates is easy.

Line 13857: l_affected_parents_tbl PA_PLSQL_DATATYPES.Char1TabTyp;

13853:
13854: -- Bug 3075609. This is a table of task versions for which atleast one of its child has changed
13855: -- its parent. That a child task has moved out of this branch. This local variable will be indexed
13856: -- with the task version ids so that eliminating duplicates is easy.
13857: l_affected_parents_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
13858:
13859: l_dummy_char VARCHAR2(1);
13860: l_dummy_number NUMBER;
13861:

Line 17195: l_prog_entry_enable_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;

17191: TYPE obj_rel_id_tbl is table of pa_object_relationships.object_relationship_id%TYPE
17192: INDEX BY BINARY_INTEGER;
17193:
17194: l_parent_version_id pa_proj_element_versions.element_version_id%TYPE;
17195: l_prog_entry_enable_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
17196: l_obj_rel_id_tbl obj_rel_id_tbl;
17197: l_plsql_max_array_size CONSTANT NUMBER := 200; -- limiting the max fetch size
17198: l_task_weightage_tbl weighting_percentage_tbl;
17199: l_weightage_set_flag VARCHAR2(1);

Line 22341: l_Strings_Tab PA_PLSQL_DATATYPES.Char240TabTyp;

22337: X_Msg_Count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
22338: X_Msg_Data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
22339: )
22340: IS
22341: l_Strings_Tab PA_PLSQL_DATATYPES.Char240TabTyp;
22342: l_begin NUMBER;
22343: l_End NUMBER;
22344: l_Col1 NUMBER;
22345: l_Col2 VARCHAR2(10);