APPS.EAM_PMDEF_PUB dependencies on DUAL

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 1479: select eam_pm_scheduling_rules_s.nextval into l_rule_id from dual; --Bug#5453536

1475: end if;
1476: n:=1;
1477: while (l_current_rules_tbl.exists(n)) loop
1478:
1479: select eam_pm_scheduling_rules_s.nextval into l_rule_id from dual; --Bug#5453536
1480:
1481: insert into eam_pm_scheduling_rules
1482: ( rule_id,
1483: PM_SCHEDULE_ID,

Line 1897: select 1 into l_count from dual where exists

1893:
1894:
1895: -- validate that the meter id is valid
1896: --added for perofrmance issues
1897: select 1 into l_count from dual where exists
1898: (select COUNTER_ID from CSI_COUNTERS_B where counter_id = p_pm_rule_rec.meter_id
1899: union
1900: select COUNTER_ID from CSI_COUNTER_TEMPLATE_B where counter_id = p_pm_rule_rec.meter_id) ;
1901:

Line 2001: -- validate each rule individually

1997: begin
1998: -- validate each day interval rule
1999:
2000: -- Go through the table one by one,
2001: -- validate each rule individually
2002: -- pick out the one(s) without effective_from or effective_date_to
2003: -- make sure that there can be at most one w/o effective_from_date and at most one w/o effective_date_to,
2004: --and copy the rest to another table.
2005: