APPS.IEU_UWQ_MEDIA_TYPES_PVT dependencies on IEU_UWQ_MEDIA_TYPES_TL

Line 55: v_media_type_name IEU_UWQ_MEDIA_TYPES_TL.MEDIA_TYPE_NAME%type;

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;
58:
59: v_cli_plugin_id IEU_UWQ_CLI_MED_PLUGINS.CLI_PLUGIN_ID%type;

Line 57: v_media_type_description IEU_UWQ_MEDIA_TYPES_TL.MEDIA_TYPE_DESCRIPTION%type;

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;
58:
59: v_cli_plugin_id IEU_UWQ_CLI_MED_PLUGINS.CLI_PLUGIN_ID%type;
60:
61: v_cli_plugin_class IEU_UWQ_CLI_MED_PLUGINS.CLI_PLUGIN_CLASS%type;

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 297: select count(*) into media_name_count from IEU_UWQ_MEDIA_TYPES_TL where lower(MEDIA_TYPE_NAME) like lower(temp_media_name);

293: FND_MSG_PUB.Add;
294: x_return_status := FND_API.G_RET_STS_ERROR;
295: else
296:
297: select count(*) into media_name_count from IEU_UWQ_MEDIA_TYPES_TL where lower(MEDIA_TYPE_NAME) like lower(temp_media_name);
298: if media_name_count <> 0 then
299: FND_MESSAGE.set_name('IEU', 'IEU_PROV_MEDIA_NAME_EXISTS');
300: FND_MSG_PUB.Add;
301: x_return_status := FND_API.G_RET_STS_ERROR;

Line 659: insert into IEU_UWQ_MEDIA_TYPES_TL

655: null,
656: null
657: );
658:
659: insert into IEU_UWQ_MEDIA_TYPES_TL
660: ( MEDIA_TYPE_ID,
661: LANGUAGE,
662: CREATED_BY,
663: CREATION_DATE,

Line 961: update IEU_UWQ_MEDIA_TYPES_TL set

957: CLASSIFICATION_QUERY_PROC = rec_obj.classfn_query_proc
958: where MEDIA_TYPE_ID = rec_obj.media_type_id;
959:
960:
961: update IEU_UWQ_MEDIA_TYPES_TL set
962: LANGUAGE = l_language,
963: LAST_UPDATED_BY =FND_GLOBAL.USER_ID ,
964: LAST_UPDATE_DATE = SYSDATE,
965: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

Line 1345: delete from IEU_UWQ_MEDIA_TYPES_TL

1341: media_count NUMBER(15);
1342: temp_svr_type_id NUMBER(15);
1343:
1344: BEGIN
1345: delete from IEU_UWQ_MEDIA_TYPES_TL
1346: where MEDIA_TYPE_ID = x_media_type_id;
1347:
1348:
1349: if (sql%notfound) then