eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEU_WP_ACTION_PVT dependencies on IEU_WP_ACTION_MAPS

Line 25: rec_obj IN SYSTEM.IEU_WP_ACTION_MAPS_OBJ

21:
22: PROCEDURE CREATE_action_map (x_return_status OUT NOCOPY VARCHAR2,
23: x_msg_count OUT NOCOPY NUMBER,
24: x_msg_data OUT NOCOPY VARCHAR2,
25: rec_obj IN SYSTEM.IEU_WP_ACTION_MAPS_OBJ
26: ) AS
27:
28: l_action_map_id NUMBER(15);
29: sql_stmt varchar2(2000);

Line 45: EXECUTE IMMEDIATE 'select count(wp_action_map_id) from ieu_wp_action_maps where responsibility_id = :1 '||

41: if (rec_obj.responsibility_id is null) then
42: l_responsibility_id := -2;
43: end if;
44:
45: EXECUTE IMMEDIATE 'select count(wp_action_map_id) from ieu_wp_action_maps where responsibility_id = :1 '||
46: ' and application_id =: 2 and action_param_set_id = :3 and action_map_code= :4 and action_map_type_code = :5 '
47: INTO l_count USING l_responsibility_id, l_application_id, rec_obj.action_param_set_id,
48: rec_obj.action_map_code, rec_obj.action_map_type_code;
49:

Line 51: select IEU_wp_action_maps_S1.NEXTVAL into l_action_map_id from sys.dual;

47: INTO l_count USING l_responsibility_id, l_application_id, rec_obj.action_param_set_id,
48: rec_obj.action_map_code, rec_obj.action_map_type_code;
49:
50: IF (l_count = 0) then
51: select IEU_wp_action_maps_S1.NEXTVAL into l_action_map_id from sys.dual;
52: x_msg_data :=x_msg_data || ' , INSERT INTO maps table with id '|| l_action_map_id;
53: sql_stmt := 'insert INTO IEU_wp_action_mapS'||
54: ' (WP_ACTION_MAP_ID,'||
55: ' OBJECT_VERSION_NUMBER,'||

Line 53: sql_stmt := 'insert INTO IEU_wp_action_mapS'||

49:
50: IF (l_count = 0) then
51: select IEU_wp_action_maps_S1.NEXTVAL into l_action_map_id from sys.dual;
52: x_msg_data :=x_msg_data || ' , INSERT INTO maps table with id '|| l_action_map_id;
53: sql_stmt := 'insert INTO IEU_wp_action_mapS'||
54: ' (WP_ACTION_MAP_ID,'||
55: ' OBJECT_VERSION_NUMBER,'||
56: ' CREATED_BY,'||
57: ' CREATION_DATE,'||

Line 95: EXECUTE IMMEDIATE 'update ieu_wp_action_maps set responsibility_id = null '||

91: rec_obj.responsibility_id,rec_obj.action_map_type_code,rec_obj.action_map_code,
92: rec_obj.action_map_sequence, rec_obj.panel_sec_cat_code, rec_obj.not_valid_flag,
93: rec_obj.dev_data_flag;
94: else if (l_count >0 ) then
95: EXECUTE IMMEDIATE 'update ieu_wp_action_maps set responsibility_id = null '||
96: ' where responsibility_id = -2 and action_param_set_id = :2 '||
97: ' and action_map_code= :3 and action_map_type_code = :4 '
98: USING rec_obj.action_param_set_id,
99: rec_obj.action_map_code, rec_obj.action_map_type_code;

Line 169: EXECUTE IMMEDIATE ' delete from IEU_wp_action_mapS where action_param_set_id = :1 '

165:
166: EXECUTE IMMEDIATE 'delete from IEU_WP_ACT_PARAM_SETS_TL where action_param_set_id = :1 '
167: USING r_param_set_id;
168:
169: EXECUTE IMMEDIATE ' delete from IEU_wp_action_mapS where action_param_set_id = :1 '
170: USING r_param_set_id;
171:
172:
173: if (sql%notfound) then

Line 285: rec_obj IN SYSTEM.IEU_WP_ACTION_MAPS_OBJ

