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:
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---------------------------------------
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
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---------------------------------------
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
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: );
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;
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:
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:
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);
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);
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:
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;
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:
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,
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,
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,
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: );
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;
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;
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: );
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
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
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,
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,
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,
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);
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);