APPS.EGO_CATG_MAP_PKG dependencies on EGO_CATG_MAP_HDRS_B

Line 18: cursor C is select ROWID from EGO_CATG_MAP_HDRS_B

14: X_LAST_UPDATE_DATE in DATE,
15: X_LAST_UPDATED_BY in NUMBER,
16: X_LAST_UPDATE_LOGIN in NUMBER
17: ) is
18: cursor C is select ROWID from EGO_CATG_MAP_HDRS_B
19: where CATG_MAP_ID = X_CATG_MAP_ID
20: ;
21: begin
22: insert into EGO_CATG_MAP_HDRS_B (

Line 22: insert into EGO_CATG_MAP_HDRS_B (

18: cursor C is select ROWID from EGO_CATG_MAP_HDRS_B
19: where CATG_MAP_ID = X_CATG_MAP_ID
20: ;
21: begin
22: insert into EGO_CATG_MAP_HDRS_B (
23: CATG_MAP_ID,
24: SOURCE_CATG_SET_ID,
25: TARGET_CATG_SET_ID,
26: ENABLED_FLAG,

Line 96: from EGO_CATG_MAP_HDRS_B

92: cursor c is select
93: SOURCE_CATG_SET_ID,
94: TARGET_CATG_SET_ID,
95: ENABLED_FLAG
96: from EGO_CATG_MAP_HDRS_B
97: where CATG_MAP_ID = X_CATG_MAP_ID
98: for update of CATG_MAP_ID nowait;
99: recinfo c%rowtype;
100:

Line 161: update EGO_CATG_MAP_HDRS_B set

157: X_LAST_UPDATED_BY in NUMBER,
158: X_LAST_UPDATE_LOGIN in NUMBER
159: ) is
160: BEGIN
161: update EGO_CATG_MAP_HDRS_B set
162: SOURCE_CATG_SET_ID = X_SOURCE_CATG_SET_ID,
163: TARGET_CATG_SET_ID = X_TARGET_CATG_SET_ID,
164: ENABLED_FLAG = X_ENABLED_FLAG,
165: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 201: delete from EGO_CATG_MAP_HDRS_B

197: if (sql%notfound) then
198: raise no_data_found;
199: end if;
200:
201: delete from EGO_CATG_MAP_HDRS_B
202: where CATG_MAP_ID = X_CATG_MAP_ID;
203:
204: if (sql%notfound) then
205: raise no_data_found;

Line 230: FROM EGO_CATG_MAP_HDRS_B

226:
227: CURSOR get_catg_map_id(l_source_catg_set_id NUMBER, l_target_catg_set_id NUMBER)
228: IS
229: SELECT CATG_MAP_ID
230: FROM EGO_CATG_MAP_HDRS_B
231: WHERE SOURCE_CATG_SET_ID = l_source_catg_set_id
232: AND TARGET_CATG_SET_ID = l_target_catg_set_id;
233:
234: BEGIN

Line 273: INSERT INTO EGO_CATG_MAP_HDRS_B

269: FETCH get_catg_map_id INTO l_catg_map_id;
270: if (get_catg_map_id%NOTFOUND) THEN
271: select EGO_CATG_MAPS_S.nextval into l_catg_map_id from dual;
272:
273: INSERT INTO EGO_CATG_MAP_HDRS_B
274: (
275: CATG_MAP_ID,
276: SOURCE_CATG_SET_ID,
277: TARGET_CATG_SET_ID,

Line 328: UPDATE EGO_CATG_MAP_HDRS_B

324: AND A.LANGUAGE = L.LANGUAGE_CODE);
325: ELSE
326:
327: -- if it does exist updating the enabled flag and description
328: UPDATE EGO_CATG_MAP_HDRS_B
329: SET ENABLED_FLAG = X_ENABLED_FLAG,
330: LAST_UPDATED_BY = l_current_user_id,
331: LAST_UPDATE_DATE = sysdate,
332: LAST_UPDATE_LOGIN = l_current_login_id

Line 373: FROM EGO_CATG_MAP_HDRS_B

369:
370: CURSOR get_catg_map_id(l_source_catg_set_id NUMBER, l_target_catg_set_id NUMBER)
371: IS
372: SELECT CATG_MAP_ID
373: FROM EGO_CATG_MAP_HDRS_B
374: WHERE SOURCE_CATG_SET_ID = l_source_catg_set_id
375: AND TARGET_CATG_SET_ID = l_target_catg_set_id;
376:
377: CURSOR is_catg_map_dtls_exists(l_catg_map_id NUMBER,

Line 541: from EGO_CATG_MAP_HDRS_B B

537: begin
538: delete from EGO_CATG_MAP_HDRS_TL T
539: where not exists
540: (select NULL
541: from EGO_CATG_MAP_HDRS_B B
542: where B.CATG_MAP_ID = T.CATG_MAP_ID
543: );
544:
545: update EGO_CATG_MAP_HDRS_TL T set (