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

Line 49: template_id NUMBER := FND_API.G_MISS_NUM,

45:
46: --===================================================================
47: TYPE prod_template_rec_type IS RECORD
48: (
49: template_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 prod_template_rec_type IS RECORD
48: (
49: template_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: object_version_number NUMBER := FND_API.G_MISS_NUM,

Line 51: last_updated_by NUMBER := FND_API.G_MISS_NUM,

47: TYPE prod_template_rec_type IS RECORD
48: (
49: template_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: object_version_number NUMBER := FND_API.G_MISS_NUM,
55: last_update_login NUMBER := FND_API.G_MISS_NUM,

Line 52: creation_date DATE := FND_API.G_MISS_DATE,

48: (
49: template_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: object_version_number NUMBER := FND_API.G_MISS_NUM,
55: last_update_login NUMBER := FND_API.G_MISS_NUM,
56: security_group_id NUMBER := FND_API.G_MISS_NUM,

Line 53: created_by NUMBER := FND_API.G_MISS_NUM,

49: template_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: object_version_number NUMBER := FND_API.G_MISS_NUM,
55: last_update_login NUMBER := FND_API.G_MISS_NUM,
56: security_group_id NUMBER := FND_API.G_MISS_NUM,
57: product_service_flag VARCHAR2(40) := FND_API.G_MISS_CHAR,

Line 54: object_version_number 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: object_version_number NUMBER := FND_API.G_MISS_NUM,
55: last_update_login NUMBER := FND_API.G_MISS_NUM,
56: security_group_id NUMBER := FND_API.G_MISS_NUM,
57: product_service_flag VARCHAR2(40) := FND_API.G_MISS_CHAR,
58: template_name VARCHAR2(120) := FND_API.G_MISS_CHAR,

Line 55: last_update_login 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: object_version_number NUMBER := FND_API.G_MISS_NUM,
55: last_update_login NUMBER := FND_API.G_MISS_NUM,
56: security_group_id NUMBER := FND_API.G_MISS_NUM,
57: product_service_flag VARCHAR2(40) := FND_API.G_MISS_CHAR,
58: template_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
59: description VARCHAR2(4000) := FND_API.G_MISS_CHAR

Line 56: security_group_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: object_version_number NUMBER := FND_API.G_MISS_NUM,
55: last_update_login NUMBER := FND_API.G_MISS_NUM,
56: security_group_id NUMBER := FND_API.G_MISS_NUM,
57: product_service_flag VARCHAR2(40) := FND_API.G_MISS_CHAR,
58: template_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
59: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
60: );

Line 57: product_service_flag VARCHAR2(40) := FND_API.G_MISS_CHAR,

53: created_by NUMBER := FND_API.G_MISS_NUM,
54: object_version_number NUMBER := FND_API.G_MISS_NUM,
55: last_update_login NUMBER := FND_API.G_MISS_NUM,
56: security_group_id NUMBER := FND_API.G_MISS_NUM,
57: product_service_flag VARCHAR2(40) := FND_API.G_MISS_CHAR,
58: template_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
59: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
60: );
61:

Line 58: template_name VARCHAR2(120) := FND_API.G_MISS_CHAR,

54: object_version_number NUMBER := FND_API.G_MISS_NUM,
55: last_update_login NUMBER := FND_API.G_MISS_NUM,
56: security_group_id NUMBER := FND_API.G_MISS_NUM,
57: product_service_flag VARCHAR2(40) := FND_API.G_MISS_CHAR,
58: template_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
59: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
60: );
61:
62:

Line 59: description VARCHAR2(4000) := FND_API.G_MISS_CHAR

55: last_update_login NUMBER := FND_API.G_MISS_NUM,
56: security_group_id NUMBER := FND_API.G_MISS_NUM,
57: product_service_flag VARCHAR2(40) := FND_API.G_MISS_CHAR,
58: template_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
59: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
60: );
61:
62:
63: g_miss_prod_template_rec prod_template_rec_type;

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

76: -- Parameters
77: --
78: -- IN
79: -- p_api_version_number IN NUMBER Required
80: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
81: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
82: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
83: -- p_prod_template_rec IN prod_template_rec_type Required
84: --

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

77: --
78: -- IN
79: -- p_api_version_number IN NUMBER Required
80: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
81: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
82: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
83: -- p_prod_template_rec IN prod_template_rec_type Required
84: --
85: -- OUT

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

78: -- IN
79: -- p_api_version_number IN NUMBER Required
80: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
81: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
82: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
83: -- p_prod_template_rec IN prod_template_rec_type Required
84: --
85: -- OUT
86: -- x_return_status OUT VARCHAR2

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

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

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

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

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

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

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

120: -- Parameters
121: --
122: -- IN
123: -- p_api_version_number IN NUMBER Required
124: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
125: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
126: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
127: -- p_prod_template_rec IN prod_template_rec_type Required
128: --

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

121: --
122: -- IN
123: -- p_api_version_number IN NUMBER Required
124: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
125: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
126: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
127: -- p_prod_template_rec IN prod_template_rec_type Required
128: --
129: -- OUT

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

122: -- IN
123: -- p_api_version_number IN NUMBER Required
124: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
125: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
126: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
127: -- p_prod_template_rec IN prod_template_rec_type Required
128: --
129: -- OUT
130: -- x_return_status OUT VARCHAR2

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

249: -- End of Comments
250:
251: PROCEDURE Validate_prod_template(
252: p_api_version_number IN NUMBER,
253: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
254: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
255: p_prod_template_rec IN prod_template_rec_type,
256: p_validation_mode IN VARCHAR2,
257: x_return_status OUT NOCOPY VARCHAR2,

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

250:
251: PROCEDURE Validate_prod_template(
252: p_api_version_number IN NUMBER,
253: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
254: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
255: p_prod_template_rec IN prod_template_rec_type,
256: p_validation_mode IN VARCHAR2,
257: x_return_status OUT NOCOPY VARCHAR2,
258: x_msg_count OUT NOCOPY NUMBER,

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

288: -- End of Comments
289:
290: PROCEDURE Validate_prod_template_rec(
291: p_api_version_number IN NUMBER,
292: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
293: x_return_status OUT NOCOPY VARCHAR2,
294: x_msg_count OUT NOCOPY NUMBER,
295: x_msg_data OUT NOCOPY VARCHAR2,
296: p_prod_template_rec IN prod_template_rec_type