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 FND_GLOBAL

Line 89: EXECUTE IMMEDIATE sql_stmt USING l_action_map_id, '1',FND_GLOBAL.USER_ID, SYSDATE,

85: ' :14,'||
86: ' :15,'||
87: ' :16 '||
88: ' )';
89: EXECUTE IMMEDIATE sql_stmt USING l_action_map_id, '1',FND_GLOBAL.USER_ID, SYSDATE,
90: FND_GLOBAL.USER_ID,SYSDATE,FND_GLOBAL.LOGIN_ID, rec_obj.action_param_set_id, rec_obj.application_id,
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;

Line 90: FND_GLOBAL.USER_ID,SYSDATE,FND_GLOBAL.LOGIN_ID, rec_obj.action_param_set_id, rec_obj.application_id,

86: ' :15,'||
87: ' :16 '||
88: ' )';
89: EXECUTE IMMEDIATE sql_stmt USING l_action_map_id, '1',FND_GLOBAL.USER_ID, SYSDATE,
90: FND_GLOBAL.USER_ID,SYSDATE,FND_GLOBAL.LOGIN_ID, rec_obj.action_param_set_id, rec_obj.application_id,
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

Line 233: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

229: BEGIN
230: fnd_msg_pub.delete_msg();
231: x_return_status := fnd_api.g_ret_sts_success;
232: FND_MSG_PUB.initialize;
233: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
234: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
235: x_msg_data := '';
236: execute immediate ' update IEU_WP_ACT_PARAM_SETS_TL ' ||
237: ' set ' ||

Line 234: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

230: fnd_msg_pub.delete_msg();
231: x_return_status := fnd_api.g_ret_sts_success;
232: FND_MSG_PUB.initialize;
233: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
234: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
235: x_msg_data := '';
236: execute immediate ' update IEU_WP_ACT_PARAM_SETS_TL ' ||
237: ' set ' ||
238: ' LAST_UPDATED_BY = FND_GLOBAL.USER_ID, ' ||

Line 238: ' LAST_UPDATED_BY = FND_GLOBAL.USER_ID, ' ||

234: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
235: x_msg_data := '';
236: execute immediate ' update IEU_WP_ACT_PARAM_SETS_TL ' ||
237: ' set ' ||
238: ' LAST_UPDATED_BY = FND_GLOBAL.USER_ID, ' ||
239: ' LAST_UPDATE_DATE = SYSDATE, '||
240: ' LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID, '||
241: ' ACTION_PARAM_SET_LABEL = :1 , '||
242: ' ACTION_PARAM_SET_DESC = :2 ' ||

Line 240: ' LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID, '||

236: execute immediate ' update IEU_WP_ACT_PARAM_SETS_TL ' ||
237: ' set ' ||
238: ' LAST_UPDATED_BY = FND_GLOBAL.USER_ID, ' ||
239: ' LAST_UPDATE_DATE = SYSDATE, '||
240: ' LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID, '||
241: ' ACTION_PARAM_SET_LABEL = :1 , '||
242: ' ACTION_PARAM_SET_DESC = :2 ' ||
243: ' where ACTION_PARAM_SET_ID = :3 ' ||
244: ' and language IN (:4 , :5 )'

Line 305: ' LAST_UPDATED_BY = FND_GLOBAL.USER_ID, '||

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, '||
307: ' LAST_UPDATE_LOGIN =FND_GLOBAL.LOGIN_ID, '||
308: /*******************ADD FOR FORWARD PORT BUG5585922 BY MAJHA**********************/
309: -- ' ACTION_MAP_SEQUENCE = :1, '||

Line 307: ' LAST_UPDATE_LOGIN =FND_GLOBAL.LOGIN_ID, '||

303: ' set ' ||
304: ' OBJECT_VERSION_NUMBER = l_cur_obj_versn+1, '||
305: ' LAST_UPDATED_BY = FND_GLOBAL.USER_ID, '||
306: ' LAST_UPDATE_DATE = SYSDATE, '||
307: ' LAST_UPDATE_LOGIN =FND_GLOBAL.LOGIN_ID, '||
308: /*******************ADD FOR FORWARD PORT BUG5585922 BY MAJHA**********************/
309: -- ' ACTION_MAP_SEQUENCE = :1, '||
310: ' ACTION_MAP_SEQUENCE = :1 '||
311: /*********************************************************************************/

