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

Line 73: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

69: fnd_msg_pub.delete_msg();
70: x_return_status := fnd_api.g_ret_sts_success;
71: FND_MSG_PUB.initialize;
72:
73: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
74: l_act_usr_lbl_count := 0;
75: l_act_def_key_count := 0;
76:
77:

Line 359: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

355: fnd_msg_pub.delete_msg();
356: x_return_status := fnd_api.g_ret_sts_success;
357: FND_MSG_PUB.initialize;
358:
359: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
360: l_set_id_count :=0;
361:
362:
363: temp_act_user_label := LTRIM(RTRIM(p_label));

Line 558: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

554:
555: fnd_msg_pub.delete_msg();
556: x_return_status := fnd_api.g_ret_sts_success;
557: FND_MSG_PUB.initialize;
558: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
559: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
560: x_msg_data := '';
561:
562:

Line 559: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

555: fnd_msg_pub.delete_msg();
556: x_return_status := fnd_api.g_ret_sts_success;
557: FND_MSG_PUB.initialize;
558: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
559: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
560: x_msg_data := '';
561:
562:
563: IEU_WorkPanel_PVT.Create_MAction2 (x_return_status,

Line 662: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

658: BEGIN
659: fnd_msg_pub.delete_msg();
660: x_return_status := fnd_api.g_ret_sts_success;
661: FND_MSG_PUB.initialize;
662: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
663: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
664: x_msg_data := '';
665: l_count := 0;
666: l_section_id := 0;

Line 663: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

659: fnd_msg_pub.delete_msg();
660: x_return_status := fnd_api.g_ret_sts_success;
661: FND_MSG_PUB.initialize;
662: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
663: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
664: x_msg_data := '';
665: l_count := 0;
666: l_section_id := 0;
667: l_section_map_sequence := 0;

Line 698: FND_GLOBAL.USER_ID,

694: MULTI_SELECT_FLAG
695: )
696: values(
697: l_maction_def_id,
698: FND_GLOBAL.USER_ID,
699: SYSDATE,
700: FND_GLOBAL.USER_ID,
701: SYSDATE,
702: FND_GLOBAL.LOGIN_ID,

Line 700: FND_GLOBAL.USER_ID,

696: values(
697: l_maction_def_id,
698: FND_GLOBAL.USER_ID,
699: SYSDATE,
700: FND_GLOBAL.USER_ID,
701: SYSDATE,
702: FND_GLOBAL.LOGIN_ID,
703: LTRIM(RTRIM(rec_obj.action_proc)),
704: rec_obj.application_id,

Line 702: FND_GLOBAL.LOGIN_ID,

698: FND_GLOBAL.USER_ID,
699: SYSDATE,
700: FND_GLOBAL.USER_ID,
701: SYSDATE,
702: FND_GLOBAL.LOGIN_ID,
703: LTRIM(RTRIM(rec_obj.action_proc)),
704: rec_obj.application_id,
705: p_maction_def_type_flag,
706: LTRIM(RTRIM(rec_obj.maction_def_key)),

Line 728: FND_GLOBAL.USER_ID,

724: OBJECT_VERSION_NUMBER
725: ) values (
726: l_maction_def_id,
727: l_language,
728: FND_GLOBAL.USER_ID,
729: SYSDATE,
730: FND_GLOBAL.USER_ID,
731: SYSDATE,
732: FND_GLOBAL.LOGIN_ID,

Line 730: FND_GLOBAL.USER_ID,

726: l_maction_def_id,
727: l_language,
728: FND_GLOBAL.USER_ID,
729: SYSDATE,
730: FND_GLOBAL.USER_ID,
731: SYSDATE,
732: FND_GLOBAL.LOGIN_ID,
733: LTRIM(RTRIM(rec_obj.action_user_label)),
734: l_source_lang,

Line 732: FND_GLOBAL.LOGIN_ID,

728: FND_GLOBAL.USER_ID,
729: SYSDATE,
730: FND_GLOBAL.USER_ID,
731: SYSDATE,
732: FND_GLOBAL.LOGIN_ID,
733: LTRIM(RTRIM(rec_obj.action_user_label)),
734: l_source_lang,
735: LTRIM(RTRIM(rec_obj.action_description)),
736: 0

Line 757: FND_GLOBAL.USER_ID,

753: WP_ACTION_DEF_ID,
754: OBJECT_VERSION_NUMBER
755: ) values (
756: l_action_param_set_id,
757: FND_GLOBAL.USER_ID,
758: SYSDATE,
759: FND_GLOBAL.USER_ID,
760: SYSDATE,
761: FND_GLOBAL.LOGIN_ID,

Line 759: FND_GLOBAL.USER_ID,

755: ) values (
756: l_action_param_set_id,
757: FND_GLOBAL.USER_ID,
758: SYSDATE,
759: FND_GLOBAL.USER_ID,
760: SYSDATE,
761: FND_GLOBAL.LOGIN_ID,
762: l_maction_def_id,
763: 0

Line 761: FND_GLOBAL.LOGIN_ID,

757: FND_GLOBAL.USER_ID,
758: SYSDATE,
759: FND_GLOBAL.USER_ID,
760: SYSDATE,
761: FND_GLOBAL.LOGIN_ID,
762: l_maction_def_id,
763: 0
764: );
765: --DBMS_OUTPUT.PUT_LINE('inserted in param sets b: ');

Line 781: FND_GLOBAL.USER_ID,

777: ACTION_PARAM_SET_DESC,
778: OBJECT_VERSION_NUMBER
779: ) values (
780: l_action_param_set_id,
781: FND_GLOBAL.USER_ID,
782: SYSDATE,
783: FND_GLOBAL.USER_ID,
784: SYSDATE,
785: FND_GLOBAL.LOGIN_ID,

Line 783: FND_GLOBAL.USER_ID,

779: ) values (
780: l_action_param_set_id,
781: FND_GLOBAL.USER_ID,
782: SYSDATE,
783: FND_GLOBAL.USER_ID,
784: SYSDATE,
785: FND_GLOBAL.LOGIN_ID,
786: LTRIM(RTRIM(rec_obj.action_user_label)),
787: l_language,

Line 785: FND_GLOBAL.LOGIN_ID,

781: FND_GLOBAL.USER_ID,
782: SYSDATE,
783: FND_GLOBAL.USER_ID,
784: SYSDATE,
785: FND_GLOBAL.LOGIN_ID,
786: LTRIM(RTRIM(rec_obj.action_user_label)),
787: l_language,
788: l_source_lang,
789: LTRIM(RTRIM(rec_obj.action_description)),

Line 887: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

883: if (p_maction_def_type_flag <> 'F') then
884:
885:
886: update IEU_UWQ_SEL_ENUMERATORS set
887: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
888: LAST_UPDATE_DATE = SYSDATE,
889: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
890: WORK_PANEL_REGISTERED_FLAG = 'Y'
891: where SEL_ENUM_ID = rec_obj.enum_id;

Line 889: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

885:
886: update IEU_UWQ_SEL_ENUMERATORS set
887: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
888: LAST_UPDATE_DATE = SYSDATE,
889: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
890: WORK_PANEL_REGISTERED_FLAG = 'Y'
891: where SEL_ENUM_ID = rec_obj.enum_id;
892:
893:

Line 905: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

901:
902: if (l_count > 0) then
903:
904: update IEU_WP_NODE_SECTION_MAPS set
905: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
906: LAST_UPDATE_DATE = SYSDATE,
907: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
908: RESPONSIBILITY_ID = null,
909: SECTION_MAP_SEQUENCE = l_section_map_sequence

Line 907: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

903:
904: update IEU_WP_NODE_SECTION_MAPS set
905: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
906: LAST_UPDATE_DATE = SYSDATE,
907: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
908: RESPONSIBILITY_ID = null,
909: SECTION_MAP_SEQUENCE = l_section_map_sequence
910: where ENUM_TYPE_UUID = l_enum_uuid
911: and APPLICATION_ID = rec_obj.application_id

Line 935: FND_GLOBAL.USER_ID,

931: SECTION_MAP_SEQUENCE
932: ) values
933: (l_wp_node_section_map_id,
934: 0,
935: FND_GLOBAL.USER_ID,
936: SYSDATE,
937: FND_GLOBAL.USER_ID,
938: SYSDATE,
939: FND_GLOBAL.LOGIN_ID,

Line 937: FND_GLOBAL.USER_ID,

933: (l_wp_node_section_map_id,
934: 0,
935: FND_GLOBAL.USER_ID,
936: SYSDATE,
937: FND_GLOBAL.USER_ID,
938: SYSDATE,
939: FND_GLOBAL.LOGIN_ID,
940: rec_obj.application_id,
941: null,

Line 939: FND_GLOBAL.LOGIN_ID,

935: FND_GLOBAL.USER_ID,
936: SYSDATE,
937: FND_GLOBAL.USER_ID,
938: SYSDATE,
939: FND_GLOBAL.LOGIN_ID,
940: rec_obj.application_id,
941: null,
942: l_enum_uuid,
943: l_section_id,

Line 1022: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

1018:
1019: fnd_msg_pub.delete_msg();
1020: x_return_status := fnd_api.g_ret_sts_success;
1021: FND_MSG_PUB.initialize;
1022: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1023: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1024: x_msg_data := '';
1025:
1026: IEU_WorkPanel_PVT.Validate_Action ( l_return_status,

Line 1023: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

1019: fnd_msg_pub.delete_msg();
1020: x_return_status := fnd_api.g_ret_sts_success;
1021: FND_MSG_PUB.initialize;
1022: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1023: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1024: x_msg_data := '';
1025:
1026: IEU_WorkPanel_PVT.Validate_Action ( l_return_status,
1027: l_msg_count,

Line 1035: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1031:
1032: if (l_return_status = 'S') then
1033: if (p_maction_def_type_flag = 'N' or p_maction_def_type_flag = 'M') then
1034: update IEU_UWQ_MACTION_DEFS_B set
1035: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1036: LAST_UPDATE_DATE = SYSDATE,
1037: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1038: ACTION_PROC = LTRIM(RTRIM(rec_obj.action_proc)),
1039: MULTI_SELECT_FLAG = rec_obj.multi_select_flag

Line 1037: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

1033: if (p_maction_def_type_flag = 'N' or p_maction_def_type_flag = 'M') then
1034: update IEU_UWQ_MACTION_DEFS_B set
1035: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1036: LAST_UPDATE_DATE = SYSDATE,
1037: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1038: ACTION_PROC = LTRIM(RTRIM(rec_obj.action_proc)),
1039: MULTI_SELECT_FLAG = rec_obj.multi_select_flag
1040: where MACTION_DEF_ID = p_param_set_id
1041: and nvl(MACTION_DEF_TYPE_FLAG,'M') = p_maction_def_type_flag;

Line 1044: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1040: where MACTION_DEF_ID = p_param_set_id
1041: and nvl(MACTION_DEF_TYPE_FLAG,'M') = p_maction_def_type_flag;
1042:
1043: update IEU_UWQ_MACTION_DEFS_tl set
1044: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1045: LAST_UPDATE_DATE = SYSDATE,
1046: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1047: action_description = LTRIM(RTRIM(rec_obj.action_description)),
1048: action_user_label = LTRIM(RTRIM(rec_obj.action_user_label))

Line 1046: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

1042:
1043: update IEU_UWQ_MACTION_DEFS_tl set
1044: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1045: LAST_UPDATE_DATE = SYSDATE,
1046: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1047: action_description = LTRIM(RTRIM(rec_obj.action_description)),
1048: action_user_label = LTRIM(RTRIM(rec_obj.action_user_label))
1049: where MACTION_DEF_ID = p_param_set_id
1050: and l_language IN (language, source_lang);

Line 1055: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1051:
1052:
1053: else
1054: update IEU_UWQ_MACTION_DEFS_B set
1055: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1056: LAST_UPDATE_DATE = SYSDATE,
1057: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1058: ACTION_PROC = LTRIM(RTRIM(rec_obj.action_proc)),
1059: MULTI_SELECT_FLAG = rec_obj.multi_select_flag

Line 1057: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

1053: else
1054: update IEU_UWQ_MACTION_DEFS_B set
1055: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1056: LAST_UPDATE_DATE = SYSDATE,
1057: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1058: ACTION_PROC = LTRIM(RTRIM(rec_obj.action_proc)),
1059: MULTI_SELECT_FLAG = rec_obj.multi_select_flag
1060: where MACTION_DEF_ID = rec_obj.maction_def_id
1061: and MACTION_DEF_TYPE_FLAG = p_maction_def_type_flag;

Line 1065: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1061: and MACTION_DEF_TYPE_FLAG = p_maction_def_type_flag;
1062:
1063:
1064: update IEU_WP_ACT_PARAM_SETS_TL set
1065: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1066: LAST_UPDATE_DATE = SYSDATE,
1067: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1068: ACTION_PARAM_SET_LABEL = LTRIM(RTRIM(rec_obj.action_user_label)),
1069: ACTION_PARAM_SET_DESC = LTRIM(RTRIM(rec_obj.action_description))

Line 1067: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

1063:
1064: update IEU_WP_ACT_PARAM_SETS_TL set
1065: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1066: LAST_UPDATE_DATE = SYSDATE,
1067: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1068: ACTION_PARAM_SET_LABEL = LTRIM(RTRIM(rec_obj.action_user_label)),
1069: ACTION_PARAM_SET_DESC = LTRIM(RTRIM(rec_obj.action_description))
1070: where ACTION_PARAM_SET_ID = p_param_set_id
1071: and l_language IN (language, source_lang);

Line 1114: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

1110:
1111:
1112:
1113: BEGIN
1114: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1115:
1116:
1117: select ACTION_PARAM_SET_ID into l_action_param_set_id
1118: from IEU_WP_ACT_PARAM_SETS_B

Line 1200: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

1196: x_return_status := fnd_api.g_ret_sts_success;
1197: x_msg_count := 0;
1198: x_msg_data := '';
1199:
1200: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1201: -- I. get the maction_def_type_flag
1202: --1. determine if this action has 1:1 for action_maps to action_param_sets
1203: --2. delete from maps
1204: --3. if 1:1 in 1,

Line 1359: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1355:
1356: if (l_count_map = 0) then
1357:
1358: update IEU_UWQ_SEL_ENUMERATORS set
1359: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1360: LAST_UPDATE_DATE = SYSDATE,
1361: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1362: WORK_PANEL_REGISTERED_FLAG = null
1363: where SEL_ENUM_ID = x_node_id;

Line 1361: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

1357:
1358: update IEU_UWQ_SEL_ENUMERATORS set
1359: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1360: LAST_UPDATE_DATE = SYSDATE,
1361: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1362: WORK_PANEL_REGISTERED_FLAG = null
1363: where SEL_ENUM_ID = x_node_id;
1364:
1365: end if;

Line 1432: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

1428: fnd_msg_pub.delete_msg();
1429: x_return_status := fnd_api.g_ret_sts_success;
1430: FND_MSG_PUB.initialize;
1431:
1432: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1433: l_param_usr_lbl_count := 0;
1434: l_param_name_count := 0;
1435:
1436:

Line 1581: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

1577:
1578: fnd_msg_pub.delete_msg();
1579: x_return_status := fnd_api.g_ret_sts_success;
1580: FND_MSG_PUB.initialize;
1581: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1582: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1583: x_msg_data := '';
1584:
1585:

Line 1582: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

1578: fnd_msg_pub.delete_msg();
1579: x_return_status := fnd_api.g_ret_sts_success;
1580: FND_MSG_PUB.initialize;
1581: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1582: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1583: x_msg_data := '';
1584:
1585:
1586:

Line 1609: FND_GLOBAL.USER_ID,

1605: OBJECT_VERSION_NUMBER,
1606: APPLICATION_ID
1607: ) values
1608: (l_param_id,
1609: FND_GLOBAL.USER_ID,
1610: SYSDATE,
1611: FND_GLOBAL.USER_ID,
1612: SYSDATE,
1613: FND_GLOBAL.LOGIN_ID,

Line 1611: FND_GLOBAL.USER_ID,

1607: ) values
1608: (l_param_id,
1609: FND_GLOBAL.USER_ID,
1610: SYSDATE,
1611: FND_GLOBAL.USER_ID,
1612: SYSDATE,
1613: FND_GLOBAL.LOGIN_ID,
1614: LTRIM(RTRIM(rec_obj.param_name)),
1615: rec_obj.data_type,

Line 1613: FND_GLOBAL.LOGIN_ID,

1609: FND_GLOBAL.USER_ID,
1610: SYSDATE,
1611: FND_GLOBAL.USER_ID,
1612: SYSDATE,
1613: FND_GLOBAL.LOGIN_ID,
1614: LTRIM(RTRIM(rec_obj.param_name)),
1615: rec_obj.data_type,
1616: 0,
1617: rec_obj.application_id

Line 1638: FND_GLOBAL.USER_ID,

1634: SOURCE_LANG,
1635: OBJECT_VERSION_NUMBER
1636: ) VALUES (
1637: l_param_id,
1638: FND_GLOBAL.USER_ID,
1639: SYSDATE,
1640: FND_GLOBAL.USER_ID,
1641: SYSDATE,
1642: FND_GLOBAL.LOGIN_ID,

Line 1640: FND_GLOBAL.USER_ID,

1636: ) VALUES (
1637: l_param_id,
1638: FND_GLOBAL.USER_ID,
1639: SYSDATE,
1640: FND_GLOBAL.USER_ID,
1641: SYSDATE,
1642: FND_GLOBAL.LOGIN_ID,
1643: LTRIM(RTRIM(rec_obj.param_user_label)),
1644: LTRIM(RTRIM(rec_obj.param_description)),

Line 1642: FND_GLOBAL.LOGIN_ID,

1638: FND_GLOBAL.USER_ID,
1639: SYSDATE,
1640: FND_GLOBAL.USER_ID,
1641: SYSDATE,
1642: FND_GLOBAL.LOGIN_ID,
1643: LTRIM(RTRIM(rec_obj.param_user_label)),
1644: LTRIM(RTRIM(rec_obj.param_description)),
1645: l_language,
1646: l_source_lang,

Line 1667: FND_GLOBAL.USER_ID,

1663: NOT_VALID_FLAG,
1664: OBJECT_VERSION_NUMBER
1665: ) VALUES (
1666: l_param_id,
1667: FND_GLOBAL.USER_ID,
1668: SYSDATE,
1669: FND_GLOBAL.USER_ID,
1670: SYSDATE,
1671: FND_GLOBAL.LOGIN_ID,

Line 1669: FND_GLOBAL.USER_ID,

1665: ) VALUES (
1666: l_param_id,
1667: FND_GLOBAL.USER_ID,
1668: SYSDATE,
1669: FND_GLOBAL.USER_ID,
1670: SYSDATE,
1671: FND_GLOBAL.LOGIN_ID,
1672: rec_obj.wp_action_def_id,
1673: l_action_param_map_id,

Line 1671: FND_GLOBAL.LOGIN_ID,

1667: FND_GLOBAL.USER_ID,
1668: SYSDATE,
1669: FND_GLOBAL.USER_ID,
1670: SYSDATE,
1671: FND_GLOBAL.LOGIN_ID,
1672: rec_obj.wp_action_def_id,
1673: l_action_param_map_id,
1674: null,
1675: 0

Line 1755: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

1751:
1752: fnd_msg_pub.delete_msg();
1753: x_return_status := fnd_api.g_ret_sts_success;
1754: FND_MSG_PUB.initialize;
1755: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1756: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1757: x_msg_data := '';
1758:
1759:

Line 1756: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

1752: fnd_msg_pub.delete_msg();
1753: x_return_status := fnd_api.g_ret_sts_success;
1754: FND_MSG_PUB.initialize;
1755: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1756: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1757: x_msg_data := '';
1758:
1759:
1760:

Line 1763: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1759:
1760:
1761:
1762: update IEU_WP_PARAM_DEFS_B set
1763: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1764: LAST_UPDATE_DATE = SYSDATE,
1765: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1766: DATA_TYPE = rec_obj.data_type
1767: where PARAM_ID = rec_obj.param_id;

Line 1765: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

1761:
1762: update IEU_WP_PARAM_DEFS_B set
1763: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1764: LAST_UPDATE_DATE = SYSDATE,
1765: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1766: DATA_TYPE = rec_obj.data_type
1767: where PARAM_ID = rec_obj.param_id;
1768:
1769:

Line 1776: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1772: end if;
1773:
1774:
1775: update IEU_WP_PARAM_DEFS_TL set
1776: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1777: LAST_UPDATE_DATE = SYSDATE,
1778: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1779: PARAM_USER_LABEL = LTRIM(RTRIM(rec_obj.param_user_label)),
1780: PARAM_DESCRIPTION = LTRIM(RTRIM(rec_obj.param_description))

Line 1778: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

1774:
1775: update IEU_WP_PARAM_DEFS_TL set
1776: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1777: LAST_UPDATE_DATE = SYSDATE,
1778: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1779: PARAM_USER_LABEL = LTRIM(RTRIM(rec_obj.param_user_label)),
1780: PARAM_DESCRIPTION = LTRIM(RTRIM(rec_obj.param_description))
1781: where PARAM_ID = rec_obj.param_id
1782: and l_language IN (language, source_lang);

Line 1846: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

1842:
1843: fnd_msg_pub.delete_msg();
1844: x_return_status := fnd_api.g_ret_sts_success;
1845: FND_MSG_PUB.initialize;
1846: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1847: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1848: x_msg_data := '';
1849:
1850:

Line 1847: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

1843: fnd_msg_pub.delete_msg();
1844: x_return_status := fnd_api.g_ret_sts_success;
1845: FND_MSG_PUB.initialize;
1846: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1847: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1848: x_msg_data := '';
1849:
1850:
1851: if ( p_property_id <> -1) then

Line 1870: FND_GLOBAL.USER_ID,

1866: VALUE_OVERRIDE_FLAG,
1867: OBJECT_VERSION_NUMBER
1868: ) VALUES (
1869: l_param_property_id,
1870: FND_GLOBAL.USER_ID,
1871: SYSDATE,
1872: FND_GLOBAL.USER_ID,
1873: SYSDATE,
1874: FND_GLOBAL.LOGIN_ID,

Line 1872: FND_GLOBAL.USER_ID,

1868: ) VALUES (
1869: l_param_property_id,
1870: FND_GLOBAL.USER_ID,
1871: SYSDATE,
1872: FND_GLOBAL.USER_ID,
1873: SYSDATE,
1874: FND_GLOBAL.LOGIN_ID,
1875: p_action_param_set_id,
1876: p_param_id,

Line 1874: FND_GLOBAL.LOGIN_ID,

1870: FND_GLOBAL.USER_ID,
1871: SYSDATE,
1872: FND_GLOBAL.USER_ID,
1873: SYSDATE,
1874: FND_GLOBAL.LOGIN_ID,
1875: p_action_param_set_id,
1876: p_param_id,
1877: p_property_id,
1878: p_property_value,

Line 1903: FND_GLOBAL.USER_ID,

1899: SOURCE_LANG,
1900: OBJECT_VERSION_NUMBER
1901: ) VALUES (
1902: l_param_property_id,
1903: FND_GLOBAL.USER_ID,
1904: SYSDATE,
1905: FND_GLOBAL.USER_ID,
1906: SYSDATE,
1907: FND_GLOBAL.LOGIN_ID,

Line 1905: FND_GLOBAL.USER_ID,

1901: ) VALUES (
1902: l_param_property_id,
1903: FND_GLOBAL.USER_ID,
1904: SYSDATE,
1905: FND_GLOBAL.USER_ID,
1906: SYSDATE,
1907: FND_GLOBAL.LOGIN_ID,
1908: p_property_value,
1909: l_language,

Line 1907: FND_GLOBAL.LOGIN_ID,

1903: FND_GLOBAL.USER_ID,
1904: SYSDATE,
1905: FND_GLOBAL.USER_ID,
1906: SYSDATE,
1907: FND_GLOBAL.LOGIN_ID,
1908: p_property_value,
1909: l_language,
1910: l_source_lang,
1911: 0

Line 1991: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

1987:
1988: fnd_msg_pub.delete_msg();
1989: x_return_status := fnd_api.g_ret_sts_success;
1990: FND_MSG_PUB.initialize;
1991: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1992: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1993: x_msg_data := '';
1994:
1995:

Line 1992: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

1988: fnd_msg_pub.delete_msg();
1989: x_return_status := fnd_api.g_ret_sts_success;
1990: FND_MSG_PUB.initialize;
1991: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1992: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1993: x_msg_data := '';
1994:
1995:
1996:

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

1999:
2000:
2001: EXECUTE immediate
2002: ' update IEU_WP_PARAM_PROPS_B set '||
2003: ' LAST_UPDATED_BY = FND_GLOBAL.USER_ID, '||
2004: ' LAST_UPDATE_DATE = SYSDATE, '||
2005: ' LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID, '||
2006: ' PROPERTY_VALUE = :1, '||
2007: ' PROPERTY_ID = :2 '||

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

2001: EXECUTE immediate
2002: ' update IEU_WP_PARAM_PROPS_B set '||
2003: ' LAST_UPDATED_BY = FND_GLOBAL.USER_ID, '||
2004: ' LAST_UPDATE_DATE = SYSDATE, '||
2005: ' LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID, '||
2006: ' PROPERTY_VALUE = :1, '||
2007: ' PROPERTY_ID = :2 '||
2008: ' where PARAM_ID= :3 '||
2009: ' and ACTION_PARAM_SET_ID = :4 ' ||

Line 2045: USING l_param_property_id,FND_GLOBAL.USER_ID,SYSDATE, FND_GLOBAL.USER_ID,

2041: ' :10, '||
2042: ' :11, '||
2043: ' :12 '||
2044: ' ) '
2045: USING l_param_property_id,FND_GLOBAL.USER_ID,SYSDATE, FND_GLOBAL.USER_ID,
2046: SYSDATE,FND_GLOBAL.LOGIN_ID, p_action_param_set_id,p_param_id,p_property_id,
2047: p_property_value, 'F', '0';
2048:
2049: end if;

Line 2046: SYSDATE,FND_GLOBAL.LOGIN_ID, p_action_param_set_id,p_param_id,p_property_id,

2042: ' :11, '||
2043: ' :12 '||
2044: ' ) '
2045: USING l_param_property_id,FND_GLOBAL.USER_ID,SYSDATE, FND_GLOBAL.USER_ID,
2046: SYSDATE,FND_GLOBAL.LOGIN_ID, p_action_param_set_id,p_param_id,p_property_id,
2047: p_property_value, 'F', '0';
2048:
2049: end if;
2050:

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

2056:
2057:
2058: EXECUTE immediate
2059: ' update IEU_WP_PARAM_PROPS_B set '||
2060: ' LAST_UPDATED_BY = FND_GLOBAL.USER_ID, '||
2061: ' LAST_UPDATE_DATE = SYSDATE, '||
2062: ' LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID, '||
2063: ' PROPERTY_VALUE = :1 '||
2064: ' where PARAM_ID= :2 '||

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

2058: EXECUTE immediate
2059: ' update IEU_WP_PARAM_PROPS_B set '||
2060: ' LAST_UPDATED_BY = FND_GLOBAL.USER_ID, '||
2061: ' LAST_UPDATE_DATE = SYSDATE, '||
2062: ' LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID, '||
2063: ' PROPERTY_VALUE = :1 '||
2064: ' where PARAM_ID= :2 '||
2065: ' and ACTION_PARAM_SET_ID = :3 '||
2066: ' and PROPERTY_ID = :4 '

Line 2099: USING l_param_property_id,FND_GLOBAL.USER_ID,SYSDATE,

2095: ' :9, '||
2096: ' :10, '||
2097: ' :11, '||
2098: ' :12) '
2099: USING l_param_property_id,FND_GLOBAL.USER_ID,SYSDATE,
2100: FND_GLOBAL.USER_ID, SYSDATE,FND_GLOBAL.LOGIN_ID,
2101: p_action_param_set_id, p_param_id, p_property_id,
2102: p_property_value, 'F','0' ;
2103: EXECUTE immediate

Line 2100: FND_GLOBAL.USER_ID, SYSDATE,FND_GLOBAL.LOGIN_ID,

2096: ' :10, '||
2097: ' :11, '||
2098: ' :12) '
2099: USING l_param_property_id,FND_GLOBAL.USER_ID,SYSDATE,
2100: FND_GLOBAL.USER_ID, SYSDATE,FND_GLOBAL.LOGIN_ID,
2101: p_action_param_set_id, p_param_id, p_property_id,
2102: p_property_value, 'F','0' ;
2103: EXECUTE immediate
2104: ' select VALUE_TRANSLATABLE_FLAG '||

Line 2135: USING l_param_property_id, FND_GLOBAL.USER_ID, SYSDATE,

2131: ' :8, '||
2132: ' :9, '||
2133: ' :10 '||
2134: ') '
2135: USING l_param_property_id, FND_GLOBAL.USER_ID, SYSDATE,
2136: FND_GLOBAL.USER_ID, SYSDATE,FND_GLOBAL.LOGIN_ID,
2137: p_property_value, l_language, l_source_lang , '0' ;
2138:
2139: end if;

Line 2136: FND_GLOBAL.USER_ID, SYSDATE,FND_GLOBAL.LOGIN_ID,

2132: ' :9, '||
2133: ' :10 '||
2134: ') '
2135: USING l_param_property_id, FND_GLOBAL.USER_ID, SYSDATE,
2136: FND_GLOBAL.USER_ID, SYSDATE,FND_GLOBAL.LOGIN_ID,
2137: p_property_value, l_language, l_source_lang , '0' ;
2138:
2139: end if;
2140:

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

2155:
2156:
2157: EXECUTE immediate
2158: ' update IEU_WP_PARAM_PROPS_TL set '||
2159: ' LAST_UPDATED_BY = FND_GLOBAL.USER_ID, '||
2160: ' LAST_UPDATE_DATE = SYSDATE, '||
2161: ' LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID, '||
2162: ' PROPERTY_VALUE = :1 ' ||
2163: ' where PARAM_PROPERTY_ID = :2 '

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

2157: EXECUTE immediate
2158: ' update IEU_WP_PARAM_PROPS_TL set '||
2159: ' LAST_UPDATED_BY = FND_GLOBAL.USER_ID, '||
2160: ' LAST_UPDATE_DATE = SYSDATE, '||
2161: ' LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID, '||
2162: ' PROPERTY_VALUE = :1 ' ||
2163: ' where PARAM_PROPERTY_ID = :2 '
2164: USING p_property_value, l_param_property_id;
2165:

Line 2219: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

2215:
2216: fnd_msg_pub.delete_msg();
2217: x_return_status := fnd_api.g_ret_sts_success;
2218: FND_MSG_PUB.initialize;
2219: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
2220: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
2221: x_msg_data := '';
2222:
2223:

Line 2220: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

2216: fnd_msg_pub.delete_msg();
2217: x_return_status := fnd_api.g_ret_sts_success;
2218: FND_MSG_PUB.initialize;
2219: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
2220: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
2221: x_msg_data := '';
2222:
2223:
2224: /*******************ADD FOR FORWARD PORT BUG5585922 BY MAJHA**********************/

Line 2229: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

2225: if (p_property_id = 10003 or p_property_id = 10022) then
2226: --if (p_property_id = 10003 or p_property_id = 10022 or p_property_id = 10011) then
2227: /*********************************************************************************/
2228: update IEU_WP_PARAM_PROPS_B set
2229: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2230: LAST_UPDATE_DATE = SYSDATE,
2231: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
2232: PROPERTY_VALUE = p_property_value,
2233: PROPERTY_ID = p_property_id

Line 2231: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

2227: /*********************************************************************************/
2228: update IEU_WP_PARAM_PROPS_B set
2229: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2230: LAST_UPDATE_DATE = SYSDATE,
2231: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
2232: PROPERTY_VALUE = p_property_value,
2233: PROPERTY_ID = p_property_id
2234: where PARAM_ID= p_param_id
2235: and ACTION_PARAM_SET_ID = p_action_param_set_id

Line 2260: FND_GLOBAL.USER_ID,

2256: VALUE_OVERRIDE_FLAG,
2257: OBJECT_VERSION_NUMBER
2258: ) VALUES (
2259: l_param_property_id,
2260: FND_GLOBAL.USER_ID,
2261: SYSDATE,
2262: FND_GLOBAL.USER_ID,
2263: SYSDATE,
2264: FND_GLOBAL.LOGIN_ID,

Line 2262: FND_GLOBAL.USER_ID,

2258: ) VALUES (
2259: l_param_property_id,
2260: FND_GLOBAL.USER_ID,
2261: SYSDATE,
2262: FND_GLOBAL.USER_ID,
2263: SYSDATE,
2264: FND_GLOBAL.LOGIN_ID,
2265: p_action_param_set_id,
2266: p_param_id,

Line 2264: FND_GLOBAL.LOGIN_ID,

2260: FND_GLOBAL.USER_ID,
2261: SYSDATE,
2262: FND_GLOBAL.USER_ID,
2263: SYSDATE,
2264: FND_GLOBAL.LOGIN_ID,
2265: p_action_param_set_id,
2266: p_param_id,
2267: p_property_id,
2268: p_property_value,

Line 2283: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

2279:
2280:
2281:
2282: update IEU_WP_PARAM_PROPS_B set
2283: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2284: LAST_UPDATE_DATE = SYSDATE,
2285: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
2286: PROPERTY_VALUE = p_property_value
2287: where PARAM_ID= p_param_id

Line 2285: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

2281:
2282: update IEU_WP_PARAM_PROPS_B set
2283: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2284: LAST_UPDATE_DATE = SYSDATE,
2285: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
2286: PROPERTY_VALUE = p_property_value
2287: where PARAM_ID= p_param_id
2288: and ACTION_PARAM_SET_ID = p_action_param_set_id
2289: and PROPERTY_ID = p_property_id;

Line 2309: FND_GLOBAL.USER_ID,

2305: VALUE_OVERRIDE_FLAG,
2306: OBJECT_VERSION_NUMBER
2307: ) VALUES (
2308: l_param_property_id,
2309: FND_GLOBAL.USER_ID,
2310: SYSDATE,
2311: FND_GLOBAL.USER_ID,
2312: SYSDATE,
2313: FND_GLOBAL.LOGIN_ID,

Line 2311: FND_GLOBAL.USER_ID,

2307: ) VALUES (
2308: l_param_property_id,
2309: FND_GLOBAL.USER_ID,
2310: SYSDATE,
2311: FND_GLOBAL.USER_ID,
2312: SYSDATE,
2313: FND_GLOBAL.LOGIN_ID,
2314: p_action_param_set_id,
2315: p_param_id,

Line 2313: FND_GLOBAL.LOGIN_ID,

2309: FND_GLOBAL.USER_ID,
2310: SYSDATE,
2311: FND_GLOBAL.USER_ID,
2312: SYSDATE,
2313: FND_GLOBAL.LOGIN_ID,
2314: p_action_param_set_id,
2315: p_param_id,
2316: p_property_id,
2317: p_property_value,

Line 2342: FND_GLOBAL.USER_ID,

2338: SOURCE_LANG,
2339: OBJECT_VERSION_NUMBER
2340: ) VALUES (
2341: l_param_property_id,
2342: FND_GLOBAL.USER_ID,
2343: SYSDATE,
2344: FND_GLOBAL.USER_ID,
2345: SYSDATE,
2346: FND_GLOBAL.LOGIN_ID,

Line 2344: FND_GLOBAL.USER_ID,

2340: ) VALUES (
2341: l_param_property_id,
2342: FND_GLOBAL.USER_ID,
2343: SYSDATE,
2344: FND_GLOBAL.USER_ID,
2345: SYSDATE,
2346: FND_GLOBAL.LOGIN_ID,
2347: p_property_value,
2348: l_language,

Line 2346: FND_GLOBAL.LOGIN_ID,

2342: FND_GLOBAL.USER_ID,
2343: SYSDATE,
2344: FND_GLOBAL.USER_ID,
2345: SYSDATE,
2346: FND_GLOBAL.LOGIN_ID,
2347: p_property_value,
2348: l_language,
2349: l_source_lang,
2350: 0

Line 2370: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

2366: and PROPERTY_ID = p_property_id;
2367:
2368:
2369: update IEU_WP_PARAM_PROPS_TL set
2370: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2371: LAST_UPDATE_DATE = SYSDATE,
2372: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
2373: PROPERTY_VALUE = p_property_value
2374: where PARAM_PROPERTY_ID = l_param_property_id;

Line 2372: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

2368:
2369: update IEU_WP_PARAM_PROPS_TL set
2370: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2371: LAST_UPDATE_DATE = SYSDATE,
2372: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
2373: PROPERTY_VALUE = p_property_value
2374: where PARAM_PROPERTY_ID = l_param_property_id;
2375:
2376: if (sql%notfound) then

Line 2424: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

2420: l_language VARCHAR2(4);
2421:
2422: l_param_property_id IEU_WP_PARAM_PROPS_TL.PARAM_PROPERTY_ID%type;
2423: BEGIN
2424: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
2425:
2426:
2427:
2428: EXECUTE immediate

Line 2582: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

2578:
2579: fnd_msg_pub.delete_msg();
2580: x_return_status := fnd_api.g_ret_sts_success;
2581: FND_MSG_PUB.initialize;
2582: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
2583: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
2584: x_msg_data := '';
2585:
2586:

Line 2583: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

2579: fnd_msg_pub.delete_msg();
2580: x_return_status := fnd_api.g_ret_sts_success;
2581: FND_MSG_PUB.initialize;
2582: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
2583: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
2584: x_msg_data := '';
2585:
2586:
2587: IEU_WorkPanel_PVT.Validate_Action_Label(l_return_status,

Line 2647: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

2643:
2644: fnd_msg_pub.delete_msg();
2645: x_return_status := fnd_api.g_ret_sts_success;
2646: FND_MSG_PUB.initialize;
2647: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
2648: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
2649: x_msg_data := '';
2650:
2651:

Line 2648: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

2644: fnd_msg_pub.delete_msg();
2645: x_return_status := fnd_api.g_ret_sts_success;
2646: FND_MSG_PUB.initialize;
2647: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
2648: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
2649: x_msg_data := '';
2650:
2651:
2652: IEU_WorkPanel_PVT.Validate_Action_Label(l_return_status,

Line 2738: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

2734:
2735: fnd_msg_pub.delete_msg();
2736: x_return_status := fnd_api.g_ret_sts_success;
2737: FND_MSG_PUB.initialize;
2738: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
2739: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
2740: x_msg_data := '';
2741:
2742:

Line 2739: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

2735: fnd_msg_pub.delete_msg();
2736: x_return_status := fnd_api.g_ret_sts_success;
2737: FND_MSG_PUB.initialize;
2738: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
2739: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
2740: x_msg_data := '';
2741:
2742:
2743:

Line 2817: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

2813: /* dolee add on 8/26/04 mapped action should set registered flag to 'y' */
2814: if (p_maction_def_type_flag <> 'F') then
2815:
2816: update IEU_UWQ_SEL_ENUMERATORS set
2817: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2818: LAST_UPDATE_DATE = SYSDATE,
2819: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
2820: WORK_PANEL_REGISTERED_FLAG = 'Y'
2821: where SEL_ENUM_ID = p_enum_id;

Line 2819: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

2815:
2816: update IEU_UWQ_SEL_ENUMERATORS set
2817: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2818: LAST_UPDATE_DATE = SYSDATE,
2819: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
2820: WORK_PANEL_REGISTERED_FLAG = 'Y'
2821: where SEL_ENUM_ID = p_enum_id;
2822:
2823:

Line 2833: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

2829: AND SECTION_ID = l_section_id;
2830:
2831: if (l_count > 0) then
2832: update IEU_WP_NODE_SECTION_MAPS set
2833: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2834: LAST_UPDATE_DATE = SYSDATE,
2835: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
2836: RESPONSIBILITY_ID = null,
2837: SECTION_MAP_SEQUENCE = l_section_map_sequence

Line 2835: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

2831: if (l_count > 0) then
2832: update IEU_WP_NODE_SECTION_MAPS set
2833: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2834: LAST_UPDATE_DATE = SYSDATE,
2835: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
2836: RESPONSIBILITY_ID = null,
2837: SECTION_MAP_SEQUENCE = l_section_map_sequence
2838: where ENUM_TYPE_UUID = l_enum_uuid
2839: and APPLICATION_ID = p_application

Line 2859: FND_GLOBAL.USER_ID,

2855: SECTION_MAP_SEQUENCE
2856: ) values
2857: (l_wp_node_section_map_id,
2858: 0,
2859: FND_GLOBAL.USER_ID,
2860: SYSDATE,
2861: FND_GLOBAL.USER_ID,
2862: SYSDATE,
2863: FND_GLOBAL.LOGIN_ID,

Line 2861: FND_GLOBAL.USER_ID,

2857: (l_wp_node_section_map_id,
2858: 0,
2859: FND_GLOBAL.USER_ID,
2860: SYSDATE,
2861: FND_GLOBAL.USER_ID,
2862: SYSDATE,
2863: FND_GLOBAL.LOGIN_ID,
2864: p_application,
2865: null,

Line 2863: FND_GLOBAL.LOGIN_ID,

2859: FND_GLOBAL.USER_ID,
2860: SYSDATE,
2861: FND_GLOBAL.USER_ID,
2862: SYSDATE,
2863: FND_GLOBAL.LOGIN_ID,
2864: p_application,
2865: null,
2866: l_enum_uuid,
2867: l_section_id,

Line 2940: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

2936:
2937: fnd_msg_pub.delete_msg();
2938: x_return_status := fnd_api.g_ret_sts_success;
2939: FND_MSG_PUB.initialize;
2940: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
2941: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
2942: x_msg_data := '';
2943:
2944:

Line 2941: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

2937: fnd_msg_pub.delete_msg();
2938: x_return_status := fnd_api.g_ret_sts_success;
2939: FND_MSG_PUB.initialize;
2940: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
2941: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
2942: x_msg_data := '';
2943:
2944:
2945:

Line 3003: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

2999: BEGIN
3000: fnd_msg_pub.delete_msg();
3001: x_return_status := fnd_api.g_ret_sts_success;
3002: FND_MSG_PUB.initialize;
3003: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
3004: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
3005: x_msg_data := '';
3006:
3007:

Line 3004: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

3000: fnd_msg_pub.delete_msg();
3001: x_return_status := fnd_api.g_ret_sts_success;
3002: FND_MSG_PUB.initialize;
3003: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
3004: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
3005: x_msg_data := '';
3006:
3007:
3008: delete from ieu_wp_param_props_b