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 1777: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

1773: select ics.ind_compiled_set_id
1774: from pa_ind_compiled_sets ics
1775: where ics.ind_rate_sch_revision_id = l_ind_rate_sch_revision_id
1776: ;
1777: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1778: l_ind_rate_sch_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1779: l_ind_rate_sch_rev_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1780: l_ind_comp_set_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1781: begin

Line 1778: l_ind_rate_sch_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

1774: from pa_ind_compiled_sets ics
1775: where ics.ind_rate_sch_revision_id = l_ind_rate_sch_revision_id
1776: ;
1777: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1778: l_ind_rate_sch_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1779: l_ind_rate_sch_rev_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1780: l_ind_comp_set_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1781: begin
1782:

Line 1779: l_ind_rate_sch_rev_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

1775: where ics.ind_rate_sch_revision_id = l_ind_rate_sch_revision_id
1776: ;
1777: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1778: l_ind_rate_sch_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1779: l_ind_rate_sch_rev_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1780: l_ind_comp_set_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1781: begin
1782:
1783: open task_cur ( x_task_id );

Line 1780: l_ind_comp_set_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

1776: ;
1777: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1778: l_ind_rate_sch_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1779: l_ind_rate_sch_rev_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1780: l_ind_comp_set_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1781: begin
1782:
1783: open task_cur ( x_task_id );
1784: fetch task_cur