DBA Data[Home] [Help]

APPS.AMS_MET_TPL_DTL_PVT dependencies on FND_API

Line 49: metric_template_detail_id NUMBER := FND_API.G_MISS_NUM,

45:
46: --===================================================================
47: TYPE met_tpl_dtl_rec_type IS RECORD
48: (
49: metric_template_detail_id NUMBER := FND_API.G_MISS_NUM,
50: last_update_date DATE := FND_API.G_MISS_DATE,
51: last_updated_by NUMBER := FND_API.G_MISS_NUM,
52: creation_date DATE := FND_API.G_MISS_DATE,
53: created_by NUMBER := FND_API.G_MISS_NUM,

Line 50: last_update_date DATE := FND_API.G_MISS_DATE,

46: --===================================================================
47: TYPE met_tpl_dtl_rec_type IS RECORD
48: (
49: metric_template_detail_id NUMBER := FND_API.G_MISS_NUM,
50: last_update_date DATE := FND_API.G_MISS_DATE,
51: last_updated_by NUMBER := FND_API.G_MISS_NUM,
52: creation_date DATE := FND_API.G_MISS_DATE,
53: created_by NUMBER := FND_API.G_MISS_NUM,
54: last_update_login NUMBER := FND_API.G_MISS_NUM,

Line 51: last_updated_by NUMBER := FND_API.G_MISS_NUM,

47: TYPE met_tpl_dtl_rec_type IS RECORD
48: (
49: metric_template_detail_id NUMBER := FND_API.G_MISS_NUM,
50: last_update_date DATE := FND_API.G_MISS_DATE,
51: last_updated_by NUMBER := FND_API.G_MISS_NUM,
52: creation_date DATE := FND_API.G_MISS_DATE,
53: created_by NUMBER := FND_API.G_MISS_NUM,
54: last_update_login NUMBER := FND_API.G_MISS_NUM,
55: object_version_number NUMBER := FND_API.G_MISS_NUM,

Line 52: creation_date DATE := FND_API.G_MISS_DATE,

48: (
49: metric_template_detail_id NUMBER := FND_API.G_MISS_NUM,
50: last_update_date DATE := FND_API.G_MISS_DATE,
51: last_updated_by NUMBER := FND_API.G_MISS_NUM,
52: creation_date DATE := FND_API.G_MISS_DATE,
53: created_by NUMBER := FND_API.G_MISS_NUM,
54: last_update_login NUMBER := FND_API.G_MISS_NUM,
55: object_version_number NUMBER := FND_API.G_MISS_NUM,
56: metric_tpl_header_id NUMBER := FND_API.G_MISS_NUM,

Line 53: created_by NUMBER := FND_API.G_MISS_NUM,

49: metric_template_detail_id NUMBER := FND_API.G_MISS_NUM,
50: last_update_date DATE := FND_API.G_MISS_DATE,
51: last_updated_by NUMBER := FND_API.G_MISS_NUM,
52: creation_date DATE := FND_API.G_MISS_DATE,
53: created_by NUMBER := FND_API.G_MISS_NUM,
54: last_update_login NUMBER := FND_API.G_MISS_NUM,
55: object_version_number NUMBER := FND_API.G_MISS_NUM,
56: metric_tpl_header_id NUMBER := FND_API.G_MISS_NUM,
57: metric_id NUMBER := FND_API.G_MISS_NUM,

Line 54: last_update_login NUMBER := FND_API.G_MISS_NUM,

50: last_update_date DATE := FND_API.G_MISS_DATE,
51: last_updated_by NUMBER := FND_API.G_MISS_NUM,
52: creation_date DATE := FND_API.G_MISS_DATE,
53: created_by NUMBER := FND_API.G_MISS_NUM,
54: last_update_login NUMBER := FND_API.G_MISS_NUM,
55: object_version_number NUMBER := FND_API.G_MISS_NUM,
56: metric_tpl_header_id NUMBER := FND_API.G_MISS_NUM,
57: metric_id NUMBER := FND_API.G_MISS_NUM,
58: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 55: object_version_number NUMBER := FND_API.G_MISS_NUM,

51: last_updated_by NUMBER := FND_API.G_MISS_NUM,
52: creation_date DATE := FND_API.G_MISS_DATE,
53: created_by NUMBER := FND_API.G_MISS_NUM,
54: last_update_login NUMBER := FND_API.G_MISS_NUM,
55: object_version_number NUMBER := FND_API.G_MISS_NUM,
56: metric_tpl_header_id NUMBER := FND_API.G_MISS_NUM,
57: metric_id NUMBER := FND_API.G_MISS_NUM,
58: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
59: );

Line 56: metric_tpl_header_id NUMBER := FND_API.G_MISS_NUM,

52: creation_date DATE := FND_API.G_MISS_DATE,
53: created_by NUMBER := FND_API.G_MISS_NUM,
54: last_update_login NUMBER := FND_API.G_MISS_NUM,
55: object_version_number NUMBER := FND_API.G_MISS_NUM,
56: metric_tpl_header_id NUMBER := FND_API.G_MISS_NUM,
57: metric_id NUMBER := FND_API.G_MISS_NUM,
58: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
59: );
60:

Line 57: metric_id NUMBER := FND_API.G_MISS_NUM,

53: created_by NUMBER := FND_API.G_MISS_NUM,
54: last_update_login NUMBER := FND_API.G_MISS_NUM,
55: object_version_number NUMBER := FND_API.G_MISS_NUM,
56: metric_tpl_header_id NUMBER := FND_API.G_MISS_NUM,
57: metric_id NUMBER := FND_API.G_MISS_NUM,
58: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
59: );
60:
61: g_miss_met_tpl_dtl_rec met_tpl_dtl_rec_type;

Line 58: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

54: last_update_login NUMBER := FND_API.G_MISS_NUM,
55: object_version_number NUMBER := FND_API.G_MISS_NUM,
56: metric_tpl_header_id NUMBER := FND_API.G_MISS_NUM,
57: metric_id NUMBER := FND_API.G_MISS_NUM,
58: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
59: );
60:
61: g_miss_met_tpl_dtl_rec met_tpl_dtl_rec_type;
62: TYPE met_tpl_dtl_tbl_type IS TABLE OF met_tpl_dtl_rec_type INDEX BY BINARY_INTEGER;

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

74: -- Parameters
75: --
76: -- IN
77: -- p_api_version_number IN NUMBER Required
78: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
79: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
80: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
81: -- p_met_tpl_dtl_rec IN met_tpl_dtl_rec_type Required
82: --

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

75: --
76: -- IN
77: -- p_api_version_number IN NUMBER Required
78: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
79: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
80: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
81: -- p_met_tpl_dtl_rec IN met_tpl_dtl_rec_type Required
82: --
83: -- OUT

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

76: -- IN
77: -- p_api_version_number IN NUMBER Required
78: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
79: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
80: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
81: -- p_met_tpl_dtl_rec IN met_tpl_dtl_rec_type Required
82: --
83: -- OUT
84: -- x_return_status OUT VARCHAR2

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

93: --
94:
95: PROCEDURE Create_Met_Tpl_Dtl(
96: p_api_version_number IN NUMBER,
97: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
98: p_commit IN VARCHAR2 := FND_API.G_FALSE,
99: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
100:
101: x_return_status OUT NOCOPY VARCHAR2,

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

94:
95: PROCEDURE Create_Met_Tpl_Dtl(
96: p_api_version_number IN NUMBER,
97: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
98: p_commit IN VARCHAR2 := FND_API.G_FALSE,
99: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
100:
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY NUMBER,

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

95: PROCEDURE Create_Met_Tpl_Dtl(
96: p_api_version_number IN NUMBER,
97: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
98: p_commit IN VARCHAR2 := FND_API.G_FALSE,
99: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
100:
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY NUMBER,
103: x_msg_data OUT NOCOPY VARCHAR2,

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

118: -- Parameters
119: --
120: -- IN
121: -- p_api_version_number IN NUMBER Required
122: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
123: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
124: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
125: -- p_met_tpl_dtl_rec IN met_tpl_dtl_rec_type Required
126: --

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

119: --
120: -- IN
121: -- p_api_version_number IN NUMBER Required
122: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
123: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
124: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
125: -- p_met_tpl_dtl_rec IN met_tpl_dtl_rec_type Required
126: --
127: -- OUT

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

120: -- IN
121: -- p_api_version_number IN NUMBER Required
122: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
123: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
124: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
125: -- p_met_tpl_dtl_rec IN met_tpl_dtl_rec_type Required
126: --
127: -- OUT
128: -- x_return_status OUT VARCHAR2

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

137: --
138:
139: PROCEDURE Update_Met_Tpl_Dtl(
140: p_api_version_number IN NUMBER,
141: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
142: p_commit IN VARCHAR2 := FND_API.G_FALSE,
143: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
144:
145: x_return_status OUT NOCOPY VARCHAR2,

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

138:
139: PROCEDURE Update_Met_Tpl_Dtl(
140: p_api_version_number IN NUMBER,
141: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
142: p_commit IN VARCHAR2 := FND_API.G_FALSE,
143: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
144:
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,

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

139: PROCEDURE Update_Met_Tpl_Dtl(
140: p_api_version_number IN NUMBER,
141: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
142: p_commit IN VARCHAR2 := FND_API.G_FALSE,
143: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
144:
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2,

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

162: -- Parameters
163: --
164: -- IN
165: -- p_api_version_number IN NUMBER Required
166: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
167: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
168: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
169: -- p_METRIC_TEMPLATE_DETAIL_ID IN NUMBER
170: -- p_object_version_number IN NUMBER Optional Default = NULL

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

163: --
164: -- IN
165: -- p_api_version_number IN NUMBER Required
166: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
167: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
168: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
169: -- p_METRIC_TEMPLATE_DETAIL_ID IN NUMBER
170: -- p_object_version_number IN NUMBER Optional Default = NULL
171: --

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

164: -- IN
165: -- p_api_version_number IN NUMBER Required
166: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
167: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
168: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
169: -- p_METRIC_TEMPLATE_DETAIL_ID IN NUMBER
170: -- p_object_version_number IN NUMBER Optional Default = NULL
171: --
172: -- OUT

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

182: --
183:
184: PROCEDURE Delete_Met_Tpl_Dtl(
185: p_api_version_number IN NUMBER,
186: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
187: p_commit IN VARCHAR2 := FND_API.G_FALSE,
188: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
189: x_return_status OUT NOCOPY VARCHAR2,
190: x_msg_count OUT NOCOPY NUMBER,

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

183:
184: PROCEDURE Delete_Met_Tpl_Dtl(
185: p_api_version_number IN NUMBER,
186: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
187: p_commit IN VARCHAR2 := FND_API.G_FALSE,
188: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
189: x_return_status OUT NOCOPY VARCHAR2,
190: x_msg_count OUT NOCOPY NUMBER,
191: x_msg_data OUT NOCOPY VARCHAR2,

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

184: PROCEDURE Delete_Met_Tpl_Dtl(
185: p_api_version_number IN NUMBER,
186: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
187: p_commit IN VARCHAR2 := FND_API.G_FALSE,
188: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
189: x_return_status OUT NOCOPY VARCHAR2,
190: x_msg_count OUT NOCOPY NUMBER,
191: x_msg_data OUT NOCOPY VARCHAR2,
192: p_metric_template_detail_id IN NUMBER,

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

205: -- Parameters
206: --
207: -- IN
208: -- p_api_version_number IN NUMBER Required
209: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
210: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
211: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
212: -- p_met_tpl_dtl_rec IN met_tpl_dtl_rec_type Required
213: --

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

206: --
207: -- IN
208: -- p_api_version_number IN NUMBER Required
209: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
210: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
211: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
212: -- p_met_tpl_dtl_rec IN met_tpl_dtl_rec_type Required
213: --
214: -- OUT

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

207: -- IN
208: -- p_api_version_number IN NUMBER Required
209: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
210: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
211: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
212: -- p_met_tpl_dtl_rec IN met_tpl_dtl_rec_type Required
213: --
214: -- OUT
215: -- x_return_status OUT VARCHAR2

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

224: --
225:
226: PROCEDURE Lock_Met_Tpl_Dtl(
227: p_api_version_number IN NUMBER,
228: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
229:
230: x_return_status OUT NOCOPY VARCHAR2,
231: x_msg_count OUT NOCOPY NUMBER,
232: x_msg_data OUT NOCOPY VARCHAR2,

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

248: -- End of Comments
249:
250: PROCEDURE Validate_met_tpl_dtl(
251: p_api_version_number IN NUMBER,
252: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
253: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
254: p_met_tpl_dtl_rec IN met_tpl_dtl_rec_type,
255: p_validation_mode IN VARCHAR2,
256: x_return_status OUT NOCOPY VARCHAR2,

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

249:
250: PROCEDURE Validate_met_tpl_dtl(
251: p_api_version_number IN NUMBER,
252: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
253: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
254: p_met_tpl_dtl_rec IN met_tpl_dtl_rec_type,
255: p_validation_mode IN VARCHAR2,
256: x_return_status OUT NOCOPY VARCHAR2,
257: x_msg_count OUT NOCOPY NUMBER,

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

287: -- End of Comments
288:
289: PROCEDURE Validate_met_tpl_dtl_rec(
290: p_api_version_number IN NUMBER,
291: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
292: x_return_status OUT NOCOPY VARCHAR2,
293: x_msg_count OUT NOCOPY NUMBER,
294: x_msg_data OUT NOCOPY VARCHAR2,
295: p_met_tpl_dtl_rec IN met_tpl_dtl_rec_type