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_CONTACTS_PVT dependencies on FND_API

Line 60: CAS_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,

56: -- End of Comments
57:
58: TYPE case_contact_Rec_Type IS RECORD
59: (
60: CAS_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
61: CAS_ID NUMBER := FND_API.G_MISS_NUM,
62: CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
63: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
64: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 61: CAS_ID NUMBER := FND_API.G_MISS_NUM,

57:
58: TYPE case_contact_Rec_Type IS RECORD
59: (
60: CAS_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
61: CAS_ID NUMBER := FND_API.G_MISS_NUM,
62: CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
63: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
64: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,

Line 62: CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM,

58: TYPE case_contact_Rec_Type IS RECORD
59: (
60: CAS_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
61: CAS_ID NUMBER := FND_API.G_MISS_NUM,
62: CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
63: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
64: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
66: PHONE_ID NUMBER := FND_API.G_MISS_NUM,

Line 63: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,

59: (
60: CAS_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
61: CAS_ID NUMBER := FND_API.G_MISS_NUM,
62: CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
63: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
64: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
66: PHONE_ID NUMBER := FND_API.G_MISS_NUM,
67: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,

Line 64: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,

60: CAS_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
61: CAS_ID NUMBER := FND_API.G_MISS_NUM,
62: CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
63: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
64: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
66: PHONE_ID NUMBER := FND_API.G_MISS_NUM,
67: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
68: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,

Line 65: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,

61: CAS_ID NUMBER := FND_API.G_MISS_NUM,
62: CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
63: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
64: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
66: PHONE_ID NUMBER := FND_API.G_MISS_NUM,
67: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
68: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
69: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,

Line 66: PHONE_ID NUMBER := FND_API.G_MISS_NUM,

62: CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
63: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
64: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
66: PHONE_ID NUMBER := FND_API.G_MISS_NUM,
67: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
68: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
69: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
70: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 67: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,

63: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
64: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
66: PHONE_ID NUMBER := FND_API.G_MISS_NUM,
67: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
68: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
69: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
70: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
71: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 68: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,

64: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
66: PHONE_ID NUMBER := FND_API.G_MISS_NUM,
67: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
68: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
69: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
70: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
71: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 69: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,

65: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
66: PHONE_ID NUMBER := FND_API.G_MISS_NUM,
67: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
68: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
69: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
70: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
71: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 70: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

66: PHONE_ID NUMBER := FND_API.G_MISS_NUM,
67: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
68: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
69: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
70: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
71: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 71: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,

67: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
68: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
69: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
70: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
71: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 72: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,

68: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
69: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
70: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
71: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 73: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,

69: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
70: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
71: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 74: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,

70: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
71: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 75: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,

71: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 76: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,

72: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 77: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,

73: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 78: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,

74: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 79: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,

75: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 80: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,

76: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 81: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,

77: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 82: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,

78: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 83: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,

79: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 84: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,

80: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
88: CREATION_DATE DATE := FND_API.G_MISS_DATE,

Line 85: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,

81: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
88: CREATION_DATE DATE := FND_API.G_MISS_DATE,
89: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 86: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,

82: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
88: CREATION_DATE DATE := FND_API.G_MISS_DATE,
89: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
90: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 87: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

83: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
88: CREATION_DATE DATE := FND_API.G_MISS_DATE,
89: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
90: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
91: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

Line 88: CREATION_DATE DATE := FND_API.G_MISS_DATE,

84: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
88: CREATION_DATE DATE := FND_API.G_MISS_DATE,
89: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
90: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
91: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
92: PRIMARY_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 89: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

85: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
88: CREATION_DATE DATE := FND_API.G_MISS_DATE,
89: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
90: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
91: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
92: PRIMARY_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
93: );

Line 90: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

86: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
88: CREATION_DATE DATE := FND_API.G_MISS_DATE,
89: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
90: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
91: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
92: PRIMARY_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
93: );
94:

Line 91: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

87: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
88: CREATION_DATE DATE := FND_API.G_MISS_DATE,
89: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
90: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
91: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
92: PRIMARY_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
93: );
94:
95: G_MISS_case_contact_REC case_contact_Rec_Type;

Line 92: PRIMARY_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR

88: CREATION_DATE DATE := FND_API.G_MISS_DATE,
89: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
90: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
91: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
92: PRIMARY_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
93: );
94:
95: G_MISS_case_contact_REC case_contact_Rec_Type;
96: TYPE case_contact_Tbl_Type IS TABLE OF case_contact_Rec_Type

Line 109: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

105: -- Pre-Req :
106: -- Parameters:
107: -- IN
108: -- p_api_version_number IN NUMBER Required
109: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
110: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
111: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
112: -- P_case_contact_Rec IN case_contact_Rec_Type Required
113: --

Line 110: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

106: -- Parameters:
107: -- IN
108: -- p_api_version_number IN NUMBER Required
109: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
110: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
111: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
112: -- P_case_contact_Rec IN case_contact_Rec_Type Required
113: --
114: -- OUT:

Line 111: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

