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.OKL_BGH_PVT dependencies on OKL_BLLNG_CHRG_HDRS_TL

Line 57: DELETE FROM OKL_BLLNG_CHRG_HDRS_TL T

53: -- PROCEDURE add_language
54: ---------------------------------------------------------------------------
55: PROCEDURE add_language IS
56: BEGIN
57: DELETE FROM OKL_BLLNG_CHRG_HDRS_TL T
58: WHERE NOT EXISTS (
59: SELECT NULL
60: FROM OKL_BLNG_CHRG_HDRS_ALL_B B --fixed bug 3321017 by kmotepal
61: WHERE B.ID = T.ID

Line 64: UPDATE OKL_BLLNG_CHRG_HDRS_TL T SET (

60: FROM OKL_BLNG_CHRG_HDRS_ALL_B B --fixed bug 3321017 by kmotepal
61: WHERE B.ID = T.ID
62: );
63:
64: UPDATE OKL_BLLNG_CHRG_HDRS_TL T SET (
65: NAME,
66: ORIGIN,
67: DESTINATION) = (SELECT
68: B.NAME,

Line 71: FROM OKL_BLLNG_CHRG_HDRS_TL B

67: DESTINATION) = (SELECT
68: B.NAME,
69: B.ORIGIN,
70: B.DESTINATION
71: FROM OKL_BLLNG_CHRG_HDRS_TL B
72: WHERE B.ID = T.ID
73: AND B.LANGUAGE = T.SOURCE_LANG)
74: WHERE (
75: T.ID,

Line 80: FROM OKL_BLLNG_CHRG_HDRS_TL SUBB, OKL_BLLNG_CHRG_HDRS_TL SUBT

76: T.LANGUAGE)
77: IN (SELECT
78: SUBT.ID,
79: SUBT.LANGUAGE
80: FROM OKL_BLLNG_CHRG_HDRS_TL SUBB, OKL_BLLNG_CHRG_HDRS_TL SUBT
81: WHERE SUBB.ID = SUBT.ID
82: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
83: AND (SUBB.NAME <> SUBT.NAME
84: OR SUBB.ORIGIN <> SUBT.ORIGIN

Line 92: INSERT INTO OKL_BLLNG_CHRG_HDRS_TL (

88: OR (SUBB.DESTINATION IS NULL AND SUBT.DESTINATION IS NOT NULL)
89: OR (SUBB.DESTINATION IS NOT NULL AND SUBT.DESTINATION IS NULL)
90: ));
91:
92: INSERT INTO OKL_BLLNG_CHRG_HDRS_TL (
93: ID,
94: LANGUAGE,
95: SOURCE_LANG,
96: SFWT_FLAG,

Line 118: FROM OKL_BLLNG_CHRG_HDRS_TL B, FND_LANGUAGES L

114: B.CREATION_DATE,
115: B.LAST_UPDATED_BY,
116: B.LAST_UPDATE_DATE,
117: B.LAST_UPDATE_LOGIN
118: FROM OKL_BLLNG_CHRG_HDRS_TL B, FND_LANGUAGES L
119: WHERE L.INSTALLED_FLAG IN ('I', 'B')
120: AND B.LANGUAGE = USERENV('LANG')
121: AND NOT EXISTS(
122: SELECT NULL

Line 123: FROM OKL_BLLNG_CHRG_HDRS_TL T

119: WHERE L.INSTALLED_FLAG IN ('I', 'B')
120: AND B.LANGUAGE = USERENV('LANG')
121: AND NOT EXISTS(
122: SELECT NULL
123: FROM OKL_BLLNG_CHRG_HDRS_TL T
124: WHERE T.ID = B.ID
125: AND T.LANGUAGE = L.LANGUAGE_CODE
126: );
127:

Line 223: -- FUNCTION get_rec for: OKL_BLLNG_CHRG_HDRS_TL

219: BEGIN
220: RETURN(get_rec(p_bgh_rec, l_row_notfound));
221: END get_rec;
222: ---------------------------------------------------------------------------
223: -- FUNCTION get_rec for: OKL_BLLNG_CHRG_HDRS_TL
224: ---------------------------------------------------------------------------
225: FUNCTION get_rec (
226: p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType,
227: x_no_data_found OUT NOCOPY BOOLEAN

Line 226: p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType,

222: ---------------------------------------------------------------------------
223: -- FUNCTION get_rec for: OKL_BLLNG_CHRG_HDRS_TL
224: ---------------------------------------------------------------------------
225: FUNCTION get_rec (
226: p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType,
227: x_no_data_found OUT NOCOPY BOOLEAN
228: ) RETURN OklBllngChrgHdrsTlRecType IS
229: CURSOR okl_bllng_chrg_hdrs_tl_pk_csr (p_id IN NUMBER,
230: p_language IN VARCHAR2) IS

Line 229: CURSOR okl_bllng_chrg_hdrs_tl_pk_csr (p_id IN NUMBER,

225: FUNCTION get_rec (
226: p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType,
227: x_no_data_found OUT NOCOPY BOOLEAN
228: ) RETURN OklBllngChrgHdrsTlRecType IS
229: CURSOR okl_bllng_chrg_hdrs_tl_pk_csr (p_id IN NUMBER,
230: p_language IN VARCHAR2) IS
231: SELECT
232: ID,
233: Okl_Bllng_Chrg_Hdrs_Tl.LANGUAGE,

Line 233: Okl_Bllng_Chrg_Hdrs_Tl.LANGUAGE,

229: CURSOR okl_bllng_chrg_hdrs_tl_pk_csr (p_id IN NUMBER,
230: p_language IN VARCHAR2) IS
231: SELECT
232: ID,
233: Okl_Bllng_Chrg_Hdrs_Tl.LANGUAGE,
234: SOURCE_LANG,
235: SFWT_FLAG,
236: NAME,
237: ORIGIN,

Line 244: FROM Okl_Bllng_Chrg_Hdrs_Tl

240: CREATION_DATE,
241: LAST_UPDATED_BY,
242: LAST_UPDATE_DATE,
243: LAST_UPDATE_LOGIN
244: FROM Okl_Bllng_Chrg_Hdrs_Tl
245: WHERE okl_bllng_chrg_hdrs_tl.id = p_id
246: AND okl_bllng_chrg_hdrs_tl.LANGUAGE = p_language;
247: l_okl_bllng_chrg_hdrs_tl_pk okl_bllng_chrg_hdrs_tl_pk_csr%ROWTYPE;
248: l_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType;

Line 245: WHERE okl_bllng_chrg_hdrs_tl.id = p_id

241: LAST_UPDATED_BY,
242: LAST_UPDATE_DATE,
243: LAST_UPDATE_LOGIN
244: FROM Okl_Bllng_Chrg_Hdrs_Tl
245: WHERE okl_bllng_chrg_hdrs_tl.id = p_id
246: AND okl_bllng_chrg_hdrs_tl.LANGUAGE = p_language;
247: l_okl_bllng_chrg_hdrs_tl_pk okl_bllng_chrg_hdrs_tl_pk_csr%ROWTYPE;
248: l_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType;
249: BEGIN

Line 246: AND okl_bllng_chrg_hdrs_tl.LANGUAGE = p_language;

242: LAST_UPDATE_DATE,
243: LAST_UPDATE_LOGIN
244: FROM Okl_Bllng_Chrg_Hdrs_Tl
245: WHERE okl_bllng_chrg_hdrs_tl.id = p_id
246: AND okl_bllng_chrg_hdrs_tl.LANGUAGE = p_language;
247: l_okl_bllng_chrg_hdrs_tl_pk okl_bllng_chrg_hdrs_tl_pk_csr%ROWTYPE;
248: l_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType;
249: BEGIN
250: x_no_data_found := TRUE;

Line 247: l_okl_bllng_chrg_hdrs_tl_pk okl_bllng_chrg_hdrs_tl_pk_csr%ROWTYPE;

243: LAST_UPDATE_LOGIN
244: FROM Okl_Bllng_Chrg_Hdrs_Tl
245: WHERE okl_bllng_chrg_hdrs_tl.id = p_id
246: AND okl_bllng_chrg_hdrs_tl.LANGUAGE = p_language;
247: l_okl_bllng_chrg_hdrs_tl_pk okl_bllng_chrg_hdrs_tl_pk_csr%ROWTYPE;
248: l_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType;
249: BEGIN
250: x_no_data_found := TRUE;
251: -- Get current database values

Line 248: l_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType;

244: FROM Okl_Bllng_Chrg_Hdrs_Tl
245: WHERE okl_bllng_chrg_hdrs_tl.id = p_id
246: AND okl_bllng_chrg_hdrs_tl.LANGUAGE = p_language;
247: l_okl_bllng_chrg_hdrs_tl_pk okl_bllng_chrg_hdrs_tl_pk_csr%ROWTYPE;
248: l_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType;
249: BEGIN
250: x_no_data_found := TRUE;
251: -- Get current database values
252: OPEN okl_bllng_chrg_hdrs_tl_pk_csr (p_okl_bllng_chrg_hdrs_tl_rec.id,

Line 252: OPEN okl_bllng_chrg_hdrs_tl_pk_csr (p_okl_bllng_chrg_hdrs_tl_rec.id,

248: l_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType;
249: BEGIN
250: x_no_data_found := TRUE;
251: -- Get current database values
252: OPEN okl_bllng_chrg_hdrs_tl_pk_csr (p_okl_bllng_chrg_hdrs_tl_rec.id,
253: p_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE);
254: FETCH okl_bllng_chrg_hdrs_tl_pk_csr INTO
255: l_okl_bllng_chrg_hdrs_tl_rec.ID,
256: l_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE,

Line 253: p_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE);

249: BEGIN
250: x_no_data_found := TRUE;
251: -- Get current database values
252: OPEN okl_bllng_chrg_hdrs_tl_pk_csr (p_okl_bllng_chrg_hdrs_tl_rec.id,
253: p_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE);
254: FETCH okl_bllng_chrg_hdrs_tl_pk_csr INTO
255: l_okl_bllng_chrg_hdrs_tl_rec.ID,
256: l_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE,
257: l_okl_bllng_chrg_hdrs_tl_rec.SOURCE_LANG,

Line 254: FETCH okl_bllng_chrg_hdrs_tl_pk_csr INTO

250: x_no_data_found := TRUE;
251: -- Get current database values
252: OPEN okl_bllng_chrg_hdrs_tl_pk_csr (p_okl_bllng_chrg_hdrs_tl_rec.id,
253: p_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE);
254: FETCH okl_bllng_chrg_hdrs_tl_pk_csr INTO
255: l_okl_bllng_chrg_hdrs_tl_rec.ID,
256: l_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE,
257: l_okl_bllng_chrg_hdrs_tl_rec.SOURCE_LANG,
258: l_okl_bllng_chrg_hdrs_tl_rec.SFWT_FLAG,

Line 255: l_okl_bllng_chrg_hdrs_tl_rec.ID,

251: -- Get current database values
252: OPEN okl_bllng_chrg_hdrs_tl_pk_csr (p_okl_bllng_chrg_hdrs_tl_rec.id,
253: p_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE);
254: FETCH okl_bllng_chrg_hdrs_tl_pk_csr INTO
255: l_okl_bllng_chrg_hdrs_tl_rec.ID,
256: l_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE,
257: l_okl_bllng_chrg_hdrs_tl_rec.SOURCE_LANG,
258: l_okl_bllng_chrg_hdrs_tl_rec.SFWT_FLAG,
259: l_okl_bllng_chrg_hdrs_tl_rec.NAME,

Line 256: l_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE,

252: OPEN okl_bllng_chrg_hdrs_tl_pk_csr (p_okl_bllng_chrg_hdrs_tl_rec.id,
253: p_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE);
254: FETCH okl_bllng_chrg_hdrs_tl_pk_csr INTO
255: l_okl_bllng_chrg_hdrs_tl_rec.ID,
256: l_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE,
257: l_okl_bllng_chrg_hdrs_tl_rec.SOURCE_LANG,
258: l_okl_bllng_chrg_hdrs_tl_rec.SFWT_FLAG,
259: l_okl_bllng_chrg_hdrs_tl_rec.NAME,
260: l_okl_bllng_chrg_hdrs_tl_rec.ORIGIN,

Line 257: l_okl_bllng_chrg_hdrs_tl_rec.SOURCE_LANG,

253: p_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE);
254: FETCH okl_bllng_chrg_hdrs_tl_pk_csr INTO
255: l_okl_bllng_chrg_hdrs_tl_rec.ID,
256: l_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE,
257: l_okl_bllng_chrg_hdrs_tl_rec.SOURCE_LANG,
258: l_okl_bllng_chrg_hdrs_tl_rec.SFWT_FLAG,
259: l_okl_bllng_chrg_hdrs_tl_rec.NAME,
260: l_okl_bllng_chrg_hdrs_tl_rec.ORIGIN,
261: l_okl_bllng_chrg_hdrs_tl_rec.DESTINATION,

Line 258: l_okl_bllng_chrg_hdrs_tl_rec.SFWT_FLAG,

254: FETCH okl_bllng_chrg_hdrs_tl_pk_csr INTO
255: l_okl_bllng_chrg_hdrs_tl_rec.ID,
256: l_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE,
257: l_okl_bllng_chrg_hdrs_tl_rec.SOURCE_LANG,
258: l_okl_bllng_chrg_hdrs_tl_rec.SFWT_FLAG,
259: l_okl_bllng_chrg_hdrs_tl_rec.NAME,
260: l_okl_bllng_chrg_hdrs_tl_rec.ORIGIN,
261: l_okl_bllng_chrg_hdrs_tl_rec.DESTINATION,
262: l_okl_bllng_chrg_hdrs_tl_rec.CREATED_BY,

Line 259: l_okl_bllng_chrg_hdrs_tl_rec.NAME,

255: l_okl_bllng_chrg_hdrs_tl_rec.ID,
256: l_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE,
257: l_okl_bllng_chrg_hdrs_tl_rec.SOURCE_LANG,
258: l_okl_bllng_chrg_hdrs_tl_rec.SFWT_FLAG,
259: l_okl_bllng_chrg_hdrs_tl_rec.NAME,
260: l_okl_bllng_chrg_hdrs_tl_rec.ORIGIN,
261: l_okl_bllng_chrg_hdrs_tl_rec.DESTINATION,
262: l_okl_bllng_chrg_hdrs_tl_rec.CREATED_BY,
263: l_okl_bllng_chrg_hdrs_tl_rec.CREATION_DATE,

Line 260: l_okl_bllng_chrg_hdrs_tl_rec.ORIGIN,

256: l_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE,
257: l_okl_bllng_chrg_hdrs_tl_rec.SOURCE_LANG,
258: l_okl_bllng_chrg_hdrs_tl_rec.SFWT_FLAG,
259: l_okl_bllng_chrg_hdrs_tl_rec.NAME,
260: l_okl_bllng_chrg_hdrs_tl_rec.ORIGIN,
261: l_okl_bllng_chrg_hdrs_tl_rec.DESTINATION,
262: l_okl_bllng_chrg_hdrs_tl_rec.CREATED_BY,
263: l_okl_bllng_chrg_hdrs_tl_rec.CREATION_DATE,
264: l_okl_bllng_chrg_hdrs_tl_rec.LAST_UPDATED_BY,

Line 261: l_okl_bllng_chrg_hdrs_tl_rec.DESTINATION,

257: l_okl_bllng_chrg_hdrs_tl_rec.SOURCE_LANG,
258: l_okl_bllng_chrg_hdrs_tl_rec.SFWT_FLAG,
259: l_okl_bllng_chrg_hdrs_tl_rec.NAME,
260: l_okl_bllng_chrg_hdrs_tl_rec.ORIGIN,
261: l_okl_bllng_chrg_hdrs_tl_rec.DESTINATION,
262: l_okl_bllng_chrg_hdrs_tl_rec.CREATED_BY,
263: l_okl_bllng_chrg_hdrs_tl_rec.CREATION_DATE,
264: l_okl_bllng_chrg_hdrs_tl_rec.LAST_UPDATED_BY,
265: l_okl_bllng_chrg_hdrs_tl_rec.LAST_UPDATE_DATE,

Line 262: l_okl_bllng_chrg_hdrs_tl_rec.CREATED_BY,

258: l_okl_bllng_chrg_hdrs_tl_rec.SFWT_FLAG,
259: l_okl_bllng_chrg_hdrs_tl_rec.NAME,
260: l_okl_bllng_chrg_hdrs_tl_rec.ORIGIN,
261: l_okl_bllng_chrg_hdrs_tl_rec.DESTINATION,
262: l_okl_bllng_chrg_hdrs_tl_rec.CREATED_BY,
263: l_okl_bllng_chrg_hdrs_tl_rec.CREATION_DATE,
264: l_okl_bllng_chrg_hdrs_tl_rec.LAST_UPDATED_BY,
265: l_okl_bllng_chrg_hdrs_tl_rec.LAST_UPDATE_DATE,
266: l_okl_bllng_chrg_hdrs_tl_rec.LAST_UPDATE_LOGIN;

Line 263: l_okl_bllng_chrg_hdrs_tl_rec.CREATION_DATE,

259: l_okl_bllng_chrg_hdrs_tl_rec.NAME,
260: l_okl_bllng_chrg_hdrs_tl_rec.ORIGIN,
261: l_okl_bllng_chrg_hdrs_tl_rec.DESTINATION,
262: l_okl_bllng_chrg_hdrs_tl_rec.CREATED_BY,
263: l_okl_bllng_chrg_hdrs_tl_rec.CREATION_DATE,
264: l_okl_bllng_chrg_hdrs_tl_rec.LAST_UPDATED_BY,
265: l_okl_bllng_chrg_hdrs_tl_rec.LAST_UPDATE_DATE,
266: l_okl_bllng_chrg_hdrs_tl_rec.LAST_UPDATE_LOGIN;
267: x_no_data_found := okl_bllng_chrg_hdrs_tl_pk_csr%NOTFOUND;

Line 264: l_okl_bllng_chrg_hdrs_tl_rec.LAST_UPDATED_BY,

260: l_okl_bllng_chrg_hdrs_tl_rec.ORIGIN,
261: l_okl_bllng_chrg_hdrs_tl_rec.DESTINATION,
262: l_okl_bllng_chrg_hdrs_tl_rec.CREATED_BY,
263: l_okl_bllng_chrg_hdrs_tl_rec.CREATION_DATE,
264: l_okl_bllng_chrg_hdrs_tl_rec.LAST_UPDATED_BY,
265: l_okl_bllng_chrg_hdrs_tl_rec.LAST_UPDATE_DATE,
266: l_okl_bllng_chrg_hdrs_tl_rec.LAST_UPDATE_LOGIN;
267: x_no_data_found := okl_bllng_chrg_hdrs_tl_pk_csr%NOTFOUND;
268: CLOSE okl_bllng_chrg_hdrs_tl_pk_csr;

Line 265: l_okl_bllng_chrg_hdrs_tl_rec.LAST_UPDATE_DATE,

261: l_okl_bllng_chrg_hdrs_tl_rec.DESTINATION,
262: l_okl_bllng_chrg_hdrs_tl_rec.CREATED_BY,
263: l_okl_bllng_chrg_hdrs_tl_rec.CREATION_DATE,
264: l_okl_bllng_chrg_hdrs_tl_rec.LAST_UPDATED_BY,
265: l_okl_bllng_chrg_hdrs_tl_rec.LAST_UPDATE_DATE,
266: l_okl_bllng_chrg_hdrs_tl_rec.LAST_UPDATE_LOGIN;
267: x_no_data_found := okl_bllng_chrg_hdrs_tl_pk_csr%NOTFOUND;
268: CLOSE okl_bllng_chrg_hdrs_tl_pk_csr;
269: RETURN(l_okl_bllng_chrg_hdrs_tl_rec);

Line 266: l_okl_bllng_chrg_hdrs_tl_rec.LAST_UPDATE_LOGIN;

262: l_okl_bllng_chrg_hdrs_tl_rec.CREATED_BY,
263: l_okl_bllng_chrg_hdrs_tl_rec.CREATION_DATE,
264: l_okl_bllng_chrg_hdrs_tl_rec.LAST_UPDATED_BY,
265: l_okl_bllng_chrg_hdrs_tl_rec.LAST_UPDATE_DATE,
266: l_okl_bllng_chrg_hdrs_tl_rec.LAST_UPDATE_LOGIN;
267: x_no_data_found := okl_bllng_chrg_hdrs_tl_pk_csr%NOTFOUND;
268: CLOSE okl_bllng_chrg_hdrs_tl_pk_csr;
269: RETURN(l_okl_bllng_chrg_hdrs_tl_rec);
270: END get_rec;

Line 267: x_no_data_found := okl_bllng_chrg_hdrs_tl_pk_csr%NOTFOUND;

263: l_okl_bllng_chrg_hdrs_tl_rec.CREATION_DATE,
264: l_okl_bllng_chrg_hdrs_tl_rec.LAST_UPDATED_BY,
265: l_okl_bllng_chrg_hdrs_tl_rec.LAST_UPDATE_DATE,
266: l_okl_bllng_chrg_hdrs_tl_rec.LAST_UPDATE_LOGIN;
267: x_no_data_found := okl_bllng_chrg_hdrs_tl_pk_csr%NOTFOUND;
268: CLOSE okl_bllng_chrg_hdrs_tl_pk_csr;
269: RETURN(l_okl_bllng_chrg_hdrs_tl_rec);
270: END get_rec;
271:

Line 268: CLOSE okl_bllng_chrg_hdrs_tl_pk_csr;

264: l_okl_bllng_chrg_hdrs_tl_rec.LAST_UPDATED_BY,
265: l_okl_bllng_chrg_hdrs_tl_rec.LAST_UPDATE_DATE,
266: l_okl_bllng_chrg_hdrs_tl_rec.LAST_UPDATE_LOGIN;
267: x_no_data_found := okl_bllng_chrg_hdrs_tl_pk_csr%NOTFOUND;
268: CLOSE okl_bllng_chrg_hdrs_tl_pk_csr;
269: RETURN(l_okl_bllng_chrg_hdrs_tl_rec);
270: END get_rec;
271:
272: FUNCTION get_rec (

Line 269: RETURN(l_okl_bllng_chrg_hdrs_tl_rec);

265: l_okl_bllng_chrg_hdrs_tl_rec.LAST_UPDATE_DATE,
266: l_okl_bllng_chrg_hdrs_tl_rec.LAST_UPDATE_LOGIN;
267: x_no_data_found := okl_bllng_chrg_hdrs_tl_pk_csr%NOTFOUND;
268: CLOSE okl_bllng_chrg_hdrs_tl_pk_csr;
269: RETURN(l_okl_bllng_chrg_hdrs_tl_rec);
270: END get_rec;
271:
272: FUNCTION get_rec (
273: p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType

Line 273: p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType

269: RETURN(l_okl_bllng_chrg_hdrs_tl_rec);
270: END get_rec;
271:
272: FUNCTION get_rec (
273: p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType
274: ) RETURN OklBllngChrgHdrsTlRecType IS
275: l_row_notfound BOOLEAN := TRUE;
276: BEGIN
277: RETURN(get_rec(p_okl_bllng_chrg_hdrs_tl_rec, l_row_notfound));

Line 277: RETURN(get_rec(p_okl_bllng_chrg_hdrs_tl_rec, l_row_notfound));

273: p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType
274: ) RETURN OklBllngChrgHdrsTlRecType IS
275: l_row_notfound BOOLEAN := TRUE;
276: BEGIN
277: RETURN(get_rec(p_okl_bllng_chrg_hdrs_tl_rec, l_row_notfound));
278: END get_rec;
279: ---------------------------------------------------------------------------
280: -- FUNCTION get_rec for: OKL_BLLNG_CHRG_HDRS_V
281: ---------------------------------------------------------------------------

Line 1142: l_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType;

1138: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1139: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1140: l_bghv_rec bghv_rec_type := p_bghv_rec;
1141: l_bgh_rec bgh_rec_type;
1142: l_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType;
1143: BEGIN
1144: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
1145: G_PKG_NAME,
1146: p_init_msg_list,

Line 1436: -- insert_row for:OKL_BLLNG_CHRG_HDRS_TL --

1432: '_PVT'
1433: );
1434: END insert_row;
1435: -------------------------------------------
1436: -- insert_row for:OKL_BLLNG_CHRG_HDRS_TL --
1437: -------------------------------------------
1438: PROCEDURE insert_row(
1439: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1440: x_return_status OUT NOCOPY VARCHAR2,

Line 1443: p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType,

1439: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1440: x_return_status OUT NOCOPY VARCHAR2,
1441: x_msg_count OUT NOCOPY NUMBER,
1442: x_msg_data OUT NOCOPY VARCHAR2,
1443: p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType,
1444: x_okl_bllng_chrg_hdrs_tl_rec OUT NOCOPY OklBllngChrgHdrsTlRecType) IS
1445:
1446: l_api_version CONSTANT NUMBER := 1;
1447: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1444: x_okl_bllng_chrg_hdrs_tl_rec OUT NOCOPY OklBllngChrgHdrsTlRecType) IS

1440: x_return_status OUT NOCOPY VARCHAR2,
1441: x_msg_count OUT NOCOPY NUMBER,
1442: x_msg_data OUT NOCOPY VARCHAR2,
1443: p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType,
1444: x_okl_bllng_chrg_hdrs_tl_rec OUT NOCOPY OklBllngChrgHdrsTlRecType) IS
1445:
1446: l_api_version CONSTANT NUMBER := 1;
1447: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1448: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 1449: l_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType := p_okl_bllng_chrg_hdrs_tl_rec;

1445:
1446: l_api_version CONSTANT NUMBER := 1;
1447: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1448: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1449: l_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType := p_okl_bllng_chrg_hdrs_tl_rec;
1450: ldefoklbllngchrghdrstlrec OklBllngChrgHdrsTlRecType;
1451: CURSOR get_languages IS
1452: SELECT *
1453: FROM FND_LANGUAGES

Line 1456: -- Set_Attributes for:OKL_BLLNG_CHRG_HDRS_TL --

1452: SELECT *
1453: FROM FND_LANGUAGES
1454: WHERE INSTALLED_FLAG IN ('I', 'B');
1455: -----------------------------------------------
1456: -- Set_Attributes for:OKL_BLLNG_CHRG_HDRS_TL --
1457: -----------------------------------------------
1458: FUNCTION Set_Attributes (
1459: p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType,
1460: x_okl_bllng_chrg_hdrs_tl_rec OUT NOCOPY OklBllngChrgHdrsTlRecType

Line 1459: p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType,

1455: -----------------------------------------------
1456: -- Set_Attributes for:OKL_BLLNG_CHRG_HDRS_TL --
1457: -----------------------------------------------
1458: FUNCTION Set_Attributes (
1459: p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType,
1460: x_okl_bllng_chrg_hdrs_tl_rec OUT NOCOPY OklBllngChrgHdrsTlRecType
1461: ) RETURN VARCHAR2 IS
1462: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1463: BEGIN

Line 1460: x_okl_bllng_chrg_hdrs_tl_rec OUT NOCOPY OklBllngChrgHdrsTlRecType

1456: -- Set_Attributes for:OKL_BLLNG_CHRG_HDRS_TL --
1457: -----------------------------------------------
1458: FUNCTION Set_Attributes (
1459: p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType,
1460: x_okl_bllng_chrg_hdrs_tl_rec OUT NOCOPY OklBllngChrgHdrsTlRecType
1461: ) RETURN VARCHAR2 IS
1462: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1463: BEGIN
1464: x_okl_bllng_chrg_hdrs_tl_rec := p_okl_bllng_chrg_hdrs_tl_rec;

Line 1464: x_okl_bllng_chrg_hdrs_tl_rec := p_okl_bllng_chrg_hdrs_tl_rec;

1460: x_okl_bllng_chrg_hdrs_tl_rec OUT NOCOPY OklBllngChrgHdrsTlRecType
1461: ) RETURN VARCHAR2 IS
1462: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1463: BEGIN
1464: x_okl_bllng_chrg_hdrs_tl_rec := p_okl_bllng_chrg_hdrs_tl_rec;
1465: x_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE := USERENV('LANG');
1466: x_okl_bllng_chrg_hdrs_tl_rec.SOURCE_LANG := USERENV('LANG');
1467: RETURN(l_return_status);
1468: END Set_Attributes;

Line 1465: x_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE := USERENV('LANG');

1461: ) RETURN VARCHAR2 IS
1462: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1463: BEGIN
1464: x_okl_bllng_chrg_hdrs_tl_rec := p_okl_bllng_chrg_hdrs_tl_rec;
1465: x_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE := USERENV('LANG');
1466: x_okl_bllng_chrg_hdrs_tl_rec.SOURCE_LANG := USERENV('LANG');
1467: RETURN(l_return_status);
1468: END Set_Attributes;
1469: BEGIN

Line 1466: x_okl_bllng_chrg_hdrs_tl_rec.SOURCE_LANG := USERENV('LANG');

1462: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1463: BEGIN
1464: x_okl_bllng_chrg_hdrs_tl_rec := p_okl_bllng_chrg_hdrs_tl_rec;
1465: x_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE := USERENV('LANG');
1466: x_okl_bllng_chrg_hdrs_tl_rec.SOURCE_LANG := USERENV('LANG');
1467: RETURN(l_return_status);
1468: END Set_Attributes;
1469: BEGIN
1470: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 1481: p_okl_bllng_chrg_hdrs_tl_rec, -- IN

1477: RAISE Okl_Api.G_EXCEPTION_ERROR;
1478: END IF;
1479: --- Setting item attributes
1480: l_return_status := Set_Attributes(
1481: p_okl_bllng_chrg_hdrs_tl_rec, -- IN
1482: l_okl_bllng_chrg_hdrs_tl_rec); -- OUT
1483: --- If any errors happen abort API
1484: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1485: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1482: l_okl_bllng_chrg_hdrs_tl_rec); -- OUT

1478: END IF;
1479: --- Setting item attributes
1480: l_return_status := Set_Attributes(
1481: p_okl_bllng_chrg_hdrs_tl_rec, -- IN
1482: l_okl_bllng_chrg_hdrs_tl_rec); -- OUT
1483: --- If any errors happen abort API
1484: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1485: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1486: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 1490: l_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE := l_lang_rec.language_code;

1486: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1487: RAISE Okl_Api.G_EXCEPTION_ERROR;
1488: END IF;
1489: FOR l_lang_rec IN get_languages LOOP
1490: l_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE := l_lang_rec.language_code;
1491: INSERT INTO OKL_BLLNG_CHRG_HDRS_TL(
1492: id,
1493: LANGUAGE,
1494: source_lang,

Line 1491: INSERT INTO OKL_BLLNG_CHRG_HDRS_TL(

1487: RAISE Okl_Api.G_EXCEPTION_ERROR;
1488: END IF;
1489: FOR l_lang_rec IN get_languages LOOP
1490: l_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE := l_lang_rec.language_code;
1491: INSERT INTO OKL_BLLNG_CHRG_HDRS_TL(
1492: id,
1493: LANGUAGE,
1494: source_lang,
1495: sfwt_flag,

Line 1505: l_okl_bllng_chrg_hdrs_tl_rec.id,

1501: last_updated_by,
1502: last_update_date,
1503: last_update_login)
1504: VALUES (
1505: l_okl_bllng_chrg_hdrs_tl_rec.id,
1506: l_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE,
1507: l_okl_bllng_chrg_hdrs_tl_rec.source_lang,
1508: l_okl_bllng_chrg_hdrs_tl_rec.sfwt_flag,
1509: l_okl_bllng_chrg_hdrs_tl_rec.name,

Line 1506: l_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE,

1502: last_update_date,
1503: last_update_login)
1504: VALUES (
1505: l_okl_bllng_chrg_hdrs_tl_rec.id,
1506: l_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE,
1507: l_okl_bllng_chrg_hdrs_tl_rec.source_lang,
1508: l_okl_bllng_chrg_hdrs_tl_rec.sfwt_flag,
1509: l_okl_bllng_chrg_hdrs_tl_rec.name,
1510: l_okl_bllng_chrg_hdrs_tl_rec.origin,

Line 1507: l_okl_bllng_chrg_hdrs_tl_rec.source_lang,

1503: last_update_login)
1504: VALUES (
1505: l_okl_bllng_chrg_hdrs_tl_rec.id,
1506: l_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE,
1507: l_okl_bllng_chrg_hdrs_tl_rec.source_lang,
1508: l_okl_bllng_chrg_hdrs_tl_rec.sfwt_flag,
1509: l_okl_bllng_chrg_hdrs_tl_rec.name,
1510: l_okl_bllng_chrg_hdrs_tl_rec.origin,
1511: l_okl_bllng_chrg_hdrs_tl_rec.destination,

Line 1508: l_okl_bllng_chrg_hdrs_tl_rec.sfwt_flag,

1504: VALUES (
1505: l_okl_bllng_chrg_hdrs_tl_rec.id,
1506: l_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE,
1507: l_okl_bllng_chrg_hdrs_tl_rec.source_lang,
1508: l_okl_bllng_chrg_hdrs_tl_rec.sfwt_flag,
1509: l_okl_bllng_chrg_hdrs_tl_rec.name,
1510: l_okl_bllng_chrg_hdrs_tl_rec.origin,
1511: l_okl_bllng_chrg_hdrs_tl_rec.destination,
1512: l_okl_bllng_chrg_hdrs_tl_rec.created_by,

Line 1509: l_okl_bllng_chrg_hdrs_tl_rec.name,

1505: l_okl_bllng_chrg_hdrs_tl_rec.id,
1506: l_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE,
1507: l_okl_bllng_chrg_hdrs_tl_rec.source_lang,
1508: l_okl_bllng_chrg_hdrs_tl_rec.sfwt_flag,
1509: l_okl_bllng_chrg_hdrs_tl_rec.name,
1510: l_okl_bllng_chrg_hdrs_tl_rec.origin,
1511: l_okl_bllng_chrg_hdrs_tl_rec.destination,
1512: l_okl_bllng_chrg_hdrs_tl_rec.created_by,
1513: l_okl_bllng_chrg_hdrs_tl_rec.creation_date,

Line 1510: l_okl_bllng_chrg_hdrs_tl_rec.origin,

1506: l_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE,
1507: l_okl_bllng_chrg_hdrs_tl_rec.source_lang,
1508: l_okl_bllng_chrg_hdrs_tl_rec.sfwt_flag,
1509: l_okl_bllng_chrg_hdrs_tl_rec.name,
1510: l_okl_bllng_chrg_hdrs_tl_rec.origin,
1511: l_okl_bllng_chrg_hdrs_tl_rec.destination,
1512: l_okl_bllng_chrg_hdrs_tl_rec.created_by,
1513: l_okl_bllng_chrg_hdrs_tl_rec.creation_date,
1514: l_okl_bllng_chrg_hdrs_tl_rec.last_updated_by,

Line 1511: l_okl_bllng_chrg_hdrs_tl_rec.destination,

1507: l_okl_bllng_chrg_hdrs_tl_rec.source_lang,
1508: l_okl_bllng_chrg_hdrs_tl_rec.sfwt_flag,
1509: l_okl_bllng_chrg_hdrs_tl_rec.name,
1510: l_okl_bllng_chrg_hdrs_tl_rec.origin,
1511: l_okl_bllng_chrg_hdrs_tl_rec.destination,
1512: l_okl_bllng_chrg_hdrs_tl_rec.created_by,
1513: l_okl_bllng_chrg_hdrs_tl_rec.creation_date,
1514: l_okl_bllng_chrg_hdrs_tl_rec.last_updated_by,
1515: l_okl_bllng_chrg_hdrs_tl_rec.last_update_date,

Line 1512: l_okl_bllng_chrg_hdrs_tl_rec.created_by,

1508: l_okl_bllng_chrg_hdrs_tl_rec.sfwt_flag,
1509: l_okl_bllng_chrg_hdrs_tl_rec.name,
1510: l_okl_bllng_chrg_hdrs_tl_rec.origin,
1511: l_okl_bllng_chrg_hdrs_tl_rec.destination,
1512: l_okl_bllng_chrg_hdrs_tl_rec.created_by,
1513: l_okl_bllng_chrg_hdrs_tl_rec.creation_date,
1514: l_okl_bllng_chrg_hdrs_tl_rec.last_updated_by,
1515: l_okl_bllng_chrg_hdrs_tl_rec.last_update_date,
1516: l_okl_bllng_chrg_hdrs_tl_rec.last_update_login);

Line 1513: l_okl_bllng_chrg_hdrs_tl_rec.creation_date,

1509: l_okl_bllng_chrg_hdrs_tl_rec.name,
1510: l_okl_bllng_chrg_hdrs_tl_rec.origin,
1511: l_okl_bllng_chrg_hdrs_tl_rec.destination,
1512: l_okl_bllng_chrg_hdrs_tl_rec.created_by,
1513: l_okl_bllng_chrg_hdrs_tl_rec.creation_date,
1514: l_okl_bllng_chrg_hdrs_tl_rec.last_updated_by,
1515: l_okl_bllng_chrg_hdrs_tl_rec.last_update_date,
1516: l_okl_bllng_chrg_hdrs_tl_rec.last_update_login);
1517: END LOOP;

Line 1514: l_okl_bllng_chrg_hdrs_tl_rec.last_updated_by,

1510: l_okl_bllng_chrg_hdrs_tl_rec.origin,
1511: l_okl_bllng_chrg_hdrs_tl_rec.destination,
1512: l_okl_bllng_chrg_hdrs_tl_rec.created_by,
1513: l_okl_bllng_chrg_hdrs_tl_rec.creation_date,
1514: l_okl_bllng_chrg_hdrs_tl_rec.last_updated_by,
1515: l_okl_bllng_chrg_hdrs_tl_rec.last_update_date,
1516: l_okl_bllng_chrg_hdrs_tl_rec.last_update_login);
1517: END LOOP;
1518: -- Set OUT values

Line 1515: l_okl_bllng_chrg_hdrs_tl_rec.last_update_date,

1511: l_okl_bllng_chrg_hdrs_tl_rec.destination,
1512: l_okl_bllng_chrg_hdrs_tl_rec.created_by,
1513: l_okl_bllng_chrg_hdrs_tl_rec.creation_date,
1514: l_okl_bllng_chrg_hdrs_tl_rec.last_updated_by,
1515: l_okl_bllng_chrg_hdrs_tl_rec.last_update_date,
1516: l_okl_bllng_chrg_hdrs_tl_rec.last_update_login);
1517: END LOOP;
1518: -- Set OUT values
1519: x_okl_bllng_chrg_hdrs_tl_rec := l_okl_bllng_chrg_hdrs_tl_rec;

Line 1516: l_okl_bllng_chrg_hdrs_tl_rec.last_update_login);

1512: l_okl_bllng_chrg_hdrs_tl_rec.created_by,
1513: l_okl_bllng_chrg_hdrs_tl_rec.creation_date,
1514: l_okl_bllng_chrg_hdrs_tl_rec.last_updated_by,
1515: l_okl_bllng_chrg_hdrs_tl_rec.last_update_date,
1516: l_okl_bllng_chrg_hdrs_tl_rec.last_update_login);
1517: END LOOP;
1518: -- Set OUT values
1519: x_okl_bllng_chrg_hdrs_tl_rec := l_okl_bllng_chrg_hdrs_tl_rec;
1520: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1519: x_okl_bllng_chrg_hdrs_tl_rec := l_okl_bllng_chrg_hdrs_tl_rec;

1515: l_okl_bllng_chrg_hdrs_tl_rec.last_update_date,
1516: l_okl_bllng_chrg_hdrs_tl_rec.last_update_login);
1517: END LOOP;
1518: -- Set OUT values
1519: x_okl_bllng_chrg_hdrs_tl_rec := l_okl_bllng_chrg_hdrs_tl_rec;
1520: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1521: EXCEPTION
1522: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1523: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

Line 1572: l_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType;

1568: l_bghv_rec bghv_rec_type;
1569: l_def_bghv_rec bghv_rec_type;
1570: l_bgh_rec bgh_rec_type;
1571: lx_bgh_rec bgh_rec_type;
1572: l_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType;
1573: lx_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType;
1574: -------------------------------
1575: -- FUNCTION fill_who_columns --
1576: -------------------------------

Line 1573: lx_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType;

1569: l_def_bghv_rec bghv_rec_type;
1570: l_bgh_rec bgh_rec_type;
1571: lx_bgh_rec bgh_rec_type;
1572: l_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType;
1573: lx_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType;
1574: -------------------------------
1575: -- FUNCTION fill_who_columns --
1576: -------------------------------
1577: FUNCTION fill_who_columns (

Line 1661: migrate(l_def_bghv_rec, l_okl_bllng_chrg_hdrs_tl_rec);

1657: --------------------------------------
1658: -- Move VIEW record to "Child" records
1659: --------------------------------------
1660: migrate(l_def_bghv_rec, l_bgh_rec);
1661: migrate(l_def_bghv_rec, l_okl_bllng_chrg_hdrs_tl_rec);
1662: --------------------------------------------
1663: -- Call the INSERT_ROW for each child record
1664: --------------------------------------------
1665: insert_row(

Line 1684: l_okl_bllng_chrg_hdrs_tl_rec,

1680: p_init_msg_list,
1681: x_return_status,
1682: x_msg_count,
1683: x_msg_data,
1684: l_okl_bllng_chrg_hdrs_tl_rec,
1685: lx_okl_bllng_chrg_hdrs_tl_rec
1686: );
1687: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1688: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1685: lx_okl_bllng_chrg_hdrs_tl_rec

1681: x_return_status,
1682: x_msg_count,
1683: x_msg_data,
1684: l_okl_bllng_chrg_hdrs_tl_rec,
1685: lx_okl_bllng_chrg_hdrs_tl_rec
1686: );
1687: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1688: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1689: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 1692: migrate(lx_okl_bllng_chrg_hdrs_tl_rec, l_def_bghv_rec);

