1859: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1860: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
1861:
1862: l_last_update_date := sysdate;
1863: l_last_updated_by := FND_GLOBAL.USER_ID;
1864: l_creation_date := sysdate;
1865: l_created_by := FND_GLOBAL.USER_ID;
1866: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1867:
1861:
1862: l_last_update_date := sysdate;
1863: l_last_updated_by := FND_GLOBAL.USER_ID;
1864: l_creation_date := sysdate;
1865: l_created_by := FND_GLOBAL.USER_ID;
1866: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1867:
1868: if (l_extraction_type = 'FULL' and nvl(p_backlog_flag, 'N') = 'N') then
1869:
1862: l_last_update_date := sysdate;
1863: l_last_updated_by := FND_GLOBAL.USER_ID;
1864: l_creation_date := sysdate;
1865: l_created_by := FND_GLOBAL.USER_ID;
1866: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1867:
1868: if (l_extraction_type = 'FULL' and nvl(p_backlog_flag, 'N') = 'N') then
1869:
1870: insert /*+ append parallel(acp) */ into PJI_AC_PROJ_F acp