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.AMS_TEMPLATE_RES_PVT dependencies on FND_API

Line 48: templ_responsibility_id NUMBER := FND_API.G_MISS_NUM,

44:
45: --===================================================================
46: TYPE template_res_rec_type IS RECORD
47: (
48: templ_responsibility_id NUMBER := FND_API.G_MISS_NUM,
49: template_id NUMBER := FND_API.G_MISS_NUM,
50: responsibility_id NUMBER := FND_API.G_MISS_NUM,
51: last_update_date DATE := FND_API.G_MISS_DATE,
52: last_updated_by NUMBER := FND_API.G_MISS_NUM,

Line 49: template_id NUMBER := FND_API.G_MISS_NUM,

45: --===================================================================
46: TYPE template_res_rec_type IS RECORD
47: (
48: templ_responsibility_id NUMBER := FND_API.G_MISS_NUM,
49: template_id NUMBER := FND_API.G_MISS_NUM,
50: responsibility_id NUMBER := FND_API.G_MISS_NUM,
51: last_update_date DATE := FND_API.G_MISS_DATE,
52: last_updated_by NUMBER := FND_API.G_MISS_NUM,
53: creation_date DATE := FND_API.G_MISS_DATE,

Line 50: responsibility_id NUMBER := FND_API.G_MISS_NUM,

46: TYPE template_res_rec_type IS RECORD
47: (
48: templ_responsibility_id NUMBER := FND_API.G_MISS_NUM,
49: template_id NUMBER := FND_API.G_MISS_NUM,
50: responsibility_id NUMBER := FND_API.G_MISS_NUM,
51: last_update_date DATE := FND_API.G_MISS_DATE,
52: last_updated_by NUMBER := FND_API.G_MISS_NUM,
53: creation_date DATE := FND_API.G_MISS_DATE,
54: created_by NUMBER := FND_API.G_MISS_NUM,

Line 51: last_update_date DATE := FND_API.G_MISS_DATE,

47: (
48: templ_responsibility_id NUMBER := FND_API.G_MISS_NUM,
49: template_id NUMBER := FND_API.G_MISS_NUM,
50: responsibility_id NUMBER := FND_API.G_MISS_NUM,
51: last_update_date DATE := FND_API.G_MISS_DATE,
52: last_updated_by NUMBER := FND_API.G_MISS_NUM,
53: creation_date DATE := FND_API.G_MISS_DATE,
54: created_by NUMBER := FND_API.G_MISS_NUM,
55: object_version_number NUMBER := FND_API.G_MISS_NUM,

Line 52: last_updated_by NUMBER := FND_API.G_MISS_NUM,

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

Line 53: creation_date DATE := FND_API.G_MISS_DATE,

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

Line 54: created_by NUMBER := FND_API.G_MISS_NUM,

50: responsibility_id NUMBER := FND_API.G_MISS_NUM,
51: last_update_date DATE := FND_API.G_MISS_DATE,
52: last_updated_by NUMBER := FND_API.G_MISS_NUM,
53: creation_date DATE := FND_API.G_MISS_DATE,
54: created_by NUMBER := FND_API.G_MISS_NUM,
55: object_version_number NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: security_group_id NUMBER := FND_API.G_MISS_NUM
58: );

Line 55: object_version_number NUMBER := FND_API.G_MISS_NUM,

51: last_update_date DATE := FND_API.G_MISS_DATE,
52: last_updated_by NUMBER := FND_API.G_MISS_NUM,
53: creation_date DATE := FND_API.G_MISS_DATE,
54: created_by NUMBER := FND_API.G_MISS_NUM,
55: object_version_number NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: security_group_id NUMBER := FND_API.G_MISS_NUM
58: );
59:

Line 56: last_update_login NUMBER := FND_API.G_MISS_NUM,

52: last_updated_by NUMBER := FND_API.G_MISS_NUM,
53: creation_date DATE := FND_API.G_MISS_DATE,
54: created_by NUMBER := FND_API.G_MISS_NUM,
55: object_version_number NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: security_group_id NUMBER := FND_API.G_MISS_NUM
58: );
59:
60: g_miss_template_res_rec template_res_rec_type;

Line 57: security_group_id NUMBER := FND_API.G_MISS_NUM

53: creation_date DATE := FND_API.G_MISS_DATE,
54: created_by NUMBER := FND_API.G_MISS_NUM,
55: object_version_number NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: security_group_id NUMBER := FND_API.G_MISS_NUM
58: );
59:
60: g_miss_template_res_rec template_res_rec_type;
61: TYPE template_res_tbl_type IS TABLE OF template_res_rec_type INDEX BY BINARY_INTEGER;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

203: -- Parameters
204: --
205: -- IN
206: -- p_api_version_number IN NUMBER Required
207: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
208: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
209: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
210: -- p_template_res_rec IN template_res_rec_type Required
211: --

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

204: --
205: -- IN
206: -- p_api_version_number IN NUMBER Required
207: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
208: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
209: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
210: -- p_template_res_rec IN template_res_rec_type Required
211: --
212: -- OUT

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

205: -- IN
206: -- p_api_version_number IN NUMBER Required
207: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
208: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
209: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
210: -- p_template_res_rec IN template_res_rec_type Required
211: --
212: -- OUT
213: -- x_return_status OUT VARCHAR2

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

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

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

246: -- End of Comments
247:
248: PROCEDURE Validate_template_res(
249: p_api_version_number IN NUMBER,
250: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
251: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
252: p_template_res_rec IN template_res_rec_type,
253: p_validation_mode IN VARCHAR2,
254: x_return_status OUT NOCOPY VARCHAR2,

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

247:
248: PROCEDURE Validate_template_res(
249: p_api_version_number IN NUMBER,
250: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
251: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
252: p_template_res_rec IN template_res_rec_type,
253: p_validation_mode IN VARCHAR2,
254: x_return_status OUT NOCOPY VARCHAR2,
255: x_msg_count OUT NOCOPY NUMBER,

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

285: -- End of Comments
286:
287: PROCEDURE Validate_template_res_rec(
288: p_api_version_number IN NUMBER,
289: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
290: x_return_status OUT NOCOPY VARCHAR2,
291: x_msg_count OUT NOCOPY NUMBER,
292: x_msg_data OUT NOCOPY VARCHAR2,
293: p_template_res_rec IN template_res_rec_type