1688: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1689: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1690: RAISE Okl_Api.G_EXCEPTION_ERROR;
1691: END IF;
1692: migrate(lx_okl_bllng_chrg_hdrs_tl_rec, l_def_bghv_rec);
1693: -- Set OUT values
1694: x_bghv_rec := l_def_bghv_rec;
1695: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1696: EXCEPTION

Line 1922: -- lock_row for:OKL_BLLNG_CHRG_HDRS_TL --

1918: '_PVT'
1919: );
1920: END lock_row;
1921: -----------------------------------------
1922: -- lock_row for:OKL_BLLNG_CHRG_HDRS_TL --
1923: -----------------------------------------
1924: PROCEDURE lock_row(
1925: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1926: x_return_status OUT NOCOPY VARCHAR2,

Line 1929: p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType) IS

1925: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1926: x_return_status OUT NOCOPY VARCHAR2,
1927: x_msg_count OUT NOCOPY NUMBER,
1928: x_msg_data OUT NOCOPY VARCHAR2,
1929: p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType) IS
1930:
1931: E_Resource_Busy EXCEPTION;
1932: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1933: CURSOR lock_csr (p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType) IS

Line 1933: CURSOR lock_csr (p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType) IS

1929: p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType) IS
1930:
1931: E_Resource_Busy EXCEPTION;
1932: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1933: CURSOR lock_csr (p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType) IS
1934: SELECT *
1935: FROM OKL_BLLNG_CHRG_HDRS_TL
1936: WHERE ID = p_okl_bllng_chrg_hdrs_tl_rec.id
1937: FOR UPDATE NOWAIT;

Line 1935: FROM OKL_BLLNG_CHRG_HDRS_TL

1931: E_Resource_Busy EXCEPTION;
1932: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1933: CURSOR lock_csr (p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType) IS
1934: SELECT *
1935: FROM OKL_BLLNG_CHRG_HDRS_TL
1936: WHERE ID = p_okl_bllng_chrg_hdrs_tl_rec.id
1937: FOR UPDATE NOWAIT;
1938:
1939: l_api_version CONSTANT NUMBER := 1;

Line 1936: WHERE ID = p_okl_bllng_chrg_hdrs_tl_rec.id

1932: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1933: CURSOR lock_csr (p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType) IS
1934: SELECT *
1935: FROM OKL_BLLNG_CHRG_HDRS_TL
1936: WHERE ID = p_okl_bllng_chrg_hdrs_tl_rec.id
1937: FOR UPDATE NOWAIT;
1938:
1939: l_api_version CONSTANT NUMBER := 1;
1940: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 1956: OPEN lock_csr(p_okl_bllng_chrg_hdrs_tl_rec);

1952: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1953: RAISE Okl_Api.G_EXCEPTION_ERROR;
1954: END IF;
1955: BEGIN
1956: OPEN lock_csr(p_okl_bllng_chrg_hdrs_tl_rec);
1957: FETCH lock_csr INTO l_lock_var;
1958: l_row_notfound := lock_csr%NOTFOUND;
1959: CLOSE lock_csr;
1960: EXCEPTION

Line 2021: l_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType;

2017: l_api_version CONSTANT NUMBER := 1;
2018: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2019: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2020: l_bgh_rec bgh_rec_type;
2021: l_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType;
2022: BEGIN
2023: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
2024: G_PKG_NAME,
2025: p_init_msg_list,

Line 2039: migrate(p_bghv_rec, l_okl_bllng_chrg_hdrs_tl_rec);

2035: --------------------------------------
2036: -- Move VIEW record to "Child" records
2037: --------------------------------------
2038: migrate(p_bghv_rec, l_bgh_rec);
2039: migrate(p_bghv_rec, l_okl_bllng_chrg_hdrs_tl_rec);
2040: --------------------------------------------
2041: -- Call the LOCK_ROW for each child record
2042: --------------------------------------------
2043: lock_row(

Line 2060: l_okl_bllng_chrg_hdrs_tl_rec

2056: p_init_msg_list,
2057: x_return_status,
2058: x_msg_count,
2059: x_msg_data,
2060: l_okl_bllng_chrg_hdrs_tl_rec
2061: );
2062: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2063: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2064: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 2451: -- update_row for:OKL_BLLNG_CHRG_HDRS_TL --

2447: '_PVT'
2448: );
2449: END update_row;
2450: -------------------------------------------
2451: -- update_row for:OKL_BLLNG_CHRG_HDRS_TL --
2452: -------------------------------------------
2453: PROCEDURE update_row(
2454: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2455: x_return_status OUT NOCOPY VARCHAR2,

Line 2458: p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType,

2454: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2455: x_return_status OUT NOCOPY VARCHAR2,
2456: x_msg_count OUT NOCOPY NUMBER,
2457: x_msg_data OUT NOCOPY VARCHAR2,
2458: p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType,
2459: x_okl_bllng_chrg_hdrs_tl_rec OUT NOCOPY OklBllngChrgHdrsTlRecType) IS
2460:
2461: l_api_version CONSTANT NUMBER := 1;
2462: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2459: x_okl_bllng_chrg_hdrs_tl_rec OUT NOCOPY OklBllngChrgHdrsTlRecType) IS

2455: x_return_status OUT NOCOPY VARCHAR2,
2456: x_msg_count OUT NOCOPY NUMBER,
2457: x_msg_data OUT NOCOPY VARCHAR2,
2458: p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType,
2459: x_okl_bllng_chrg_hdrs_tl_rec OUT NOCOPY OklBllngChrgHdrsTlRecType) IS
2460:
2461: l_api_version CONSTANT NUMBER := 1;
2462: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2463: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 2464: l_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType := p_okl_bllng_chrg_hdrs_tl_rec;

2460:
2461: l_api_version CONSTANT NUMBER := 1;
2462: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2463: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2464: l_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType := p_okl_bllng_chrg_hdrs_tl_rec;
2465: ldefoklbllngchrghdrstlrec OklBllngChrgHdrsTlRecType;
2466: l_row_notfound BOOLEAN := TRUE;
2467: ----------------------------------
2468: -- FUNCTION populate_new_record --

Line 2471: p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType,

2467: ----------------------------------
2468: -- FUNCTION populate_new_record --
2469: ----------------------------------
2470: FUNCTION populate_new_record (
2471: p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType,
2472: x_okl_bllng_chrg_hdrs_tl_rec OUT NOCOPY OklBllngChrgHdrsTlRecType
2473: ) RETURN VARCHAR2 IS
2474: l_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType;
2475: l_row_notfound BOOLEAN := TRUE;

Line 2472: x_okl_bllng_chrg_hdrs_tl_rec OUT NOCOPY OklBllngChrgHdrsTlRecType

2468: -- FUNCTION populate_new_record --
2469: ----------------------------------
2470: FUNCTION populate_new_record (
2471: p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType,
2472: x_okl_bllng_chrg_hdrs_tl_rec OUT NOCOPY OklBllngChrgHdrsTlRecType
2473: ) RETURN VARCHAR2 IS
2474: l_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType;
2475: l_row_notfound BOOLEAN := TRUE;
2476: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 2474: l_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType;

2470: FUNCTION populate_new_record (
2471: p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType,
2472: x_okl_bllng_chrg_hdrs_tl_rec OUT NOCOPY OklBllngChrgHdrsTlRecType
2473: ) RETURN VARCHAR2 IS
2474: l_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType;
2475: l_row_notfound BOOLEAN := TRUE;
2476: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2477: BEGIN
2478: x_okl_bllng_chrg_hdrs_tl_rec := p_okl_bllng_chrg_hdrs_tl_rec;

Line 2478: x_okl_bllng_chrg_hdrs_tl_rec := p_okl_bllng_chrg_hdrs_tl_rec;

2474: l_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType;
2475: l_row_notfound BOOLEAN := TRUE;
2476: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2477: BEGIN
2478: x_okl_bllng_chrg_hdrs_tl_rec := p_okl_bllng_chrg_hdrs_tl_rec;
2479: -- Get current database values
2480: l_okl_bllng_chrg_hdrs_tl_rec := get_rec(p_okl_bllng_chrg_hdrs_tl_rec, l_row_notfound);
2481: IF (l_row_notfound) THEN
2482: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 2480: l_okl_bllng_chrg_hdrs_tl_rec := get_rec(p_okl_bllng_chrg_hdrs_tl_rec, l_row_notfound);

2476: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2477: BEGIN
2478: x_okl_bllng_chrg_hdrs_tl_rec := p_okl_bllng_chrg_hdrs_tl_rec;
2479: -- Get current database values
2480: l_okl_bllng_chrg_hdrs_tl_rec := get_rec(p_okl_bllng_chrg_hdrs_tl_rec, l_row_notfound);
2481: IF (l_row_notfound) THEN
2482: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2483: END IF;
2484: IF (x_okl_bllng_chrg_hdrs_tl_rec.id = Okl_Api.G_MISS_NUM)

Line 2484: IF (x_okl_bllng_chrg_hdrs_tl_rec.id = Okl_Api.G_MISS_NUM)

2480: l_okl_bllng_chrg_hdrs_tl_rec := get_rec(p_okl_bllng_chrg_hdrs_tl_rec, l_row_notfound);
2481: IF (l_row_notfound) THEN
2482: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2483: END IF;
2484: IF (x_okl_bllng_chrg_hdrs_tl_rec.id = Okl_Api.G_MISS_NUM)
2485: THEN
2486: x_okl_bllng_chrg_hdrs_tl_rec.id := l_okl_bllng_chrg_hdrs_tl_rec.id;
2487: END IF;
2488: IF (x_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)

Line 2486: x_okl_bllng_chrg_hdrs_tl_rec.id := l_okl_bllng_chrg_hdrs_tl_rec.id;

2482: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2483: END IF;
2484: IF (x_okl_bllng_chrg_hdrs_tl_rec.id = Okl_Api.G_MISS_NUM)
2485: THEN
2486: x_okl_bllng_chrg_hdrs_tl_rec.id := l_okl_bllng_chrg_hdrs_tl_rec.id;
2487: END IF;
2488: IF (x_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)
2489: THEN
2490: x_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE := l_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE;

Line 2488: IF (x_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)

2484: IF (x_okl_bllng_chrg_hdrs_tl_rec.id = Okl_Api.G_MISS_NUM)
2485: THEN
2486: x_okl_bllng_chrg_hdrs_tl_rec.id := l_okl_bllng_chrg_hdrs_tl_rec.id;
2487: END IF;
2488: IF (x_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)
2489: THEN
2490: x_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE := l_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE;
2491: END IF;
2492: IF (x_okl_bllng_chrg_hdrs_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)

Line 2490: x_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE := l_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE;

2486: x_okl_bllng_chrg_hdrs_tl_rec.id := l_okl_bllng_chrg_hdrs_tl_rec.id;
2487: END IF;
2488: IF (x_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)
2489: THEN
2490: x_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE := l_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE;
2491: END IF;
2492: IF (x_okl_bllng_chrg_hdrs_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)
2493: THEN
2494: x_okl_bllng_chrg_hdrs_tl_rec.source_lang := l_okl_bllng_chrg_hdrs_tl_rec.source_lang;

