APPS.PA_TASKS_MAINT_PUB dependencies on PA_PREVIEW_FIN_TASKS_TEMP

Line 3117: -- : table PA_PREVIEW_FIN_TASKS_TEMP for Preview Financial tasks page.

3113: -- Procedure : POPULATE_TEMP_TABLE
3114: -- Type : Public Procedure
3115: -- Purpose : This API will be called from set financial tasks page in financial tab
3116: -- : This Api is to populate the global temp
3117: -- : table PA_PREVIEW_FIN_TASKS_TEMP for Preview Financial tasks page.
3118: -- : The VO of Preview page is based on this temp table
3119: -- :
3120: -- Note : This API first populates the temp table with structure information and then it selects all the parent
3121: -- : tasks for the passed task id and popultes the temp table with parent tasks information

Line 3251: FROM pa_preview_fin_tasks_temp temp

3247: )
3248: AND NOT EXISTS -- This is to insure that the same record does not get inserted twice
3249: (
3250: SELECT 'xyz'
3251: FROM pa_preview_fin_tasks_temp temp
3252: WHERE temp.element_version_id = elemver.element_version_id
3253: );
3254:
3255: BEGIN

Line 3281: DELETE FROM pa_preview_fin_tasks_temp;

3277: END IF;
3278:
3279: --Delete all elements from temporary table first.
3280: BEGIN
3281: DELETE FROM pa_preview_fin_tasks_temp;
3282:
3283: EXCEPTION
3284: WHEN OTHERS THEN
3285:

Line 3334: INSERT INTO pa_preview_fin_tasks_temp

3330:
3331: --Open cursor c_get_structure_info and get the structure information
3332: OPEN c_get_structure_info(p_project_id , p_structure_version_id);
3333: FETCH c_get_structure_info INTO l_rec_fin_tasks_temp;
3334: INSERT INTO pa_preview_fin_tasks_temp
3335: (
3336: PROJECT_ID
3337: , ELEMENT_VERSION_ID
3338: , PARENT_STRUCTURE_VERSION_ID

Line 3371: --Bulk Collect the cursor in to table of pa_preview_fin_tasks_temp_tbl type records

3367: FOR iCounter IN REVERSE p_task_version_id_array.FIRST..p_task_version_id_array.LAST LOOP
3368: --Get all the parentes of the task Ids passed
3369:
3370: OPEN c_get_parents ( p_project_id , p_task_version_id_array (iCounter) );
3371: --Bulk Collect the cursor in to table of pa_preview_fin_tasks_temp_tbl type records
3372: FETCH c_get_parents BULK COLLECT INTO
3373: l_project_id_tbl
3374: , l_element_version_id_tbl
3375: , l_prnt_struct_ver_id_tbl

Line 3392: INSERT INTO pa_preview_fin_tasks_temp

3388:
3389: IF (l_element_version_id_tbl.COUNT > 0)THEN
3390: --Loop thorugh the table and insert all the data in the temp table
3391: FORALL iCounter1 IN l_element_version_id_tbl.FIRST..l_element_version_id_tbl.LAST
3392: INSERT INTO pa_preview_fin_tasks_temp
3393: (
3394: PROJECT_ID
3395: , ELEMENT_VERSION_ID
3396: , PARENT_STRUCTURE_VERSION_ID