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

Line 54: -- Defaults: FND_API.G_MISS*

50: -- LAST_UPDATE_DATE
51: -- LAST_UPDATE_LOGIN
52: --
53: -- Required:
54: -- Defaults: FND_API.G_MISS*
55: -- History: Jan-16-2008 rfieldma created
56: --
57: -- End of Comments
58: --

Line 61: RO_BULLETIN_ID NUMBER := FND_API.G_MISS_NUM

57: -- End of Comments
58: --
59: TYPE RO_BULLETIN_REC_TYPE IS RECORD
60: (
61: RO_BULLETIN_ID NUMBER := FND_API.G_MISS_NUM
62: ,REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM
63: ,BULLETIN_ID NUMBER := FND_API.G_MISS_NUM
64: ,LAST_VIEWED_DATE DATE := FND_API.G_MISS_DATE
65: ,LAST_VIEWED_BY NUMBER := FND_API.G_MISS_NUM

Line 62: ,REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM

58: --
59: TYPE RO_BULLETIN_REC_TYPE IS RECORD
60: (
61: RO_BULLETIN_ID NUMBER := FND_API.G_MISS_NUM
62: ,REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM
63: ,BULLETIN_ID NUMBER := FND_API.G_MISS_NUM
64: ,LAST_VIEWED_DATE DATE := FND_API.G_MISS_DATE
65: ,LAST_VIEWED_BY NUMBER := FND_API.G_MISS_NUM
66: ,SOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 63: ,BULLETIN_ID NUMBER := FND_API.G_MISS_NUM

59: TYPE RO_BULLETIN_REC_TYPE IS RECORD
60: (
61: RO_BULLETIN_ID NUMBER := FND_API.G_MISS_NUM
62: ,REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM
63: ,BULLETIN_ID NUMBER := FND_API.G_MISS_NUM
64: ,LAST_VIEWED_DATE DATE := FND_API.G_MISS_DATE
65: ,LAST_VIEWED_BY NUMBER := FND_API.G_MISS_NUM
66: ,SOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
67: ,SOURCE_ID NUMBER := FND_API.G_MISS_NUM

Line 64: ,LAST_VIEWED_DATE DATE := FND_API.G_MISS_DATE

60: (
61: RO_BULLETIN_ID NUMBER := FND_API.G_MISS_NUM
62: ,REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM
63: ,BULLETIN_ID NUMBER := FND_API.G_MISS_NUM
64: ,LAST_VIEWED_DATE DATE := FND_API.G_MISS_DATE
65: ,LAST_VIEWED_BY NUMBER := FND_API.G_MISS_NUM
66: ,SOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
67: ,SOURCE_ID NUMBER := FND_API.G_MISS_NUM
68: ,OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM

Line 65: ,LAST_VIEWED_BY NUMBER := FND_API.G_MISS_NUM

61: RO_BULLETIN_ID NUMBER := FND_API.G_MISS_NUM
62: ,REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM
63: ,BULLETIN_ID NUMBER := FND_API.G_MISS_NUM
64: ,LAST_VIEWED_DATE DATE := FND_API.G_MISS_DATE
65: ,LAST_VIEWED_BY NUMBER := FND_API.G_MISS_NUM
66: ,SOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
67: ,SOURCE_ID NUMBER := FND_API.G_MISS_NUM
68: ,OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
69: ,CREATED_BY NUMBER := FND_API.G_MISS_NUM

Line 66: ,SOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR

62: ,REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM
63: ,BULLETIN_ID NUMBER := FND_API.G_MISS_NUM
64: ,LAST_VIEWED_DATE DATE := FND_API.G_MISS_DATE
65: ,LAST_VIEWED_BY NUMBER := FND_API.G_MISS_NUM
66: ,SOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
67: ,SOURCE_ID NUMBER := FND_API.G_MISS_NUM
68: ,OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
69: ,CREATED_BY NUMBER := FND_API.G_MISS_NUM
70: ,CREATION_DATE DATE := FND_API.G_MISS_DATE

Line 67: ,SOURCE_ID NUMBER := FND_API.G_MISS_NUM

63: ,BULLETIN_ID NUMBER := FND_API.G_MISS_NUM
64: ,LAST_VIEWED_DATE DATE := FND_API.G_MISS_DATE
65: ,LAST_VIEWED_BY NUMBER := FND_API.G_MISS_NUM
66: ,SOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
67: ,SOURCE_ID NUMBER := FND_API.G_MISS_NUM
68: ,OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
69: ,CREATED_BY NUMBER := FND_API.G_MISS_NUM
70: ,CREATION_DATE DATE := FND_API.G_MISS_DATE
71: ,LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM

Line 68: ,OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM

64: ,LAST_VIEWED_DATE DATE := FND_API.G_MISS_DATE
65: ,LAST_VIEWED_BY NUMBER := FND_API.G_MISS_NUM
66: ,SOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
67: ,SOURCE_ID NUMBER := FND_API.G_MISS_NUM
68: ,OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
69: ,CREATED_BY NUMBER := FND_API.G_MISS_NUM
70: ,CREATION_DATE DATE := FND_API.G_MISS_DATE
71: ,LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
72: ,LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE

Line 69: ,CREATED_BY NUMBER := FND_API.G_MISS_NUM

65: ,LAST_VIEWED_BY NUMBER := FND_API.G_MISS_NUM
66: ,SOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
67: ,SOURCE_ID NUMBER := FND_API.G_MISS_NUM
68: ,OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
69: ,CREATED_BY NUMBER := FND_API.G_MISS_NUM
70: ,CREATION_DATE DATE := FND_API.G_MISS_DATE
71: ,LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
72: ,LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
73: ,LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM

Line 70: ,CREATION_DATE DATE := FND_API.G_MISS_DATE

66: ,SOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
67: ,SOURCE_ID NUMBER := FND_API.G_MISS_NUM
68: ,OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
69: ,CREATED_BY NUMBER := FND_API.G_MISS_NUM
70: ,CREATION_DATE DATE := FND_API.G_MISS_DATE
71: ,LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
72: ,LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
73: ,LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
74: );

Line 71: ,LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM

67: ,SOURCE_ID NUMBER := FND_API.G_MISS_NUM
68: ,OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
69: ,CREATED_BY NUMBER := FND_API.G_MISS_NUM
70: ,CREATION_DATE DATE := FND_API.G_MISS_DATE
71: ,LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
72: ,LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
73: ,LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
74: );
75:

Line 72: ,LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE

68: ,OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
69: ,CREATED_BY NUMBER := FND_API.G_MISS_NUM
70: ,CREATION_DATE DATE := FND_API.G_MISS_DATE
71: ,LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
72: ,LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
73: ,LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
74: );
75:
76: G_MISS_RO_BULLETIN_REC RO_BULLETIN_REC_TYPE;

Line 73: ,LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM

69: ,CREATED_BY NUMBER := FND_API.G_MISS_NUM
70: ,CREATION_DATE DATE := FND_API.G_MISS_DATE
71: ,LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
72: ,LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
73: ,LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
74: );
75:
76: G_MISS_RO_BULLETIN_REC RO_BULLETIN_REC_TYPE;
77: TYPE RO_BULLETIN_TBL_TYPE IS TABLE OF RO_BULLETIN_Rec_Type

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

112: -- Pre-Req :
113: -- Parameters:
114: -- IN
115: -- p_api_version_number IN NUMBER Required
116: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
117: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
118: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
119: -- P_RO_BULLETIN_Rec IN CSD_RO_BULLETIN_REC_TYPE Required
120: --

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

113: -- Parameters:
114: -- IN
115: -- p_api_version_number IN NUMBER Required
116: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
117: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
118: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
119: -- P_RO_BULLETIN_Rec IN CSD_RO_BULLETIN_REC_TYPE Required
120: --
121: -- OUT:

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

114: -- IN
115: -- p_api_version_number IN NUMBER Required
116: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
117: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
118: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
119: -- P_RO_BULLETIN_Rec IN CSD_RO_BULLETIN_REC_TYPE Required
120: --
121: -- OUT:
122: -- x_return_status OUT NOCOPY VARCHAR2

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

128: -- End of Comments
129: -- -------------------
130: PROCEDURE CREATE_RO_BULLETIN(
131: p_api_version_number IN NUMBER,
132: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
133: p_commit IN VARCHAR2 := FND_API.G_FALSE,
134: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
135: p_ro_bulletin_rec IN RO_BULLETIN_Rec_Type /*:= G_MISS_CSD_RO_BULLETIN_REC*/,
136: x_ro_bulletin_id OUT NOCOPY NUMBER,

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

129: -- -------------------
130: PROCEDURE CREATE_RO_BULLETIN(
131: p_api_version_number IN NUMBER,
132: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
133: p_commit IN VARCHAR2 := FND_API.G_FALSE,
134: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
135: p_ro_bulletin_rec IN RO_BULLETIN_Rec_Type /*:= G_MISS_CSD_RO_BULLETIN_REC*/,
136: x_ro_bulletin_id OUT NOCOPY NUMBER,
137: x_return_status OUT NOCOPY VARCHAR2,

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

130: PROCEDURE CREATE_RO_BULLETIN(
131: p_api_version_number IN NUMBER,
132: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
133: p_commit IN VARCHAR2 := FND_API.G_FALSE,
134: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
135: p_ro_bulletin_rec IN RO_BULLETIN_Rec_Type /*:= G_MISS_CSD_RO_BULLETIN_REC*/,
136: x_ro_bulletin_id OUT NOCOPY NUMBER,
137: x_return_status OUT NOCOPY VARCHAR2,
138: x_msg_count OUT NOCOPY NUMBER,

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

147: -- Pre-Req :
148: -- Parameters:
149: -- IN
150: -- p_api_version_number IN NUMBER Required
151: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
152: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
153: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
154: -- P_RO_BULLETIN_Rec IN CSD_RO_BULLETIN_REC_TYPE Required
155: --

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

148: -- Parameters:
149: -- IN
150: -- p_api_version_number IN NUMBER Required
151: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
152: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
153: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
154: -- P_RO_BULLETIN_Rec IN CSD_RO_BULLETIN_REC_TYPE Required
155: --
156: -- OUT:

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

149: -- IN
150: -- p_api_version_number IN NUMBER Required
151: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
152: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
153: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
154: -- P_RO_BULLETIN_Rec IN CSD_RO_BULLETIN_REC_TYPE Required
155: --
156: -- OUT:
157: -- x_return_status OUT NOCOPY VARCHAR2

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

162: -- End of Comments
163: -- -------------------
164: PROCEDURE UPDATE_RO_BULLETIN(
165: p_api_version_number IN NUMBER,
166: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
167: p_commit IN VARCHAR2 := FND_API.G_FALSE,
168: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
169: p_ro_bulletin_rec IN RO_BULLETIN_Rec_Type,
170: x_return_status OUT NOCOPY VARCHAR2,

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

163: -- -------------------
164: PROCEDURE UPDATE_RO_BULLETIN(
165: p_api_version_number IN NUMBER,
166: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
167: p_commit IN VARCHAR2 := FND_API.G_FALSE,
168: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
169: p_ro_bulletin_rec IN RO_BULLETIN_Rec_Type,
170: x_return_status OUT NOCOPY VARCHAR2,
171: x_msg_count OUT NOCOPY NUMBER,

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

164: PROCEDURE UPDATE_RO_BULLETIN(
165: p_api_version_number IN NUMBER,
166: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
167: p_commit IN VARCHAR2 := FND_API.G_FALSE,
168: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
169: p_ro_bulletin_rec IN RO_BULLETIN_Rec_Type,
170: x_return_status OUT NOCOPY VARCHAR2,
171: x_msg_count OUT NOCOPY NUMBER,
172: x_msg_data OUT NOCOPY VARCHAR2

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

180: -- Pre-Req :
181: -- Parameters:
182: -- IN
183: -- p_api_version_number IN NUMBER Required
184: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
185: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
186: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
187: -- p_ro_bulletin_id IN NUMBER Required
188: --

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

181: -- Parameters:
182: -- IN
183: -- p_api_version_number IN NUMBER Required
184: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
185: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
186: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
187: -- p_ro_bulletin_id IN NUMBER Required
188: --
189: -- OUT:

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

182: -- IN
183: -- p_api_version_number IN NUMBER Required
184: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
185: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
186: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
187: -- p_ro_bulletin_id IN NUMBER Required
188: --
189: -- OUT:
190: -- x_return_status OUT NOCOPY VARCHAR2

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

195: -- End of Comments
196: -- -------------------
197: PROCEDURE DELETE_RO_BULLETIN(
198: p_api_version_number IN NUMBER,
199: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
200: p_commit IN VARCHAR2 := FND_API.G_FALSE,
201: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202: p_ro_bulletin_id IN NUMBER,
203: x_return_status OUT NOCOPY VARCHAR2,

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

196: -- -------------------
197: PROCEDURE DELETE_RO_BULLETIN(
198: p_api_version_number IN NUMBER,
199: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
200: p_commit IN VARCHAR2 := FND_API.G_FALSE,
201: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202: p_ro_bulletin_id IN NUMBER,
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_count OUT NOCOPY NUMBER,

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

197: PROCEDURE DELETE_RO_BULLETIN(
198: p_api_version_number IN NUMBER,
199: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
200: p_commit IN VARCHAR2 := FND_API.G_FALSE,
201: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202: p_ro_bulletin_id IN NUMBER,
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_count OUT NOCOPY NUMBER,
205: x_msg_data OUT NOCOPY VARCHAR2

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

213: -- Pre-Req :
214: -- Parameters:
215: -- IN
216: -- p_api_version_number IN NUMBER Required
217: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
218: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
219: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
220: -- p_ro_bulletin_rec IN RO_BULLETIN_REC_TYPE Required
221: -- OUT:

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

214: -- Parameters:
215: -- IN
216: -- p_api_version_number IN NUMBER Required
217: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
218: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
219: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
220: -- p_ro_bulletin_rec IN RO_BULLETIN_REC_TYPE Required
221: -- OUT:
222: -- x_return_status OUT NOCOPY VARCHAR2

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

215: -- IN
216: -- p_api_version_number IN NUMBER Required
217: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
218: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
219: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
220: -- p_ro_bulletin_rec IN RO_BULLETIN_REC_TYPE Required
221: -- OUT:
222: -- x_return_status OUT NOCOPY VARCHAR2
223: -- x_msg_count OUT NOCOPY NUMBER

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

227: -- End of Comments
228: -- -------------------
229: PROCEDURE LOCK_RO_BULLETIN(
230: p_api_version_number IN NUMBER,
231: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
232: p_commit IN VARCHAR2 := FND_API.G_FALSE,
233: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
234: p_ro_bulletin_rec IN RO_BULLETIN_Rec_Type,
235: x_return_status OUT NOCOPY VARCHAR2,

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

228: -- -------------------
229: PROCEDURE LOCK_RO_BULLETIN(
230: p_api_version_number IN NUMBER,
231: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
232: p_commit IN VARCHAR2 := FND_API.G_FALSE,
233: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
234: p_ro_bulletin_rec IN RO_BULLETIN_Rec_Type,
235: x_return_status OUT NOCOPY VARCHAR2,
236: x_msg_count OUT NOCOPY NUMBER,

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

229: PROCEDURE LOCK_RO_BULLETIN(
230: p_api_version_number IN NUMBER,
231: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
232: p_commit IN VARCHAR2 := FND_API.G_FALSE,
233: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
234: p_ro_bulletin_rec IN RO_BULLETIN_Rec_Type,
235: x_return_status OUT NOCOPY VARCHAR2,
236: x_msg_count OUT NOCOPY NUMBER,
237: x_msg_data OUT NOCOPY VARCHAR2

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

246: -- Pre-Req :
247: -- Parameters:
248: -- IN
249: -- p_api_version_number IN NUMBER Required
250: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
251: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
252: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
253: -- p_repair_line_id IN NUMBER Required
254: -- px_sc_ids_tbl IN OUT NOCOPY CSD_RO_SC_IDS_TBL_TYPE Required

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

247: -- Parameters:
248: -- IN
249: -- p_api_version_number IN NUMBER Required
250: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
251: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
252: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
253: -- p_repair_line_id IN NUMBER Required
254: -- px_sc_ids_tbl IN OUT NOCOPY CSD_RO_SC_IDS_TBL_TYPE Required
255: -- OUT:

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

248: -- IN
249: -- p_api_version_number IN NUMBER Required
250: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
251: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
252: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
253: -- p_repair_line_id IN NUMBER Required
254: -- px_sc_ids_tbl IN OUT NOCOPY CSD_RO_SC_IDS_TBL_TYPE Required
255: -- OUT:
256: -- x_return_status OUT NOCOPY VARCHAR2

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

261: -- End of Comments
262: -- -------------------
263: PROCEDURE LINK_BULLETINS_TO_RO(
264: p_api_version_number IN NUMBER,
265: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
266: p_commit IN VARCHAR2 := FND_API.G_FALSE,
267: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
268: p_repair_line_id IN NUMBER,
269: px_ro_sc_ids_tbl IN OUT NOCOPY CSD_RO_SC_IDS_TBL_TYPE,

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

262: -- -------------------
263: PROCEDURE LINK_BULLETINS_TO_RO(
264: p_api_version_number IN NUMBER,
265: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
266: p_commit IN VARCHAR2 := FND_API.G_FALSE,
267: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
268: p_repair_line_id IN NUMBER,
269: px_ro_sc_ids_tbl IN OUT NOCOPY CSD_RO_SC_IDS_TBL_TYPE,
270: x_return_status OUT NOCOPY VARCHAR2,

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

263: PROCEDURE LINK_BULLETINS_TO_RO(
264: p_api_version_number IN NUMBER,
265: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
266: p_commit IN VARCHAR2 := FND_API.G_FALSE,
267: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
268: p_repair_line_id IN NUMBER,
269: px_ro_sc_ids_tbl IN OUT NOCOPY CSD_RO_SC_IDS_TBL_TYPE,
270: x_return_status OUT NOCOPY VARCHAR2,
271: x_msg_count OUT NOCOPY NUMBER,

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

280: -- Pre-Req :
281: -- Parameters:
282: -- IN
283: -- p_api_version_number IN NUMBER Required
284: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
285: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
286: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
287: -- p_repair_line_id IN NUMBER Required
288: -- p_bulletin_id IN NUMBER Required

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

281: -- Parameters:
282: -- IN
283: -- p_api_version_number IN NUMBER Required
284: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
285: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
286: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
287: -- p_repair_line_id IN NUMBER Required
288: -- p_bulletin_id IN NUMBER Required
289: -- p_rule_id IN NUMBER Required

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

282: -- IN
283: -- p_api_version_number IN NUMBER Required
284: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
285: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
286: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
287: -- p_repair_line_id IN NUMBER Required
288: -- p_bulletin_id IN NUMBER Required
289: -- p_rule_id IN NUMBER Required
290: -- px_sc_ids_tbl IN OUT NOCOPY CSD_RO_SC_IDS_TBL_TYPE Required