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_WORK_ACTION_PVT dependencies on FND_GLOBAL

Line 39: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

35:
36: fnd_msg_pub.delete_msg();
37: x_return_status := fnd_api.g_ret_sts_success;
38: FND_MSG_PUB.initialize;
39: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
40: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
41: x_msg_data := '';
42:
43:

Line 40: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

36: fnd_msg_pub.delete_msg();
37: x_return_status := fnd_api.g_ret_sts_success;
38: FND_MSG_PUB.initialize;
39: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
40: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
41: x_msg_data := '';
42:
43:
44:

Line 120: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

116:
117: CREATE_action_map(x_return_status,x_msg_count, x_msg_data, act_map_obj1);
118:
119: update IEU_UWQ_SEL_ENUMERATORS set
120: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
121: LAST_UPDATE_DATE = SYSDATE,
122: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
123: WORK_PANEL_REGISTERED_FLAG = 'Y'
124: where SEL_ENUM_ID = p_enum_id;

Line 122: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

118:
119: update IEU_UWQ_SEL_ENUMERATORS set
120: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
121: LAST_UPDATE_DATE = SYSDATE,
122: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
123: WORK_PANEL_REGISTERED_FLAG = 'Y'
124: where SEL_ENUM_ID = p_enum_id;
125:
126: if (upper(p_maction_def_type_flag) <> 'G' ) then

Line 137: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

133:
134: if (l_count > 0) then
135:
136: update IEU_WP_NODE_SECTION_MAPS set
137: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
138: LAST_UPDATE_DATE = SYSDATE,
139: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
140: RESPONSIBILITY_ID = null,
141: SECTION_MAP_SEQUENCE = l_section_map_sequence

Line 139: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

135:
136: update IEU_WP_NODE_SECTION_MAPS set
137: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
138: LAST_UPDATE_DATE = SYSDATE,
139: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
140: RESPONSIBILITY_ID = null,
141: SECTION_MAP_SEQUENCE = l_section_map_sequence
142: where ENUM_TYPE_UUID = l_enum_uuid
143: and APPLICATION_ID = p_mapping_application

Line 169: FND_GLOBAL.USER_ID,

165: NOT_VALID_FLAG
166: ) values
167: (l_wp_node_section_map_id,
168: 0,
169: FND_GLOBAL.USER_ID,
170: SYSDATE,
171: FND_GLOBAL.USER_ID,
172: SYSDATE,
173: FND_GLOBAL.LOGIN_ID,

Line 171: FND_GLOBAL.USER_ID,

167: (l_wp_node_section_map_id,
168: 0,
169: FND_GLOBAL.USER_ID,
170: SYSDATE,
171: FND_GLOBAL.USER_ID,
172: SYSDATE,
173: FND_GLOBAL.LOGIN_ID,
174: NULL,
175: p_mapping_application,

Line 173: FND_GLOBAL.LOGIN_ID,

169: FND_GLOBAL.USER_ID,
170: SYSDATE,
171: FND_GLOBAL.USER_ID,
172: SYSDATE,
173: FND_GLOBAL.LOGIN_ID,
174: NULL,
175: p_mapping_application,
176: null,
177: l_enum_uuid,

Line 247: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

243: fnd_msg_pub.delete_msg();
244: x_return_status := fnd_api.g_ret_sts_success;
245: FND_MSG_PUB.initialize;
246:
247: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
248: l_set_id_count :=0;
249: temp_act_user_label := LTRIM(RTRIM(p_label));
250: select count(b.maction_def_id) into l_act_usr_lbl_count
251: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl,

Line 387: FND_GLOBAL.USER_ID,

383: )
384: values (
385: l_action_map_id,
386: 1,
387: FND_GLOBAL.USER_ID,
388: SYSDATE,
389: FND_GLOBAL.USER_ID,
390: SYSDATE,
391: FND_GLOBAL.LOGIN_ID,

Line 389: FND_GLOBAL.USER_ID,

385: l_action_map_id,
386: 1,
387: FND_GLOBAL.USER_ID,
388: SYSDATE,
389: FND_GLOBAL.USER_ID,
390: SYSDATE,
391: FND_GLOBAL.LOGIN_ID,
392: rec_obj.action_param_set_id,
393: rec_obj.application_id,

Line 391: FND_GLOBAL.LOGIN_ID,

387: FND_GLOBAL.USER_ID,
388: SYSDATE,
389: FND_GLOBAL.USER_ID,
390: SYSDATE,
391: FND_GLOBAL.LOGIN_ID,
392: rec_obj.action_param_set_id,
393: rec_obj.application_id,
394: rec_obj.responsibility_id,
395: rec_obj.action_map_type_code,

Line 449: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

445: BEGIN
446: fnd_msg_pub.delete_msg();
447: x_return_status := fnd_api.g_ret_sts_success;
448: FND_MSG_PUB.initialize;
449: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
450: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
451: x_msg_data := '';
452: l_count := 0;
453: l_section_id := 0;

Line 450: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

446: fnd_msg_pub.delete_msg();
447: x_return_status := fnd_api.g_ret_sts_success;
448: FND_MSG_PUB.initialize;
449: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
450: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
451: x_msg_data := '';
452: l_count := 0;
453: l_section_id := 0;
454: l_section_map_sequence := 0;

Line 480: FND_GLOBAL.USER_ID,

476: MULTI_SELECT_FLAG
477: )
478: values(
479: l_maction_def_id,
480: FND_GLOBAL.USER_ID,
481: SYSDATE,
482: FND_GLOBAL.USER_ID,
483: SYSDATE,
484: FND_GLOBAL.LOGIN_ID,

Line 482: FND_GLOBAL.USER_ID,

478: values(
479: l_maction_def_id,
480: FND_GLOBAL.USER_ID,
481: SYSDATE,
482: FND_GLOBAL.USER_ID,
483: SYSDATE,
484: FND_GLOBAL.LOGIN_ID,
485: LTRIM(RTRIM(rec_obj.action_proc)),
486: rec_obj.application_id,

Line 484: FND_GLOBAL.LOGIN_ID,

480: FND_GLOBAL.USER_ID,
481: SYSDATE,
482: FND_GLOBAL.USER_ID,
483: SYSDATE,
484: FND_GLOBAL.LOGIN_ID,
485: LTRIM(RTRIM(rec_obj.action_proc)),
486: rec_obj.application_id,
487: null,
488: LTRIM(RTRIM(rec_obj.maction_def_key)),

Line 509: FND_GLOBAL.USER_ID,

505: MULTI_SELECT_FLAG
506: )
507: values(
508: l_maction_def_id,
509: FND_GLOBAL.USER_ID,
510: SYSDATE,
511: FND_GLOBAL.USER_ID,
512: SYSDATE,
513: FND_GLOBAL.LOGIN_ID,

Line 511: FND_GLOBAL.USER_ID,

507: values(
508: l_maction_def_id,
509: FND_GLOBAL.USER_ID,
510: SYSDATE,
511: FND_GLOBAL.USER_ID,
512: SYSDATE,
513: FND_GLOBAL.LOGIN_ID,
514: LTRIM(RTRIM(rec_obj.action_proc)),
515: rec_obj.application_id,

Line 513: FND_GLOBAL.LOGIN_ID,

509: FND_GLOBAL.USER_ID,
510: SYSDATE,
511: FND_GLOBAL.USER_ID,
512: SYSDATE,
513: FND_GLOBAL.LOGIN_ID,
514: LTRIM(RTRIM(rec_obj.action_proc)),
515: rec_obj.application_id,
516: p_maction_def_type_flag,
517: LTRIM(RTRIM(rec_obj.maction_def_key)),

Line 538: FND_GLOBAL.USER_ID,

534: OBJECT_VERSION_NUMBER
535: ) values (
536: l_maction_def_id,
537: l_language,
538: FND_GLOBAL.USER_ID,
539: SYSDATE,
540: FND_GLOBAL.USER_ID,
541: SYSDATE,
542: FND_GLOBAL.LOGIN_ID,

Line 540: FND_GLOBAL.USER_ID,

536: l_maction_def_id,
537: l_language,
538: FND_GLOBAL.USER_ID,
539: SYSDATE,
540: FND_GLOBAL.USER_ID,
541: SYSDATE,
542: FND_GLOBAL.LOGIN_ID,
543: LTRIM(RTRIM(rec_obj.action_user_label)),
544: l_source_lang,

Line 542: FND_GLOBAL.LOGIN_ID,

538: FND_GLOBAL.USER_ID,
539: SYSDATE,
540: FND_GLOBAL.USER_ID,
541: SYSDATE,
542: FND_GLOBAL.LOGIN_ID,
543: LTRIM(RTRIM(rec_obj.action_user_label)),
544: l_source_lang,
545: LTRIM(RTRIM(rec_obj.action_description)),
546: 0

Line 562: FND_GLOBAL.USER_ID,

558: WP_ACTION_DEF_ID,
559: OBJECT_VERSION_NUMBER
560: ) values (
561: l_action_param_set_id,
562: FND_GLOBAL.USER_ID,
563: SYSDATE,
564: FND_GLOBAL.USER_ID,
565: SYSDATE,
566: FND_GLOBAL.LOGIN_ID,

Line 564: FND_GLOBAL.USER_ID,

560: ) values (
561: l_action_param_set_id,
562: FND_GLOBAL.USER_ID,
563: SYSDATE,
564: FND_GLOBAL.USER_ID,
565: SYSDATE,
566: FND_GLOBAL.LOGIN_ID,
567: l_maction_def_id,
568: 0

Line 566: FND_GLOBAL.LOGIN_ID,

562: FND_GLOBAL.USER_ID,
563: SYSDATE,
564: FND_GLOBAL.USER_ID,
565: SYSDATE,
566: FND_GLOBAL.LOGIN_ID,
567: l_maction_def_id,
568: 0
569: );
570: insert INTO IEU_WP_ACT_PARAM_SETS_TL

Line 584: FND_GLOBAL.USER_ID,

580: ACTION_PARAM_SET_DESC,
581: OBJECT_VERSION_NUMBER
582: ) values (
583: l_action_param_set_id,
584: FND_GLOBAL.USER_ID,
585: SYSDATE,
586: FND_GLOBAL.USER_ID,
587: SYSDATE,
588: FND_GLOBAL.LOGIN_ID,

Line 586: FND_GLOBAL.USER_ID,

582: ) values (
583: l_action_param_set_id,
584: FND_GLOBAL.USER_ID,
585: SYSDATE,
586: FND_GLOBAL.USER_ID,
587: SYSDATE,
588: FND_GLOBAL.LOGIN_ID,
589: LTRIM(RTRIM(rec_obj.action_user_label)),
590: l_language,

Line 588: FND_GLOBAL.LOGIN_ID,

584: FND_GLOBAL.USER_ID,
585: SYSDATE,
586: FND_GLOBAL.USER_ID,
587: SYSDATE,
588: FND_GLOBAL.LOGIN_ID,
589: LTRIM(RTRIM(rec_obj.action_user_label)),
590: l_language,
591: l_source_lang,
592: LTRIM(RTRIM(rec_obj.action_description)),

Line 638: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

634: end if;
635: */
636: if (p_maction_def_type_flag <> 'F') then
637: update IEU_UWQ_SEL_ENUMERATORS set
638: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
639: LAST_UPDATE_DATE = SYSDATE,
640: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
641: WORK_PANEL_REGISTERED_FLAG = 'Y'
642: where SEL_ENUM_ID = rec_obj.enum_id;

Line 640: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

636: if (p_maction_def_type_flag <> 'F') then
637: update IEU_UWQ_SEL_ENUMERATORS set
638: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
639: LAST_UPDATE_DATE = SYSDATE,
640: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
641: WORK_PANEL_REGISTERED_FLAG = 'Y'
642: where SEL_ENUM_ID = rec_obj.enum_id;
643:
644: end if;

Line 743: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

739:
740: fnd_msg_pub.delete_msg();
741: x_return_status := fnd_api.g_ret_sts_success;
742: FND_MSG_PUB.initialize;
743: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
744: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
745: x_msg_data := '';
746:
747: Validate_Action_Label( x_return_status ,

Line 744: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

740: fnd_msg_pub.delete_msg();
741: x_return_status := fnd_api.g_ret_sts_success;
742: FND_MSG_PUB.initialize;
743: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
744: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
745: x_msg_data := '';
746:
747: Validate_Action_Label( x_return_status ,
748: x_msg_count ,

Line 764: FND_GLOBAL.USER_ID,

760: LAST_UPDATE_LOGIN,
761: WP_ACTION_DEF_ID,
762: OBJECT_VERSION_NUMBER)
763: values( l_new_param_set_id,
764: FND_GLOBAL.USER_ID,
765: SYSDATE,
766: FND_GLOBAL.USER_ID,
767: SYSDATE,
768: FND_GLOBAL.LOGIN_ID,

Line 766: FND_GLOBAL.USER_ID,

762: OBJECT_VERSION_NUMBER)
763: values( l_new_param_set_id,
764: FND_GLOBAL.USER_ID,
765: SYSDATE,
766: FND_GLOBAL.USER_ID,
767: SYSDATE,
768: FND_GLOBAL.LOGIN_ID,
769: r_maction_def_id,
770: 1);

Line 768: FND_GLOBAL.LOGIN_ID,

764: FND_GLOBAL.USER_ID,
765: SYSDATE,
766: FND_GLOBAL.USER_ID,
767: SYSDATE,
768: FND_GLOBAL.LOGIN_ID,
769: r_maction_def_id,
770: 1);
771:
772: INSERT INTO ieu_WP_ACT_PARAM_SETS_tl

Line 786: FND_GLOBAL.USER_ID,

782: source_lang,
783: OBJECT_VERSION_NUMBER)
784: values( l_new_param_set_id,
785: r_language,
786: FND_GLOBAL.USER_ID,
787: SYSDATE,
788: FND_GLOBAL.USER_ID,
789: SYSDATE,
790: FND_GLOBAL.LOGIN_ID,

Line 788: FND_GLOBAL.USER_ID,

784: values( l_new_param_set_id,
785: r_language,
786: FND_GLOBAL.USER_ID,
787: SYSDATE,
788: FND_GLOBAL.USER_ID,
789: SYSDATE,
790: FND_GLOBAL.LOGIN_ID,
791: LTRIM(RTRIM(r_label)),
792: LTRIM(RTRIM(r_desc)),

Line 790: FND_GLOBAL.LOGIN_ID,

786: FND_GLOBAL.USER_ID,
787: SYSDATE,
788: FND_GLOBAL.USER_ID,
789: SYSDATE,
790: FND_GLOBAL.LOGIN_ID,
791: LTRIM(RTRIM(r_label)),
792: LTRIM(RTRIM(r_desc)),
793: l_source_lang,
794: 1);

Line 814: FND_GLOBAL.USER_ID,

810: VALUE_OVERRIDE_FLAG,
811: NOT_VALID_FLAG,
812: OBJECT_VERSION_NUMBER)
813: VALUES (l_param_property_id,
814: FND_GLOBAL.USER_ID,
815: SYSDATE,
816: FND_GLOBAL.USER_ID,
817: SYSDATE,
818: FND_GLOBAL.LOGIN_ID,

Line 816: FND_GLOBAL.USER_ID,

812: OBJECT_VERSION_NUMBER)
813: VALUES (l_param_property_id,
814: FND_GLOBAL.USER_ID,
815: SYSDATE,
816: FND_GLOBAL.USER_ID,
817: SYSDATE,
818: FND_GLOBAL.LOGIN_ID,
819: l_new_param_set_id,
820: c_rec.param_id,

Line 818: FND_GLOBAL.LOGIN_ID,

814: FND_GLOBAL.USER_ID,
815: SYSDATE,
816: FND_GLOBAL.USER_ID,
817: SYSDATE,
818: FND_GLOBAL.LOGIN_ID,
819: l_new_param_set_id,
820: c_rec.param_id,
821: c_rec.property_id,
822: c_rec.property_value,

Line 846: FND_GLOBAL.USER_ID,

842: SOURCE_LANG,
843: OBJECT_VERSION_NUMBER
844: ) VALUES (
845: l_param_property_id,
846: FND_GLOBAL.USER_ID,
847: SYSDATE,
848: FND_GLOBAL.USER_ID,
849: SYSDATE,
850: FND_GLOBAL.LOGIN_ID,

Line 848: FND_GLOBAL.USER_ID,

844: ) VALUES (
845: l_param_property_id,
846: FND_GLOBAL.USER_ID,
847: SYSDATE,
848: FND_GLOBAL.USER_ID,
849: SYSDATE,
850: FND_GLOBAL.LOGIN_ID,
851: c_rec.property_value,
852: l_language,

Line 850: FND_GLOBAL.LOGIN_ID,

846: FND_GLOBAL.USER_ID,
847: SYSDATE,
848: FND_GLOBAL.USER_ID,
849: SYSDATE,
850: FND_GLOBAL.LOGIN_ID,
851: c_rec.property_value,
852: l_language,
853: l_source_lang,
854: 1

Line 905: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

901: x_return_status := fnd_api.g_ret_sts_success;
902: x_msg_count := 0;
903: x_msg_data := '';
904:
905: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
906: -- I. get the maction_def_type_flag
907: --1. determine if this action has 1:1 for action_maps to action_param_sets
908: --2. delete from maps
909: --3. if 1:1 in 1,

Line 1068: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1064:
1065: if (l_count_map = 0) then
1066:
1067: update IEU_UWQ_SEL_ENUMERATORS set
1068: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1069: LAST_UPDATE_DATE = SYSDATE,
1070: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1071: WORK_PANEL_REGISTERED_FLAG = null
1072: where SEL_ENUM_ID = x_node_id;

Line 1070: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

1066:
1067: update IEU_UWQ_SEL_ENUMERATORS set
1068: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1069: LAST_UPDATE_DATE = SYSDATE,
1070: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1071: WORK_PANEL_REGISTERED_FLAG = null
1072: where SEL_ENUM_ID = x_node_id;
1073:
1074: