APPS.EAM_PMDEF_PUB dependencies on EAM_PM_SCHEDULINGS_S

Line 170: select eam_pm_schedulings_s.nextval into l_pm_schedule_id from dual;

166: FND_MSG_PUB.Add;
167: RAISE FND_API.G_EXC_ERROR;
168: end;
169:
170: select eam_pm_schedulings_s.nextval into l_pm_schedule_id from dual;
171:
172: -- If the source pm is not a template, raise error
173: if (not (pm_header_row.tmpl_flag = 'Y')) then
174: FND_MESSAGE.SET_NAME('EAM', 'EAM_PM_INST_NOT_TMPL');

Line 853: select eam_pm_schedulings_s.nextval into l_pm_schedule_id from dual;

849: FND_MSG_PUB.Add;
850: RAISE FND_API.G_EXC_ERROR;
851: END IF;
852:
853: select eam_pm_schedulings_s.nextval into l_pm_schedule_id from dual;
854:
855:
856: insert into eam_pm_schedulings (
857: PM_SCHEDULE_ID,

Line 1317: update eam_pm_schedulings set

1313: l_act_names
1314: );
1315: if (l_validated and l_validated_act) then
1316:
1317: update eam_pm_schedulings set
1318: ACTIVITY_ASSOCIATION_ID=p_pm_schedule_rec.ACTIVITY_ASSOCIATION_ID,
1319: NON_SCHEDULED_FLAG=p_pm_schedule_rec.NON_SCHEDULED_FLAG,
1320: FROM_EFFECTIVE_DATE=p_pm_schedule_rec.FROM_EFFECTIVE_DATE,
1321: TO_EFFECTIVE_DATE=p_pm_schedule_rec.TO_EFFECTIVE_DATE,

Line 3115: update eam_pm_schedulings set EAM_LAST_CYCLIC_ACT = l_act_assoc_id,

3111: end if;
3112:
3113: -- updating the eam_last_cyclic_act field
3114:
3115: update eam_pm_schedulings set EAM_LAST_CYCLIC_ACT = l_act_assoc_id,
3116: last_update_date=sysdate,
3117: last_updated_by=fnd_global.user_id,
3118: creation_date=sysdate,
3119: last_update_login=fnd_global.login_id,