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

Line 51: site_id NUMBER := FND_API.G_MISS_NUM,

47:
48: --===================================================================
49: TYPE iba_pl_sites_rec_type IS RECORD
50: (
51: site_id NUMBER := FND_API.G_MISS_NUM,
52: site_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: site_category_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: site_category_object_id NUMBER := FND_API.G_MISS_NUM,
55: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 52: site_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

48: --===================================================================
49: TYPE iba_pl_sites_rec_type IS RECORD
50: (
51: site_id NUMBER := FND_API.G_MISS_NUM,
52: site_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: site_category_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: site_category_object_id NUMBER := FND_API.G_MISS_NUM,
55: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: created_by NUMBER := FND_API.G_MISS_NUM,

Line 53: site_category_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

49: TYPE iba_pl_sites_rec_type IS RECORD
50: (
51: site_id NUMBER := FND_API.G_MISS_NUM,
52: site_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: site_category_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: site_category_object_id NUMBER := FND_API.G_MISS_NUM,
55: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: created_by NUMBER := FND_API.G_MISS_NUM,
57: creation_date DATE := FND_API.G_MISS_DATE,

Line 54: site_category_object_id NUMBER := FND_API.G_MISS_NUM,

50: (
51: site_id NUMBER := FND_API.G_MISS_NUM,
52: site_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: site_category_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: site_category_object_id NUMBER := FND_API.G_MISS_NUM,
55: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: created_by NUMBER := FND_API.G_MISS_NUM,
57: creation_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,

Line 55: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

51: site_id NUMBER := FND_API.G_MISS_NUM,
52: site_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: site_category_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: site_category_object_id NUMBER := FND_API.G_MISS_NUM,
55: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: created_by NUMBER := FND_API.G_MISS_NUM,
57: creation_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: last_update_date DATE := FND_API.G_MISS_DATE,

Line 56: created_by NUMBER := FND_API.G_MISS_NUM,

52: site_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: site_category_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: site_category_object_id NUMBER := FND_API.G_MISS_NUM,
55: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: created_by NUMBER := FND_API.G_MISS_NUM,
57: creation_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: last_update_date DATE := FND_API.G_MISS_DATE,
60: last_update_login NUMBER := FND_API.G_MISS_NUM,

Line 57: creation_date DATE := FND_API.G_MISS_DATE,

53: site_category_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: site_category_object_id NUMBER := FND_API.G_MISS_NUM,
55: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: created_by NUMBER := FND_API.G_MISS_NUM,
57: creation_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: last_update_date DATE := FND_API.G_MISS_DATE,
60: last_update_login NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,

Line 58: last_updated_by NUMBER := FND_API.G_MISS_NUM,

54: site_category_object_id NUMBER := FND_API.G_MISS_NUM,
55: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: created_by NUMBER := FND_API.G_MISS_NUM,
57: creation_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: last_update_date DATE := FND_API.G_MISS_DATE,
60: last_update_login NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,
62: name VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 59: last_update_date DATE := FND_API.G_MISS_DATE,

55: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: created_by NUMBER := FND_API.G_MISS_NUM,
57: creation_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: last_update_date DATE := FND_API.G_MISS_DATE,
60: last_update_login NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,
62: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
63: description VARCHAR2(4000) := FND_API.G_MISS_CHAR

Line 60: last_update_login NUMBER := FND_API.G_MISS_NUM,

56: created_by NUMBER := FND_API.G_MISS_NUM,
57: creation_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: last_update_date DATE := FND_API.G_MISS_DATE,
60: last_update_login NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,
62: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
63: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
64: );

Line 61: object_version_number NUMBER := FND_API.G_MISS_NUM,

57: creation_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: last_update_date DATE := FND_API.G_MISS_DATE,
60: last_update_login NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,
62: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
63: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
64: );
65:

Line 62: name VARCHAR2(240) := FND_API.G_MISS_CHAR,

58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: last_update_date DATE := FND_API.G_MISS_DATE,
60: last_update_login NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,
62: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
63: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
64: );
65:
66: g_miss_iba_pl_sites_rec iba_pl_sites_rec_type;

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

59: last_update_date DATE := FND_API.G_MISS_DATE,
60: last_update_login NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,
62: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
63: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
64: );
65:
66: g_miss_iba_pl_sites_rec iba_pl_sites_rec_type;
67: TYPE iba_pl_sites_tbl_type IS TABLE OF iba_pl_sites_rec_type INDEX BY BINARY_INTEGER;

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

79: -- Parameters
80: --
81: -- IN
82: -- p_api_version_number IN NUMBER Required
83: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
84: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
85: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
86: -- p_iba_pl_sites_rec IN iba_pl_sites_rec_type Required
87: --

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

80: --
81: -- IN
82: -- p_api_version_number IN NUMBER Required
83: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
84: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
85: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
86: -- p_iba_pl_sites_rec IN iba_pl_sites_rec_type Required
87: --
88: -- OUT

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

81: -- IN
82: -- p_api_version_number IN NUMBER Required
83: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
84: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
85: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
86: -- p_iba_pl_sites_rec IN iba_pl_sites_rec_type Required
87: --
88: -- OUT
89: -- x_return_status OUT VARCHAR2

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

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

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

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

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

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

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

123: -- Parameters
124: --
125: -- IN
126: -- p_api_version_number IN NUMBER Required
127: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
128: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
129: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
130: -- p_iba_pl_sites_rec IN iba_pl_sites_rec_type Required
131: --

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

124: --
125: -- IN
126: -- p_api_version_number IN NUMBER Required
127: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
128: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
129: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
130: -- p_iba_pl_sites_rec IN iba_pl_sites_rec_type Required
131: --
132: -- OUT

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

125: -- IN
126: -- p_api_version_number IN NUMBER Required
127: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
128: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
129: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
130: -- p_iba_pl_sites_rec IN iba_pl_sites_rec_type Required
131: --
132: -- OUT
133: -- x_return_status OUT VARCHAR2

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

189: PROCEDURE Delete_Iba_Pl_Sites(
190: p_api_version_number IN NUMBER,
191: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
192: p_commit IN VARCHAR2 := FND_API.G_FALSE,
193: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
194: x_return_status OUT NOCOPY VARCHAR2,
195: x_msg_count OUT NOCOPY NUMBER,
196: x_msg_data OUT NOCOPY VARCHAR2,
197: p_site_id IN NUMBER,

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

210: -- Parameters
211: --
212: -- IN
213: -- p_api_version_number IN NUMBER Required
214: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
215: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
216: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
217: -- p_iba_pl_sites_rec IN iba_pl_sites_rec_type Required
218: --

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

211: --
212: -- IN
213: -- p_api_version_number IN NUMBER Required
214: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
215: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
216: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
217: -- p_iba_pl_sites_rec IN iba_pl_sites_rec_type Required
218: --
219: -- OUT

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

212: -- IN
213: -- p_api_version_number IN NUMBER Required
214: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
215: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
216: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
217: -- p_iba_pl_sites_rec IN iba_pl_sites_rec_type Required
218: --
219: -- OUT
220: -- x_return_status OUT VARCHAR2

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

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

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

253: -- End of Comments
254:
255: PROCEDURE Validate_iba_pl_sites(
256: p_api_version_number IN NUMBER
257: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
258: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
259: , p_iba_pl_sites_rec IN iba_pl_sites_rec_type
260: , x_return_status OUT NOCOPY VARCHAR2
261: , x_msg_count OUT NOCOPY NUMBER

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

254:
255: PROCEDURE Validate_iba_pl_sites(
256: p_api_version_number IN NUMBER
257: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
258: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
259: , p_iba_pl_sites_rec IN iba_pl_sites_rec_type
260: , x_return_status OUT NOCOPY VARCHAR2
261: , x_msg_count OUT NOCOPY NUMBER
262: , x_msg_data OUT NOCOPY VARCHAR2

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

292: -- End of Comments
293:
294: PROCEDURE Validate_iba_pl_sites_rec(
295: p_api_version_number IN NUMBER,
296: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
297: x_return_status OUT NOCOPY VARCHAR2,
298: x_msg_count OUT NOCOPY NUMBER,
299: x_msg_data OUT NOCOPY VARCHAR2,
300: p_iba_pl_sites_rec IN iba_pl_sites_rec_type