281:
282: PROCEDURE UPDATE_action_map (x_return_status OUT NOCOPY VARCHAR2,
283: x_msg_count OUT NOCOPY NUMBER,
284: x_msg_data OUT NOCOPY VARCHAR2,
285: rec_obj IN SYSTEM.IEU_WP_ACTION_MAPS_OBJ
286: ) AS
287:
288: l_cur_obj_versn NUMBER;
289:

Line 297: execute immediate 'select unique(object_version_number) from ieu_wp_action_maps where wp_action_map_ID = :1'

293: x_return_status := fnd_api.g_ret_sts_success;
294: FND_MSG_PUB.initialize;
295: x_msg_data := '';
296:
297: execute immediate 'select unique(object_version_number) from ieu_wp_action_maps where wp_action_map_ID = :1'
298: into l_cur_obj_versn using rec_obj.wp_action_map_id;
299:
300:
301: EXECUTE IMMEDIATE

Line 302: ' update IEU_WP_ACTION_MAPS '||

298: into l_cur_obj_versn using rec_obj.wp_action_map_id;
299:
300:
301: EXECUTE IMMEDIATE
302: ' update IEU_WP_ACTION_MAPS '||
303: ' set ' ||
304: ' OBJECT_VERSION_NUMBER = l_cur_obj_versn+1, '||
305: ' LAST_UPDATED_BY = FND_GLOBAL.USER_ID, '||
306: ' LAST_UPDATE_DATE = SYSDATE, '||

Line 360: r_action_param_set_id IN IEU_WP_ACTION_MAPS.action_param_set_id%type,

356:
357: PROCEDURE UPDATE_action_map_sequence (x_return_status OUT NOCOPY VARCHAR2,
358: x_msg_count OUT NOCOPY NUMBER,
359: x_msg_data OUT NOCOPY VARCHAR2,
360: r_action_param_set_id IN IEU_WP_ACTION_MAPS.action_param_set_id%type,
361: r_MACTION_DEF_TYPE_FLAG IN IEU_UWQ_MACTION_DEFS_B.MACTION_DEF_TYPE_FLAG %type,
362: r_application_id IN IEU_WP_ACTION_MAPS.application_id%type,
363: r_sel_enum_id IN IEU_UWQ_SEL_ENUMERATORS.sel_enum_id%type,
364: r_action_map_sequence IN IEU_WP_ACTION_MAPS.action_map_sequence%type,

Line 362: r_application_id IN IEU_WP_ACTION_MAPS.application_id%type,

358: x_msg_count OUT NOCOPY NUMBER,
359: x_msg_data OUT NOCOPY VARCHAR2,
360: r_action_param_set_id IN IEU_WP_ACTION_MAPS.action_param_set_id%type,
361: r_MACTION_DEF_TYPE_FLAG IN IEU_UWQ_MACTION_DEFS_B.MACTION_DEF_TYPE_FLAG %type,
362: r_application_id IN IEU_WP_ACTION_MAPS.application_id%type,
363: r_sel_enum_id IN IEU_UWQ_SEL_ENUMERATORS.sel_enum_id%type,
364: r_action_map_sequence IN IEU_WP_ACTION_MAPS.action_map_sequence%type,
365: r_not_valid_flag IN IEU_WP_ACTION_MAPS.not_valid_flag%type
366: ) AS

Line 364: r_action_map_sequence IN IEU_WP_ACTION_MAPS.action_map_sequence%type,

360: r_action_param_set_id IN IEU_WP_ACTION_MAPS.action_param_set_id%type,
361: r_MACTION_DEF_TYPE_FLAG IN IEU_UWQ_MACTION_DEFS_B.MACTION_DEF_TYPE_FLAG %type,
362: r_application_id IN IEU_WP_ACTION_MAPS.application_id%type,
363: r_sel_enum_id IN IEU_UWQ_SEL_ENUMERATORS.sel_enum_id%type,
364: r_action_map_sequence IN IEU_WP_ACTION_MAPS.action_map_sequence%type,
365: r_not_valid_flag IN IEU_WP_ACTION_MAPS.not_valid_flag%type
366: ) AS
367:
368: l_cur_obj_versn NUMBER;

Line 365: r_not_valid_flag IN IEU_WP_ACTION_MAPS.not_valid_flag%type

361: r_MACTION_DEF_TYPE_FLAG IN IEU_UWQ_MACTION_DEFS_B.MACTION_DEF_TYPE_FLAG %type,
362: r_application_id IN IEU_WP_ACTION_MAPS.application_id%type,
363: r_sel_enum_id IN IEU_UWQ_SEL_ENUMERATORS.sel_enum_id%type,
364: r_action_map_sequence IN IEU_WP_ACTION_MAPS.action_map_sequence%type,
365: r_not_valid_flag IN IEU_WP_ACTION_MAPS.not_valid_flag%type
366: ) AS
367:
368: l_cur_obj_versn NUMBER;
369: v_type_code varchar2(100);

Line 370: v_ver_number ieu_wp_action_maps.object_version_number%type;

366: ) AS
367:
368: l_cur_obj_versn NUMBER;
369: v_type_code varchar2(100);
370: v_ver_number ieu_wp_action_maps.object_version_number%type;
371: v_MACTION_DEF_TYPE_FLAG ieu_uwq_maction_defs_b.MACTION_DEF_TYPE_FLAG%type;
372: v_action_param_set_id ieu_wp_action_maps.action_param_set_id%type;
373: v_application_id ieu_wp_action_maps.application_id%type;
374: v_sel_enum_id ieu_uwq_sel_enumerators.sel_enum_id%type;

Line 372: v_action_param_set_id ieu_wp_action_maps.action_param_set_id%type;

368: l_cur_obj_versn NUMBER;
369: v_type_code varchar2(100);
370: v_ver_number ieu_wp_action_maps.object_version_number%type;
371: v_MACTION_DEF_TYPE_FLAG ieu_uwq_maction_defs_b.MACTION_DEF_TYPE_FLAG%type;
372: v_action_param_set_id ieu_wp_action_maps.action_param_set_id%type;
373: v_application_id ieu_wp_action_maps.application_id%type;
374: v_sel_enum_id ieu_uwq_sel_enumerators.sel_enum_id%type;
375: CURSOR c_cursor is
376: select m.WP_ACTION_MAP_ID, m.object_version_number

Line 373: v_application_id ieu_wp_action_maps.application_id%type;

369: v_type_code varchar2(100);
370: v_ver_number ieu_wp_action_maps.object_version_number%type;
371: v_MACTION_DEF_TYPE_FLAG ieu_uwq_maction_defs_b.MACTION_DEF_TYPE_FLAG%type;
372: v_action_param_set_id ieu_wp_action_maps.action_param_set_id%type;
373: v_application_id ieu_wp_action_maps.application_id%type;
374: v_sel_enum_id ieu_uwq_sel_enumerators.sel_enum_id%type;
375: CURSOR c_cursor is
376: select m.WP_ACTION_MAP_ID, m.object_version_number
377: from ieu_wp_action_maps m, ieu_uwq_maction_defs_b db,

Line 377: from ieu_wp_action_maps m, ieu_uwq_maction_defs_b db,

373: v_application_id ieu_wp_action_maps.application_id%type;
374: v_sel_enum_id ieu_uwq_sel_enumerators.sel_enum_id%type;
375: CURSOR c_cursor is
376: select m.WP_ACTION_MAP_ID, m.object_version_number
377: from ieu_wp_action_maps m, ieu_uwq_maction_defs_b db,
378: ieu_wp_act_param_sets_b sb
379: where m.action_map_type_code = v_type_code
380: --and m.application_id = db.application_id
381: and db.maction_def_type_flag= v_MACTION_DEF_TYPE_FLAG

Line 392: from ieu_wp_action_maps m, ieu_uwq_maction_defs_b db,

388: where sel_enum_id = v_sel_enum_id);
389: c_rec c_cursor%ROWTYPE;
390: CURSOR c_cursor2 is
391: select m.WP_ACTION_MAP_ID, m.object_version_number
392: from ieu_wp_action_maps m, ieu_uwq_maction_defs_b db,
393: ieu_wp_act_param_sets_b sb, ieu_uwq_node_ds ds
394: where m.action_map_type_code = v_type_code
395: --and m.application_id = db.application_id
396: and db.maction_def_type_flag= 'F'

Line 428: ' update IEU_WP_ACTION_MAPS '||

