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

Line 49: action_param_value_id NUMBER := FND_API.G_MISS_NUM,

45:
46: --===================================================================
47: TYPE ctd_prm_val_rec_type IS RECORD
48: (
49: action_param_value_id NUMBER := FND_API.G_MISS_NUM,
50: action_param_value VARCHAR2(256) := FND_API.G_MISS_CHAR,
51: ctd_id NUMBER := FND_API.G_MISS_NUM,
52: action_param_id NUMBER := FND_API.G_MISS_NUM,
53: object_version_number NUMBER := FND_API.G_MISS_NUM,

Line 50: action_param_value VARCHAR2(256) := FND_API.G_MISS_CHAR,

46: --===================================================================
47: TYPE ctd_prm_val_rec_type IS RECORD
48: (
49: action_param_value_id NUMBER := FND_API.G_MISS_NUM,
50: action_param_value VARCHAR2(256) := FND_API.G_MISS_CHAR,
51: ctd_id NUMBER := FND_API.G_MISS_NUM,
52: action_param_id NUMBER := FND_API.G_MISS_NUM,
53: object_version_number NUMBER := FND_API.G_MISS_NUM,
54: last_update_date DATE := FND_API.G_MISS_DATE,

Line 51: ctd_id NUMBER := FND_API.G_MISS_NUM,

47: TYPE ctd_prm_val_rec_type IS RECORD
48: (
49: action_param_value_id NUMBER := FND_API.G_MISS_NUM,
50: action_param_value VARCHAR2(256) := FND_API.G_MISS_CHAR,
51: ctd_id NUMBER := FND_API.G_MISS_NUM,
52: action_param_id NUMBER := FND_API.G_MISS_NUM,
53: object_version_number NUMBER := FND_API.G_MISS_NUM,
54: last_update_date DATE := FND_API.G_MISS_DATE,
55: last_updated_by NUMBER := FND_API.G_MISS_NUM,

Line 52: action_param_id NUMBER := FND_API.G_MISS_NUM,

48: (
49: action_param_value_id NUMBER := FND_API.G_MISS_NUM,
50: action_param_value VARCHAR2(256) := FND_API.G_MISS_CHAR,
51: ctd_id NUMBER := FND_API.G_MISS_NUM,
52: action_param_id NUMBER := FND_API.G_MISS_NUM,
53: object_version_number NUMBER := FND_API.G_MISS_NUM,
54: last_update_date DATE := FND_API.G_MISS_DATE,
55: last_updated_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,

Line 53: object_version_number NUMBER := FND_API.G_MISS_NUM,

49: action_param_value_id NUMBER := FND_API.G_MISS_NUM,
50: action_param_value VARCHAR2(256) := FND_API.G_MISS_CHAR,
51: ctd_id NUMBER := FND_API.G_MISS_NUM,
52: action_param_id NUMBER := FND_API.G_MISS_NUM,
53: object_version_number NUMBER := FND_API.G_MISS_NUM,
54: last_update_date DATE := FND_API.G_MISS_DATE,
55: last_updated_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: creation_date DATE := FND_API.G_MISS_DATE,

Line 54: last_update_date DATE := FND_API.G_MISS_DATE,

50: action_param_value VARCHAR2(256) := FND_API.G_MISS_CHAR,
51: ctd_id NUMBER := FND_API.G_MISS_NUM,
52: action_param_id NUMBER := FND_API.G_MISS_NUM,
53: object_version_number NUMBER := FND_API.G_MISS_NUM,
54: last_update_date DATE := FND_API.G_MISS_DATE,
55: last_updated_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: creation_date DATE := FND_API.G_MISS_DATE,
58: created_by NUMBER := FND_API.G_MISS_NUM,

Line 55: last_updated_by NUMBER := FND_API.G_MISS_NUM,

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

Line 56: last_update_login NUMBER := FND_API.G_MISS_NUM,

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

Line 57: creation_date DATE := FND_API.G_MISS_DATE,

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

Line 58: created_by NUMBER := FND_API.G_MISS_NUM,

54: last_update_date DATE := FND_API.G_MISS_DATE,
55: last_updated_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: creation_date DATE := FND_API.G_MISS_DATE,
58: created_by NUMBER := FND_API.G_MISS_NUM,
59: security_group_id NUMBER := FND_API.G_MISS_NUM
60: );
61:
62: g_miss_ctd_prm_val_rec ctd_prm_val_rec_type;

Line 59: security_group_id NUMBER := FND_API.G_MISS_NUM

55: last_updated_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: creation_date DATE := FND_API.G_MISS_DATE,
58: created_by NUMBER := FND_API.G_MISS_NUM,
59: security_group_id NUMBER := FND_API.G_MISS_NUM
60: );
61:
62: g_miss_ctd_prm_val_rec ctd_prm_val_rec_type;
63: TYPE ctd_prm_val_tbl_type IS TABLE OF ctd_prm_val_rec_type INDEX BY BINARY_INTEGER;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

140: PROCEDURE Update_Ctd_Prm_Val(
141: p_api_version_number IN NUMBER,
142: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
143: p_commit IN VARCHAR2 := FND_API.G_FALSE,
144: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
145:
146: x_return_status OUT NOCOPY VARCHAR2,
147: x_msg_count OUT NOCOPY NUMBER,
148: 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_ACTION_PARAM_VALUE_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_ACTION_PARAM_VALUE_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_ACTION_PARAM_VALUE_ID IN NUMBER
171: -- p_object_version_number IN NUMBER Optional Default = NULL
172: --
173: -- OUT NOCOPY

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

183: --
184:
185: PROCEDURE Delete_Ctd_Prm_Val(
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_Ctd_Prm_Val(
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_Ctd_Prm_Val(
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_action_param_value_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_ctd_prm_val_rec IN ctd_prm_val_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_ctd_prm_val_rec IN ctd_prm_val_rec_type Required
214: --
215: -- OUT NOCOPY

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_ctd_prm_val_rec IN ctd_prm_val_rec_type Required
214: --
215: -- OUT NOCOPY
216: -- x_return_status OUT NOCOPY VARCHAR2

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

225: --
226:
227: PROCEDURE Lock_Ctd_Prm_Val(
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_ctd_prm_val(
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_ctd_prm_val_rec IN ctd_prm_val_rec_type,
256: x_return_status OUT NOCOPY VARCHAR2,
257: x_msg_count OUT NOCOPY NUMBER,

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

250:
251: PROCEDURE Validate_ctd_prm_val(
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_ctd_prm_val_rec IN ctd_prm_val_rec_type,
256: x_return_status OUT NOCOPY VARCHAR2,
257: x_msg_count OUT NOCOPY NUMBER,
258: x_msg_data OUT NOCOPY VARCHAR2

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

287: -- End of Comments
288:
289: PROCEDURE Validate_ctd_prm_val_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_ctd_prm_val_rec IN ctd_prm_val_rec_type