APPS.PA_TASKS_MAINT_PUB dependencies on PA_PREVIEW_FIN_TASKS_TEMP

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

3105: -- Procedure : POPULATE_TEMP_TABLE
3106: -- Type : Public Procedure
3107: -- Purpose : This API will be called from set financial tasks page in financial tab
3108: -- : This Api is to populate the global temp
3109: -- : table PA_PREVIEW_FIN_TASKS_TEMP for Preview Financial tasks page.
3110: -- : The VO of Preview page is based on this temp table
3111: -- :
3112: -- Note : This API first populates the temp table with structure information and then it selects all the parent
3113: -- : tasks for the passed task id and popultes the temp table with parent tasks information

Line 3243: FROM pa_preview_fin_tasks_temp temp

3239: )
3240: AND NOT EXISTS -- This is to insure that the same record does not get inserted twice
3241: (
3242: SELECT 'xyz'
3243: FROM pa_preview_fin_tasks_temp temp
3244: WHERE temp.element_version_id = elemver.element_version_id
3245: );
3246:
3247: BEGIN

Line 3273: DELETE FROM pa_preview_fin_tasks_temp;

3269: END IF;
3270:
3271: --Delete all elements from temporary table first.
3272: BEGIN
3273: DELETE FROM pa_preview_fin_tasks_temp;
3274:
3275: EXCEPTION
3276: WHEN OTHERS THEN
3277:

Line 3326: INSERT INTO pa_preview_fin_tasks_temp

3322:
3323: --Open cursor c_get_structure_info and get the structure information
3324: OPEN c_get_structure_info(p_project_id , p_structure_version_id);
3325: FETCH c_get_structure_info INTO l_rec_fin_tasks_temp;
3326: INSERT INTO pa_preview_fin_tasks_temp
3327: (
3328: PROJECT_ID
3329: , ELEMENT_VERSION_ID
3330: , PARENT_STRUCTURE_VERSION_ID

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

3359: FOR iCounter IN REVERSE p_task_version_id_array.FIRST..p_task_version_id_array.LAST LOOP
3360: --Get all the parentes of the task Ids passed
3361:
3362: OPEN c_get_parents ( p_project_id , p_task_version_id_array (iCounter) );
3363: --Bulk Collect the cursor in to table of pa_preview_fin_tasks_temp_tbl type records
3364: FETCH c_get_parents BULK COLLECT INTO
3365: l_project_id_tbl
3366: , l_element_version_id_tbl
3367: , l_prnt_struct_ver_id_tbl

Line 3384: INSERT INTO pa_preview_fin_tasks_temp

3380:
3381: IF (l_element_version_id_tbl.COUNT > 0)THEN
3382: --Loop thorugh the table and insert all the data in the temp table
3383: FORALL iCounter1 IN l_element_version_id_tbl.FIRST..l_element_version_id_tbl.LAST
3384: INSERT INTO pa_preview_fin_tasks_temp
3385: (
3386: PROJECT_ID
3387: , ELEMENT_VERSION_ID
3388: , PARENT_STRUCTURE_VERSION_ID