424: v_ver_number := c_rec.object_version_number+1 ;
425: end if;
426: IF r_not_valid_flag IS NOT NULL then
427: EXECUTE immediate
428: ' update IEU_WP_ACTION_MAPS '||
429: ' set ' ||
430: ' OBJECT_VERSION_NUMBER = :1, '||
431: ' LAST_UPDATED_BY = FND_GLOBAL.USER_ID, '||
432: ' LAST_UPDATE_DATE = SYSDATE, '||

Line 440: ' update IEU_WP_ACTION_MAPS ' ||

436: ' where WP_ACTION_MAP_ID = :4 '
437: USING v_ver_number, r_action_map_sequence, r_not_valid_flag, c_rec.wp_action_map_id;
438: else
439: EXECUTE immediate
440: ' update IEU_WP_ACTION_MAPS ' ||
441: ' set ' ||
442: ' OBJECT_VERSION_NUMBER = :1 , '||
443: ' LAST_UPDATED_BY = FND_GLOBAL.USER_ID, '||
444: ' LAST_UPDATE_DATE = SYSDATE, '||

Line 467: ' update IEU_WP_ACTION_MAPS '||

463: v_ver_number := c_rec.object_version_number+1 ;
464: end if;
465: IF r_not_valid_flag IS NOT NULL then
466: EXECUTE immediate
467: ' update IEU_WP_ACTION_MAPS '||
468: ' SET '||
469: ' OBJECT_VERSION_NUMBER = :1 , '||
470: ' LAST_UPDATED_BY = FND_GLOBAL.USER_ID, '||
471: ' LAST_UPDATE_DATE = SYSDATE, '||

Line 479: ' update IEU_WP_ACTION_MAPS '||

475: ' where WP_ACTION_MAP_ID = :4 '
476: USING v_ver_number, r_action_map_sequence, r_not_valid_flag, c_rec2.wp_action_map_id;
477: else
478: EXECUTE immediate
479: ' update IEU_WP_ACTION_MAPS '||
480: ' SET '||
481: ' OBJECT_VERSION_NUMBER = :1 , '||
482: ' LAST_UPDATED_BY = FND_GLOBAL.USER_ID, '||
483: ' LAST_UPDATE_DATE = SYSDATE, '||

Line 545: ' from ieu_wp_action_maps where wp_action_map_id = :1 '||

541: x_return_status := fnd_api.g_ret_sts_success;
542: FND_MSG_PUB.initialize;
543: x_msg_data := '';
544: execute immediate ' select count(*) '||
545: ' from ieu_wp_action_maps where wp_action_map_id = :1 '||
546: ' and responsibility_id is null'
547: into l_count
548: using r_action_map_id;
549: x_msg_data := x_msg_data || ' count is '|| l_count;

Line 552: ' delete from IEU_wp_action_mapS '||

548: using r_action_map_id;
549: x_msg_data := x_msg_data || ' count is '|| l_count;
550: if (l_count <> 1) then
551: EXECUTE immediate
552: ' delete from IEU_wp_action_mapS '||
553: ' where wp_action_map_ID = :1 '
554: USING r_action_map_id;
555: else
556: execute immediate

Line 557: ' update ieu_wp_action_maps set responsibility_id = -2 ' ||

553: ' where wp_action_map_ID = :1 '
554: USING r_action_map_id;
555: else
556: execute immediate
557: ' update ieu_wp_action_maps set responsibility_id = -2 ' ||
558: ' where wp_action_map_id = :1 '
559: using r_action_map_id;
560: end if;
561:

Line 648: l_temp_map_sequence ieu_wp_action_maps.action_map_sequence%type;

644: l_value_override_flag varchar(5);
645: v_numrows1 NUMBER;
646: l_new_param_set_id NUMBER(15);
647: l_wp_action_map_id NUMBER(15);
648: l_temp_map_sequence ieu_wp_action_maps.action_map_sequence%type;
649:
650:
651: BEGIN
652:

Line 736: l_temp_map_sequence ieu_wp_action_maps.action_map_sequence%type;

732: l_value_override_flag varchar(5);
733: v_numrows1 NUMBER;
734: l_new_param_set_id NUMBER(15);
735: l_wp_action_map_id NUMBER(15);
736: l_temp_map_sequence ieu_wp_action_maps.action_map_sequence%type;
737: param_sets_rec IEU_WP_ACT_PARAM_SETS_SEED_PKG.WP_ACT_PARAM_SETS_rec_type;
738: param_props_rec IEU_WP_PARAM_PROPS_SEED_PKG.wp_param_props_rec_type;
739: v_SelectStmt Varchar2(500);
740: v_CursorID INTEGER;

Line 745: v_responsibility_id ieu_wp_action_maps.responsibility_id%type;

741: v_Dummy INTEGER;
742: v_param_set_id ieu_wp_param_props_b.action_param_set_id%type;
743: v_language ieu_wp_param_props_tl.language%type;
744: v_enumId ieu_uwq_sel_enumerators.sel_enum_id%type;
745: v_responsibility_id ieu_wp_action_maps.responsibility_id%type;
746: cursor c_cur is
747: SELECT
748: PARAM_ID, PROPERTY_ID,property_value
749: , value_override_flag,not_valid_flag

Line 760: from ieu_wp_action_maps

756: and c.maction_def_key = LTRIM(RTRIM(v_wp_action_key))
757: and b.language = v_language
758: and c.maction_def_id = a.wp_action_def_id
759: and a.action_param_set_id in (select action_param_set_id
760: from ieu_wp_action_maps
761: where action_map_code in (select enum_type_uuid from ieu_uwq_sel_enumerators
762: where sel_enum_id =v_enumId
763: )
764: )

Line 771: FROM ieu_wp_action_maps

767: cursor c_cur2 is
768: SELECT
769: object_version_number, application_id, action_map_type_code,
770: action_map_code, panel_sec_cat_code, not_valid_flag
771: FROM ieu_wp_action_maps
772: WHERE responsibility_id = v_responsibility_id
773: AND action_param_set_id in
774: (select a.action_param_set_id
775: from ieu_wp_act_param_sets_b a, ieu_wp_act_param_sets_tl b, ieu_uwq_maction_defs_b c

Line 889: ' from ieu_wp_action_maps m, ieu_uwq_maction_defs_b db, '||

885: EXIT WHEN c_cur2%NOTFOUND;
886: ReOrdering(x_return_status,x_msg_count,x_msg_data,r_enumId ,c_rec2.application_id ,'W');
887: EXECUTE immediate
888: ' select max(m.action_map_sequence) '||
889: ' from ieu_wp_action_maps m, ieu_uwq_maction_defs_b db, '||
890: ' ieu_wp_act_param_sets_b sb '||
891: -- ' where m.application_id = :1 '||
892: ' where m.action_map_type_code = :1 '||
893: ' and m.action_map_code = :2 '||

Line 907: select IEU_WP_ACTION_MAPS_S1.NEXTVAL into l_wp_action_map_id from sys.dual;

903: END if;
904:
905:
906: --INSERT one RECORD WITH responsibility_id = -1
907: select IEU_WP_ACTION_MAPS_S1.NEXTVAL into l_wp_action_map_id from sys.dual;
908: EXECUTE immediate
909: ' insert INTO IEU_WP_ACTION_MAPS ' ||
910: ' (WP_ACTION_MAP_ID, '||
911: ' CREATED_BY, '||

Line 909: ' insert INTO IEU_WP_ACTION_MAPS ' ||

905:
906: --INSERT one RECORD WITH responsibility_id = -1
907: select IEU_WP_ACTION_MAPS_S1.NEXTVAL into l_wp_action_map_id from sys.dual;
908: EXECUTE immediate
909: ' insert INTO IEU_WP_ACTION_MAPS ' ||
910: ' (WP_ACTION_MAP_ID, '||
911: ' CREATED_BY, '||
912: ' CREATION_DATE, '||
913: ' LAST_UPDATED_BY, '||

Line 951: select IEU_WP_ACTION_MAPS_S1.NEXTVAL into l_wp_action_map_id from sys.dual;

947: l_temp_map_sequence, r_dev_data_flag;
948:
949:
950: --INSERT one RECORD WITH responsibility_id IS null
951: select IEU_WP_ACTION_MAPS_S1.NEXTVAL into l_wp_action_map_id from sys.dual;
952: v_responsibility_id := null;
953: EXECUTE immediate
954: ' insert INTO IEU_WP_ACTION_MAPS '||
955: ' (WP_ACTION_MAP_ID, '||

Line 954: ' insert INTO IEU_WP_ACTION_MAPS '||

950: --INSERT one RECORD WITH responsibility_id IS null
951: select IEU_WP_ACTION_MAPS_S1.NEXTVAL into l_wp_action_map_id from sys.dual;
952: v_responsibility_id := null;
953: EXECUTE immediate
954: ' insert INTO IEU_WP_ACTION_MAPS '||
955: ' (WP_ACTION_MAP_ID, '||
956: ' CREATED_BY, '||
957: ' CREATION_DATE, '||
958: ' LAST_UPDATED_BY, '||

Line 1296: v_applId ieu_wp_action_maps.application_id%type;

1292: r_panel IN VARCHAR2)
1293: As
1294:
1295: v_enumId ieu_uwq_Sel_enumerators.sel_enum_id%type;
1296: v_applId ieu_wp_action_maps.application_id%type;
1297: v_panel ieu_uwq_maction_defs_b.maction_def_type_flag%type;
1298:
1299: cursor c_cur is
1300: select d.action_param_set_label, b.action_map_sequence,

