DBA Data[Home] [Help]

APPS.AHL_LTP_SIMUL_PLAN_PVT dependencies on FND_GLOBAL

Line 771: X_CREATED_BY => Fnd_Global.USER_ID,

767: X_ATTRIBUTE15 => l_simulation_plan_rec.attribute15,
768: X_SIMULATION_PLAN_NAME => l_simulation_plan_rec.simulation_plan_name,
769: X_DESCRIPTION => l_simulation_plan_rec.description,
770: X_CREATION_DATE => SYSDATE,
771: X_CREATED_BY => Fnd_Global.USER_ID,
772: X_LAST_UPDATE_DATE => SYSDATE,
773: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
774: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,
775: X_STATUS_CODE => NULL,

Line 773: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,

769: X_DESCRIPTION => l_simulation_plan_rec.description,
770: X_CREATION_DATE => SYSDATE,
771: X_CREATED_BY => Fnd_Global.USER_ID,
772: X_LAST_UPDATE_DATE => SYSDATE,
773: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
774: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,
775: X_STATUS_CODE => NULL,
776: X_SIMULATION_TYPE => NULL);
777:

Line 774: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,

770: X_CREATION_DATE => SYSDATE,
771: X_CREATED_BY => Fnd_Global.USER_ID,
772: X_LAST_UPDATE_DATE => SYSDATE,
773: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
774: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,
775: X_STATUS_CODE => NULL,
776: X_SIMULATION_TYPE => NULL);
777:
778: p_x_simulation_plan_rec.plan_id := l_simulation_plan_id;

Line 1018: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,

1014: X_ATTRIBUTE13 => l_Asimulation_plan_rec.attribute13,
1015: X_ATTRIBUTE14 => l_Asimulation_plan_rec.attribute14,
1016: X_ATTRIBUTE15 => l_Asimulation_plan_rec.attribute15,
1017: X_LAST_UPDATE_DATE => SYSDATE,
1018: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
1019: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,
1020: X_STATUS_CODE => NULL,
1021: X_SIMULATION_TYPE => NULL);
1022:

Line 1019: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,

1015: X_ATTRIBUTE14 => l_Asimulation_plan_rec.attribute14,
1016: X_ATTRIBUTE15 => l_Asimulation_plan_rec.attribute15,
1017: X_LAST_UPDATE_DATE => SYSDATE,
1018: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
1019: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,
1020: X_STATUS_CODE => NULL,
1021: X_SIMULATION_TYPE => NULL);
1022:
1023:

Line 1924: X_CREATED_BY => Fnd_Global.USER_ID,

1920: -- set the Planning and In-Repair locators
1921: X_COMP_PLANNING_LOC_ID => l_visit_detail_rec.comp_planning_loc_id,
1922: X_COMP_INREPAIR_LOC_ID => l_visit_detail_rec.comp_inrepair_loc_id,
1923: X_CREATION_DATE => SYSDATE,
1924: X_CREATED_BY => Fnd_Global.USER_ID,
1925: X_LAST_UPDATE_DATE => SYSDATE,
1926: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
1927: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,
1928: -- AVIKUKUM :: FP:PIE ::14-OCT-2010

Line 1926: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,

1922: X_COMP_INREPAIR_LOC_ID => l_visit_detail_rec.comp_inrepair_loc_id,
1923: X_CREATION_DATE => SYSDATE,
1924: X_CREATED_BY => Fnd_Global.USER_ID,
1925: X_LAST_UPDATE_DATE => SYSDATE,
1926: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
1927: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,
1928: -- AVIKUKUM :: FP:PIE ::14-OCT-2010
1929: X_TOP_PROJECT_TASK_ID => l_visit_detail_rec.top_project_task_id,
1930: X_PAST_DATED_VISIT_FLAG => l_visit_detail_rec.past_dated_visit_flag, -- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011

Line 1927: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,

1923: X_CREATION_DATE => SYSDATE,
1924: X_CREATED_BY => Fnd_Global.USER_ID,
1925: X_LAST_UPDATE_DATE => SYSDATE,
1926: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
1927: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,
1928: -- AVIKUKUM :: FP:PIE ::14-OCT-2010
1929: X_TOP_PROJECT_TASK_ID => l_visit_detail_rec.top_project_task_id,
1930: X_PAST_DATED_VISIT_FLAG => l_visit_detail_rec.past_dated_visit_flag, -- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
1931: X_FIRMED_FLAG => l_visit_detail_rec.firmed_flag, -- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011

Line 1981: X_CREATED_BY => Fnd_Global.USER_ID,

1977: X_ATTRIBUTE13 => l_stage_rec.ATTRIBUTE13,
1978: X_ATTRIBUTE14 => l_stage_rec.ATTRIBUTE14,
1979: X_ATTRIBUTE15 => l_stage_rec.ATTRIBUTE15,
1980: X_CREATION_DATE => SYSDATE,
1981: X_CREATED_BY => Fnd_Global.USER_ID,
1982: X_LAST_UPDATE_DATE => SYSDATE,
1983: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
1984: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,
1985: X_STAGE_STATUS_CODE => NULL,-- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011

Line 1983: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,

1979: X_ATTRIBUTE15 => l_stage_rec.ATTRIBUTE15,
1980: X_CREATION_DATE => SYSDATE,
1981: X_CREATED_BY => Fnd_Global.USER_ID,
1982: X_LAST_UPDATE_DATE => SYSDATE,
1983: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
1984: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,
1985: X_STAGE_STATUS_CODE => NULL,-- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
1986: X_PLANNED_START_DATE => NULL,-- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
1987: X_PLANNED_END_DATE => NULL,-- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011

Line 1984: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,

1980: X_CREATION_DATE => SYSDATE,
1981: X_CREATED_BY => Fnd_Global.USER_ID,
1982: X_LAST_UPDATE_DATE => SYSDATE,
1983: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
1984: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,
1985: X_STAGE_STATUS_CODE => NULL,-- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
1986: X_PLANNED_START_DATE => NULL,-- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
1987: X_PLANNED_END_DATE => NULL,-- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
1988: X_PREV_STAGE_NUM => NULL,-- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011

Line 2169: X_CREATED_BY => Fnd_Global.USER_ID,

2165: X_VISIT_TASK_NAME => l_visit_task_rec.visit_task_name,
2166: X_DESCRIPTION => l_visit_task_rec.description,
2167: X_QUANTITY => l_visit_task_rec.quantity, -- Added by rnahata for Issue 105
2168: X_CREATION_DATE => SYSDATE,
2169: X_CREATED_BY => Fnd_Global.USER_ID,
2170: X_LAST_UPDATE_DATE => SYSDATE,
2171: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
2172: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );
2173:

Line 2171: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,

2167: X_QUANTITY => l_visit_task_rec.quantity, -- Added by rnahata for Issue 105
2168: X_CREATION_DATE => SYSDATE,
2169: X_CREATED_BY => Fnd_Global.USER_ID,
2170: X_LAST_UPDATE_DATE => SYSDATE,
2171: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
2172: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );
2173:
2174: END LOOP;
2175: CLOSE get_visit_task_cur;

Line 2172: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );

2168: X_CREATION_DATE => SYSDATE,
2169: X_CREATED_BY => Fnd_Global.USER_ID,
2170: X_LAST_UPDATE_DATE => SYSDATE,
2171: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
2172: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );
2173:
2174: END LOOP;
2175: CLOSE get_visit_task_cur;
2176:

Line 2272: Fnd_Global.USER_ID,

2268: (
2269: ahl_task_links_s.nextval,
2270: 1,
2271: SYSDATE,
2272: Fnd_Global.USER_ID,
2273: SYSDATE,
2274: Fnd_Global.USER_ID,
2275: Fnd_Global.USER_ID,
2276: l_new_task_id,

Line 2274: Fnd_Global.USER_ID,

2270: 1,
2271: SYSDATE,
2272: Fnd_Global.USER_ID,
2273: SYSDATE,
2274: Fnd_Global.USER_ID,
2275: Fnd_Global.USER_ID,
2276: l_new_task_id,
2277: l_new_parent_task_id,
2278: --l_task_link_rec.SECURITY_GROUP_ID,

Line 2275: Fnd_Global.USER_ID,

2271: SYSDATE,
2272: Fnd_Global.USER_ID,
2273: SYSDATE,
2274: Fnd_Global.USER_ID,
2275: Fnd_Global.USER_ID,
2276: l_new_task_id,
2277: l_new_parent_task_id,
2278: --l_task_link_rec.SECURITY_GROUP_ID,
2279: l_task_link_rec.ATTRIBUTE_CATEGORY,

Line 2362: Fnd_Global.user_id,

2358: NULL,
2359: NULL,
2360: NULL,
2361: SYSDATE,
2362: Fnd_Global.user_id,
2363: SYSDATE,
2364: Fnd_Global.user_id,
2365: Fnd_Global.login_id
2366: );

Line 2364: Fnd_Global.user_id,

2360: NULL,
2361: SYSDATE,
2362: Fnd_Global.user_id,
2363: SYSDATE,
2364: Fnd_Global.user_id,
2365: Fnd_Global.login_id
2366: );
2367:
2368: END IF;

Line 2365: Fnd_Global.login_id

2361: SYSDATE,
2362: Fnd_Global.user_id,
2363: SYSDATE,
2364: Fnd_Global.user_id,
2365: Fnd_Global.login_id
2366: );
2367:
2368: END IF;
2369: END LOOP;

Line 4202: X_CREATED_BY => Fnd_Global.USER_ID,

4198: X_DESCRIPTION => l_simul_visit_task_rec.description,
4199: X_DEPARTMENT_ID => l_simul_visit_task_rec.department_id,
4200: X_QUANTITY => l_simul_visit_task_rec.quantity, -- Added by rnahata for Issue 105
4201: X_CREATION_DATE => SYSDATE,
4202: X_CREATED_BY => Fnd_Global.USER_ID,
4203: X_LAST_UPDATE_DATE => SYSDATE,
4204: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
4205: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID
4206: );

Line 4204: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,

4200: X_QUANTITY => l_simul_visit_task_rec.quantity, -- Added by rnahata for Issue 105
4201: X_CREATION_DATE => SYSDATE,
4202: X_CREATED_BY => Fnd_Global.USER_ID,
4203: X_LAST_UPDATE_DATE => SYSDATE,
4204: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
4205: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID
4206: );
4207: /* Need to update the simulation_visit's primary_visit_task_id with the Id thats generated here */
4208: UPDATE ahl_visit_tasks_b

Line 4205: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID

4201: X_CREATION_DATE => SYSDATE,
4202: X_CREATED_BY => Fnd_Global.USER_ID,
4203: X_LAST_UPDATE_DATE => SYSDATE,
4204: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
4205: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID
4206: );
4207: /* Need to update the simulation_visit's primary_visit_task_id with the Id thats generated here */
4208: UPDATE ahl_visit_tasks_b
4209: SET primary_visit_task_id = l_visit_task_id

Line 4409: Fnd_Global.USER_ID,

4405: (
4406: ahl_task_links_s.nextval,
4407: 1,
4408: SYSDATE,
4409: Fnd_Global.USER_ID,
4410: SYSDATE,
4411: Fnd_Global.USER_ID,
4412: Fnd_Global.USER_ID,
4413: l_new_task_id,

Line 4411: Fnd_Global.USER_ID,

4407: 1,
4408: SYSDATE,
4409: Fnd_Global.USER_ID,
4410: SYSDATE,
4411: Fnd_Global.USER_ID,
4412: Fnd_Global.USER_ID,
4413: l_new_task_id,
4414: l_new_parent_task_id,
4415: --l_task_link_rec.SECURITY_GROUP_ID,

Line 4412: Fnd_Global.USER_ID,

4408: SYSDATE,
4409: Fnd_Global.USER_ID,
4410: SYSDATE,
4411: Fnd_Global.USER_ID,
4412: Fnd_Global.USER_ID,
4413: l_new_task_id,
4414: l_new_parent_task_id,
4415: --l_task_link_rec.SECURITY_GROUP_ID,
4416: l_task_link_rec.ATTRIBUTE_CATEGORY,

Line 4479: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,

4475: X_ATTRIBUTE13 => l_stage_rec.ATTRIBUTE13,
4476: X_ATTRIBUTE14 => l_stage_rec.ATTRIBUTE14,
4477: X_ATTRIBUTE15 => l_stage_rec.ATTRIBUTE15,
4478: X_LAST_UPDATE_DATE => SYSDATE,
4479: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
4480: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,
4481: X_STAGE_STATUS_CODE => NULL,-- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
4482: X_PLANNED_START_DATE => NULL,-- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
4483: X_PLANNED_END_DATE => NULL,-- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011

Line 4480: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,

4476: X_ATTRIBUTE14 => l_stage_rec.ATTRIBUTE14,
4477: X_ATTRIBUTE15 => l_stage_rec.ATTRIBUTE15,
4478: X_LAST_UPDATE_DATE => SYSDATE,
4479: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
4480: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID,
4481: X_STAGE_STATUS_CODE => NULL,-- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
4482: X_PLANNED_START_DATE => NULL,-- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
4483: X_PLANNED_END_DATE => NULL,-- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
4484: X_PREV_STAGE_NUM => NULL,-- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011