Line 2492: IF (x_okl_bllng_chrg_hdrs_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)

2488: IF (x_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)
2489: THEN
2490: x_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE := l_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE;
2491: END IF;
2492: IF (x_okl_bllng_chrg_hdrs_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)
2493: THEN
2494: x_okl_bllng_chrg_hdrs_tl_rec.source_lang := l_okl_bllng_chrg_hdrs_tl_rec.source_lang;
2495: END IF;
2496: IF (x_okl_bllng_chrg_hdrs_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)

Line 2494: x_okl_bllng_chrg_hdrs_tl_rec.source_lang := l_okl_bllng_chrg_hdrs_tl_rec.source_lang;

2490: x_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE := l_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE;
2491: END IF;
2492: IF (x_okl_bllng_chrg_hdrs_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)
2493: THEN
2494: x_okl_bllng_chrg_hdrs_tl_rec.source_lang := l_okl_bllng_chrg_hdrs_tl_rec.source_lang;
2495: END IF;
2496: IF (x_okl_bllng_chrg_hdrs_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)
2497: THEN
2498: x_okl_bllng_chrg_hdrs_tl_rec.sfwt_flag := l_okl_bllng_chrg_hdrs_tl_rec.sfwt_flag;

Line 2496: IF (x_okl_bllng_chrg_hdrs_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)

2492: IF (x_okl_bllng_chrg_hdrs_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)
2493: THEN
2494: x_okl_bllng_chrg_hdrs_tl_rec.source_lang := l_okl_bllng_chrg_hdrs_tl_rec.source_lang;
2495: END IF;
2496: IF (x_okl_bllng_chrg_hdrs_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)
2497: THEN
2498: x_okl_bllng_chrg_hdrs_tl_rec.sfwt_flag := l_okl_bllng_chrg_hdrs_tl_rec.sfwt_flag;
2499: END IF;
2500: IF (x_okl_bllng_chrg_hdrs_tl_rec.name = Okl_Api.G_MISS_CHAR)

Line 2498: x_okl_bllng_chrg_hdrs_tl_rec.sfwt_flag := l_okl_bllng_chrg_hdrs_tl_rec.sfwt_flag;

2494: x_okl_bllng_chrg_hdrs_tl_rec.source_lang := l_okl_bllng_chrg_hdrs_tl_rec.source_lang;
2495: END IF;
2496: IF (x_okl_bllng_chrg_hdrs_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)
2497: THEN
2498: x_okl_bllng_chrg_hdrs_tl_rec.sfwt_flag := l_okl_bllng_chrg_hdrs_tl_rec.sfwt_flag;
2499: END IF;
2500: IF (x_okl_bllng_chrg_hdrs_tl_rec.name = Okl_Api.G_MISS_CHAR)
2501: THEN
2502: x_okl_bllng_chrg_hdrs_tl_rec.name := l_okl_bllng_chrg_hdrs_tl_rec.name;

Line 2500: IF (x_okl_bllng_chrg_hdrs_tl_rec.name = Okl_Api.G_MISS_CHAR)

2496: IF (x_okl_bllng_chrg_hdrs_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)
2497: THEN
2498: x_okl_bllng_chrg_hdrs_tl_rec.sfwt_flag := l_okl_bllng_chrg_hdrs_tl_rec.sfwt_flag;
2499: END IF;
2500: IF (x_okl_bllng_chrg_hdrs_tl_rec.name = Okl_Api.G_MISS_CHAR)
2501: THEN
2502: x_okl_bllng_chrg_hdrs_tl_rec.name := l_okl_bllng_chrg_hdrs_tl_rec.name;
2503: END IF;
2504: IF (x_okl_bllng_chrg_hdrs_tl_rec.origin = Okl_Api.G_MISS_CHAR)

Line 2502: x_okl_bllng_chrg_hdrs_tl_rec.name := l_okl_bllng_chrg_hdrs_tl_rec.name;

2498: x_okl_bllng_chrg_hdrs_tl_rec.sfwt_flag := l_okl_bllng_chrg_hdrs_tl_rec.sfwt_flag;
2499: END IF;
2500: IF (x_okl_bllng_chrg_hdrs_tl_rec.name = Okl_Api.G_MISS_CHAR)
2501: THEN
2502: x_okl_bllng_chrg_hdrs_tl_rec.name := l_okl_bllng_chrg_hdrs_tl_rec.name;
2503: END IF;
2504: IF (x_okl_bllng_chrg_hdrs_tl_rec.origin = Okl_Api.G_MISS_CHAR)
2505: THEN
2506: x_okl_bllng_chrg_hdrs_tl_rec.origin := l_okl_bllng_chrg_hdrs_tl_rec.origin;

Line 2504: IF (x_okl_bllng_chrg_hdrs_tl_rec.origin = Okl_Api.G_MISS_CHAR)

2500: IF (x_okl_bllng_chrg_hdrs_tl_rec.name = Okl_Api.G_MISS_CHAR)
2501: THEN
2502: x_okl_bllng_chrg_hdrs_tl_rec.name := l_okl_bllng_chrg_hdrs_tl_rec.name;
2503: END IF;
2504: IF (x_okl_bllng_chrg_hdrs_tl_rec.origin = Okl_Api.G_MISS_CHAR)
2505: THEN
2506: x_okl_bllng_chrg_hdrs_tl_rec.origin := l_okl_bllng_chrg_hdrs_tl_rec.origin;
2507: END IF;
2508: IF (x_okl_bllng_chrg_hdrs_tl_rec.destination = Okl_Api.G_MISS_CHAR)

Line 2506: x_okl_bllng_chrg_hdrs_tl_rec.origin := l_okl_bllng_chrg_hdrs_tl_rec.origin;

2502: x_okl_bllng_chrg_hdrs_tl_rec.name := l_okl_bllng_chrg_hdrs_tl_rec.name;
2503: END IF;
2504: IF (x_okl_bllng_chrg_hdrs_tl_rec.origin = Okl_Api.G_MISS_CHAR)
2505: THEN
2506: x_okl_bllng_chrg_hdrs_tl_rec.origin := l_okl_bllng_chrg_hdrs_tl_rec.origin;
2507: END IF;
2508: IF (x_okl_bllng_chrg_hdrs_tl_rec.destination = Okl_Api.G_MISS_CHAR)
2509: THEN
2510: x_okl_bllng_chrg_hdrs_tl_rec.destination := l_okl_bllng_chrg_hdrs_tl_rec.destination;

Line 2508: IF (x_okl_bllng_chrg_hdrs_tl_rec.destination = Okl_Api.G_MISS_CHAR)

2504: IF (x_okl_bllng_chrg_hdrs_tl_rec.origin = Okl_Api.G_MISS_CHAR)
2505: THEN
2506: x_okl_bllng_chrg_hdrs_tl_rec.origin := l_okl_bllng_chrg_hdrs_tl_rec.origin;
2507: END IF;
2508: IF (x_okl_bllng_chrg_hdrs_tl_rec.destination = Okl_Api.G_MISS_CHAR)
2509: THEN
2510: x_okl_bllng_chrg_hdrs_tl_rec.destination := l_okl_bllng_chrg_hdrs_tl_rec.destination;
2511: END IF;
2512: IF (x_okl_bllng_chrg_hdrs_tl_rec.created_by = Okl_Api.G_MISS_NUM)

Line 2510: x_okl_bllng_chrg_hdrs_tl_rec.destination := l_okl_bllng_chrg_hdrs_tl_rec.destination;

2506: x_okl_bllng_chrg_hdrs_tl_rec.origin := l_okl_bllng_chrg_hdrs_tl_rec.origin;
2507: END IF;
2508: IF (x_okl_bllng_chrg_hdrs_tl_rec.destination = Okl_Api.G_MISS_CHAR)
2509: THEN
2510: x_okl_bllng_chrg_hdrs_tl_rec.destination := l_okl_bllng_chrg_hdrs_tl_rec.destination;
2511: END IF;
2512: IF (x_okl_bllng_chrg_hdrs_tl_rec.created_by = Okl_Api.G_MISS_NUM)
2513: THEN
2514: x_okl_bllng_chrg_hdrs_tl_rec.created_by := l_okl_bllng_chrg_hdrs_tl_rec.created_by;

Line 2512: IF (x_okl_bllng_chrg_hdrs_tl_rec.created_by = Okl_Api.G_MISS_NUM)

2508: IF (x_okl_bllng_chrg_hdrs_tl_rec.destination = Okl_Api.G_MISS_CHAR)
2509: THEN
2510: x_okl_bllng_chrg_hdrs_tl_rec.destination := l_okl_bllng_chrg_hdrs_tl_rec.destination;
2511: END IF;
2512: IF (x_okl_bllng_chrg_hdrs_tl_rec.created_by = Okl_Api.G_MISS_NUM)
2513: THEN
2514: x_okl_bllng_chrg_hdrs_tl_rec.created_by := l_okl_bllng_chrg_hdrs_tl_rec.created_by;
2515: END IF;
2516: IF (x_okl_bllng_chrg_hdrs_tl_rec.creation_date = Okl_Api.G_MISS_DATE)

Line 2514: x_okl_bllng_chrg_hdrs_tl_rec.created_by := l_okl_bllng_chrg_hdrs_tl_rec.created_by;

2510: x_okl_bllng_chrg_hdrs_tl_rec.destination := l_okl_bllng_chrg_hdrs_tl_rec.destination;
2511: END IF;
2512: IF (x_okl_bllng_chrg_hdrs_tl_rec.created_by = Okl_Api.G_MISS_NUM)
2513: THEN
2514: x_okl_bllng_chrg_hdrs_tl_rec.created_by := l_okl_bllng_chrg_hdrs_tl_rec.created_by;
2515: END IF;
2516: IF (x_okl_bllng_chrg_hdrs_tl_rec.creation_date = Okl_Api.G_MISS_DATE)
2517: THEN
2518: x_okl_bllng_chrg_hdrs_tl_rec.creation_date := l_okl_bllng_chrg_hdrs_tl_rec.creation_date;

Line 2516: IF (x_okl_bllng_chrg_hdrs_tl_rec.creation_date = Okl_Api.G_MISS_DATE)

2512: IF (x_okl_bllng_chrg_hdrs_tl_rec.created_by = Okl_Api.G_MISS_NUM)
2513: THEN
2514: x_okl_bllng_chrg_hdrs_tl_rec.created_by := l_okl_bllng_chrg_hdrs_tl_rec.created_by;
2515: END IF;
2516: IF (x_okl_bllng_chrg_hdrs_tl_rec.creation_date = Okl_Api.G_MISS_DATE)
2517: THEN
2518: x_okl_bllng_chrg_hdrs_tl_rec.creation_date := l_okl_bllng_chrg_hdrs_tl_rec.creation_date;
2519: END IF;
2520: IF (x_okl_bllng_chrg_hdrs_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)