107: -- IN
108: -- p_api_version_number IN NUMBER Required
109: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
110: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
111: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
112: -- P_case_contact_Rec IN case_contact_Rec_Type Required
113: --
114: -- OUT:
115: -- x_return_status OUT NOCOPY VARCHAR2

Line 126: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

122: -- End of Comments
123: --
124: PROCEDURE Create_case_contact(
125: P_Api_Version_Number IN NUMBER,
126: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
127: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
128: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
129: P_case_contact_Rec IN case_contact_Rec_Type := G_MISS_case_contact_REC,
130: X_CAS_CONTACT_ID OUT NOCOPY NUMBER,

Line 127: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

123: --
124: PROCEDURE Create_case_contact(
125: P_Api_Version_Number IN NUMBER,
126: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
127: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
128: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
129: P_case_contact_Rec IN case_contact_Rec_Type := G_MISS_case_contact_REC,
130: X_CAS_CONTACT_ID OUT NOCOPY NUMBER,
131: X_Return_Status OUT NOCOPY VARCHAR2,

Line 128: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

124: PROCEDURE Create_case_contact(
125: P_Api_Version_Number IN NUMBER,
126: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
127: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
128: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
129: P_case_contact_Rec IN case_contact_Rec_Type := G_MISS_case_contact_REC,
130: X_CAS_CONTACT_ID OUT NOCOPY NUMBER,
131: X_Return_Status OUT NOCOPY VARCHAR2,
132: X_Msg_Count OUT NOCOPY NUMBER,

Line 145: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

141: -- Pre-Req :
142: -- Parameters:
143: -- IN
144: -- p_api_version_number IN NUMBER Required
145: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
146: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
147: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
148: -- P_case_contact_Rec IN case_contact_Rec_Type Required
149: --

Line 146: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

142: -- Parameters:
143: -- IN
144: -- p_api_version_number IN NUMBER Required
145: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
146: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
147: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
148: -- P_case_contact_Rec IN case_contact_Rec_Type Required
149: --
150: -- OUT:

Line 147: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

143: -- IN
144: -- p_api_version_number IN NUMBER Required
145: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
146: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
147: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
148: -- P_case_contact_Rec IN case_contact_Rec_Type Required
149: --
150: -- OUT:
151: -- x_return_status OUT NOCOPY VARCHAR2

Line 163: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

159: --
160: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
161: PROCEDURE Update_case_contact(
162: P_Api_Version_Number IN NUMBER,
163: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
164: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
165: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
166: P_case_contact_Rec IN case_contact_Rec_Type,
167: X_Return_Status OUT NOCOPY VARCHAR2,

Line 164: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

160: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
161: PROCEDURE Update_case_contact(
162: P_Api_Version_Number IN NUMBER,
163: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
164: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
165: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
166: P_case_contact_Rec IN case_contact_Rec_Type,
167: X_Return_Status OUT NOCOPY VARCHAR2,
168: X_Msg_Count OUT NOCOPY NUMBER,

Line 165: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

161: PROCEDURE Update_case_contact(
162: P_Api_Version_Number IN NUMBER,
163: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
164: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
165: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
166: P_case_contact_Rec IN case_contact_Rec_Type,
167: X_Return_Status OUT NOCOPY VARCHAR2,
168: X_Msg_Count OUT NOCOPY NUMBER,
169: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 182: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

178: -- Pre-Req :
179: -- Parameters:
180: -- IN
181: -- p_api_version_number IN NUMBER Required
182: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
183: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
184: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
185: -- P_case_contact_Rec IN case_contact_Rec_Type Required
186: --

Line 183: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

179: -- Parameters:
180: -- IN
181: -- p_api_version_number IN NUMBER Required
182: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
183: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
184: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
185: -- P_case_contact_Rec IN case_contact_Rec_Type Required
186: --
187: -- OUT:

Line 184: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

180: -- IN
181: -- p_api_version_number IN NUMBER Required
182: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
183: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
184: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
185: -- P_case_contact_Rec IN case_contact_Rec_Type Required
186: --
187: -- OUT:
188: -- x_return_status OUT NOCOPY VARCHAR2

Line 197: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

193: -- End of Comments
194: --
195: PROCEDURE Delete_case_contact(
196: P_Api_Version_Number IN NUMBER,
197: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
198: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
199: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
200: P_cas_contact_id IN NUMBER,
201: X_Return_Status OUT NOCOPY VARCHAR2,

Line 198: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

194: --
195: PROCEDURE Delete_case_contact(
196: P_Api_Version_Number IN NUMBER,
197: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
198: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
199: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
200: P_cas_contact_id IN NUMBER,
201: X_Return_Status OUT NOCOPY VARCHAR2,
202: X_Msg_Count OUT NOCOPY NUMBER,

Line 199: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

195: PROCEDURE Delete_case_contact(
196: P_Api_Version_Number IN NUMBER,
197: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
198: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
199: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
200: P_cas_contact_id IN NUMBER,
201: X_Return_Status OUT NOCOPY VARCHAR2,
202: X_Msg_Count OUT NOCOPY NUMBER,
203: X_Msg_Data OUT NOCOPY VARCHAR2