APPS.EAM_SETNAME_PUB dependencies on EAM_PM_SET_NAMES

Line 14: This procedure inserts a record in the eam_pm_set_names table

10: /* for de-bugging */
11: /* g_sr_no number ; */
12:
13: /*
14: This procedure inserts a record in the eam_pm_set_names table
15: -- Parameters :
16: -- IN : P_API_VERSION IN NUMBER REQUIRED
17: -- P_INIT_MSG_LIST IN VARCHAR2 OPTIONAL
18: -- DEFAULT = FND_API.G_FALSE

Line 183: SELECT EAM_PM_SET_NAMES_S.NEXTVAL INTO L_SET_NAME_ID FROM DUAL;

179:
180:
181: /* End validation calls */
182:
183: SELECT EAM_PM_SET_NAMES_S.NEXTVAL INTO L_SET_NAME_ID FROM DUAL;
184:
185: X_NEW_SET_NAME_ID := L_SET_NAME_ID;
186:
187: INSERT INTO eam_pm_set_names

Line 187: INSERT INTO eam_pm_set_names

183: SELECT EAM_PM_SET_NAMES_S.NEXTVAL INTO L_SET_NAME_ID FROM DUAL;
184:
185: X_NEW_SET_NAME_ID := L_SET_NAME_ID;
186:
187: INSERT INTO eam_pm_set_names
188: (
189: set_name_id ,
190: set_name ,
191: description ,

Line 300: This procedure updates a record in the eam_pm_set_names table

296: END Insert_PMSetName;
297:
298:
299: /*
300: This procedure updates a record in the eam_pm_set_names table
301: -- Parameters :
302: -- IN : P_API_VERSION IN NUMBER REQUIRED
303: -- P_INIT_MSG_LIST IN VARCHAR2 OPTIONAL
304: -- DEFAULT = FND_API.G_FALSE

Line 399: from eam_pm_set_names

395: end if;
396:
397: if p_set_name_id is null then
398: select set_name_id into l_set_name_id
399: from eam_pm_set_names
400: where set_name = p_set_name;
401: else
402: l_set_name_id := p_set_name_id;
403: end if;

Line 461: FROM eam_pm_set_names

457:
458: BEGIN
459: SELECT end_date, local_flag
460: INTO l_end_date, l_local_flag
461: FROM eam_pm_set_names
462: WHERE set_name_id = l_set_name_id;
463: EXCEPTION
464: WHEN NO_DATA_FOUND THEN
465: raise_error('EAM_INVALID_SET_NAME');

Line 531: eam_pm_set_names

527: /* End validation calls */
528:
529:
530: UPDATE
531: eam_pm_set_names
532: SET
533: set_name = p_set_name ,
534: description = p_description ,
535: end_date = p_end_date ,

Line 622: eam_pm_set_names

618:
619: SELECT
620: count (*) into l_status
621: FROM
622: eam_pm_set_names
623: WHERE
624: set_name_id = p_set_name_id
625: and set_name=p_set_name;
626:

Line 648: eam_pm_set_names

644:
645: SELECT
646: count(*) into l_status
647: FROM
648: eam_pm_set_names
649: WHERE
650: set_name = p_set_name ;
651:
652: IF l_status = 0 THEN