APPS.FND_MANAGER dependencies on FND_CP_SERVICES

Line 229: from FND_CP_SERVICES

225: svc_id number;
226: begin
227: select SERVICE_ID
228: into svc_id
229: from FND_CP_SERVICES
230: where upper(svc_handle) = upper(SERVICE_HANDLE);
231:
232: return svc_id;
233:

Line 689: select fnd_cp_services_s.nextval

685: svc_id := 5;
686: elsif ( service_handle = 'FNDSM' ) then
687: svc_id := 6;
688: else
689: select fnd_cp_services_s.nextval
690: into svc_id
691: from sys.dual;
692: end if;
693:

Line 699: from FND_CP_SERVICES;

695:
696: if ( OAM_DISPLAY_ORDER is NULL) then
697: select (NVL(max(OAM_DISPLAY_ORDER),0) + 10)
698: into oam_d_o
699: from FND_CP_SERVICES;
700: else
701: oam_d_o := OAM_DISPLAY_ORDER;
702: end if;
703:

Line 719: insert into fnd_cp_services

715: end;
716: end if;
717:
718: /* Do the insert */
719: insert into fnd_cp_services
720: (SERVICE_ID, SERVICE_HANDLE, ALLOW_MULTIPLE_PROC_INSTANCE,
721: ALLOW_MULTIPLE_PROC_NODE, MIGRATE_ON_FAILURE, SERVER_TYPE,
722: ALLOW_SUSPEND, ALLOW_VERIFY, ALLOW_PARAMETER, ALLOW_START,
723: ALLOW_RESTART, PARAMETER_CHANGE_ACTION, LAST_UPDATE_DATE,

Line 743: insert into fnd_cp_services_tl (

739: ENABLED, cart_appl_id, DEBUG_TYPE, ALLOW_MULTIPLE_PROC_SI,
740: DEFAULT_DEBUG_LEVEL
741: from sys.dual;
742:
743: insert into fnd_cp_services_tl (
744: SERVICE_ID, LANGUAGE, SOURCE_LANG, SERVICE_NAME, LAST_UPDATE_DATE,
745: LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY, DESCRIPTION,
746: SERVICE_PLURAL_NAME)
747: select

Line 755: from fnd_cp_services_tl T

751: from FND_LANGUAGES L
752: where L.INSTALLED_FLAG in ('I', 'B')
753: and not exists
754: (select NULL
755: from fnd_cp_services_tl T
756: where T.SERVICE_ID = svc_id
757: and T.LANGUAGE = L.LANGUAGE_CODE);
758:
759: end register_svc;

Line 1267: from fnd_cp_services

1263: message_init;
1264:
1265: select 'Y'
1266: into dummy
1267: from fnd_cp_services
1268: where svc_handle = SERVICE_HANDLE;
1269:
1270: return TRUE;
1271: exception