DBA Data[Home] [Help]

APPS.IEX_CASE_UTL_PUB dependencies on IEX_CASE_OBJECTS

Line 146: x_case_object_rec OUT NOCOPY iex_case_objects_pvt.case_object_Rec_Type)IS

142:
143: /**Name Converts Case record type from public to PVT **/
144: Procedure Convert_case_object_Record (
145: p_attribute_rec IN iex_case_utl_pub.cas_Rec_Type,
146: x_case_object_rec OUT NOCOPY iex_case_objects_pvt.case_object_Rec_Type)IS
147: Begin
148: -- IF PG_DEBUG < 10 THEN
149: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
150: iex_debug_pub.LogMessage('Convert_case_object_Record: ' || '*********End of Convert case object Record record *********');

Line 390: iex_case_objects_pvt.case_object_rec_type)IS

386: p_object_id IN NUMBER,
387: p_cas_id IN NUMBER,
388: p_attribute_rec IN CAS_Rec_Type := G_MISS_CAS_REC,
389: x_case_object_rec OUT NOCOPY
390: iex_case_objects_pvt.case_object_rec_type)IS
391:
392: BEGIN
393: -- IF PG_DEBUG < 10 THEN
394: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 921: l_case_object_rec iex_case_objects_pvt.case_object_rec_type

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;
925:

Line 922: := iex_case_objects_pvt.g_miss_case_object_rec;

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;
925:
926: l_resource_tab iex_utilities.resource_tab_type; -- added by ehuh Aug 1 2003

Line 932: from iex_case_objects

928:
929: Cursor get_case_objects_obj_ver_num (p_cas_id in number) is
930: select object_version_number,
931: case_object_id
932: from iex_case_objects
933: where cas_id =p_cas_id
934: and active_flag ='Y';
935:
936: BEGIN

Line 1203: iex_case_objects_pvt.update_case_objects(

1199: -- IF PG_DEBUG < 10 THEN
1200: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1201: iex_debug_pub.logMessage('CloseCase: ' || 'Before Calling update Case Object PVT');
1202: END IF;
1203: iex_case_objects_pvt.update_case_objects(
1204: P_Api_Version_Number =>l_api_version_number,
1205: P_Init_Msg_List =>FND_API.G_FALSE,
1206: P_Commit =>FND_API.G_FALSE,
1207: p_validation_level =>P_validation_level,

Line 1336: l_case_object_rec iex_case_objects_pvt.case_object_rec_type

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
1340: l_resource_id NUMBER := nvl(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'),0);

Line 1337: := iex_case_objects_pvt.g_miss_case_object_rec;

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
1340: l_resource_id NUMBER := nvl(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'),0);
1341:

Line 1530: iex_case_objects_pvt.Create_case_objects(

1526: -- IF PG_DEBUG < 10 THEN
1527: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1528: iex_debug_pub.logMessage('CreateCaseObjects: ' || '---------------------------------');
1529: END IF;
1530: iex_case_objects_pvt.Create_case_objects(
1531: P_Api_Version_Number =>l_api_version_number,
1532: P_Init_Msg_List =>FND_API.G_FALSE,
1533: P_Commit =>FND_API.G_FALSE,
1534: p_validation_level =>P_validation_level,

Line 1608: iex_case_objects_pvt.Create_case_objects(

1604: -- IF PG_DEBUG < 10 THEN
1605: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1606: iex_debug_pub.logMessage('CreateCaseObjects: ' || '---------------------------------');
1607: END IF;
1608: iex_case_objects_pvt.Create_case_objects(
1609: P_Api_Version_Number =>l_api_version_number,
1610: P_Init_Msg_List =>FND_API.G_FALSE,
1611: P_Commit =>FND_API.G_FALSE,
1612: p_validation_level =>P_validation_level,

Line 1791: iex_case_objects_pvt.Create_case_objects(

1787: -- IF PG_DEBUG < 10 THEN
1788: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1789: iex_debug_pub.logMessage('CreateCaseObjects: ' || '---------------------------------');
1790: END IF;
1791: iex_case_objects_pvt.Create_case_objects(
1792: P_Api_Version_Number =>l_api_version_number,
1793: P_Init_Msg_List =>FND_API.G_FALSE,
1794: P_Commit =>FND_API.G_FALSE,
1795: p_validation_level =>P_validation_level,

Line 1894: ** Delete the contracts from iex_case_objects

1890:
1891: /* Name ReassignCaseObjects
1892: ** api : Current version 2.0
1893: ** Purpose To Reassign case object.
1894: ** Delete the contracts from iex_case_objects
1895: ** It first checks if a case exists, else creates
1896: ** a new case with the given case definition. Also checks if the case definition
1897: ** elements passed are valid or not.The logic is as follows
1898: ** 1. Checks validity of Case Definition

Line 1946: l_case_object_rec iex_case_objects_pvt.case_object_rec_type

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;
1950: l_new_case_id NUMBER;

Line 1947: := iex_case_objects_pvt.g_miss_case_object_rec;

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;
1950: l_new_case_id NUMBER;
1951: x_del_id NUMBER;

Line 2130: from iex_case_objects a, okc_k_headers_b b

2126: -- Store the old case Id , will be used for re-score
2127: BEGIN
2128: select a.cas_id ,b.contract_number
2129: into l_old_case_id,l_contract_number
2130: from iex_case_objects a, okc_k_headers_b b
2131: where a.object_id =p_object_id
2132: and b.id =a.object_id;
2133:
2134: -- IF PG_DEBUG < 10 THEN

Line 2165: from iex_case_objects

2161: END IF;
2162:
2163: --Delete the contract/object from case objects table
2164: select case_object_id into l_case_object_id
2165: from iex_case_objects
2166: where object_id =p_object_id;
2167:
2168: iex_case_objects_pvt.delete_case_objects(
2169: P_Api_Version_Number =>l_api_version_number,

Line 2168: iex_case_objects_pvt.delete_case_objects(

2164: select case_object_id into l_case_object_id
2165: from iex_case_objects
2166: where object_id =p_object_id;
2167:
2168: iex_case_objects_pvt.delete_case_objects(
2169: P_Api_Version_Number =>l_api_version_number,
2170: P_Init_Msg_List =>FND_API.G_TRUE,
2171: P_Commit =>FND_API.G_FALSE,
2172: p_validation_level =>P_validation_level,

Line 2221: iex_case_objects_pvt.Create_case_objects(

2217: -- IF PG_DEBUG < 10 THEN
2218: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2219: iex_debug_pub.logMessage('ReassignCaseObjects: ' || '---------------------------------');
2220: END IF;
2221: iex_case_objects_pvt.Create_case_objects(
2222: P_Api_Version_Number =>l_api_version_number,
2223: P_Init_Msg_List =>FND_API.G_FALSE,
2224: P_Commit =>FND_API.G_FALSE,
2225: p_validation_level =>P_validation_level,

Line 2299: iex_case_objects_pvt.Create_case_objects(

2295: -- IF PG_DEBUG < 10 THEN
2296: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2297: iex_debug_pub.logMessage('ReassignCaseObjects: ' || '---------------------------------');
2298: END IF;
2299: iex_case_objects_pvt.Create_case_objects(
2300: P_Api_Version_Number =>l_api_version_number,
2301: P_Init_Msg_List =>FND_API.G_FALSE,
2302: P_Commit =>FND_API.G_FALSE,
2303: p_validation_level =>P_validation_level,

Line 2477: iex_case_objects_pvt.Create_case_objects(

2473: -- IF PG_DEBUG < 10 THEN
2474: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2475: iex_debug_pub.logMessage('ReassignCaseObjects: ' || '---------------------------------');
2476: END IF;
2477: iex_case_objects_pvt.Create_case_objects(
2478: P_Api_Version_Number =>l_api_version_number,
2479: P_Init_Msg_List =>FND_API.G_FALSE,
2480: P_Commit =>FND_API.G_FALSE,
2481: p_validation_level =>P_validation_level,

Line 3103: x_ObjectID iex_case_Objects.object_id%TYPE;

3099: */
3100: Function CheckContract
3101: (P_ObjectID IN NUMBER
3102: )Return BOOLEAN IS
3103: x_ObjectID iex_case_Objects.object_id%TYPE;
3104: Begin
3105: Select object_id INTO x_ObjectID
3106: from iex_case_objects
3107: where object_id =P_ObjectID;

Line 3106: from iex_case_objects

3102: )Return BOOLEAN IS
3103: x_ObjectID iex_case_Objects.object_id%TYPE;
3104: Begin
3105: Select object_id INTO x_ObjectID
3106: from iex_case_objects
3107: where object_id =P_ObjectID;
3108: return TRUE;
3109: EXCEPTION WHEN OTHERS THEN
3110: Return FALSE;