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

Line 49: created_by NUMBER := FND_API.G_MISS_NUM,

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

Line 50: creation_date DATE := FND_API.G_MISS_DATE,

46: --===================================================================
47: TYPE ps_cndclses_rec_type IS RECORD
48: (
49: created_by NUMBER := FND_API.G_MISS_NUM,
50: creation_date DATE := FND_API.G_MISS_DATE,
51: last_updated_by NUMBER := FND_API.G_MISS_NUM,
52: last_update_date DATE := FND_API.G_MISS_DATE,
53: last_update_login 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 ps_cndclses_rec_type IS RECORD
48: (
49: created_by NUMBER := FND_API.G_MISS_NUM,
50: creation_date DATE := FND_API.G_MISS_DATE,
51: last_updated_by NUMBER := FND_API.G_MISS_NUM,
52: last_update_date DATE := FND_API.G_MISS_DATE,
53: last_update_login NUMBER := FND_API.G_MISS_NUM,
54: object_version_number NUMBER := FND_API.G_MISS_NUM,
55: cnd_clause_id NUMBER := FND_API.G_MISS_NUM,

Line 52: last_update_date DATE := FND_API.G_MISS_DATE,

48: (
49: created_by NUMBER := FND_API.G_MISS_NUM,
50: creation_date DATE := FND_API.G_MISS_DATE,
51: last_updated_by NUMBER := FND_API.G_MISS_NUM,
52: last_update_date DATE := FND_API.G_MISS_DATE,
53: last_update_login NUMBER := FND_API.G_MISS_NUM,
54: object_version_number NUMBER := FND_API.G_MISS_NUM,
55: cnd_clause_id NUMBER := FND_API.G_MISS_NUM,
56: cnd_clause_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 53: last_update_login NUMBER := FND_API.G_MISS_NUM,

49: created_by NUMBER := FND_API.G_MISS_NUM,
50: creation_date DATE := FND_API.G_MISS_DATE,
51: last_updated_by NUMBER := FND_API.G_MISS_NUM,
52: last_update_date DATE := FND_API.G_MISS_DATE,
53: last_update_login NUMBER := FND_API.G_MISS_NUM,
54: object_version_number NUMBER := FND_API.G_MISS_NUM,
55: cnd_clause_id NUMBER := FND_API.G_MISS_NUM,
56: cnd_clause_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: cnd_clause_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 54: object_version_number NUMBER := FND_API.G_MISS_NUM,

50: creation_date DATE := FND_API.G_MISS_DATE,
51: last_updated_by NUMBER := FND_API.G_MISS_NUM,
52: last_update_date DATE := FND_API.G_MISS_DATE,
53: last_update_login NUMBER := FND_API.G_MISS_NUM,
54: object_version_number NUMBER := FND_API.G_MISS_NUM,
55: cnd_clause_id NUMBER := FND_API.G_MISS_NUM,
56: cnd_clause_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: cnd_clause_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: cnd_comp_operator VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 55: cnd_clause_id NUMBER := FND_API.G_MISS_NUM,

51: last_updated_by NUMBER := FND_API.G_MISS_NUM,
52: last_update_date DATE := FND_API.G_MISS_DATE,
53: last_update_login NUMBER := FND_API.G_MISS_NUM,
54: object_version_number NUMBER := FND_API.G_MISS_NUM,
55: cnd_clause_id NUMBER := FND_API.G_MISS_NUM,
56: cnd_clause_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: cnd_clause_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: cnd_comp_operator VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: cnd_default_value VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 56: cnd_clause_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR,

52: last_update_date DATE := FND_API.G_MISS_DATE,
53: last_update_login NUMBER := FND_API.G_MISS_NUM,
54: object_version_number NUMBER := FND_API.G_MISS_NUM,
55: cnd_clause_id NUMBER := FND_API.G_MISS_NUM,
56: cnd_clause_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: cnd_clause_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: cnd_comp_operator VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: cnd_default_value VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: cnd_clause_name VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 57: cnd_clause_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

53: last_update_login NUMBER := FND_API.G_MISS_NUM,
54: object_version_number NUMBER := FND_API.G_MISS_NUM,
55: cnd_clause_id NUMBER := FND_API.G_MISS_NUM,
56: cnd_clause_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: cnd_clause_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: cnd_comp_operator VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: cnd_default_value VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: cnd_clause_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
61: cnd_clause_description VARCHAR2(4000) := FND_API.G_MISS_CHAR

Line 58: cnd_comp_operator VARCHAR2(30) := FND_API.G_MISS_CHAR,

54: object_version_number NUMBER := FND_API.G_MISS_NUM,
55: cnd_clause_id NUMBER := FND_API.G_MISS_NUM,
56: cnd_clause_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: cnd_clause_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: cnd_comp_operator VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: cnd_default_value VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: cnd_clause_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
61: cnd_clause_description VARCHAR2(4000) := FND_API.G_MISS_CHAR
62: );

Line 59: cnd_default_value VARCHAR2(30) := FND_API.G_MISS_CHAR,

55: cnd_clause_id NUMBER := FND_API.G_MISS_NUM,
56: cnd_clause_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: cnd_clause_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: cnd_comp_operator VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: cnd_default_value VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: cnd_clause_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
61: cnd_clause_description VARCHAR2(4000) := FND_API.G_MISS_CHAR
62: );
63:

Line 60: cnd_clause_name VARCHAR2(240) := FND_API.G_MISS_CHAR,

56: cnd_clause_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: cnd_clause_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: cnd_comp_operator VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: cnd_default_value VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: cnd_clause_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
61: cnd_clause_description VARCHAR2(4000) := FND_API.G_MISS_CHAR
62: );
63:
64: g_miss_ps_cndclses_rec ps_cndclses_rec_type;

