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.IEX_CASE_UTL_PUB dependencies on IEX_CASE_DEFINITIONS

Line 188: x_case_def_rec OUT NOCOPY iex_case_definitions_pvt.CASE_DEFINITION_Rec_Type) IS

184:
185: /**Name Converts Case def record type from public to PVT **/
186: Procedure Convert_case_def_Record (
187: p_attribute_rec IN iex_case_utl_pub.cas_Rec_Type,
188: x_case_def_rec OUT NOCOPY iex_case_definitions_pvt.CASE_DEFINITION_Rec_Type) IS
189: Begin
190: -- IF PG_DEBUG < 10 THEN
191: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
192: iex_debug_pub.LogMessage('Convert_case_def_Record: ' || '*********End of Convert case def Record record *********');

Line 238: From iex_case_definitions

234: ) IS
235:
236: Cursor get_case_def is
237: Select column_name,column_value,table_name
238: From iex_case_definitions
239: where cas_id =p_cas_id
240: and active_flag ='Y';
241: tbl_ctr NUMBER ;
242: BEGIN

Line 340: iex_case_definitions_pvt.case_definition_rec_type) IS

336: p_column_value IN VARCHAR2,
337: p_cas_id IN NUMBER,
338: p_attribute_rec IN CAS_Rec_Type := G_MISS_CAS_REC,
339: x_case_def_rec OUT NOCOPY
340: iex_case_definitions_pvt.case_definition_rec_type) IS
341: BEGIN
342: -- IF PG_DEBUG < 10 THEN
343: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
344: IEX_DEBUG_PUB.LogMessage ('*********Start of Procedure =>PopulateCaseDefRec*********');

Line 720: vstr2 VARCHAR2 (2000):= ' iex_case_definitions a ';

716: ' and ICAS.active_flag='||'''Y''' ||' ) ';
717:
718: -- clchang updated for sql bind var 05/07/2003
719: vstr1 VARCHAR2 (2000):= ' select a.cas_id from ';
720: vstr2 VARCHAR2 (2000):= ' iex_case_definitions a ';
721: vstr3 VARCHAR2 (2000):= ' where a.column_name = ' ;
722: vstr4 VARCHAR2 (2000):= '''';
723: vstr5 VARCHAR2 (2000):= ' and a.column_value = ';
724: vstr6 VARCHAR2 (2000):= ' and a.active_flag= ''Y'' ';

Line 730: ' iex_case_definitions a '||

726: vstr7 VARCHAR2 (100) := ' and table_name=' ;
727: l_table_clause VARCHAR2 (100);
728: /*
729: l_first_sql VARCHAR2 (2000):=' select a.cas_id from '||
730: ' iex_case_definitions a '||
731: ' where a.column_name =' ||''''|| l_column_name || ''''||
732: ' and a.column_value =' ||''''|| l_column_value || ''''||
733: ' and a.active_flag='||'''Y''';
734: l_table_clause VARCHAR2(100) := ' and table_name=' ||''''|| l_table_name || '''' ;

Line 739: v_sql_str2 VARCHAR2(100) := ' iex_case_definitions ';

735: */
736:
737: -- for l_sql
738: v_sql_str1 VARCHAR2(100) := ' and exists ( select null from ';
739: v_sql_str2 VARCHAR2(100) := ' iex_case_definitions ';
740: v_sql_str3 VARCHAR2(100) := ' where column_name = ';
741: v_sql_str4 VARCHAR2(100) := ' and column_value = ' ;
742: v_sql_str5 VARCHAR2(100) := ' and ';
743: v_sql_str6 VARCHAR2(100) := '.cas_id= a.cas_id ' ;

Line 811: ' iex_case_definitions ' || l_table_alias ||

807: v_sql_str5 || l_table_alias || v_sql_str6 ||
808: v_sql_str5 || l_table_alias || v_sql_str7 ;
809: /*
810: l_sql := l_sql || ' and exists ( select null from '||
811: ' iex_case_definitions ' || l_table_alias ||
812: ' where column_name =' ||''''|| l_column_name || ''''||
813: ' and column_value =' ||''''|| l_column_value || ''''||
814: ' and '||l_table_alias ||'.cas_id= ' ||'a.cas_id'||
815: ' and '||l_table_alias ||'.active_flag='||'''Y''' ;

Line 919: l_case_definition_rec iex_case_definitions_pvt.case_definition_rec_type

915: l_case_object_id NUMBER;
916: l_case_definition_id NUMBER;
917: l_cas_rec iex_cases_pvt.cas_rec_type
918: := iex_cases_pvt.g_miss_cas_rec;
919: l_case_definition_rec iex_case_definitions_pvt.case_definition_rec_type
920: := iex_case_definitions_pvt.g_miss_case_definition_rec;
921: l_case_object_rec iex_case_objects_pvt.case_object_rec_type
922: := iex_case_objects_pvt.g_miss_case_object_rec;
923: l_case_definition_tbl CASE_DEFINITION_TBL_TYPE

Line 920: := iex_case_definitions_pvt.g_miss_case_definition_rec;

916: l_case_definition_id NUMBER;
917: l_cas_rec iex_cases_pvt.cas_rec_type
918: := iex_cases_pvt.g_miss_cas_rec;
919: l_case_definition_rec iex_case_definitions_pvt.case_definition_rec_type
920: := iex_case_definitions_pvt.g_miss_case_definition_rec;
921: l_case_object_rec iex_case_objects_pvt.case_object_rec_type
922: := iex_case_objects_pvt.g_miss_case_object_rec;
923: l_case_definition_tbl CASE_DEFINITION_TBL_TYPE
924: DEFAULT G_MISS_CASE_DEF_TBL;

Line 1158: iex_case_definitions_pvt.create_case_definitions(

1154: -- IF PG_DEBUG < 10 THEN
1155: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1156: iex_debug_pub.logMessage('CloseCase: ' || 'Before Calling Create Case Definition PVT');
1157: END IF;
1158: iex_case_definitions_pvt.create_case_definitions(
1159: P_Api_Version_Number =>l_api_version_number,
1160: P_Init_Msg_List =>FND_API.G_FALSE,
1161: P_Commit =>FND_API.G_FALSE,
1162: p_validation_level =>P_validation_level,

Line 1334: l_case_definition_rec iex_case_definitions_pvt.case_definition_rec_type

1330: l_case_object_id NUMBER;
1331: l_case_definition_id NUMBER;
1332: l_cas_rec iex_cases_pvt.cas_rec_type
1333: := iex_cases_pvt.g_miss_cas_rec;
1334: l_case_definition_rec iex_case_definitions_pvt.case_definition_rec_type
1335: := iex_case_definitions_pvt.g_miss_case_definition_rec;
1336: l_case_object_rec iex_case_objects_pvt.case_object_rec_type
1337: := iex_case_objects_pvt.g_miss_case_object_rec;
1338:

Line 1335: := iex_case_definitions_pvt.g_miss_case_definition_rec;

1331: l_case_definition_id NUMBER;
1332: l_cas_rec iex_cases_pvt.cas_rec_type
1333: := iex_cases_pvt.g_miss_cas_rec;
1334: l_case_definition_rec iex_case_definitions_pvt.case_definition_rec_type
1335: := iex_case_definitions_pvt.g_miss_case_definition_rec;
1336: l_case_object_rec iex_case_objects_pvt.case_object_rec_type
1337: := iex_case_objects_pvt.g_miss_case_object_rec;
1338:
1339: l_resource_tab iex_utilities.resource_tab_type; -- added by ehuh Aug 1 2003

Line 1754: iex_case_definitions_pvt.create_case_definitions(

1750: -- IF PG_DEBUG < 10 THEN
1751: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1752: iex_debug_pub.logMessage('CreateCaseObjects: ' || '---------------------------------');
1753: END IF;
1754: iex_case_definitions_pvt.create_case_definitions(
1755: P_Api_Version_Number =>l_api_version_number,
1756: P_Init_Msg_List =>FND_API.G_FALSE,
1757: P_Commit =>FND_API.G_FALSE,
1758: p_validation_level =>P_validation_level,

Line 1944: l_case_definition_rec iex_case_definitions_pvt.case_definition_rec_type

1940: l_case_object_id NUMBER;
1941: l_case_definition_id NUMBER;
1942: l_cas_rec iex_cases_pvt.cas_rec_type
1943: := iex_cases_pvt.g_miss_cas_rec;
1944: l_case_definition_rec iex_case_definitions_pvt.case_definition_rec_type
1945: := iex_case_definitions_pvt.g_miss_case_definition_rec;
1946: l_case_object_rec iex_case_objects_pvt.case_object_rec_type
1947: := iex_case_objects_pvt.g_miss_case_object_rec;
1948:

Line 1945: := iex_case_definitions_pvt.g_miss_case_definition_rec;

1941: l_case_definition_id NUMBER;
1942: l_cas_rec iex_cases_pvt.cas_rec_type
1943: := iex_cases_pvt.g_miss_cas_rec;
1944: l_case_definition_rec iex_case_definitions_pvt.case_definition_rec_type
1945: := iex_case_definitions_pvt.g_miss_case_definition_rec;
1946: l_case_object_rec iex_case_objects_pvt.case_object_rec_type
1947: := iex_case_objects_pvt.g_miss_case_object_rec;
1948:
1949: l_old_case_id NUMBER;

Line 2440: iex_case_definitions_pvt.create_case_definitions(

2436: -- IF PG_DEBUG < 10 THEN
2437: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2438: iex_debug_pub.logMessage('ReassignCaseObjects: ' || '---------------------------------');
2439: END IF;
2440: iex_case_definitions_pvt.create_case_definitions(
2441: P_Api_Version_Number =>l_api_version_number,
2442: P_Init_Msg_List =>FND_API.G_FALSE,
2443: P_Commit =>FND_API.G_FALSE,
2444: p_validation_level =>P_validation_level,