Line 431: ' LAST_UPDATED_BY = FND_GLOBAL.USER_ID, '||

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, '||
433: ' LAST_UPDATE_LOGIN =FND_GLOBAL.LOGIN_ID, '||
434: ' ACTION_MAP_SEQUENCE = :2 , '||
435: ' NOT_VALID_FLAG = :3 '||

Line 433: ' LAST_UPDATE_LOGIN =FND_GLOBAL.LOGIN_ID, '||

429: ' set ' ||
430: ' OBJECT_VERSION_NUMBER = :1, '||
431: ' LAST_UPDATED_BY = FND_GLOBAL.USER_ID, '||
432: ' LAST_UPDATE_DATE = SYSDATE, '||
433: ' LAST_UPDATE_LOGIN =FND_GLOBAL.LOGIN_ID, '||
434: ' ACTION_MAP_SEQUENCE = :2 , '||
435: ' NOT_VALID_FLAG = :3 '||
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;

Line 443: ' LAST_UPDATED_BY = FND_GLOBAL.USER_ID, '||

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, '||
445: ' LAST_UPDATE_LOGIN =FND_GLOBAL.LOGIN_ID, '||
446: ' ACTION_MAP_SEQUENCE = :2'||
447: ' where WP_ACTION_MAP_ID = :3 '

Line 445: ' LAST_UPDATE_LOGIN =FND_GLOBAL.LOGIN_ID, '||

441: ' set ' ||
442: ' OBJECT_VERSION_NUMBER = :1 , '||
443: ' LAST_UPDATED_BY = FND_GLOBAL.USER_ID, '||
444: ' LAST_UPDATE_DATE = SYSDATE, '||
445: ' LAST_UPDATE_LOGIN =FND_GLOBAL.LOGIN_ID, '||
446: ' ACTION_MAP_SEQUENCE = :2'||
447: ' where WP_ACTION_MAP_ID = :3 '
448: USING v_ver_number, r_action_map_sequence, c_rec.wp_action_map_id;
449: END if;

Line 470: ' LAST_UPDATED_BY = FND_GLOBAL.USER_ID, '||

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, '||
472: ' LAST_UPDATE_LOGIN =FND_GLOBAL.LOGIN_ID, '||
473: ' ACTION_MAP_SEQUENCE = :2 , '||
474: ' NOT_VALID_FLAG = :3 '||

Line 472: ' LAST_UPDATE_LOGIN =FND_GLOBAL.LOGIN_ID, '||

468: ' SET '||
469: ' OBJECT_VERSION_NUMBER = :1 , '||
470: ' LAST_UPDATED_BY = FND_GLOBAL.USER_ID, '||
471: ' LAST_UPDATE_DATE = SYSDATE, '||
472: ' LAST_UPDATE_LOGIN =FND_GLOBAL.LOGIN_ID, '||
473: ' ACTION_MAP_SEQUENCE = :2 , '||
474: ' NOT_VALID_FLAG = :3 '||
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;

Line 482: ' LAST_UPDATED_BY = FND_GLOBAL.USER_ID, '||

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, '||
484: ' LAST_UPDATE_LOGIN =FND_GLOBAL.LOGIN_ID, '||
485: ' ACTION_MAP_SEQUENCE = :2 '||
486: ' where WP_ACTION_MAP_ID = :3 '

Line 484: ' LAST_UPDATE_LOGIN =FND_GLOBAL.LOGIN_ID, '||

480: ' SET '||
481: ' OBJECT_VERSION_NUMBER = :1 , '||
482: ' LAST_UPDATED_BY = FND_GLOBAL.USER_ID, '||
483: ' LAST_UPDATE_DATE = SYSDATE, '||
484: ' LAST_UPDATE_LOGIN =FND_GLOBAL.LOGIN_ID, '||
485: ' ACTION_MAP_SEQUENCE = :2 '||
486: ' where WP_ACTION_MAP_ID = :3 '
487: USING v_ver_number, r_action_map_sequence, c_rec2.wp_action_map_id;
488: END if;

Line 656: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

652:
653: fnd_msg_pub.delete_msg();
654: x_return_status := fnd_api.g_ret_sts_success;
655: FND_MSG_PUB.initialize;
656: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
657: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
658: x_msg_data := '';
659:
660:

Line 657: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

653: fnd_msg_pub.delete_msg();
654: x_return_status := fnd_api.g_ret_sts_success;
655: FND_MSG_PUB.initialize;
656: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
657: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
658: x_msg_data := '';
659:
660:
661: IEU_WP_ACTION_PVT.CreateFromAction2( x_return_status, x_msg_count,

Line 793: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

789:
790: fnd_msg_pub.delete_msg();
791: x_return_status := fnd_api.g_ret_sts_success;
792: FND_MSG_PUB.initialize;
793: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
794: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
795: x_msg_data := '';
796:
797:

Line 794: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

790: fnd_msg_pub.delete_msg();
791: x_return_status := fnd_api.g_ret_sts_success;
792: FND_MSG_PUB.initialize;
793: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
794: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
795: x_msg_data := '';
796:
797:
798: execute immediate ' select a.wp_action_def_id ' ||

Line 825: param_sets_rec.created_by := FND_GLOBAL.USER_ID;

821: param_sets_rec.ACTION_PARAM_SET_ID := l_new_param_set_id;
822: param_sets_rec.WP_ACTION_DEF_ID := l_wp_maction_def_id;
823: param_sets_rec.ACTION_PARAM_SET_LABEL := LTRIM(RTRIM(r_label));
824: param_sets_rec.ACTION_PARAM_SET_DESC := LTRIM(RTRIM(r_desc));
825: param_sets_rec.created_by := FND_GLOBAL.USER_ID;
826: param_sets_rec.creation_date := SYSDATE;
827: param_sets_rec.last_updated_by := FND_GLOBAL.USER_ID;
828: param_sets_rec.last_update_date := SYSDATE;
829: param_sets_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

Line 827: param_sets_rec.last_updated_by := FND_GLOBAL.USER_ID;

823: param_sets_rec.ACTION_PARAM_SET_LABEL := LTRIM(RTRIM(r_label));
824: param_sets_rec.ACTION_PARAM_SET_DESC := LTRIM(RTRIM(r_desc));
825: param_sets_rec.created_by := FND_GLOBAL.USER_ID;
826: param_sets_rec.creation_date := SYSDATE;
827: param_sets_rec.last_updated_by := FND_GLOBAL.USER_ID;
828: param_sets_rec.last_update_date := SYSDATE;
829: param_sets_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
830: param_sets_rec.owner := 1;
831: IEU_WP_ACT_PARAM_SETS_SEED_PKG.Insert_Row(p_WP_ACT_PARAM_SETS_rec=>param_Sets_rec);

Line 829: param_sets_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

825: param_sets_rec.created_by := FND_GLOBAL.USER_ID;
826: param_sets_rec.creation_date := SYSDATE;
827: param_sets_rec.last_updated_by := FND_GLOBAL.USER_ID;
828: param_sets_rec.last_update_date := SYSDATE;
829: param_sets_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
830: param_sets_rec.owner := 1;
831: IEU_WP_ACT_PARAM_SETS_SEED_PKG.Insert_Row(p_WP_ACT_PARAM_SETS_rec=>param_Sets_rec);
832: end if ;
833:

Line 868: param_props_rec.created_by := FND_GLOBAL.USER_ID;

864: param_props_rec.PROPERTY_ID := c_rec.property_id;
865: param_props_rec.PROPERTY_VALUE := c_rec.property_value;
866: param_props_rec.PROPERTY_VALUE_TL := c_rec.property_value;
867: param_props_rec.VALUE_OVERRIDE_FLAG := c_rec.value_override_flag;
868: param_props_rec.created_by := FND_GLOBAL.USER_ID;
869: param_props_rec.creation_date := SYSDATE;
870: param_props_rec.last_updated_by := FND_GLOBAL.USER_ID;
871: param_props_rec.last_update_date := SYSDATE;
872: param_props_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

Line 870: param_props_rec.last_updated_by := FND_GLOBAL.USER_ID;

866: param_props_rec.PROPERTY_VALUE_TL := c_rec.property_value;
867: param_props_rec.VALUE_OVERRIDE_FLAG := c_rec.value_override_flag;
868: param_props_rec.created_by := FND_GLOBAL.USER_ID;
869: param_props_rec.creation_date := SYSDATE;
870: param_props_rec.last_updated_by := FND_GLOBAL.USER_ID;
871: param_props_rec.last_update_date := SYSDATE;
872: param_props_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
873: param_props_rec.NOT_VALID_FLAG := c_rec.not_valid_flag;
874: param_props_rec.owner := 1;

Line 872: param_props_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

868: param_props_rec.created_by := FND_GLOBAL.USER_ID;
869: param_props_rec.creation_date := SYSDATE;
870: param_props_rec.last_updated_by := FND_GLOBAL.USER_ID;
871: param_props_rec.last_update_date := SYSDATE;
872: param_props_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
873: param_props_rec.NOT_VALID_FLAG := c_rec.not_valid_flag;
874: param_props_rec.owner := 1;
875: IEU_WP_PARAM_PROPS_SEED_PKG.Insert_Row(p_wp_param_props_rec => param_props_rec);
876: end LOOP;

Line 944: USING l_wp_action_map_id,FND_GLOBAL.USER_ID,SYSDATE, FND_GLOBAL.USER_ID, SYSDATE,

940: ' :14, '||
941: ' :15, '||
942: ' :16 '||
943: ' ) '
944: USING l_wp_action_map_id,FND_GLOBAL.USER_ID,SYSDATE, FND_GLOBAL.USER_ID, SYSDATE,
945: FND_GLOBAL.LOGIN_ID, l_new_param_set_id, c_rec2.application_id, '-1', c_rec2.action_map_type_code,
946: c_rec2.action_map_code, c_rec2.panel_sec_cat_code, c_rec2.not_valid_flag, c_rec2.object_version_number,
947: l_temp_map_sequence, r_dev_data_flag;
948:

Line 945: FND_GLOBAL.LOGIN_ID, l_new_param_set_id, c_rec2.application_id, '-1', c_rec2.action_map_type_code,

941: ' :15, '||
942: ' :16 '||
943: ' ) '
944: USING l_wp_action_map_id,FND_GLOBAL.USER_ID,SYSDATE, FND_GLOBAL.USER_ID, SYSDATE,
945: FND_GLOBAL.LOGIN_ID, l_new_param_set_id, c_rec2.application_id, '-1', c_rec2.action_map_type_code,
946: c_rec2.action_map_code, c_rec2.panel_sec_cat_code, c_rec2.not_valid_flag, c_rec2.object_version_number,
947: l_temp_map_sequence, r_dev_data_flag;
948:
949:

Line 986: USING l_wp_action_map_id,FND_GLOBAL.USER_ID, SYSDATE,FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.LOGIN_ID,

982: ' :12 , '||
983: ' :13 , '||
984: ' :14 , '||
985: ' :15 )'
986: USING l_wp_action_map_id,FND_GLOBAL.USER_ID, SYSDATE,FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.LOGIN_ID,
987: l_new_param_set_id, c_rec2.application_id, c_rec2.action_map_type_code,
988: c_rec2.action_map_code, c_rec2.panel_sec_cat_code, c_rec2.not_valid_flag, c_rec2.object_version_number,
989: l_temp_map_sequence, r_dev_data_flag;
990: end loop;

Line 1103: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

1099:
1100: fnd_msg_pub.delete_msg();
1101: x_return_status := fnd_api.g_ret_sts_success;
1102: FND_MSG_PUB.initialize;
1103: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1104: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1105: x_msg_data := '';
1106:
1107: --delete param props if param has been deleted by some actions

Line 1104: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

1100: fnd_msg_pub.delete_msg();
1101: x_return_status := fnd_api.g_ret_sts_success;
1102: FND_MSG_PUB.initialize;
1103: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1104: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1105: x_msg_data := '';
1106:
1107: --delete param props if param has been deleted by some actions
1108: delete from ieu_wp_param_props_b where param_property_id in

Line 1209: param_props_rec.created_by := FND_GLOBAL.USER_ID;

1205: param_props_rec.PROPERTY_ID := l_property_id;
1206: param_props_rec.PROPERTY_VALUE := l_property_value;
1207: param_props_rec.PROPERTY_VALUE_TL := l_property_value;
1208: param_props_rec.VALUE_OVERRIDE_FLAG := l_value_override_flag;
1209: param_props_rec.created_by := FND_GLOBAL.USER_ID;
1210: param_props_rec.creation_date := SYSDATE;
1211: param_props_rec.last_updated_by := FND_GLOBAL.USER_ID;
1212: param_props_rec.last_update_date := SYSDATE;
1213: param_props_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

Line 1211: param_props_rec.last_updated_by := FND_GLOBAL.USER_ID;

1207: param_props_rec.PROPERTY_VALUE_TL := l_property_value;
1208: param_props_rec.VALUE_OVERRIDE_FLAG := l_value_override_flag;
1209: param_props_rec.created_by := FND_GLOBAL.USER_ID;
1210: param_props_rec.creation_date := SYSDATE;
1211: param_props_rec.last_updated_by := FND_GLOBAL.USER_ID;
1212: param_props_rec.last_update_date := SYSDATE;
1213: param_props_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1214: param_props_rec.NOT_VALID_FLAG :=l_not_valid_flag;
1215: param_props_rec.owner := 1;

Line 1213: param_props_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

1209: param_props_rec.created_by := FND_GLOBAL.USER_ID;
1210: param_props_rec.creation_date := SYSDATE;
1211: param_props_rec.last_updated_by := FND_GLOBAL.USER_ID;
1212: param_props_rec.last_update_date := SYSDATE;
1213: param_props_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1214: param_props_rec.NOT_VALID_FLAG :=l_not_valid_flag;
1215: param_props_rec.owner := 1;
1216: IEU_WP_PARAM_PROPS_SEED_PKG.Insert_Row(p_wp_param_props_rec => param_props_rec);
1217: end loop;-- for v_cursor2

Line 1307: and e.language = FND_GLOBAL.CURRENT_LANGUAGE

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
1307: and e.language = FND_GLOBAL.CURRENT_LANGUAGE
1308: and a.enum_type_uuid = b.action_map_code
1309: and c.action_param_set_id = b.action_param_set_id
1310: -- and b.application_id = v_applId bug#5585922
1311: and c.wp_action_def_id = e.maction_def_id

Line 1315: AND d.language=FND_GLOBAL.CURRENT_LANGUAGE

1311: and c.wp_action_def_id = e.maction_def_id
1312: and b.responsibility_id = -1
1313: and d.action_param_set_id = c.action_param_set_id
1314: and e.maction_def_id =f.maction_def_id
1315: AND d.language=FND_GLOBAL.CURRENT_LANGUAGE
1316: order by b.action_map_sequence;
1317:
1318: c_rec c_cur%ROWTYPE;
1319:

Line 1330: and e.language = FND_GLOBAL.CURRENT_LANGUAGE

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
1330: and e.language = FND_GLOBAL.CURRENT_LANGUAGE
1331: AND d.language=FND_GLOBAL.CURRENT_LANGUAGE
1332: and a.enum_type_uuid = ds.enum_type_uuid
1333: AND b.ACTION_MAP_TYPE_CODE = v_action_map_type_code
1334: AND to_char(ds.NODE_DS_ID) = b.ACTION_MAP_CODE

Line 1331: AND d.language=FND_GLOBAL.CURRENT_LANGUAGE

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
1330: and e.language = FND_GLOBAL.CURRENT_LANGUAGE
1331: AND d.language=FND_GLOBAL.CURRENT_LANGUAGE
1332: and a.enum_type_uuid = ds.enum_type_uuid
1333: AND b.ACTION_MAP_TYPE_CODE = v_action_map_type_code
1334: AND to_char(ds.NODE_DS_ID) = b.ACTION_MAP_CODE
1335: and c.action_param_set_id = b.action_param_set_id

Line 1554: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

1550:
1551: fnd_msg_pub.delete_msg();
1552: x_return_status := fnd_api.g_ret_sts_success;
1553: FND_MSG_PUB.initialize;
1554: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1555: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1556: x_msg_data := '';
1557:
1558: execute immediate ' select a.wp_action_def_id ' ||

Line 1555: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

1551: fnd_msg_pub.delete_msg();
1552: x_return_status := fnd_api.g_ret_sts_success;
1553: FND_MSG_PUB.initialize;
1554: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1555: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1556: x_msg_data := '';
1557:
1558: execute immediate ' select a.wp_action_def_id ' ||
1559: ' from ieu_wp_act_param_sets_b a, ieu_uwq_maction_defs_b c ' ||

Line 1584: param_sets_rec.created_by := FND_GLOBAL.USER_ID;

1580: param_sets_rec.ACTION_PARAM_SET_ID := l_new_param_set_id;
1581: param_sets_rec.WP_ACTION_DEF_ID := l_wp_maction_def_id;
1582: param_sets_rec.ACTION_PARAM_SET_LABEL := LTRIM(RTRIM(r_label));
1583: param_sets_rec.ACTION_PARAM_SET_DESC := LTRIM(RTRIM(r_desc));
1584: param_sets_rec.created_by := FND_GLOBAL.USER_ID;
1585: param_sets_rec.creation_date := SYSDATE;
1586: param_sets_rec.last_updated_by := FND_GLOBAL.USER_ID;
1587: param_sets_rec.last_update_date := SYSDATE;
1588: param_sets_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

Line 1586: param_sets_rec.last_updated_by := FND_GLOBAL.USER_ID;

1582: param_sets_rec.ACTION_PARAM_SET_LABEL := LTRIM(RTRIM(r_label));
1583: param_sets_rec.ACTION_PARAM_SET_DESC := LTRIM(RTRIM(r_desc));
1584: param_sets_rec.created_by := FND_GLOBAL.USER_ID;
1585: param_sets_rec.creation_date := SYSDATE;
1586: param_sets_rec.last_updated_by := FND_GLOBAL.USER_ID;
1587: param_sets_rec.last_update_date := SYSDATE;
1588: param_sets_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1589: param_sets_rec.owner := 1;
1590: IEU_WP_ACT_PARAM_SETS_SEED_PKG.Insert_Row(p_WP_ACT_PARAM_SETS_rec=>param_Sets_rec);

Line 1588: param_sets_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

1584: param_sets_rec.created_by := FND_GLOBAL.USER_ID;
1585: param_sets_rec.creation_date := SYSDATE;
1586: param_sets_rec.last_updated_by := FND_GLOBAL.USER_ID;
1587: param_sets_rec.last_update_date := SYSDATE;
1588: param_sets_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1589: param_sets_rec.owner := 1;
1590: IEU_WP_ACT_PARAM_SETS_SEED_PKG.Insert_Row(p_WP_ACT_PARAM_SETS_rec=>param_Sets_rec);
1591: end if ;
1592:

Line 1626: param_props_rec.created_by := FND_GLOBAL.USER_ID;

1622: param_props_rec.PROPERTY_ID := c_rec.property_id;
1623: param_props_rec.PROPERTY_VALUE := c_rec.property_value;
1624: param_props_rec.PROPERTY_VALUE_TL := c_rec.property_value;
1625: param_props_rec.VALUE_OVERRIDE_FLAG := c_rec.value_override_flag;
1626: param_props_rec.created_by := FND_GLOBAL.USER_ID;
1627: param_props_rec.creation_date := SYSDATE;
1628: param_props_rec.last_updated_by := FND_GLOBAL.USER_ID;
1629: param_props_rec.last_update_date := SYSDATE;
1630: param_props_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

Line 1628: param_props_rec.last_updated_by := FND_GLOBAL.USER_ID;

1624: param_props_rec.PROPERTY_VALUE_TL := c_rec.property_value;
1625: param_props_rec.VALUE_OVERRIDE_FLAG := c_rec.value_override_flag;
1626: param_props_rec.created_by := FND_GLOBAL.USER_ID;
1627: param_props_rec.creation_date := SYSDATE;
1628: param_props_rec.last_updated_by := FND_GLOBAL.USER_ID;
1629: param_props_rec.last_update_date := SYSDATE;
1630: param_props_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1631: param_props_rec.NOT_VALID_FLAG := c_rec.not_valid_flag;
1632: param_props_rec.owner := 1;

Line 1630: param_props_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

1626: param_props_rec.created_by := FND_GLOBAL.USER_ID;
1627: param_props_rec.creation_date := SYSDATE;
1628: param_props_rec.last_updated_by := FND_GLOBAL.USER_ID;
1629: param_props_rec.last_update_date := SYSDATE;
1630: param_props_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1631: param_props_rec.NOT_VALID_FLAG := c_rec.not_valid_flag;
1632: param_props_rec.owner := 1;
1633: IEU_WP_PARAM_PROPS_SEED_PKG.Insert_Row(p_wp_param_props_rec => param_props_rec);
1634: end loop;

Line 1683: USING l_wp_action_map_id, FND_GLOBAL.USER_ID, SYSDATE,FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.LOGIN_ID,

1679: ' :15 , '||
1680: ' :16 , '||
1681: ' :17 '||
1682: ' ) '
1683: USING l_wp_action_map_id, FND_GLOBAL.USER_ID, SYSDATE,FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.LOGIN_ID,
1684: l_new_param_set_id, c_rec2.application_id,'-1', c_rec2.action_map_type_code,
1685: c_rec2.action_map_code,c_rec2.panel_sec_cat_code, c_rec2.not_valid_flag, c_rec2.object_version_number,
1686: l_security_group_id, l_temp_map_sequence, r_dev_data_flag;
1687: