DBA Data[Home] [Help]

APPS.IEX_CASE_UTL_PUB dependencies on IEX_CASES_PVT

Line 89: x_cas_rec OUT NOCOPY iex_cases_pvt.cas_Rec_Type) IS

85:
86: /**Name Converts Case record type from public to PVT **/
87: Procedure Convert_case_Record (
88: p_cas_rec IN iex_case_utl_pub.cas_Rec_Type,
89: x_cas_rec OUT NOCOPY iex_cases_pvt.cas_Rec_Type) IS
90: Begin
91: -- IF PG_DEBUG < 10 THEN
92: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
93: iex_debug_pub.LogMessage('Convert_case_Record: ' || '*********Start of Convert Case record *********');

Line 262: x_cas_rec OUT NOCOPY iex_cases_pvt.cas_rec_type) IS

258: END PopulateCaseDefTbl;
259:
260: /** Populate Case Record **/
261: PROCEDURE PopCaseRec(p_cas_id IN NUMBER,
262: x_cas_rec OUT NOCOPY iex_cases_pvt.cas_rec_type) IS
263: Cursor Case_rec_cur (p_cas_id in number)is
264: select * from iex_cases_all_b
265: where cas_id =p_cas_id
266: and active_flag ='Y';

Line 365: x_cas_rec OUT NOCOPY iex_cases_pvt.cas_rec_type) IS

361: p_comments IN VARCHAR2 ,
362: p_org_id IN NUMBER ,
363: p_case_established_date IN DATE ,
364: p_attribute_rec IN CAS_Rec_Type := G_MISS_CAS_REC,
365: x_cas_rec OUT NOCOPY iex_cases_pvt.cas_rec_type) IS
366: BEGIN
367: -- IF PG_DEBUG < 10 THEN
368: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
369: IEX_DEBUG_PUB.LogMessage ('*********Start of Procedure =>PopulateCaseRec ********* ');

Line 917: l_cas_rec iex_cases_pvt.cas_rec_type

913: l_msg_count NUMBER;
914: l_msg_data VARCHAR2(32767);
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

Line 918: := iex_cases_pvt.g_miss_cas_rec;

914: l_msg_data VARCHAR2(32767);
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;

Line 1039: iex_cases_pvt.update_cas

1035: -- IF PG_DEBUG < 10 THEN
1036: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1037: iex_debug_pub.logMessage('CloseCase: ' || 'Before Calling Update PVT');
1038: END IF;
1039: iex_cases_pvt.update_cas
1040: (P_Api_Version_Number =>l_api_version_number,
1041: P_Init_Msg_List =>FND_API.G_FALSE,
1042: P_Commit =>FND_API.G_FALSE,
1043: p_validation_level =>P_validation_level,

Line 1118: iex_cases_pvt.Create_CAS(

1114: null;
1115: end;
1116: -- ended by ehuh Aug 10 2003
1117:
1118: iex_cases_pvt.Create_CAS(
1119: P_Api_Version_Number =>l_api_version_number,
1120: P_Init_Msg_List =>FND_API.G_FALSE,
1121: P_Commit =>FND_API.G_FALSE,
1122: p_validation_level =>P_validation_level,

Line 1332: l_cas_rec iex_cases_pvt.cas_rec_type

1328: l_msg_count NUMBER;
1329: l_msg_data VARCHAR2(32767);
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

Line 1333: := iex_cases_pvt.g_miss_cas_rec;

1329: l_msg_data VARCHAR2(32767);
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;

Line 1705: --Call iex_cases_pvt to create a case

1701: null;
1702: end;
1703: -- ended by ehuh Aug 10 2003
1704:
1705: --Call iex_cases_pvt to create a case
1706: -- IF PG_DEBUG < 10 THEN
1707: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1708: iex_debug_pub.logMessage('CreateCaseObjects: ' || 'Before Calling Create Case PVT');
1709: END IF;

Line 1716: iex_cases_pvt.Create_CAS(

1712: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1713: iex_debug_pub.logMessage('CreateCaseObjects: ' || '---------------------------------');
1714: END IF;
1715:
1716: iex_cases_pvt.Create_CAS(
1717: P_Api_Version_Number =>l_api_version_number,
1718: P_Init_Msg_List =>FND_API.G_FALSE,
1719: P_Commit =>FND_API.G_FALSE,
1720: p_validation_level =>P_validation_level,

Line 1942: l_cas_rec iex_cases_pvt.cas_rec_type

1938: l_msg_count NUMBER;
1939: l_msg_data VARCHAR2(32767);
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

Line 1943: := iex_cases_pvt.g_miss_cas_rec;

1939: l_msg_data VARCHAR2(32767);
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;

Line 2343: --Call iex_cases_pvt to create a case

2339: p_case_established_date =>l_case_established_date,
2340: p_attribute_rec =>p_cas_rec,
2341: x_cas_rec =>l_cas_rec);
2342: l_cas_rec.party_id :=p_party_id;
2343: --Call iex_cases_pvt to create a case
2344:
2345: -- IF PG_DEBUG < 10 THEN
2346: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2347: iex_debug_pub.logMessage('ReassignCaseObjects: ' || 'Before Calling Create Case PVT');

Line 2402: iex_cases_pvt.Create_CAS(

2398: end;
2399:
2400: -- ended by ehuh Aug 10 2003
2401:
2402: iex_cases_pvt.Create_CAS(
2403: P_Api_Version_Number =>l_api_version_number,
2404: P_Init_Msg_List =>FND_API.G_FALSE,
2405: P_Commit =>FND_API.G_FALSE,
2406: p_validation_level =>P_validation_level,

Line 2651: l_cas_rec iex_cases_pvt.cas_rec_type

2647: l_msg_count NUMBER;
2648: l_msg_data VARCHAR2(32767);
2649: l_case_object_id NUMBER;
2650: l_case_definition_id NUMBER;
2651: l_cas_rec iex_cases_pvt.cas_rec_type
2652: := iex_cases_pvt.g_miss_cas_rec;
2653: l_object_version_number NUMBER;
2654: BEGIN
2655: -- IF PG_DEBUG < 10 THEN

Line 2652: := iex_cases_pvt.g_miss_cas_rec;

2648: l_msg_data VARCHAR2(32767);
2649: l_case_object_id NUMBER;
2650: l_case_definition_id NUMBER;
2651: l_cas_rec iex_cases_pvt.cas_rec_type
2652: := iex_cases_pvt.g_miss_cas_rec;
2653: l_object_version_number NUMBER;
2654: BEGIN
2655: -- IF PG_DEBUG < 10 THEN
2656: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2761: iex_cases_pvt.update_cas

2757: -- IF PG_DEBUG < 10 THEN
2758: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2759: iex_debug_pub.logMessage('UpdateCase: ' || 'Before Calling Update PVT');
2760: END IF;
2761: iex_cases_pvt.update_cas
2762: (P_Api_Version_Number =>l_api_version_number,
2763: P_Init_Msg_List =>FND_API.G_FALSE,
2764: P_Commit =>FND_API.G_FALSE,
2765: p_validation_level =>P_validation_level,