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:

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:
776: p_x_simulation_plan_rec.plan_id := l_simulation_plan_id;
777: ---------------------------End of Body---------------------------------------

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:
776: p_x_simulation_plan_rec.plan_id := l_simulation_plan_id;
777: ---------------------------End of Body---------------------------------------
778: --Standard check to count messages

Line 1016: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,

1012: X_ATTRIBUTE13 => l_Asimulation_plan_rec.attribute13,
1013: X_ATTRIBUTE14 => l_Asimulation_plan_rec.attribute14,
1014: X_ATTRIBUTE15 => l_Asimulation_plan_rec.attribute15,
1015: X_LAST_UPDATE_DATE => SYSDATE,
1016: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
1017: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID);
1018:
1019:
1020: ---------------------------End of Body---------------------------------------

Line 1017: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID);

1013: X_ATTRIBUTE14 => l_Asimulation_plan_rec.attribute14,
1014: X_ATTRIBUTE15 => l_Asimulation_plan_rec.attribute15,
1015: X_LAST_UPDATE_DATE => SYSDATE,
1016: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
1017: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID);
1018:
1019:
1020: ---------------------------End of Body---------------------------------------
1021: --Standard check to count messages

Line 1904: X_CREATED_BY => Fnd_Global.USER_ID,

1900: X_PROJECT_TEMPLATE_ID => l_visit_detail_rec.project_template_id,
1901: X_UNIT_SCHEDULE_ID => l_visit_detail_rec.unit_schedule_id,
1902: X_INV_LOCATOR_ID => l_visit_detail_rec.inv_locator_id, /*Added by sowsubra*/
1903: X_CREATION_DATE => SYSDATE,
1904: X_CREATED_BY => Fnd_Global.USER_ID,
1905: X_LAST_UPDATE_DATE => SYSDATE,
1906: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
1907: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID
1908: );

Line 1906: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,

1902: X_INV_LOCATOR_ID => l_visit_detail_rec.inv_locator_id, /*Added by sowsubra*/
1903: X_CREATION_DATE => SYSDATE,
1904: X_CREATED_BY => Fnd_Global.USER_ID,
1905: X_LAST_UPDATE_DATE => SYSDATE,
1906: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
1907: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID
1908: );
1909: --Assign Out parameter
1910: x_visit_id := l_visit_id;

Line 1907: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID

1903: X_CREATION_DATE => SYSDATE,
1904: X_CREATED_BY => Fnd_Global.USER_ID,
1905: X_LAST_UPDATE_DATE => SYSDATE,
1906: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
1907: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID
1908: );
1909: --Assign Out parameter
1910: x_visit_id := l_visit_id;
1911:

Line 1955: X_CREATED_BY => Fnd_Global.USER_ID,

1951: X_ATTRIBUTE13 => l_stage_rec.ATTRIBUTE13,
1952: X_ATTRIBUTE14 => l_stage_rec.ATTRIBUTE14,
1953: X_ATTRIBUTE15 => l_stage_rec.ATTRIBUTE15,
1954: X_CREATION_DATE => SYSDATE,
1955: X_CREATED_BY => Fnd_Global.USER_ID,
1956: X_LAST_UPDATE_DATE => SYSDATE,
1957: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
1958: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID);
1959:

Line 1957: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,

1953: X_ATTRIBUTE15 => l_stage_rec.ATTRIBUTE15,
1954: X_CREATION_DATE => SYSDATE,
1955: X_CREATED_BY => Fnd_Global.USER_ID,
1956: X_LAST_UPDATE_DATE => SYSDATE,
1957: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
1958: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID);
1959:
1960: IF G_DEBUG='Y' THEN
1961: AHL_DEBUG_PUB.Debug( l_full_name ||': Visit ID =' || l_visit_id);

Line 1958: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID);

1954: X_CREATION_DATE => SYSDATE,
1955: X_CREATED_BY => Fnd_Global.USER_ID,
1956: X_LAST_UPDATE_DATE => SYSDATE,
1957: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
1958: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID);
1959:
1960: IF G_DEBUG='Y' THEN
1961: AHL_DEBUG_PUB.Debug( l_full_name ||': Visit ID =' || l_visit_id);
1962: AHL_DEBUG_PUB.Debug( l_full_name ||': Stage Number =' ||l_stage_rec.Stage_Num);

Line 2130: X_CREATED_BY => Fnd_Global.USER_ID,

2126: X_VISIT_TASK_NAME => l_visit_task_rec.visit_task_name,
2127: X_DESCRIPTION => l_visit_task_rec.description,
2128: X_QUANTITY => l_visit_task_rec.quantity, -- Added by rnahata for Issue 105
2129: X_CREATION_DATE => SYSDATE,
2130: X_CREATED_BY => Fnd_Global.USER_ID,
2131: X_LAST_UPDATE_DATE => SYSDATE,
2132: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
2133: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );
2134:

Line 2132: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,

2128: X_QUANTITY => l_visit_task_rec.quantity, -- Added by rnahata for Issue 105
2129: X_CREATION_DATE => SYSDATE,
2130: X_CREATED_BY => Fnd_Global.USER_ID,
2131: X_LAST_UPDATE_DATE => SYSDATE,
2132: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
2133: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );
2134:
2135: END LOOP;
2136: CLOSE get_visit_task_cur;

Line 2133: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );

2129: X_CREATION_DATE => SYSDATE,
2130: X_CREATED_BY => Fnd_Global.USER_ID,
2131: X_LAST_UPDATE_DATE => SYSDATE,
2132: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
2133: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );
2134:
2135: END LOOP;
2136: CLOSE get_visit_task_cur;
2137:

Line 2233: Fnd_Global.USER_ID,

2229: (
2230: ahl_task_links_s.nextval,
2231: 1,
2232: SYSDATE,
2233: Fnd_Global.USER_ID,
2234: SYSDATE,
2235: Fnd_Global.USER_ID,
2236: Fnd_Global.USER_ID,
2237: l_new_task_id,

Line 2235: Fnd_Global.USER_ID,

2231: 1,
2232: SYSDATE,
2233: Fnd_Global.USER_ID,
2234: SYSDATE,
2235: Fnd_Global.USER_ID,
2236: Fnd_Global.USER_ID,
2237: l_new_task_id,
2238: l_new_parent_task_id,
2239: --l_task_link_rec.SECURITY_GROUP_ID,

Line 2236: Fnd_Global.USER_ID,

2232: SYSDATE,
2233: Fnd_Global.USER_ID,
2234: SYSDATE,
2235: Fnd_Global.USER_ID,
2236: Fnd_Global.USER_ID,
2237: l_new_task_id,
2238: l_new_parent_task_id,
2239: --l_task_link_rec.SECURITY_GROUP_ID,
2240: l_task_link_rec.ATTRIBUTE_CATEGORY,

Line 2323: Fnd_Global.user_id,

2319: NULL,
2320: NULL,
2321: NULL,
2322: SYSDATE,
2323: Fnd_Global.user_id,
2324: SYSDATE,
2325: Fnd_Global.user_id,
2326: Fnd_Global.login_id
2327: );

Line 2325: Fnd_Global.user_id,

2321: NULL,
2322: SYSDATE,
2323: Fnd_Global.user_id,
2324: SYSDATE,
2325: Fnd_Global.user_id,
2326: Fnd_Global.login_id
2327: );
2328:
2329: END IF;

Line 2326: Fnd_Global.login_id

2322: SYSDATE,
2323: Fnd_Global.user_id,
2324: SYSDATE,
2325: Fnd_Global.user_id,
2326: Fnd_Global.login_id
2327: );
2328:
2329: END IF;
2330: END LOOP;

Line 4142: X_CREATED_BY => Fnd_Global.USER_ID,

