APPS.PA_PROJECT_CORE dependencies on PA_PLSQL_DATATYPES

Line 124: l_tasks_tbl PA_PLSQL_DATATYPES.IdTabTyp;

120: FROM PA_TASKS
121: WHERE project_id = x_project_id;
122:
123: -- added for bug#3693197
124: l_tasks_tbl PA_PLSQL_DATATYPES.IdTabTyp;
125:
126:
127:
128: l_template_flag VARCHAR2(1);

Line 1793: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

1789: select ics.ind_compiled_set_id
1790: from pa_ind_compiled_sets ics
1791: where ics.ind_rate_sch_revision_id = l_ind_rate_sch_revision_id
1792: ;
1793: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1794: l_ind_rate_sch_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1795: l_ind_rate_sch_rev_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1796: l_ind_comp_set_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1797: begin

Line 1794: l_ind_rate_sch_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

1790: from pa_ind_compiled_sets ics
1791: where ics.ind_rate_sch_revision_id = l_ind_rate_sch_revision_id
1792: ;
1793: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1794: l_ind_rate_sch_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1795: l_ind_rate_sch_rev_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1796: l_ind_comp_set_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1797: begin
1798:

Line 1795: l_ind_rate_sch_rev_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

1791: where ics.ind_rate_sch_revision_id = l_ind_rate_sch_revision_id
1792: ;
1793: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1794: l_ind_rate_sch_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1795: l_ind_rate_sch_rev_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1796: l_ind_comp_set_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1797: begin
1798:
1799: open task_cur ( x_task_id );

Line 1796: l_ind_comp_set_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

1792: ;
1793: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1794: l_ind_rate_sch_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1795: l_ind_rate_sch_rev_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1796: l_ind_comp_set_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1797: begin
1798:
1799: open task_cur ( x_task_id );
1800: fetch task_cur