DBA Data[Home] [Help]

APPS.AMS_CAT_ACTIVITY_PVT dependencies on FND_API

Line 65: cat_activity_id NUMBER := FND_API.G_MISS_NUM,

61:
62: --===================================================================
63: TYPE cat_activity_rec_type IS RECORD
64: (
65: cat_activity_id NUMBER := FND_API.G_MISS_NUM,
66: object_version_number NUMBER := FND_API.G_MISS_NUM,
67: category_id NUMBER := FND_API.G_MISS_NUM,
68: activity_id NUMBER := FND_API.G_MISS_NUM,
69: last_update_date DATE := FND_API.G_MISS_DATE,

Line 66: object_version_number NUMBER := FND_API.G_MISS_NUM,

62: --===================================================================
63: TYPE cat_activity_rec_type IS RECORD
64: (
65: cat_activity_id NUMBER := FND_API.G_MISS_NUM,
66: object_version_number NUMBER := FND_API.G_MISS_NUM,
67: category_id NUMBER := FND_API.G_MISS_NUM,
68: activity_id NUMBER := FND_API.G_MISS_NUM,
69: last_update_date DATE := FND_API.G_MISS_DATE,
70: last_updated_by NUMBER := FND_API.G_MISS_NUM,

Line 67: category_id NUMBER := FND_API.G_MISS_NUM,

63: TYPE cat_activity_rec_type IS RECORD
64: (
65: cat_activity_id NUMBER := FND_API.G_MISS_NUM,
66: object_version_number NUMBER := FND_API.G_MISS_NUM,
67: category_id NUMBER := FND_API.G_MISS_NUM,
68: activity_id NUMBER := FND_API.G_MISS_NUM,
69: last_update_date DATE := FND_API.G_MISS_DATE,
70: last_updated_by NUMBER := FND_API.G_MISS_NUM,
71: creation_date DATE := FND_API.G_MISS_DATE,

Line 68: activity_id NUMBER := FND_API.G_MISS_NUM,

64: (
65: cat_activity_id NUMBER := FND_API.G_MISS_NUM,
66: object_version_number NUMBER := FND_API.G_MISS_NUM,
67: category_id NUMBER := FND_API.G_MISS_NUM,
68: activity_id NUMBER := FND_API.G_MISS_NUM,
69: last_update_date DATE := FND_API.G_MISS_DATE,
70: last_updated_by NUMBER := FND_API.G_MISS_NUM,
71: creation_date DATE := FND_API.G_MISS_DATE,
72: created_by NUMBER := FND_API.G_MISS_NUM,

Line 69: last_update_date DATE := FND_API.G_MISS_DATE,

65: cat_activity_id NUMBER := FND_API.G_MISS_NUM,
66: object_version_number NUMBER := FND_API.G_MISS_NUM,
67: category_id NUMBER := FND_API.G_MISS_NUM,
68: activity_id NUMBER := FND_API.G_MISS_NUM,
69: last_update_date DATE := FND_API.G_MISS_DATE,
70: last_updated_by NUMBER := FND_API.G_MISS_NUM,
71: creation_date DATE := FND_API.G_MISS_DATE,
72: created_by NUMBER := FND_API.G_MISS_NUM,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,

Line 70: last_updated_by NUMBER := FND_API.G_MISS_NUM,

66: object_version_number NUMBER := FND_API.G_MISS_NUM,
67: category_id NUMBER := FND_API.G_MISS_NUM,
68: activity_id NUMBER := FND_API.G_MISS_NUM,
69: last_update_date DATE := FND_API.G_MISS_DATE,
70: last_updated_by NUMBER := FND_API.G_MISS_NUM,
71: creation_date DATE := FND_API.G_MISS_DATE,
72: created_by NUMBER := FND_API.G_MISS_NUM,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: --security_group_id NUMBER := FND_API.G_MISS_NUM,

Line 71: creation_date DATE := FND_API.G_MISS_DATE,

67: category_id NUMBER := FND_API.G_MISS_NUM,
68: activity_id NUMBER := FND_API.G_MISS_NUM,
69: last_update_date DATE := FND_API.G_MISS_DATE,
70: last_updated_by NUMBER := FND_API.G_MISS_NUM,
71: creation_date DATE := FND_API.G_MISS_DATE,
72: created_by NUMBER := FND_API.G_MISS_NUM,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: --security_group_id NUMBER := FND_API.G_MISS_NUM,
75: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 72: created_by NUMBER := FND_API.G_MISS_NUM,

68: activity_id NUMBER := FND_API.G_MISS_NUM,
69: last_update_date DATE := FND_API.G_MISS_DATE,
70: last_updated_by NUMBER := FND_API.G_MISS_NUM,
71: creation_date DATE := FND_API.G_MISS_DATE,
72: created_by NUMBER := FND_API.G_MISS_NUM,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: --security_group_id NUMBER := FND_API.G_MISS_NUM,
75: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 73: last_update_login NUMBER := FND_API.G_MISS_NUM,

69: last_update_date DATE := FND_API.G_MISS_DATE,
70: last_updated_by NUMBER := FND_API.G_MISS_NUM,
71: creation_date DATE := FND_API.G_MISS_DATE,
72: created_by NUMBER := FND_API.G_MISS_NUM,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: --security_group_id NUMBER := FND_API.G_MISS_NUM,
75: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 74: --security_group_id NUMBER := FND_API.G_MISS_NUM,

70: last_updated_by NUMBER := FND_API.G_MISS_NUM,
71: creation_date DATE := FND_API.G_MISS_DATE,
72: created_by NUMBER := FND_API.G_MISS_NUM,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: --security_group_id NUMBER := FND_API.G_MISS_NUM,
75: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 75: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,

71: creation_date DATE := FND_API.G_MISS_DATE,
72: created_by NUMBER := FND_API.G_MISS_NUM,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: --security_group_id NUMBER := FND_API.G_MISS_NUM,
75: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 76: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

72: created_by NUMBER := FND_API.G_MISS_NUM,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: --security_group_id NUMBER := FND_API.G_MISS_NUM,
75: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 77: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: --security_group_id NUMBER := FND_API.G_MISS_NUM,
75: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 78: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

74: --security_group_id NUMBER := FND_API.G_MISS_NUM,
75: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 79: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

75: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 80: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

76: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 81: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

77: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 82: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

78: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 83: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

79: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 84: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

80: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 85: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

81: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 86: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

82: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 87: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

83: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
91: );

Line 88: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

84: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
91: );
92:

Line 89: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

85: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
91: );
92:
93: g_miss_cat_activity_rec cat_activity_rec_type;

Line 90: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR

86: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
91: );
92:
93: g_miss_cat_activity_rec cat_activity_rec_type;
94: TYPE cat_activity_tbl_type IS TABLE OF cat_activity_rec_type INDEX BY BINARY_INTEGER;

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

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

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

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

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

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

Line 129: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

125: --
126:
127: PROCEDURE Create_Cat_Activity(
128: p_api_version_number IN NUMBER,
129: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
130: p_commit IN VARCHAR2 := FND_API.G_FALSE,
131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132:
133: x_return_status OUT NOCOPY VARCHAR2,

Line 130: p_commit IN VARCHAR2 := FND_API.G_FALSE,

126:
127: PROCEDURE Create_Cat_Activity(
128: p_api_version_number IN NUMBER,
129: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
130: p_commit IN VARCHAR2 := FND_API.G_FALSE,
131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132:
133: x_return_status OUT NOCOPY VARCHAR2,
134: x_msg_count OUT NOCOPY NUMBER,

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

127: PROCEDURE Create_Cat_Activity(
128: p_api_version_number IN NUMBER,
129: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
130: p_commit IN VARCHAR2 := FND_API.G_FALSE,
131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132:
133: x_return_status OUT NOCOPY VARCHAR2,
134: x_msg_count OUT NOCOPY NUMBER,
135: x_msg_data OUT NOCOPY VARCHAR2,

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

150: -- Parameters
151: --
152: -- IN
153: -- p_api_version_number IN NUMBER Required
154: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
155: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
156: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
157: -- p_cat_activity_rec IN cat_activity_rec_type Required
158: --

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

151: --
152: -- IN
153: -- p_api_version_number IN NUMBER Required
154: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
155: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
156: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
157: -- p_cat_activity_rec IN cat_activity_rec_type Required
158: --
159: -- OUT

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

152: -- IN
153: -- p_api_version_number IN NUMBER Required
154: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
155: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
156: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
157: -- p_cat_activity_rec IN cat_activity_rec_type Required
158: --
159: -- OUT
160: -- x_return_status OUT VARCHAR2

Line 173: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

169: --
170:
171: PROCEDURE Update_Cat_Activity(
172: p_api_version_number IN NUMBER,
173: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
174: p_commit IN VARCHAR2 := FND_API.G_FALSE,
175: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
176:
177: x_return_status OUT NOCOPY VARCHAR2,

Line 174: p_commit IN VARCHAR2 := FND_API.G_FALSE,

170:
171: PROCEDURE Update_Cat_Activity(
172: p_api_version_number IN NUMBER,
173: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
174: p_commit IN VARCHAR2 := FND_API.G_FALSE,
175: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
176:
177: x_return_status OUT NOCOPY VARCHAR2,
178: x_msg_count OUT NOCOPY NUMBER,

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

171: PROCEDURE Update_Cat_Activity(
172: p_api_version_number IN NUMBER,
173: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
174: p_commit IN VARCHAR2 := FND_API.G_FALSE,
175: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
176:
177: x_return_status OUT NOCOPY VARCHAR2,
178: x_msg_count OUT NOCOPY NUMBER,
179: x_msg_data OUT NOCOPY VARCHAR2,

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

194: -- Parameters
195: --
196: -- IN
197: -- p_api_version_number IN NUMBER Required
198: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
199: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
200: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
201: -- p_CAT_ACTIVITY_ID IN NUMBER
202: -- p_object_version_number IN NUMBER Optional Default = NULL

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

195: --
196: -- IN
197: -- p_api_version_number IN NUMBER Required
198: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
199: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
200: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
201: -- p_CAT_ACTIVITY_ID IN NUMBER
202: -- p_object_version_number IN NUMBER Optional Default = NULL
203: --

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

196: -- IN
197: -- p_api_version_number IN NUMBER Required
198: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
199: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
200: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
201: -- p_CAT_ACTIVITY_ID IN NUMBER
202: -- p_object_version_number IN NUMBER Optional Default = NULL
203: --
204: -- OUT

Line 218: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

214: --
215:
216: PROCEDURE Delete_Cat_Activity(
217: p_api_version_number IN NUMBER,
218: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
219: p_commit IN VARCHAR2 := FND_API.G_FALSE,
220: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
221: x_return_status OUT NOCOPY VARCHAR2,
222: x_msg_count OUT NOCOPY NUMBER,

Line 219: p_commit IN VARCHAR2 := FND_API.G_FALSE,

215:
216: PROCEDURE Delete_Cat_Activity(
217: p_api_version_number IN NUMBER,
218: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
219: p_commit IN VARCHAR2 := FND_API.G_FALSE,
220: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
221: x_return_status OUT NOCOPY VARCHAR2,
222: x_msg_count OUT NOCOPY NUMBER,
223: x_msg_data OUT NOCOPY VARCHAR2,

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

216: PROCEDURE Delete_Cat_Activity(
217: p_api_version_number IN NUMBER,
218: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
219: p_commit IN VARCHAR2 := FND_API.G_FALSE,
220: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
221: x_return_status OUT NOCOPY VARCHAR2,
222: x_msg_count OUT NOCOPY NUMBER,
223: x_msg_data OUT NOCOPY VARCHAR2,
224: p_cat_activity_id IN NUMBER,

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

237: -- Parameters
238: --
239: -- IN
240: -- p_api_version_number IN NUMBER Required
241: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
242: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
243: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
244: -- p_cat_activity_rec IN cat_activity_rec_type Required
245: --

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

238: --
239: -- IN
240: -- p_api_version_number IN NUMBER Required
241: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
242: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
243: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
244: -- p_cat_activity_rec IN cat_activity_rec_type Required
245: --
246: -- OUT

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

239: -- IN
240: -- p_api_version_number IN NUMBER Required
241: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
242: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
243: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
244: -- p_cat_activity_rec IN cat_activity_rec_type Required
245: --
246: -- OUT
247: -- x_return_status OUT VARCHAR2

Line 260: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

256: --
257:
258: PROCEDURE Lock_Cat_Activity(
259: p_api_version_number IN NUMBER,
260: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
261:
262: x_return_status OUT NOCOPY VARCHAR2,
263: x_msg_count OUT NOCOPY NUMBER,
264: x_msg_data OUT NOCOPY VARCHAR2,

Line 284: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

280: -- End of Comments
281:
282: PROCEDURE Validate_cat_activity(
283: p_api_version_number IN NUMBER,
284: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
285: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
286: p_cat_activity_rec IN cat_activity_rec_type,
287: x_return_status OUT NOCOPY VARCHAR2,
288: x_msg_count OUT NOCOPY NUMBER,

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

281:
282: PROCEDURE Validate_cat_activity(
283: p_api_version_number IN NUMBER,
284: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
285: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
286: p_cat_activity_rec IN cat_activity_rec_type,
287: x_return_status OUT NOCOPY VARCHAR2,
288: x_msg_count OUT NOCOPY NUMBER,
289: x_msg_data OUT NOCOPY VARCHAR2

Line 322: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

318: -- End of Comments
319:
320: PROCEDURE Validate_cat_activity_rec(
321: p_api_version_number IN NUMBER,
322: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
323: x_return_status OUT NOCOPY VARCHAR2,
324: x_msg_count OUT NOCOPY NUMBER,
325: x_msg_data OUT NOCOPY VARCHAR2,
326: p_cat_activity_rec IN cat_activity_rec_type