APPS.EAM_PMDEF_PUB dependencies on EAM_PM_SCHEDULINGS_S

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

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

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

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

Line 1358: update eam_pm_schedulings set

1354: l_act_names
1355: );
1356: if (l_validated and l_validated_act) then
1357:
1358: update eam_pm_schedulings set
1359: ACTIVITY_ASSOCIATION_ID=p_pm_schedule_rec.ACTIVITY_ASSOCIATION_ID,
1360: NON_SCHEDULED_FLAG=p_pm_schedule_rec.NON_SCHEDULED_FLAG,
1361: FROM_EFFECTIVE_DATE=p_pm_schedule_rec.FROM_EFFECTIVE_DATE,
1362: TO_EFFECTIVE_DATE=p_pm_schedule_rec.TO_EFFECTIVE_DATE,

Line 3221: update eam_pm_schedulings set EAM_LAST_CYCLIC_ACT = l_act_assoc_id,

3217:
3218: -- updating the eam_last_cyclic_act field
3219: -- modified for 9754424.
3220: if (l_act_assoc_id is not null) or (l_act_assoc_id <>FND_API.G_MISS_NUM) THEN
3221: update eam_pm_schedulings set EAM_LAST_CYCLIC_ACT = l_act_assoc_id,
3222: last_update_date=sysdate,
3223: last_updated_by=fnd_global.user_id,
3224: last_update_login=fnd_global.login_id
3225: where pm_schedule_id = p_pm_schedule_id;