[Home] [Help]
5998: l_created_by NUMBER := FND_GLOBAL.USER_ID;
5999: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
6000: BEGIN
6001:
6002: INSERT INTO PJI_AC_XBS_ACCUM_F
6003: (
6004: PROJECT_ID
6005: , PROJECT_ORG_ID
6006: , PROJECT_ORGANIZATION_ID
6192: , rl.ROWID pjp1_rowid
6193: , tmp.ROWID TMP1_ROWID
6194: FROM
6195: pji_ac_aggr_pjp1 tmp
6196: , PJI_AC_XBS_ACCUM_F rl
6197: WHERE 1 = 1
6198: AND tmp.worker_id = g_worker_id
6199: AND tmp.PROJECT_ID = rl.PROJECT_ID (+)
6200: AND tmp.PROJECT_ORG_ID = rl.PROJECT_ORG_ID (+)
6224:
6225: BEGIN
6226:
6227: UPDATE /*+ ordered use_nl(rl) rowid(rl) */
6228: PJI_AC_XBS_ACCUM_F rl
6229: SET (
6230: rl.REVENUE
6231: , rl.INITIAL_FUNDING_AMOUNT
6232: , rl.INITIAL_FUNDING_COUNT
6362: l_created_by NUMBER := FND_GLOBAL.USER_ID;
6363: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
6364: BEGIN
6365:
6366: INSERT INTO PJI_AC_XBS_ACCUM_F
6367: (
6368: PROJECT_ID
6369: , PROJECT_ORG_ID
6370: , PROJECT_ORGANIZATION_ID