Line 1302: from ieu_uwq_Sel_enumerators a, ieu_wp_action_maps b,

1298:
1299: cursor c_cur is
1300: select d.action_param_set_label, b.action_map_sequence,
1301: d.action_param_set_desc , e.action_user_label, b.not_valid_flag,c.action_param_set_id
1302: from ieu_uwq_Sel_enumerators a, ieu_wp_action_maps b,
1303: ieu_wp_act_param_sets_b c, ieu_wp_act_param_sets_tl d,
1304: ieu_uwq_maction_defs_tl e , ieu_uwq_maction_defs_b f
1305: where a.sel_enum_id =v_enumId
1306: and f.maction_def_type_flag = v_panel

Line 1320: v_action_map_type_code ieu_wp_action_maps.action_map_type_code%type;

1316: order by b.action_map_sequence;
1317:
1318: c_rec c_cur%ROWTYPE;
1319:
1320: v_action_map_type_code ieu_wp_action_maps.action_map_type_code%type;
1321:
1322: cursor c_cur2 is
1323: select d.action_param_set_label, b.action_map_sequence,
1324: d.action_param_set_desc , e.action_user_label, b.not_valid_flag,c.action_param_set_id

Line 1325: from ieu_uwq_Sel_enumerators a, ieu_wp_action_maps b,

1321:
1322: cursor c_cur2 is
1323: select d.action_param_set_label, b.action_map_sequence,
1324: d.action_param_set_desc , e.action_user_label, b.not_valid_flag,c.action_param_set_id
1325: from ieu_uwq_Sel_enumerators a, ieu_wp_action_maps b,
1326: ieu_wp_act_param_sets_b c, ieu_wp_act_param_sets_tl d,
1327: ieu_uwq_maction_defs_tl e , ieu_uwq_maction_defs_b f, ieu_uwq_node_ds ds
1328: where a.sel_enum_id =v_enumId
1329: and f.maction_def_type_flag = v_panel

Line 1365: ' update ieu_wp_action_maps '||

1361: if (c_rec2.action_map_sequence IS NULL OR l_count <> c_rec2.action_map_sequence) then
1362:
1363: IF (c_rec2.action_map_sequence IS null) THEN
1364: EXECUTE immediate
1365: ' update ieu_wp_action_maps '||
1366: ' set action_map_sequence = :1 '||
1367: ' where action_map_sequence IS null '||
1368: ' and ACTION_MAP_TYPE_CODE = :2 '||
1369: ' and action_param_set_id = :3 '||

Line 1384: ' update ieu_wp_action_maps '||

1380: --USING l_count, r_applId,'NODE_DS', c_rec2.action_param_set_id, r_enumId ;
1381: USING l_count, 'NODE_DS', c_rec2.action_param_set_id, r_enumId ;
1382: ELSE
1383: EXECUTE immediate
1384: ' update ieu_wp_action_maps '||
1385: ' set action_map_sequence = :1 '||
1386: ' where action_map_sequence = :2 '||
1387: ' and ACTION_MAP_TYPE_CODE = :3 ' ||
1388: ' and action_param_set_id = :4 '||

Line 1418: ' update ieu_wp_action_maps '||

1414: EXIT WHEN c_cur%NOTFOUND;
1415: if (c_rec.action_map_sequence IS NULL OR l_count <> c_rec.action_map_sequence) then
1416: IF (c_rec.action_map_sequence IS null) THEN
1417: EXECUTE immediate
1418: ' update ieu_wp_action_maps '||
1419: ' set action_map_sequence = :1 '||
1420: ' where action_map_sequence IS null '||
1421: ' and action_param_set_id = :2 '||
1422: /*******************ADD FOR FORWARD PORT BUG5585922 BY MAJHA**********************/

Line 1432: ' update ieu_wp_action_maps '||

1428: --USING l_count,r_applId, c_rec.action_param_set_id, r_enumId ;
1429: USING l_count, c_rec.action_param_set_id, r_enumId ;
1430: ELSE
1431: EXECUTE immediate
1432: ' update ieu_wp_action_maps '||
1433: ' set action_map_sequence = :1'||
1434: ' where action_map_sequence = :2 '||
1435: ' and action_param_set_id = :3 '||
1436: /*******************ADD FOR FORWARD PORT BUG5585922 BY MAJHA**********************/

Line 1493: l_temp_map_sequence ieu_wp_action_maps.action_map_sequence%type;

1489: l_value_override_flag varchar(5);
1490: v_numrows1 NUMBER;
1491: l_new_param_set_id NUMBER(15);
1492: l_wp_action_map_id NUMBER(15);
1493: l_temp_map_sequence ieu_wp_action_maps.action_map_sequence%type;
1494: param_sets_rec IEU_WP_ACT_PARAM_SETS_SEED_PKG.WP_ACT_PARAM_SETS_rec_type;
1495: param_props_rec IEU_WP_PARAM_PROPS_SEED_PKG.wp_param_props_rec_type;
1496: v_SelectStmt Varchar2(500);
1497: v_CursorID INTEGER;

Line 1518: from ieu_wp_action_maps

1514: and c.maction_def_key = LTRIM(RTRIM(v_wp_action_key))
1515: and b.language = v_language
1516: and c.maction_def_id = a.wp_action_def_id
1517: and a.action_param_set_id in (select action_param_set_id
1518: from ieu_wp_action_maps
1519: where action_map_code in (SELECT to_char(ds.NODE_DS_ID) FROM ieu_uwq_sel_enumerators e,
1520: ieu_uwq_node_ds ds
1521: WHERE e.sel_enum_id = v_enumId
1522: and e.ENUM_TYPE_UUID = ds.ENUM_TYPE_UUID)

Line 1533: FROM ieu_wp_action_maps

1529: cursor c_cur2 is
1530: SELECT
1531: object_version_number, application_id, action_map_type_code,
1532: action_map_code, panel_sec_cat_code, not_valid_flag
1533: FROM ieu_wp_action_maps
1534: WHERE responsibility_id = -1
1535: AND action_param_set_id in
1536: (select a.action_param_set_id
1537: from ieu_wp_act_param_sets_b a, ieu_wp_act_param_sets_tl b, ieu_uwq_maction_defs_b c

Line 1644: select IEU_WP_ACTION_MAPS_S1.NEXTVAL into l_wp_action_map_id from sys.dual;

1640: FETCH c_cur2 INTO c_rec2;
1641: EXIT WHEN c_cur2%NOTFOUND;
1642: l_temp_map_sequence := 1;
1643: --INSERT one RECORD WITH responsibility_id = -1
1644: select IEU_WP_ACTION_MAPS_S1.NEXTVAL into l_wp_action_map_id from sys.dual;
1645: EXECUTE immediate
1646: ' insert INTO IEU_WP_ACTION_MAPS '||
1647: ' (WP_ACTION_MAP_ID, '||
1648: ' CREATED_BY, '||

Line 1646: ' insert INTO IEU_WP_ACTION_MAPS '||

1642: l_temp_map_sequence := 1;
1643: --INSERT one RECORD WITH responsibility_id = -1
1644: select IEU_WP_ACTION_MAPS_S1.NEXTVAL into l_wp_action_map_id from sys.dual;
1645: EXECUTE immediate
1646: ' insert INTO IEU_WP_ACTION_MAPS '||
1647: ' (WP_ACTION_MAP_ID, '||
1648: ' CREATED_BY, '||
1649: ' CREATION_DATE, '||
1650: ' LAST_UPDATED_BY, '||