DBA Data[Home] [Help]

APPS.IEX_CASE_OBJECTS_PVT dependencies on FND_API

Line 55: CASE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,

51: -- End of Comments
52:
53: TYPE case_object_Rec_Type IS RECORD
54: (
55: CASE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
56: object_id NUMBER := FND_API.G_MISS_NUM,
57: OBJECT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: ACTIVE_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,

Line 56: object_id NUMBER := FND_API.G_MISS_NUM,

52:
53: TYPE case_object_Rec_Type IS RECORD
54: (
55: CASE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
56: object_id NUMBER := FND_API.G_MISS_NUM,
57: OBJECT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: ACTIVE_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
60: CAS_ID NUMBER := FND_API.G_MISS_NUM,

Line 57: OBJECT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

53: TYPE case_object_Rec_Type IS RECORD
54: (
55: CASE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
56: object_id NUMBER := FND_API.G_MISS_NUM,
57: OBJECT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: ACTIVE_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
60: CAS_ID NUMBER := FND_API.G_MISS_NUM,
61: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,

Line 58: ACTIVE_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR,

54: (
55: CASE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
56: object_id NUMBER := FND_API.G_MISS_NUM,
57: OBJECT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: ACTIVE_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
60: CAS_ID NUMBER := FND_API.G_MISS_NUM,
61: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
62: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,

Line 59: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,

55: CASE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
56: object_id NUMBER := FND_API.G_MISS_NUM,
57: OBJECT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: ACTIVE_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
60: CAS_ID NUMBER := FND_API.G_MISS_NUM,
61: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
62: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
63: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,

Line 60: CAS_ID NUMBER := FND_API.G_MISS_NUM,

56: object_id NUMBER := FND_API.G_MISS_NUM,
57: OBJECT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: ACTIVE_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
60: CAS_ID NUMBER := FND_API.G_MISS_NUM,
61: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
62: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
63: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
64: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 61: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,

57: OBJECT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: ACTIVE_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
60: CAS_ID NUMBER := FND_API.G_MISS_NUM,
61: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
62: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
63: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
64: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
65: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 62: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,

58: ACTIVE_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
60: CAS_ID NUMBER := FND_API.G_MISS_NUM,
61: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
62: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
63: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
64: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
65: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 63: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,

59: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
60: CAS_ID NUMBER := FND_API.G_MISS_NUM,
61: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
62: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
63: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
64: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
65: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 64: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

60: CAS_ID NUMBER := FND_API.G_MISS_NUM,
61: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
62: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
63: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
64: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
65: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,

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

61: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
62: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
63: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
64: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
65: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,

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

62: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
63: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
64: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
65: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,

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

63: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
64: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
65: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,

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

64: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
65: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,

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

65: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,

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

66: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,

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

67: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,

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

68: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,

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

69: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,

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

70: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,

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

71: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,

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

72: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,

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

73: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

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

74: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
82: CREATION_DATE DATE := FND_API.G_MISS_DATE,

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

75: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
82: CREATION_DATE DATE := FND_API.G_MISS_DATE,
83: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

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

76: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
82: CREATION_DATE DATE := FND_API.G_MISS_DATE,
83: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
84: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 81: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

77: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
82: CREATION_DATE DATE := FND_API.G_MISS_DATE,
83: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
84: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
85: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM

Line 82: CREATION_DATE DATE := FND_API.G_MISS_DATE,

78: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
82: CREATION_DATE DATE := FND_API.G_MISS_DATE,
83: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
84: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
85: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
86: );

Line 83: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

79: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
82: CREATION_DATE DATE := FND_API.G_MISS_DATE,
83: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
84: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
85: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
86: );
87:

Line 84: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

80: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
82: CREATION_DATE DATE := FND_API.G_MISS_DATE,
83: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
84: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
85: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
86: );
87:
88: G_MISS_case_object_REC case_object_Rec_Type;

Line 85: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM

81: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
82: CREATION_DATE DATE := FND_API.G_MISS_DATE,
83: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
84: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
85: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
86: );
87:
88: G_MISS_case_object_REC case_object_Rec_Type;
89: TYPE case_object_Tbl_Type IS TABLE OF case_object_Rec_Type

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

98: -- Pre-Req :
99: -- Parameters:
100: -- IN
101: -- p_api_version_number IN NUMBER Required
102: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
103: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
104: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
105: -- P_case_object_Rec IN case_object_Rec_Type Required
106:

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

99: -- Parameters:
100: -- IN
101: -- p_api_version_number IN NUMBER Required
102: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
103: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
104: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
105: -- P_case_object_Rec IN case_object_Rec_Type Required
106:
107: --

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

100: -- IN
101: -- p_api_version_number IN NUMBER Required
102: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
103: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
104: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
105: -- P_case_object_Rec IN case_object_Rec_Type Required
106:
107: --
108: -- OUT:

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

118: -- End of Comments
119: --
120: PROCEDURE Create_case_objects(
121: P_Api_Version_Number IN NUMBER,
122: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
123: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125: P_case_object_Rec IN case_object_Rec_Type := G_MISS_case_object_REC,
126: X_CASE_OBJECT_ID OUT NOCOPY NUMBER,

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

119: --
120: PROCEDURE Create_case_objects(
121: P_Api_Version_Number IN NUMBER,
122: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
123: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125: P_case_object_Rec IN case_object_Rec_Type := G_MISS_case_object_REC,
126: X_CASE_OBJECT_ID OUT NOCOPY NUMBER,
127: X_Return_Status OUT NOCOPY VARCHAR2,

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

120: PROCEDURE Create_case_objects(
121: P_Api_Version_Number IN NUMBER,
122: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
123: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125: P_case_object_Rec IN case_object_Rec_Type := G_MISS_case_object_REC,
126: X_CASE_OBJECT_ID OUT NOCOPY NUMBER,
127: X_Return_Status OUT NOCOPY VARCHAR2,
128: X_Msg_Count OUT NOCOPY NUMBER,

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

137: -- Pre-Req :
138: -- Parameters:
139: -- IN
140: -- p_api_version_number IN NUMBER Required
141: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
142: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
143: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
144: -- P_case_object_Rec IN case_object_Rec_Type Required
145: --

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

138: -- Parameters:
139: -- IN
140: -- p_api_version_number IN NUMBER Required
141: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
142: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
143: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
144: -- P_case_object_Rec IN case_object_Rec_Type Required
145: --
146: -- OUT:

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

139: -- IN
140: -- p_api_version_number IN NUMBER Required
141: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
142: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
143: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
144: -- P_case_object_Rec IN case_object_Rec_Type Required
145: --
146: -- OUT:
147: -- x_return_status OUT NOCOPY VARCHAR2

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

152: --
153: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
154: PROCEDURE Update_case_objects(
155: P_Api_Version_Number IN NUMBER,
156: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
157: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159: P_case_object_Rec IN case_object_Rec_Type,
160: X_Return_Status OUT NOCOPY VARCHAR2,

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

153: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
154: PROCEDURE Update_case_objects(
155: P_Api_Version_Number IN NUMBER,
156: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
157: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159: P_case_object_Rec IN case_object_Rec_Type,
160: X_Return_Status OUT NOCOPY VARCHAR2,
161: X_Msg_Count OUT NOCOPY NUMBER,

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

154: PROCEDURE Update_case_objects(
155: P_Api_Version_Number IN NUMBER,
156: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
157: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159: P_case_object_Rec IN case_object_Rec_Type,
160: X_Return_Status OUT NOCOPY VARCHAR2,
161: X_Msg_Count OUT NOCOPY NUMBER,
162: X_Msg_Data OUT NOCOPY VARCHAR2,

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

171: -- Pre-Req :
172: -- Parameters:
173: -- IN
174: -- p_api_version_number IN NUMBER Required
175: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
176: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
177: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
178: -- P_case_object_Rec IN case_object_Rec_Type Required
179: --

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

172: -- Parameters:
173: -- IN
174: -- p_api_version_number IN NUMBER Required
175: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
176: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
177: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
178: -- P_case_object_Rec IN case_object_Rec_Type Required
179: --
180: -- OUT:

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

173: -- IN
174: -- p_api_version_number IN NUMBER Required
175: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
176: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
177: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
178: -- P_case_object_Rec IN case_object_Rec_Type Required
179: --
180: -- OUT:
181: -- x_return_status OUT NOCOPY VARCHAR2

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

190: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
191: -- The Master delete procedure may not be needed depends on different business requirements.
192: PROCEDURE Delete_case_objects(
193: P_Api_Version_Number IN NUMBER,
194: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
195: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
196: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
197: P_case_object_Id IN NUMBER,
198: X_Return_Status OUT NOCOPY VARCHAR2,

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

191: -- The Master delete procedure may not be needed depends on different business requirements.
192: PROCEDURE Delete_case_objects(
193: P_Api_Version_Number IN NUMBER,
194: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
195: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
196: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
197: P_case_object_Id IN NUMBER,
198: X_Return_Status OUT NOCOPY VARCHAR2,
199: X_Msg_Count OUT NOCOPY NUMBER,

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

192: PROCEDURE Delete_case_objects(
193: P_Api_Version_Number IN NUMBER,
194: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
195: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
196: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
197: P_case_object_Id IN NUMBER,
198: X_Return_Status OUT NOCOPY VARCHAR2,
199: X_Msg_Count OUT NOCOPY NUMBER,
200: X_Msg_Data OUT NOCOPY VARCHAR2