Line 2518: x_okl_bllng_chrg_hdrs_tl_rec.creation_date := l_okl_bllng_chrg_hdrs_tl_rec.creation_date;

2514: x_okl_bllng_chrg_hdrs_tl_rec.created_by := l_okl_bllng_chrg_hdrs_tl_rec.created_by;
2515: END IF;
2516: IF (x_okl_bllng_chrg_hdrs_tl_rec.creation_date = Okl_Api.G_MISS_DATE)
2517: THEN
2518: x_okl_bllng_chrg_hdrs_tl_rec.creation_date := l_okl_bllng_chrg_hdrs_tl_rec.creation_date;
2519: END IF;
2520: IF (x_okl_bllng_chrg_hdrs_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)
2521: THEN
2522: x_okl_bllng_chrg_hdrs_tl_rec.last_updated_by := l_okl_bllng_chrg_hdrs_tl_rec.last_updated_by;

Line 2520: IF (x_okl_bllng_chrg_hdrs_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)

2516: IF (x_okl_bllng_chrg_hdrs_tl_rec.creation_date = Okl_Api.G_MISS_DATE)
2517: THEN
2518: x_okl_bllng_chrg_hdrs_tl_rec.creation_date := l_okl_bllng_chrg_hdrs_tl_rec.creation_date;
2519: END IF;
2520: IF (x_okl_bllng_chrg_hdrs_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)
2521: THEN
2522: x_okl_bllng_chrg_hdrs_tl_rec.last_updated_by := l_okl_bllng_chrg_hdrs_tl_rec.last_updated_by;
2523: END IF;
2524: IF (x_okl_bllng_chrg_hdrs_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)

Line 2522: x_okl_bllng_chrg_hdrs_tl_rec.last_updated_by := l_okl_bllng_chrg_hdrs_tl_rec.last_updated_by;

2518: x_okl_bllng_chrg_hdrs_tl_rec.creation_date := l_okl_bllng_chrg_hdrs_tl_rec.creation_date;
2519: END IF;
2520: IF (x_okl_bllng_chrg_hdrs_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)
2521: THEN
2522: x_okl_bllng_chrg_hdrs_tl_rec.last_updated_by := l_okl_bllng_chrg_hdrs_tl_rec.last_updated_by;
2523: END IF;
2524: IF (x_okl_bllng_chrg_hdrs_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)
2525: THEN
2526: x_okl_bllng_chrg_hdrs_tl_rec.last_update_date := l_okl_bllng_chrg_hdrs_tl_rec.last_update_date;

Line 2524: IF (x_okl_bllng_chrg_hdrs_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)

2520: IF (x_okl_bllng_chrg_hdrs_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)
2521: THEN
2522: x_okl_bllng_chrg_hdrs_tl_rec.last_updated_by := l_okl_bllng_chrg_hdrs_tl_rec.last_updated_by;
2523: END IF;
2524: IF (x_okl_bllng_chrg_hdrs_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)
2525: THEN
2526: x_okl_bllng_chrg_hdrs_tl_rec.last_update_date := l_okl_bllng_chrg_hdrs_tl_rec.last_update_date;
2527: END IF;
2528: IF (x_okl_bllng_chrg_hdrs_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)

Line 2526: x_okl_bllng_chrg_hdrs_tl_rec.last_update_date := l_okl_bllng_chrg_hdrs_tl_rec.last_update_date;

2522: x_okl_bllng_chrg_hdrs_tl_rec.last_updated_by := l_okl_bllng_chrg_hdrs_tl_rec.last_updated_by;
2523: END IF;
2524: IF (x_okl_bllng_chrg_hdrs_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)
2525: THEN
2526: x_okl_bllng_chrg_hdrs_tl_rec.last_update_date := l_okl_bllng_chrg_hdrs_tl_rec.last_update_date;
2527: END IF;
2528: IF (x_okl_bllng_chrg_hdrs_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)
2529: THEN
2530: x_okl_bllng_chrg_hdrs_tl_rec.last_update_login := l_okl_bllng_chrg_hdrs_tl_rec.last_update_login;

Line 2528: IF (x_okl_bllng_chrg_hdrs_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)

2524: IF (x_okl_bllng_chrg_hdrs_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)
2525: THEN
2526: x_okl_bllng_chrg_hdrs_tl_rec.last_update_date := l_okl_bllng_chrg_hdrs_tl_rec.last_update_date;
2527: END IF;
2528: IF (x_okl_bllng_chrg_hdrs_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)
2529: THEN
2530: x_okl_bllng_chrg_hdrs_tl_rec.last_update_login := l_okl_bllng_chrg_hdrs_tl_rec.last_update_login;
2531: END IF;
2532: RETURN(l_return_status);

Line 2530: x_okl_bllng_chrg_hdrs_tl_rec.last_update_login := l_okl_bllng_chrg_hdrs_tl_rec.last_update_login;

2526: x_okl_bllng_chrg_hdrs_tl_rec.last_update_date := l_okl_bllng_chrg_hdrs_tl_rec.last_update_date;
2527: END IF;
2528: IF (x_okl_bllng_chrg_hdrs_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)
2529: THEN
2530: x_okl_bllng_chrg_hdrs_tl_rec.last_update_login := l_okl_bllng_chrg_hdrs_tl_rec.last_update_login;
2531: END IF;
2532: RETURN(l_return_status);
2533: END populate_new_record;
2534: -----------------------------------------------

Line 2535: -- Set_Attributes for:OKL_BLLNG_CHRG_HDRS_TL --

2531: END IF;
2532: RETURN(l_return_status);
2533: END populate_new_record;
2534: -----------------------------------------------
2535: -- Set_Attributes for:OKL_BLLNG_CHRG_HDRS_TL --
2536: -----------------------------------------------
2537: FUNCTION Set_Attributes (
2538: p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType,
2539: x_okl_bllng_chrg_hdrs_tl_rec OUT NOCOPY OklBllngChrgHdrsTlRecType

Line 2538: p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType,

2534: -----------------------------------------------
2535: -- Set_Attributes for:OKL_BLLNG_CHRG_HDRS_TL --
2536: -----------------------------------------------
2537: FUNCTION Set_Attributes (
2538: p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType,
2539: x_okl_bllng_chrg_hdrs_tl_rec OUT NOCOPY OklBllngChrgHdrsTlRecType
2540: ) RETURN VARCHAR2 IS
2541: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2542: BEGIN

Line 2539: x_okl_bllng_chrg_hdrs_tl_rec OUT NOCOPY OklBllngChrgHdrsTlRecType

2535: -- Set_Attributes for:OKL_BLLNG_CHRG_HDRS_TL --
2536: -----------------------------------------------
2537: FUNCTION Set_Attributes (
2538: p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType,
2539: x_okl_bllng_chrg_hdrs_tl_rec OUT NOCOPY OklBllngChrgHdrsTlRecType
2540: ) RETURN VARCHAR2 IS
2541: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2542: BEGIN
2543: x_okl_bllng_chrg_hdrs_tl_rec := p_okl_bllng_chrg_hdrs_tl_rec;

Line 2543: x_okl_bllng_chrg_hdrs_tl_rec := p_okl_bllng_chrg_hdrs_tl_rec;

2539: x_okl_bllng_chrg_hdrs_tl_rec OUT NOCOPY OklBllngChrgHdrsTlRecType
2540: ) RETURN VARCHAR2 IS
2541: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2542: BEGIN
2543: x_okl_bllng_chrg_hdrs_tl_rec := p_okl_bllng_chrg_hdrs_tl_rec;
2544: x_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE := USERENV('LANG');
2545: x_okl_bllng_chrg_hdrs_tl_rec.SOURCE_LANG := USERENV('LANG');
2546: RETURN(l_return_status);
2547: END Set_Attributes;

Line 2544: x_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE := USERENV('LANG');

2540: ) RETURN VARCHAR2 IS
2541: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2542: BEGIN
2543: x_okl_bllng_chrg_hdrs_tl_rec := p_okl_bllng_chrg_hdrs_tl_rec;
2544: x_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE := USERENV('LANG');
2545: x_okl_bllng_chrg_hdrs_tl_rec.SOURCE_LANG := USERENV('LANG');
2546: RETURN(l_return_status);
2547: END Set_Attributes;
2548: BEGIN

Line 2545: x_okl_bllng_chrg_hdrs_tl_rec.SOURCE_LANG := USERENV('LANG');

2541: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2542: BEGIN
2543: x_okl_bllng_chrg_hdrs_tl_rec := p_okl_bllng_chrg_hdrs_tl_rec;
2544: x_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE := USERENV('LANG');
2545: x_okl_bllng_chrg_hdrs_tl_rec.SOURCE_LANG := USERENV('LANG');
2546: RETURN(l_return_status);
2547: END Set_Attributes;
2548: BEGIN
2549: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 2560: p_okl_bllng_chrg_hdrs_tl_rec, -- IN

2556: RAISE Okl_Api.G_EXCEPTION_ERROR;
2557: END IF;
2558: --- Setting item attributes
2559: l_return_status := Set_Attributes(
2560: p_okl_bllng_chrg_hdrs_tl_rec, -- IN
2561: l_okl_bllng_chrg_hdrs_tl_rec); -- OUT
2562: --- If any errors happen abort API
2563: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2564: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2561: l_okl_bllng_chrg_hdrs_tl_rec); -- OUT

2557: END IF;
2558: --- Setting item attributes
2559: l_return_status := Set_Attributes(
2560: p_okl_bllng_chrg_hdrs_tl_rec, -- IN
2561: l_okl_bllng_chrg_hdrs_tl_rec); -- OUT
2562: --- If any errors happen abort API
2563: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2564: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2565: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 2568: l_return_status := populate_new_record(l_okl_bllng_chrg_hdrs_tl_rec, ldefoklbllngchrghdrstlrec);

2564: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2565: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2566: RAISE Okl_Api.G_EXCEPTION_ERROR;
2567: END IF;
2568: l_return_status := populate_new_record(l_okl_bllng_chrg_hdrs_tl_rec, ldefoklbllngchrghdrstlrec);
2569: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2570: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2571: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2572: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 2574: UPDATE OKL_BLLNG_CHRG_HDRS_TL

2570: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2571: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2572: RAISE Okl_Api.G_EXCEPTION_ERROR;
2573: END IF;
2574: UPDATE OKL_BLLNG_CHRG_HDRS_TL
2575: SET NAME = ldefoklbllngchrghdrstlrec.name,
2576: ORIGIN = ldefoklbllngchrghdrstlrec.origin,
2577: DESTINATION = ldefoklbllngchrghdrstlrec.destination,
2578: CREATED_BY = ldefoklbllngchrghdrstlrec.created_by,

Line 2587: UPDATE OKL_BLLNG_CHRG_HDRS_TL

2583: WHERE ID = ldefoklbllngchrghdrstlrec.id
2584: --AND SOURCE_LANG = USERENV('LANG');
2585: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
2586:
2587: UPDATE OKL_BLLNG_CHRG_HDRS_TL
2588: SET SFWT_FLAG = 'Y'
2589: WHERE ID = ldefoklbllngchrghdrstlrec.id
2590: AND SOURCE_LANG <> USERENV('LANG');
2591:

Line 2592: x_okl_bllng_chrg_hdrs_tl_rec := ldefoklbllngchrghdrstlrec;

2588: SET SFWT_FLAG = 'Y'
2589: WHERE ID = ldefoklbllngchrghdrstlrec.id
2590: AND SOURCE_LANG <> USERENV('LANG');
2591:
2592: x_okl_bllng_chrg_hdrs_tl_rec := ldefoklbllngchrghdrstlrec;
2593: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2594: EXCEPTION
2595: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2596: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

Line 2643: l_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType;

2639: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2640: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2641: l_bghv_rec bghv_rec_type := p_bghv_rec;
2642: l_def_bghv_rec bghv_rec_type;
2643: l_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType;
2644: lx_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType;
2645: l_bgh_rec bgh_rec_type;
2646: lx_bgh_rec bgh_rec_type;
2647: -------------------------------

Line 2644: lx_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType;

2640: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2641: l_bghv_rec bghv_rec_type := p_bghv_rec;
2642: l_def_bghv_rec bghv_rec_type;
2643: l_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType;
2644: lx_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType;
2645: l_bgh_rec bgh_rec_type;
2646: lx_bgh_rec bgh_rec_type;
2647: -------------------------------
2648: -- FUNCTION fill_who_columns --

Line 2897: migrate(l_def_bghv_rec, l_okl_bllng_chrg_hdrs_tl_rec);

2893:
2894: --------------------------------------
2895: -- Move VIEW record to "Child" records
2896: --------------------------------------
2897: migrate(l_def_bghv_rec, l_okl_bllng_chrg_hdrs_tl_rec);
2898: migrate(l_def_bghv_rec, l_bgh_rec);
2899: --------------------------------------------
2900: -- Call the UPDATE_ROW for each child record
2901: --------------------------------------------

Line 2907: l_okl_bllng_chrg_hdrs_tl_rec,

2903: p_init_msg_list,
2904: x_return_status,
2905: x_msg_count,
2906: x_msg_data,
2907: l_okl_bllng_chrg_hdrs_tl_rec,
2908: lx_okl_bllng_chrg_hdrs_tl_rec
2909: );
2910: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2911: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2908: lx_okl_bllng_chrg_hdrs_tl_rec

2904: x_return_status,
2905: x_msg_count,
2906: x_msg_data,
2907: l_okl_bllng_chrg_hdrs_tl_rec,
2908: lx_okl_bllng_chrg_hdrs_tl_rec
2909: );
2910: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2911: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2912: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 2915: migrate(lx_okl_bllng_chrg_hdrs_tl_rec, l_def_bghv_rec);

2911: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2912: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2913: RAISE Okl_Api.G_EXCEPTION_ERROR;
2914: END IF;
2915: migrate(lx_okl_bllng_chrg_hdrs_tl_rec, l_def_bghv_rec);
2916: update_row(
2917: p_init_msg_list,
2918: x_return_status,
2919: x_msg_count,

Line 3113: -- delete_row for:OKL_BLLNG_CHRG_HDRS_TL --

3109: '_PVT'
3110: );
3111: END delete_row;
3112: -------------------------------------------
3113: -- delete_row for:OKL_BLLNG_CHRG_HDRS_TL --
3114: -------------------------------------------
3115: PROCEDURE delete_row(
3116: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
3117: x_return_status OUT NOCOPY VARCHAR2,

Line 3120: p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType) IS

3116: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
3117: x_return_status OUT NOCOPY VARCHAR2,
3118: x_msg_count OUT NOCOPY NUMBER,
3119: x_msg_data OUT NOCOPY VARCHAR2,
3120: p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType) IS
3121:
3122: l_api_version CONSTANT NUMBER := 1;
3123: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3124: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 3125: l_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType:= p_okl_bllng_chrg_hdrs_tl_rec;

3121:
3122: l_api_version CONSTANT NUMBER := 1;
3123: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3124: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3125: l_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType:= p_okl_bllng_chrg_hdrs_tl_rec;
3126: l_row_notfound BOOLEAN := TRUE;
3127: -----------------------------------------------
3128: -- Set_Attributes for:OKL_BLLNG_CHRG_HDRS_TL --
3129: -----------------------------------------------

Line 3128: -- Set_Attributes for:OKL_BLLNG_CHRG_HDRS_TL --

3124: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3125: l_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType:= p_okl_bllng_chrg_hdrs_tl_rec;
3126: l_row_notfound BOOLEAN := TRUE;
3127: -----------------------------------------------
3128: -- Set_Attributes for:OKL_BLLNG_CHRG_HDRS_TL --
3129: -----------------------------------------------
3130: FUNCTION Set_Attributes (
3131: p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType,
3132: x_okl_bllng_chrg_hdrs_tl_rec OUT NOCOPY OklBllngChrgHdrsTlRecType

Line 3131: p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType,

3127: -----------------------------------------------
3128: -- Set_Attributes for:OKL_BLLNG_CHRG_HDRS_TL --
3129: -----------------------------------------------
3130: FUNCTION Set_Attributes (
3131: p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType,
3132: x_okl_bllng_chrg_hdrs_tl_rec OUT NOCOPY OklBllngChrgHdrsTlRecType
3133: ) RETURN VARCHAR2 IS
3134: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3135: BEGIN

Line 3132: x_okl_bllng_chrg_hdrs_tl_rec OUT NOCOPY OklBllngChrgHdrsTlRecType

3128: -- Set_Attributes for:OKL_BLLNG_CHRG_HDRS_TL --
3129: -----------------------------------------------
3130: FUNCTION Set_Attributes (
3131: p_okl_bllng_chrg_hdrs_tl_rec IN OklBllngChrgHdrsTlRecType,
3132: x_okl_bllng_chrg_hdrs_tl_rec OUT NOCOPY OklBllngChrgHdrsTlRecType
3133: ) RETURN VARCHAR2 IS
3134: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3135: BEGIN
3136: x_okl_bllng_chrg_hdrs_tl_rec := p_okl_bllng_chrg_hdrs_tl_rec;

Line 3136: x_okl_bllng_chrg_hdrs_tl_rec := p_okl_bllng_chrg_hdrs_tl_rec;

3132: x_okl_bllng_chrg_hdrs_tl_rec OUT NOCOPY OklBllngChrgHdrsTlRecType
3133: ) RETURN VARCHAR2 IS
3134: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3135: BEGIN
3136: x_okl_bllng_chrg_hdrs_tl_rec := p_okl_bllng_chrg_hdrs_tl_rec;
3137: x_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE := USERENV('LANG');
3138: RETURN(l_return_status);
3139: END Set_Attributes;
3140: BEGIN

Line 3137: x_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE := USERENV('LANG');

3133: ) RETURN VARCHAR2 IS
3134: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3135: BEGIN
3136: x_okl_bllng_chrg_hdrs_tl_rec := p_okl_bllng_chrg_hdrs_tl_rec;
3137: x_okl_bllng_chrg_hdrs_tl_rec.LANGUAGE := USERENV('LANG');
3138: RETURN(l_return_status);
3139: END Set_Attributes;
3140: BEGIN
3141: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 3152: p_okl_bllng_chrg_hdrs_tl_rec, -- IN

3148: RAISE Okl_Api.G_EXCEPTION_ERROR;
3149: END IF;
3150: --- Setting item attributes
3151: l_return_status := Set_Attributes(
3152: p_okl_bllng_chrg_hdrs_tl_rec, -- IN
3153: l_okl_bllng_chrg_hdrs_tl_rec); -- OUT
3154: --- If any errors happen abort API
3155: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3156: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3153: l_okl_bllng_chrg_hdrs_tl_rec); -- OUT

3149: END IF;
3150: --- Setting item attributes
3151: l_return_status := Set_Attributes(
3152: p_okl_bllng_chrg_hdrs_tl_rec, -- IN
3153: l_okl_bllng_chrg_hdrs_tl_rec); -- OUT
3154: --- If any errors happen abort API
3155: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3156: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3157: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 3160: DELETE FROM OKL_BLLNG_CHRG_HDRS_TL

3156: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3157: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3158: RAISE Okl_Api.G_EXCEPTION_ERROR;
3159: END IF;
3160: DELETE FROM OKL_BLLNG_CHRG_HDRS_TL
3161: WHERE ID = l_okl_bllng_chrg_hdrs_tl_rec.id;
3162:
3163: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3164: EXCEPTION

Line 3161: WHERE ID = l_okl_bllng_chrg_hdrs_tl_rec.id;

3157: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3158: RAISE Okl_Api.G_EXCEPTION_ERROR;
3159: END IF;
3160: DELETE FROM OKL_BLLNG_CHRG_HDRS_TL
3161: WHERE ID = l_okl_bllng_chrg_hdrs_tl_rec.id;
3162:
3163: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3164: EXCEPTION
3165: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

Line 3211: l_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType;

3207: l_api_version CONSTANT NUMBER := 1;
3208: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3209: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3210: l_bghv_rec bghv_rec_type := p_bghv_rec;
3211: l_okl_bllng_chrg_hdrs_tl_rec OklBllngChrgHdrsTlRecType;
3212: l_bgh_rec bgh_rec_type;
3213: BEGIN
3214: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
3215: G_PKG_NAME,

Line 3229: migrate(l_bghv_rec, l_okl_bllng_chrg_hdrs_tl_rec);

3225: END IF;
3226: --------------------------------------
3227: -- Move VIEW record to "Child" records
3228: --------------------------------------
3229: migrate(l_bghv_rec, l_okl_bllng_chrg_hdrs_tl_rec);
3230: migrate(l_bghv_rec, l_bgh_rec);
3231: --------------------------------------------
3232: -- Call the DELETE_ROW for each child record
3233: --------------------------------------------

Line 3239: l_okl_bllng_chrg_hdrs_tl_rec

3235: p_init_msg_list,
3236: x_return_status,
3237: x_msg_count,
3238: x_msg_data,
3239: l_okl_bllng_chrg_hdrs_tl_rec
3240: );
3241: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3242: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3243: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN