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_UWQ_MEDIA_TYPES_PVT dependencies on IEU_UWQ_MEDIA_TYPES_B

Line 51: v_media_type_id IEU_UWQ_MEDIA_TYPES_B.MEDIA_TYPE_ID%type;

47:
48: v_dummy INTEGER;
49:
50:
51: v_media_type_id IEU_UWQ_MEDIA_TYPES_B.MEDIA_TYPE_ID%type;
52:
53: v_tel_reqd_flag IEU_UWQ_MEDIA_TYPES_B.TEL_REQD_FLAG%type;
54:
55: v_media_type_name IEU_UWQ_MEDIA_TYPES_TL.MEDIA_TYPE_NAME%type;

Line 53: v_tel_reqd_flag IEU_UWQ_MEDIA_TYPES_B.TEL_REQD_FLAG%type;

49:
50:
51: v_media_type_id IEU_UWQ_MEDIA_TYPES_B.MEDIA_TYPE_ID%type;
52:
53: v_tel_reqd_flag IEU_UWQ_MEDIA_TYPES_B.TEL_REQD_FLAG%type;
54:
55: v_media_type_name IEU_UWQ_MEDIA_TYPES_TL.MEDIA_TYPE_NAME%type;
56:
57: v_media_type_description IEU_UWQ_MEDIA_TYPES_TL.MEDIA_TYPE_DESCRIPTION%type;

Line 69: v_media_type_uuid IEU_UWQ_MEDIA_TYPES_B.MEDIA_TYPE_UUID%type;

65: v_svr_mps_plugin_id IEU_UWQ_SVR_MPS_PLUGINS.SVR_MPS_PLUGIN_ID%type;
66:
67: v_svr_plugin_class IEU_UWQ_SVR_MPS_PLUGINS.SVR_PLUGIN_CLASS%type;
68:
69: v_media_type_uuid IEU_UWQ_MEDIA_TYPES_B.MEDIA_TYPE_UUID%type;
70:
71: v_svr_login_rule_id IEU_UWQ_MEDIA_TYPES_B.SVR_LOGIN_RULE_ID%type;
72:
73: v_application_id IEU_UWQ_MEDIA_TYPES_B.APPLICATION_ID%type;

Line 71: v_svr_login_rule_id IEU_UWQ_MEDIA_TYPES_B.SVR_LOGIN_RULE_ID%type;

67: v_svr_plugin_class IEU_UWQ_SVR_MPS_PLUGINS.SVR_PLUGIN_CLASS%type;
68:
69: v_media_type_uuid IEU_UWQ_MEDIA_TYPES_B.MEDIA_TYPE_UUID%type;
70:
71: v_svr_login_rule_id IEU_UWQ_MEDIA_TYPES_B.SVR_LOGIN_RULE_ID%type;
72:
73: v_application_id IEU_UWQ_MEDIA_TYPES_B.APPLICATION_ID%type;
74:
75: v_application_name FND_APPLICATION_TL.APPLICATION_NAME%type;

Line 73: v_application_id IEU_UWQ_MEDIA_TYPES_B.APPLICATION_ID%type;

69: v_media_type_uuid IEU_UWQ_MEDIA_TYPES_B.MEDIA_TYPE_UUID%type;
70:
71: v_svr_login_rule_id IEU_UWQ_MEDIA_TYPES_B.SVR_LOGIN_RULE_ID%type;
72:
73: v_application_id IEU_UWQ_MEDIA_TYPES_B.APPLICATION_ID%type;
74:
75: v_application_name FND_APPLICATION_TL.APPLICATION_NAME%type;
76:
77: v_is_server_side VARCHAR2(2);

Line 79: v_classfn_query_proc IEU_UWQ_MEDIA_TYPES_B.CLASSIFICATION_QUERY_PROC%type;

75: v_application_name FND_APPLICATION_TL.APPLICATION_NAME%type;
76:
77: v_is_server_side VARCHAR2(2);
78:
79: v_classfn_query_proc IEU_UWQ_MEDIA_TYPES_B.CLASSIFICATION_QUERY_PROC%type;
80:
81:
82: BEGIN
83: x_return_status := fnd_api.g_ret_sts_success;

Line 92: ' b.SVR_LOGIN_RULE_ID, b.APPLICATION_ID,b.CLASSIFICATION_QUERY_PROC from IEU_UWQ_MEDIA_TYPES_B b, IEU_UWQ_MEDIA_TYPES_TL tl, IEU_UWQ_CLI_MED_PLUGINS cl, ' ||

88: v_is_server_side := 'N';
89:
90: v_selectStmt := ' select b.MEDIA_TYPE_ID, b.TEL_REQD_FLAG, tl.MEDIA_TYPE_NAME, tl.MEDIA_TYPE_DESCRIPTION, cl.CLI_PLUGIN_ID,' ||
91: ' cl.CLI_PLUGIN_CLASS, svm.SVR_TYPE_ID, svp.SVR_MPS_PLUGIN_ID, svp.SVR_PLUGIN_CLASS, b.MEDIA_TYPE_UUID, ' ||
92: ' b.SVR_LOGIN_RULE_ID, b.APPLICATION_ID,b.CLASSIFICATION_QUERY_PROC from IEU_UWQ_MEDIA_TYPES_B b, IEU_UWQ_MEDIA_TYPES_TL tl, IEU_UWQ_CLI_MED_PLUGINS cl, ' ||
93: ' IEU_UWQ_SVR_MPS_MMAPS svm, IEU_UWQ_SVR_MPS_PLUGINS svp ' ||
94: ' where b.MEDIA_TYPE_ID = tl.MEDIA_TYPE_ID and b.MEDIA_TYPE_ID = cl.MEDIA_TYPE_ID ' ||
95: ' and tl.LANGUAGE = '||''''||p_language||''''||' and b.MEDIA_TYPE_ID = svm.MEDIA_TYPE_ID ' ||
96: ' and svm.SVR_TYPE_ID = svp.SVR_TYPE_ID order by ' || p_order_by || ' ' || p_asc;

Line 244: l_temp_classproc IEU_UWQ_MEDIA_TYPES_B.CLASSIFICATION_QUERY_PROC%type;

240: class_name_count NUMBER(5);
241:
242: cli_class_name_count NUMBER(5);
243:
244: l_temp_classproc IEU_UWQ_MEDIA_TYPES_B.CLASSIFICATION_QUERY_PROC%type;
245: l_temp_pkg_name IEU_UWQ_MEDIA_TYPES_B.CLASSIFICATION_QUERY_PROC%type;
246:
247: l_temp_class_count NUMBER(5);
248:

Line 245: l_temp_pkg_name IEU_UWQ_MEDIA_TYPES_B.CLASSIFICATION_QUERY_PROC%type;

241:
242: cli_class_name_count NUMBER(5);
243:
244: l_temp_classproc IEU_UWQ_MEDIA_TYPES_B.CLASSIFICATION_QUERY_PROC%type;
245: l_temp_pkg_name IEU_UWQ_MEDIA_TYPES_B.CLASSIFICATION_QUERY_PROC%type;
246:
247: l_temp_class_count NUMBER(5);
248:
249:

Line 337: select count(*) into media_uuid_count from IEU_UWQ_MEDIA_TYPES_B where lower(MEDIA_TYPE_UUID) like lower(temp_uuid);

333: FND_MSG_PUB.Add;
334: x_return_status := FND_API.G_RET_STS_ERROR;
335: else
336:
337: select count(*) into media_uuid_count from IEU_UWQ_MEDIA_TYPES_B where lower(MEDIA_TYPE_UUID) like lower(temp_uuid);
338:
339: if media_uuid_count <> 0 then
340: FND_MESSAGE.set_name('IEU', 'IEU_PROV_MEDIA_UUID_EXISTS');
341: FND_MSG_PUB.Add;

Line 614: select IEU_UWQ_MEDIA_TYPES_B_S2.NEXTVAL into l_media_type_id from sys.dual;

610: x_msg_data,
611: rec_obj, true);
612: if x_return_status = 'S' then
613:
614: select IEU_UWQ_MEDIA_TYPES_B_S2.NEXTVAL into l_media_type_id from sys.dual;
615:
616: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
617:
618: insert INTO IEU_UWQ_MEDIA_TYPES_B

Line 618: insert INTO IEU_UWQ_MEDIA_TYPES_B

614: select IEU_UWQ_MEDIA_TYPES_B_S2.NEXTVAL into l_media_type_id from sys.dual;
615:
616: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
617:
618: insert INTO IEU_UWQ_MEDIA_TYPES_B
619: (MEDIA_TYPE_ID,
620: CREATED_BY,
621: CREATION_DATE,
622: LAST_UPDATED_BY,

Line 950: update IEU_UWQ_MEDIA_TYPES_B set

946:
947: if x_return_status = 'S' then
948:
949:
950: update IEU_UWQ_MEDIA_TYPES_B set
951: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
952: LAST_UPDATE_DATE = SYSDATE,
953: LAST_UPDATE_LOGIN =FND_GLOBAL.LOGIN_ID,
954: TEL_REQD_FLAG = rec_obj.tel_reqd_flag,

Line 1353: delete from IEU_UWQ_MEDIA_TYPES_B

1349: if (sql%notfound) then
1350: null;
1351: end if;
1352:
1353: delete from IEU_UWQ_MEDIA_TYPES_B
1354: where MEDIA_TYPE_ID = x_media_type_id;
1355:
1356: if (sql%notfound) then
1357: null;