DBA Data[Home] [Help]

APPS.PA_FP_GEN_FCST_AMT_PUB3 dependencies on FND_GLOBAL

Line 4226: := FND_GLOBAL.user_id;

4222:
4223:
4224:
4225: l_last_updated_by PA_RESOURCE_ASSIGNMENTS.LAST_UPDATED_BY%TYPE
4226: := FND_GLOBAL.user_id;
4227: l_last_update_login PA_RESOURCE_ASSIGNMENTS.LAST_UPDATE_LOGIN%TYPE
4228: := FND_GLOBAL.login_id;
4229:
4230: l_override_quantity NUMBER;

Line 4228: := FND_GLOBAL.login_id;

4224:
4225: l_last_updated_by PA_RESOURCE_ASSIGNMENTS.LAST_UPDATED_BY%TYPE
4226: := FND_GLOBAL.user_id;
4227: l_last_update_login PA_RESOURCE_ASSIGNMENTS.LAST_UPDATE_LOGIN%TYPE
4228: := FND_GLOBAL.login_id;
4229:
4230: l_override_quantity NUMBER;
4231: l_copy_lines varchar2(20);
4232: l_is_gl_greater VARCHAR2(1) := 'N';

Line 4345: FND_GLOBAL.USER_ID,

4341: l_end_date_tab(i),
4342: l_period_name_tab(i),
4343: l_src_quantity_tab(i),
4344: sysdate,
4345: FND_GLOBAL.USER_ID,
4346: sysdate,
4347: FND_GLOBAL.USER_ID,
4348: FND_GLOBAL.LOGIN_ID,
4349: P_FP_COLS_TGT_REC.X_PROJECT_CURRENCY_CODE,

Line 4347: FND_GLOBAL.USER_ID,

4343: l_src_quantity_tab(i),
4344: sysdate,
4345: FND_GLOBAL.USER_ID,
4346: sysdate,
4347: FND_GLOBAL.USER_ID,
4348: FND_GLOBAL.LOGIN_ID,
4349: P_FP_COLS_TGT_REC.X_PROJECT_CURRENCY_CODE,
4350: P_FP_COLS_TGT_REC.X_PROJFUNC_CURRENCY_CODE,
4351: l_cost_rate_override_tab(i),

Line 4348: FND_GLOBAL.LOGIN_ID,

4344: sysdate,
4345: FND_GLOBAL.USER_ID,
4346: sysdate,
4347: FND_GLOBAL.USER_ID,
4348: FND_GLOBAL.LOGIN_ID,
4349: P_FP_COLS_TGT_REC.X_PROJECT_CURRENCY_CODE,
4350: P_FP_COLS_TGT_REC.X_PROJFUNC_CURRENCY_CODE,
4351: l_cost_rate_override_tab(i),
4352: l_b_cost_rate_override_tab(i)

Line 4434: FND_GLOBAL.USER_ID,

4430: l_end_date_tab(i),
4431: l_period_name_tab(i),
4432: l_src_quantity_tab(i),
4433: sysdate,
4434: FND_GLOBAL.USER_ID,
4435: sysdate,
4436: FND_GLOBAL.USER_ID,
4437: FND_GLOBAL.LOGIN_ID,
4438: P_FP_COLS_TGT_REC.X_PROJECT_CURRENCY_CODE,

Line 4436: FND_GLOBAL.USER_ID,

4432: l_src_quantity_tab(i),
4433: sysdate,
4434: FND_GLOBAL.USER_ID,
4435: sysdate,
4436: FND_GLOBAL.USER_ID,
4437: FND_GLOBAL.LOGIN_ID,
4438: P_FP_COLS_TGT_REC.X_PROJECT_CURRENCY_CODE,
4439: P_FP_COLS_TGT_REC.X_PROJFUNC_CURRENCY_CODE,
4440: l_cost_rate_override_tab(i),

Line 4437: FND_GLOBAL.LOGIN_ID,

4433: sysdate,
4434: FND_GLOBAL.USER_ID,
4435: sysdate,
4436: FND_GLOBAL.USER_ID,
4437: FND_GLOBAL.LOGIN_ID,
4438: P_FP_COLS_TGT_REC.X_PROJECT_CURRENCY_CODE,
4439: P_FP_COLS_TGT_REC.X_PROJFUNC_CURRENCY_CODE,
4440: l_cost_rate_override_tab(i),
4441: l_b_cost_rate_override_tab(i),

Line 4526: FND_GLOBAL.USER_ID,

4522: l_end_date_tab(i),
4523: l_period_name_tab(i),
4524: l_src_quantity_tab(i),
4525: sysdate,
4526: FND_GLOBAL.USER_ID,
4527: sysdate,
4528: FND_GLOBAL.USER_ID,
4529: FND_GLOBAL.LOGIN_ID,
4530: P_FP_COLS_TGT_REC.X_PROJECT_CURRENCY_CODE,

Line 4528: FND_GLOBAL.USER_ID,

4524: l_src_quantity_tab(i),
4525: sysdate,
4526: FND_GLOBAL.USER_ID,
4527: sysdate,
4528: FND_GLOBAL.USER_ID,
4529: FND_GLOBAL.LOGIN_ID,
4530: P_FP_COLS_TGT_REC.X_PROJECT_CURRENCY_CODE,
4531: P_FP_COLS_TGT_REC.X_PROJFUNC_CURRENCY_CODE,
4532: l_cost_rate_override_tab(i),

Line 4529: FND_GLOBAL.LOGIN_ID,

4525: sysdate,
4526: FND_GLOBAL.USER_ID,
4527: sysdate,
4528: FND_GLOBAL.USER_ID,
4529: FND_GLOBAL.LOGIN_ID,
4530: P_FP_COLS_TGT_REC.X_PROJECT_CURRENCY_CODE,
4531: P_FP_COLS_TGT_REC.X_PROJFUNC_CURRENCY_CODE,
4532: l_cost_rate_override_tab(i),
4533: l_b_cost_rate_override_tab(i),

Line 4691: FND_GLOBAL.USER_ID,

4687: l_pr_end_date_tab(i),
4688: l_pr_period_name_tab(i),
4689: l_pr_src_quantity_tab(i),
4690: sysdate,
4691: FND_GLOBAL.USER_ID,
4692: sysdate,
4693: FND_GLOBAL.USER_ID,
4694: FND_GLOBAL.LOGIN_ID,
4695: P_FP_COLS_TGT_REC.X_PROJECT_CURRENCY_CODE,

Line 4693: FND_GLOBAL.USER_ID,

4689: l_pr_src_quantity_tab(i),
4690: sysdate,
4691: FND_GLOBAL.USER_ID,
4692: sysdate,
4693: FND_GLOBAL.USER_ID,
4694: FND_GLOBAL.LOGIN_ID,
4695: P_FP_COLS_TGT_REC.X_PROJECT_CURRENCY_CODE,
4696: P_FP_COLS_TGT_REC.X_PROJFUNC_CURRENCY_CODE,
4697: l_pr_cost_rate_override_tab(i),

Line 4694: FND_GLOBAL.LOGIN_ID,

4690: sysdate,
4691: FND_GLOBAL.USER_ID,
4692: sysdate,
4693: FND_GLOBAL.USER_ID,
4694: FND_GLOBAL.LOGIN_ID,
4695: P_FP_COLS_TGT_REC.X_PROJECT_CURRENCY_CODE,
4696: P_FP_COLS_TGT_REC.X_PROJFUNC_CURRENCY_CODE,
4697: l_pr_cost_rate_override_tab(i),
4698: l_pr_b_cost_rate_override_tab(i),

Line 4789: FND_GLOBAL.USER_ID as LAST_UPDATED_BY,

4785: l_pr_end_date_tab(i) as END_DATE,
4786: l_pr_period_name_tab(i) as PERIOD_NAME,
4787: l_pr_src_quantity_tab(i) as QUANTITY,
4788: sysdate as LAST_UPDATE_DATE,
4789: FND_GLOBAL.USER_ID as LAST_UPDATED_BY,
4790: sysdate as CREATION_DATE,
4791: FND_GLOBAL.USER_ID as CREATED_BY,
4792: FND_GLOBAL.LOGIN_ID as LAST_UPDATE_LOGIN,
4793: P_FP_COLS_TGT_REC.X_PROJECT_CURRENCY_CODE as PROJECT_CURRENCY_CODE,

Line 4791: FND_GLOBAL.USER_ID as CREATED_BY,

4787: l_pr_src_quantity_tab(i) as QUANTITY,
4788: sysdate as LAST_UPDATE_DATE,
4789: FND_GLOBAL.USER_ID as LAST_UPDATED_BY,
4790: sysdate as CREATION_DATE,
4791: FND_GLOBAL.USER_ID as CREATED_BY,
4792: FND_GLOBAL.LOGIN_ID as LAST_UPDATE_LOGIN,
4793: P_FP_COLS_TGT_REC.X_PROJECT_CURRENCY_CODE as PROJECT_CURRENCY_CODE,
4794: P_FP_COLS_TGT_REC.X_PROJFUNC_CURRENCY_CODE as PROJFUNC_CURRENCY_CODE,
4795: l_pr_cost_rate_override_tab(i) as TXN_COST_RATE_OVERRIDE,

Line 4792: FND_GLOBAL.LOGIN_ID as LAST_UPDATE_LOGIN,

4788: sysdate as LAST_UPDATE_DATE,
4789: FND_GLOBAL.USER_ID as LAST_UPDATED_BY,
4790: sysdate as CREATION_DATE,
4791: FND_GLOBAL.USER_ID as CREATED_BY,
4792: FND_GLOBAL.LOGIN_ID as LAST_UPDATE_LOGIN,
4793: P_FP_COLS_TGT_REC.X_PROJECT_CURRENCY_CODE as PROJECT_CURRENCY_CODE,
4794: P_FP_COLS_TGT_REC.X_PROJFUNC_CURRENCY_CODE as PROJFUNC_CURRENCY_CODE,
4795: l_pr_cost_rate_override_tab(i) as TXN_COST_RATE_OVERRIDE,
4796: l_pr_b_cost_rate_override_tab(i) as BURDEN_COST_RATE_OVERRIDE ,

Line 4810: ,pbl.LAST_UPDATED_BY = FND_GLOBAL.USER_ID

4806: SET pbl.TXN_RAW_COST = nvl(pbl.TXN_RAW_COST,0) + nvl(tmp.TXN_RAW_COST,0)
4807: ,pbl.TXN_BURDENED_COST = nvl(pbl.TXN_BURDENED_COST,0) + nvl(tmp.TXN_BURDENED_COST,0)
4808: ,pbl.QUANTITY = nvl(pbl.QUANTITY,0) + nvl(tmp.QUANTITY,0)
4809: ,pbl.LAST_UPDATE_DATE = sysdate
4810: ,pbl.LAST_UPDATED_BY = FND_GLOBAL.USER_ID
4811: ,pbl.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
4812: WHEN NOT MATCHED THEN
4813: INSERT (
4814: pbl.BUDGET_LINE_ID,

Line 4811: ,pbl.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

4807: ,pbl.TXN_BURDENED_COST = nvl(pbl.TXN_BURDENED_COST,0) + nvl(tmp.TXN_BURDENED_COST,0)
4808: ,pbl.QUANTITY = nvl(pbl.QUANTITY,0) + nvl(tmp.QUANTITY,0)
4809: ,pbl.LAST_UPDATE_DATE = sysdate
4810: ,pbl.LAST_UPDATED_BY = FND_GLOBAL.USER_ID
4811: ,pbl.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
4812: WHEN NOT MATCHED THEN
4813: INSERT (
4814: pbl.BUDGET_LINE_ID,
4815: pbl.BUDGET_VERSION_ID,

Line 4950: FND_GLOBAL.USER_ID as LAST_UPDATED_BY,

4946: l_pr_end_date_tab(i) as END_DATE,
4947: l_pr_period_name_tab(i) as PERIOD_NAME,
4948: l_pr_src_quantity_tab(i) as QUANTITY,
4949: sysdate as LAST_UPDATE_DATE,
4950: FND_GLOBAL.USER_ID as LAST_UPDATED_BY,
4951: sysdate as CREATION_DATE,
4952: FND_GLOBAL.USER_ID as CREATED_BY,
4953: FND_GLOBAL.LOGIN_ID as LAST_UPDATE_LOGIN,
4954: P_FP_COLS_TGT_REC.X_PROJECT_CURRENCY_CODE as PROJECT_CURRENCY_CODE,

Line 4952: FND_GLOBAL.USER_ID as CREATED_BY,

4948: l_pr_src_quantity_tab(i) as QUANTITY,
4949: sysdate as LAST_UPDATE_DATE,
4950: FND_GLOBAL.USER_ID as LAST_UPDATED_BY,
4951: sysdate as CREATION_DATE,
4952: FND_GLOBAL.USER_ID as CREATED_BY,
4953: FND_GLOBAL.LOGIN_ID as LAST_UPDATE_LOGIN,
4954: P_FP_COLS_TGT_REC.X_PROJECT_CURRENCY_CODE as PROJECT_CURRENCY_CODE,
4955: P_FP_COLS_TGT_REC.X_PROJFUNC_CURRENCY_CODE as PROJFUNC_CURRENCY_CODE,
4956: l_pr_cost_rate_override_tab(i) as TXN_COST_RATE_OVERRIDE,

Line 4953: FND_GLOBAL.LOGIN_ID as LAST_UPDATE_LOGIN,

4949: sysdate as LAST_UPDATE_DATE,
4950: FND_GLOBAL.USER_ID as LAST_UPDATED_BY,
4951: sysdate as CREATION_DATE,
4952: FND_GLOBAL.USER_ID as CREATED_BY,
4953: FND_GLOBAL.LOGIN_ID as LAST_UPDATE_LOGIN,
4954: P_FP_COLS_TGT_REC.X_PROJECT_CURRENCY_CODE as PROJECT_CURRENCY_CODE,
4955: P_FP_COLS_TGT_REC.X_PROJFUNC_CURRENCY_CODE as PROJFUNC_CURRENCY_CODE,
4956: l_pr_cost_rate_override_tab(i) as TXN_COST_RATE_OVERRIDE,
4957: l_pr_b_cost_rate_override_tab(i) as BURDEN_COST_RATE_OVERRIDE,

Line 4971: ,pbl.LAST_UPDATED_BY = FND_GLOBAL.USER_ID

4967: SET pbl.TXN_RAW_COST = nvl(pbl.TXN_RAW_COST,0) + nvl(tmp.TXN_RAW_COST,0)
4968: ,pbl.TXN_BURDENED_COST = nvl(pbl.TXN_BURDENED_COST,0) + nvl(tmp.TXN_BURDENED_COST,0)
4969: ,pbl.QUANTITY = nvl(pbl.QUANTITY,0) + nvl(tmp.QUANTITY,0)
4970: ,pbl.LAST_UPDATE_DATE = sysdate
4971: ,pbl.LAST_UPDATED_BY = FND_GLOBAL.USER_ID
4972: ,pbl.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
4973: WHEN NOT MATCHED THEN
4974: INSERT (
4975: pbl.BUDGET_LINE_ID,

Line 4972: ,pbl.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

4968: ,pbl.TXN_BURDENED_COST = nvl(pbl.TXN_BURDENED_COST,0) + nvl(tmp.TXN_BURDENED_COST,0)
4969: ,pbl.QUANTITY = nvl(pbl.QUANTITY,0) + nvl(tmp.QUANTITY,0)
4970: ,pbl.LAST_UPDATE_DATE = sysdate
4971: ,pbl.LAST_UPDATED_BY = FND_GLOBAL.USER_ID
4972: ,pbl.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
4973: WHEN NOT MATCHED THEN
4974: INSERT (
4975: pbl.BUDGET_LINE_ID,
4976: pbl.BUDGET_VERSION_ID,