4138: X_DESCRIPTION => l_simul_visit_task_rec.description,
4139: X_DEPARTMENT_ID => l_simul_visit_task_rec.department_id,
4140: X_QUANTITY => l_simul_visit_task_rec.quantity, -- Added by rnahata for Issue 105
4141: X_CREATION_DATE => SYSDATE,
4142: X_CREATED_BY => Fnd_Global.USER_ID,
4143: X_LAST_UPDATE_DATE => SYSDATE,
4144: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
4145: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID
4146: );

Line 4144: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,

4140: X_QUANTITY => l_simul_visit_task_rec.quantity, -- Added by rnahata for Issue 105
4141: X_CREATION_DATE => SYSDATE,
4142: X_CREATED_BY => Fnd_Global.USER_ID,
4143: X_LAST_UPDATE_DATE => SYSDATE,
4144: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
4145: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID
4146: );
4147: /* Need to update the simulation_visit's primary_visit_task_id with the Id thats generated here */
4148: UPDATE ahl_visit_tasks_b

Line 4145: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID

4141: X_CREATION_DATE => SYSDATE,
4142: X_CREATED_BY => Fnd_Global.USER_ID,
4143: X_LAST_UPDATE_DATE => SYSDATE,
4144: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
4145: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID
4146: );
4147: /* Need to update the simulation_visit's primary_visit_task_id with the Id thats generated here */
4148: UPDATE ahl_visit_tasks_b
4149: SET primary_visit_task_id = l_visit_task_id

Line 4349: Fnd_Global.USER_ID,

4345: (
4346: ahl_task_links_s.nextval,
4347: 1,
4348: SYSDATE,
4349: Fnd_Global.USER_ID,
4350: SYSDATE,
4351: Fnd_Global.USER_ID,
4352: Fnd_Global.USER_ID,
4353: l_new_task_id,

Line 4351: Fnd_Global.USER_ID,

4347: 1,
4348: SYSDATE,
4349: Fnd_Global.USER_ID,
4350: SYSDATE,
4351: Fnd_Global.USER_ID,
4352: Fnd_Global.USER_ID,
4353: l_new_task_id,
4354: l_new_parent_task_id,
4355: --l_task_link_rec.SECURITY_GROUP_ID,

Line 4352: Fnd_Global.USER_ID,

4348: SYSDATE,
4349: Fnd_Global.USER_ID,
4350: SYSDATE,
4351: Fnd_Global.USER_ID,
4352: Fnd_Global.USER_ID,
4353: l_new_task_id,
4354: l_new_parent_task_id,
4355: --l_task_link_rec.SECURITY_GROUP_ID,
4356: l_task_link_rec.ATTRIBUTE_CATEGORY,

Line 4420: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,

4416: X_ATTRIBUTE13 => l_stage_rec.ATTRIBUTE13,
4417: X_ATTRIBUTE14 => l_stage_rec.ATTRIBUTE14,
4418: X_ATTRIBUTE15 => l_stage_rec.ATTRIBUTE15,
4419: X_LAST_UPDATE_DATE => SYSDATE,
4420: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
4421: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );
4422:
4423: IF G_DEBUG='Y' THEN
4424: AHL_DEBUG_PUB.Debug( l_full_name ||': Visit ID =' || l_primary_visit_id);

Line 4421: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );

4417: X_ATTRIBUTE14 => l_stage_rec.ATTRIBUTE14,
4418: X_ATTRIBUTE15 => l_stage_rec.ATTRIBUTE15,
4419: X_LAST_UPDATE_DATE => SYSDATE,
4420: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
4421: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );
4422:
4423: IF G_DEBUG='Y' THEN
4424: AHL_DEBUG_PUB.Debug( l_full_name ||': Visit ID =' || l_primary_visit_id);
4425: AHL_DEBUG_PUB.Debug( l_full_name ||': Stage Number =' || l_stage_rec.Stage_Num);