Line 61: cnd_clause_description VARCHAR2(4000) := FND_API.G_MISS_CHAR

57: cnd_clause_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: cnd_comp_operator VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: cnd_default_value VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: cnd_clause_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
61: cnd_clause_description VARCHAR2(4000) := FND_API.G_MISS_CHAR
62: );
63:
64: g_miss_ps_cndclses_rec ps_cndclses_rec_type;
65: TYPE ps_cndclses_tbl_type IS TABLE OF ps_cndclses_rec_type INDEX BY BINARY_INTEGER;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

187: PROCEDURE Delete_Ps_Cndclses(
188: p_api_version_number IN NUMBER,
189: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
190: p_commit IN VARCHAR2 := FND_API.G_FALSE,
191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
192: x_return_status OUT NOCOPY VARCHAR2,
193: x_msg_count OUT NOCOPY NUMBER,
194: x_msg_data OUT NOCOPY VARCHAR2,
195: p_cnd_clause_id IN NUMBER,

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

208: -- Parameters
209: --
210: -- IN
211: -- p_api_version_number IN NUMBER Required
212: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
213: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
214: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
215: -- p_ps_cndclses_rec IN ps_cndclses_rec_type Required
216: --

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

209: --
210: -- IN
211: -- p_api_version_number IN NUMBER Required
212: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
213: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
214: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
215: -- p_ps_cndclses_rec IN ps_cndclses_rec_type Required
216: --
217: -- OUT

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

210: -- IN
211: -- p_api_version_number IN NUMBER Required
212: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
213: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
214: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
215: -- p_ps_cndclses_rec IN ps_cndclses_rec_type Required
216: --
217: -- OUT
218: -- x_return_status OUT VARCHAR2

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

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

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

251: -- End of Comments
252:
253: PROCEDURE Validate_ps_cndclses(
254: p_api_version_number IN NUMBER,
255: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
256: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
257: p_ps_cndclses_rec IN ps_cndclses_rec_type,
258: x_return_status OUT NOCOPY VARCHAR2,
259: x_msg_count OUT NOCOPY NUMBER,

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

252:
253: PROCEDURE Validate_ps_cndclses(
254: p_api_version_number IN NUMBER,
255: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
256: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
257: p_ps_cndclses_rec IN ps_cndclses_rec_type,
258: x_return_status OUT NOCOPY VARCHAR2,
259: x_msg_count OUT NOCOPY NUMBER,
260: x_msg_data OUT NOCOPY VARCHAR2

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

289: -- End of Comments
290:
291: PROCEDURE Validate_ps_cndclses_rec(
292: p_api_version_number IN NUMBER,
293: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
294: x_return_status OUT NOCOPY VARCHAR2,
295: x_msg_count OUT NOCOPY NUMBER,
296: x_msg_data OUT NOCOPY VARCHAR2,
297: p_ps_cndclses_rec IN ps_cndclses_rec_type