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_BCH_PVT dependencies on OKL_BILLING_CHARGES_TL

Line 57: DELETE FROM OKL_BILLING_CHARGES_TL T

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

Line 64: UPDATE OKL_BILLING_CHARGES_TL T SET (

60: FROM OKL_BLNG_CHARGES_ALL_B B --fixed bug 3321017 by kmotepal
61: WHERE B.ID = T.ID
62: );
63:
64: UPDATE OKL_BILLING_CHARGES_TL T SET (
65: CHARGE_TYPE,
66: DESCRIPTION) = (SELECT
67: B.CHARGE_TYPE,
68: B.DESCRIPTION

Line 69: FROM OKL_BILLING_CHARGES_TL B

65: CHARGE_TYPE,
66: DESCRIPTION) = (SELECT
67: B.CHARGE_TYPE,
68: B.DESCRIPTION
69: FROM OKL_BILLING_CHARGES_TL B
70: WHERE B.ID = T.ID
71: AND B.LANGUAGE = T.SOURCE_LANG)
72: WHERE (
73: T.ID,

Line 78: FROM OKL_BILLING_CHARGES_TL SUBB, OKL_BILLING_CHARGES_TL SUBT

74: T.LANGUAGE)
75: IN (SELECT
76: SUBT.ID,
77: SUBT.LANGUAGE
78: FROM OKL_BILLING_CHARGES_TL SUBB, OKL_BILLING_CHARGES_TL SUBT
79: WHERE SUBB.ID = SUBT.ID
80: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
81: AND (SUBB.CHARGE_TYPE <> SUBT.CHARGE_TYPE
82: OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 89: INSERT INTO OKL_BILLING_CHARGES_TL (

85: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
86: OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
87: ));
88:
89: INSERT INTO OKL_BILLING_CHARGES_TL (
90: ID,
91: LANGUAGE,
92: SOURCE_LANG,
93: SFWT_FLAG,

Line 113: FROM OKL_BILLING_CHARGES_TL B, FND_LANGUAGES L

109: B.CREATION_DATE,
110: B.LAST_UPDATED_BY,
111: B.LAST_UPDATE_DATE,
112: B.LAST_UPDATE_LOGIN
113: FROM OKL_BILLING_CHARGES_TL B, FND_LANGUAGES L
114: WHERE L.INSTALLED_FLAG IN ('I', 'B')
115: AND B.LANGUAGE = USERENV('LANG')
116: AND NOT EXISTS(
117: SELECT NULL

Line 118: FROM OKL_BILLING_CHARGES_TL T

114: WHERE L.INSTALLED_FLAG IN ('I', 'B')
115: AND B.LANGUAGE = USERENV('LANG')
116: AND NOT EXISTS(
117: SELECT NULL
118: FROM OKL_BILLING_CHARGES_TL T
119: WHERE T.ID = B.ID
120: AND T.LANGUAGE = L.LANGUAGE_CODE
121: );
122:

Line 268: -- FUNCTION get_rec for: OKL_BILLING_CHARGES_TL

264: BEGIN
265: RETURN(get_rec(p_bch_rec, l_row_notfound));
266: END get_rec;
267: ---------------------------------------------------------------------------
268: -- FUNCTION get_rec for: OKL_BILLING_CHARGES_TL
269: ---------------------------------------------------------------------------
270: FUNCTION get_rec (
271: p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType,
272: x_no_data_found OUT NOCOPY BOOLEAN

Line 271: p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType,

267: ---------------------------------------------------------------------------
268: -- FUNCTION get_rec for: OKL_BILLING_CHARGES_TL
269: ---------------------------------------------------------------------------
270: FUNCTION get_rec (
271: p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType,
272: x_no_data_found OUT NOCOPY BOOLEAN
273: ) RETURN OklBillingChargesTlRecType IS
274: CURSOR okl_billing_charges_tl_pk_csr (p_id IN NUMBER,
275: p_language IN VARCHAR2) IS

Line 274: CURSOR okl_billing_charges_tl_pk_csr (p_id IN NUMBER,

270: FUNCTION get_rec (
271: p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType,
272: x_no_data_found OUT NOCOPY BOOLEAN
273: ) RETURN OklBillingChargesTlRecType IS
274: CURSOR okl_billing_charges_tl_pk_csr (p_id IN NUMBER,
275: p_language IN VARCHAR2) IS
276: SELECT
277: ID,
278: Okl_Billing_Charges_Tl.LANGUAGE,

Line 278: Okl_Billing_Charges_Tl.LANGUAGE,

274: CURSOR okl_billing_charges_tl_pk_csr (p_id IN NUMBER,
275: p_language IN VARCHAR2) IS
276: SELECT
277: ID,
278: Okl_Billing_Charges_Tl.LANGUAGE,
279: SOURCE_LANG,
280: SFWT_FLAG,
281: CHARGE_TYPE,
282: DESCRIPTION,

Line 288: FROM Okl_Billing_Charges_Tl

284: CREATION_DATE,
285: LAST_UPDATED_BY,
286: LAST_UPDATE_DATE,
287: LAST_UPDATE_LOGIN
288: FROM Okl_Billing_Charges_Tl
289: WHERE okl_billing_charges_tl.id = p_id
290: AND okl_billing_charges_tl.LANGUAGE = p_language;
291: l_okl_billing_charges_tl_pk okl_billing_charges_tl_pk_csr%ROWTYPE;
292: l_okl_billing_charges_tl_rec OklBillingChargesTlRecType;

Line 289: WHERE okl_billing_charges_tl.id = p_id

285: LAST_UPDATED_BY,
286: LAST_UPDATE_DATE,
287: LAST_UPDATE_LOGIN
288: FROM Okl_Billing_Charges_Tl
289: WHERE okl_billing_charges_tl.id = p_id
290: AND okl_billing_charges_tl.LANGUAGE = p_language;
291: l_okl_billing_charges_tl_pk okl_billing_charges_tl_pk_csr%ROWTYPE;
292: l_okl_billing_charges_tl_rec OklBillingChargesTlRecType;
293: BEGIN

Line 290: AND okl_billing_charges_tl.LANGUAGE = p_language;

286: LAST_UPDATE_DATE,
287: LAST_UPDATE_LOGIN
288: FROM Okl_Billing_Charges_Tl
289: WHERE okl_billing_charges_tl.id = p_id
290: AND okl_billing_charges_tl.LANGUAGE = p_language;
291: l_okl_billing_charges_tl_pk okl_billing_charges_tl_pk_csr%ROWTYPE;
292: l_okl_billing_charges_tl_rec OklBillingChargesTlRecType;
293: BEGIN
294: x_no_data_found := TRUE;

Line 291: l_okl_billing_charges_tl_pk okl_billing_charges_tl_pk_csr%ROWTYPE;

287: LAST_UPDATE_LOGIN
288: FROM Okl_Billing_Charges_Tl
289: WHERE okl_billing_charges_tl.id = p_id
290: AND okl_billing_charges_tl.LANGUAGE = p_language;
291: l_okl_billing_charges_tl_pk okl_billing_charges_tl_pk_csr%ROWTYPE;
292: l_okl_billing_charges_tl_rec OklBillingChargesTlRecType;
293: BEGIN
294: x_no_data_found := TRUE;
295: -- Get current database values

Line 292: l_okl_billing_charges_tl_rec OklBillingChargesTlRecType;

288: FROM Okl_Billing_Charges_Tl
289: WHERE okl_billing_charges_tl.id = p_id
290: AND okl_billing_charges_tl.LANGUAGE = p_language;
291: l_okl_billing_charges_tl_pk okl_billing_charges_tl_pk_csr%ROWTYPE;
292: l_okl_billing_charges_tl_rec OklBillingChargesTlRecType;
293: BEGIN
294: x_no_data_found := TRUE;
295: -- Get current database values
296: OPEN okl_billing_charges_tl_pk_csr (p_okl_billing_charges_tl_rec.id,

Line 296: OPEN okl_billing_charges_tl_pk_csr (p_okl_billing_charges_tl_rec.id,

292: l_okl_billing_charges_tl_rec OklBillingChargesTlRecType;
293: BEGIN
294: x_no_data_found := TRUE;
295: -- Get current database values
296: OPEN okl_billing_charges_tl_pk_csr (p_okl_billing_charges_tl_rec.id,
297: p_okl_billing_charges_tl_rec.LANGUAGE);
298: FETCH okl_billing_charges_tl_pk_csr INTO
299: l_okl_billing_charges_tl_rec.ID,
300: l_okl_billing_charges_tl_rec.LANGUAGE,

Line 297: p_okl_billing_charges_tl_rec.LANGUAGE);

293: BEGIN
294: x_no_data_found := TRUE;
295: -- Get current database values
296: OPEN okl_billing_charges_tl_pk_csr (p_okl_billing_charges_tl_rec.id,
297: p_okl_billing_charges_tl_rec.LANGUAGE);
298: FETCH okl_billing_charges_tl_pk_csr INTO
299: l_okl_billing_charges_tl_rec.ID,
300: l_okl_billing_charges_tl_rec.LANGUAGE,
301: l_okl_billing_charges_tl_rec.SOURCE_LANG,

Line 298: FETCH okl_billing_charges_tl_pk_csr INTO

294: x_no_data_found := TRUE;
295: -- Get current database values
296: OPEN okl_billing_charges_tl_pk_csr (p_okl_billing_charges_tl_rec.id,
297: p_okl_billing_charges_tl_rec.LANGUAGE);
298: FETCH okl_billing_charges_tl_pk_csr INTO
299: l_okl_billing_charges_tl_rec.ID,
300: l_okl_billing_charges_tl_rec.LANGUAGE,
301: l_okl_billing_charges_tl_rec.SOURCE_LANG,
302: l_okl_billing_charges_tl_rec.SFWT_FLAG,

Line 299: l_okl_billing_charges_tl_rec.ID,

295: -- Get current database values
296: OPEN okl_billing_charges_tl_pk_csr (p_okl_billing_charges_tl_rec.id,
297: p_okl_billing_charges_tl_rec.LANGUAGE);
298: FETCH okl_billing_charges_tl_pk_csr INTO
299: l_okl_billing_charges_tl_rec.ID,
300: l_okl_billing_charges_tl_rec.LANGUAGE,
301: l_okl_billing_charges_tl_rec.SOURCE_LANG,
302: l_okl_billing_charges_tl_rec.SFWT_FLAG,
303: l_okl_billing_charges_tl_rec.CHARGE_TYPE,

Line 300: l_okl_billing_charges_tl_rec.LANGUAGE,

296: OPEN okl_billing_charges_tl_pk_csr (p_okl_billing_charges_tl_rec.id,
297: p_okl_billing_charges_tl_rec.LANGUAGE);
298: FETCH okl_billing_charges_tl_pk_csr INTO
299: l_okl_billing_charges_tl_rec.ID,
300: l_okl_billing_charges_tl_rec.LANGUAGE,
301: l_okl_billing_charges_tl_rec.SOURCE_LANG,
302: l_okl_billing_charges_tl_rec.SFWT_FLAG,
303: l_okl_billing_charges_tl_rec.CHARGE_TYPE,
304: l_okl_billing_charges_tl_rec.DESCRIPTION,

Line 301: l_okl_billing_charges_tl_rec.SOURCE_LANG,

297: p_okl_billing_charges_tl_rec.LANGUAGE);
298: FETCH okl_billing_charges_tl_pk_csr INTO
299: l_okl_billing_charges_tl_rec.ID,
300: l_okl_billing_charges_tl_rec.LANGUAGE,
301: l_okl_billing_charges_tl_rec.SOURCE_LANG,
302: l_okl_billing_charges_tl_rec.SFWT_FLAG,
303: l_okl_billing_charges_tl_rec.CHARGE_TYPE,
304: l_okl_billing_charges_tl_rec.DESCRIPTION,
305: l_okl_billing_charges_tl_rec.CREATED_BY,

Line 302: l_okl_billing_charges_tl_rec.SFWT_FLAG,

298: FETCH okl_billing_charges_tl_pk_csr INTO
299: l_okl_billing_charges_tl_rec.ID,
300: l_okl_billing_charges_tl_rec.LANGUAGE,
301: l_okl_billing_charges_tl_rec.SOURCE_LANG,
302: l_okl_billing_charges_tl_rec.SFWT_FLAG,
303: l_okl_billing_charges_tl_rec.CHARGE_TYPE,
304: l_okl_billing_charges_tl_rec.DESCRIPTION,
305: l_okl_billing_charges_tl_rec.CREATED_BY,
306: l_okl_billing_charges_tl_rec.CREATION_DATE,

Line 303: l_okl_billing_charges_tl_rec.CHARGE_TYPE,

299: l_okl_billing_charges_tl_rec.ID,
300: l_okl_billing_charges_tl_rec.LANGUAGE,
301: l_okl_billing_charges_tl_rec.SOURCE_LANG,
302: l_okl_billing_charges_tl_rec.SFWT_FLAG,
303: l_okl_billing_charges_tl_rec.CHARGE_TYPE,
304: l_okl_billing_charges_tl_rec.DESCRIPTION,
305: l_okl_billing_charges_tl_rec.CREATED_BY,
306: l_okl_billing_charges_tl_rec.CREATION_DATE,
307: l_okl_billing_charges_tl_rec.LAST_UPDATED_BY,

Line 304: l_okl_billing_charges_tl_rec.DESCRIPTION,

300: l_okl_billing_charges_tl_rec.LANGUAGE,
301: l_okl_billing_charges_tl_rec.SOURCE_LANG,
302: l_okl_billing_charges_tl_rec.SFWT_FLAG,
303: l_okl_billing_charges_tl_rec.CHARGE_TYPE,
304: l_okl_billing_charges_tl_rec.DESCRIPTION,
305: l_okl_billing_charges_tl_rec.CREATED_BY,
306: l_okl_billing_charges_tl_rec.CREATION_DATE,
307: l_okl_billing_charges_tl_rec.LAST_UPDATED_BY,
308: l_okl_billing_charges_tl_rec.LAST_UPDATE_DATE,

Line 305: l_okl_billing_charges_tl_rec.CREATED_BY,

301: l_okl_billing_charges_tl_rec.SOURCE_LANG,
302: l_okl_billing_charges_tl_rec.SFWT_FLAG,
303: l_okl_billing_charges_tl_rec.CHARGE_TYPE,
304: l_okl_billing_charges_tl_rec.DESCRIPTION,
305: l_okl_billing_charges_tl_rec.CREATED_BY,
306: l_okl_billing_charges_tl_rec.CREATION_DATE,
307: l_okl_billing_charges_tl_rec.LAST_UPDATED_BY,
308: l_okl_billing_charges_tl_rec.LAST_UPDATE_DATE,
309: l_okl_billing_charges_tl_rec.LAST_UPDATE_LOGIN;

Line 306: l_okl_billing_charges_tl_rec.CREATION_DATE,

302: l_okl_billing_charges_tl_rec.SFWT_FLAG,
303: l_okl_billing_charges_tl_rec.CHARGE_TYPE,
304: l_okl_billing_charges_tl_rec.DESCRIPTION,
305: l_okl_billing_charges_tl_rec.CREATED_BY,
306: l_okl_billing_charges_tl_rec.CREATION_DATE,
307: l_okl_billing_charges_tl_rec.LAST_UPDATED_BY,
308: l_okl_billing_charges_tl_rec.LAST_UPDATE_DATE,
309: l_okl_billing_charges_tl_rec.LAST_UPDATE_LOGIN;
310: x_no_data_found := okl_billing_charges_tl_pk_csr%NOTFOUND;

Line 307: l_okl_billing_charges_tl_rec.LAST_UPDATED_BY,

303: l_okl_billing_charges_tl_rec.CHARGE_TYPE,
304: l_okl_billing_charges_tl_rec.DESCRIPTION,
305: l_okl_billing_charges_tl_rec.CREATED_BY,
306: l_okl_billing_charges_tl_rec.CREATION_DATE,
307: l_okl_billing_charges_tl_rec.LAST_UPDATED_BY,
308: l_okl_billing_charges_tl_rec.LAST_UPDATE_DATE,
309: l_okl_billing_charges_tl_rec.LAST_UPDATE_LOGIN;
310: x_no_data_found := okl_billing_charges_tl_pk_csr%NOTFOUND;
311: CLOSE okl_billing_charges_tl_pk_csr;

Line 308: l_okl_billing_charges_tl_rec.LAST_UPDATE_DATE,

304: l_okl_billing_charges_tl_rec.DESCRIPTION,
305: l_okl_billing_charges_tl_rec.CREATED_BY,
306: l_okl_billing_charges_tl_rec.CREATION_DATE,
307: l_okl_billing_charges_tl_rec.LAST_UPDATED_BY,
308: l_okl_billing_charges_tl_rec.LAST_UPDATE_DATE,
309: l_okl_billing_charges_tl_rec.LAST_UPDATE_LOGIN;
310: x_no_data_found := okl_billing_charges_tl_pk_csr%NOTFOUND;
311: CLOSE okl_billing_charges_tl_pk_csr;
312: RETURN(l_okl_billing_charges_tl_rec);

Line 309: l_okl_billing_charges_tl_rec.LAST_UPDATE_LOGIN;

305: l_okl_billing_charges_tl_rec.CREATED_BY,
306: l_okl_billing_charges_tl_rec.CREATION_DATE,
307: l_okl_billing_charges_tl_rec.LAST_UPDATED_BY,
308: l_okl_billing_charges_tl_rec.LAST_UPDATE_DATE,
309: l_okl_billing_charges_tl_rec.LAST_UPDATE_LOGIN;
310: x_no_data_found := okl_billing_charges_tl_pk_csr%NOTFOUND;
311: CLOSE okl_billing_charges_tl_pk_csr;
312: RETURN(l_okl_billing_charges_tl_rec);
313: END get_rec;

Line 310: x_no_data_found := okl_billing_charges_tl_pk_csr%NOTFOUND;

306: l_okl_billing_charges_tl_rec.CREATION_DATE,
307: l_okl_billing_charges_tl_rec.LAST_UPDATED_BY,
308: l_okl_billing_charges_tl_rec.LAST_UPDATE_DATE,
309: l_okl_billing_charges_tl_rec.LAST_UPDATE_LOGIN;
310: x_no_data_found := okl_billing_charges_tl_pk_csr%NOTFOUND;
311: CLOSE okl_billing_charges_tl_pk_csr;
312: RETURN(l_okl_billing_charges_tl_rec);
313: END get_rec;
314:

Line 311: CLOSE okl_billing_charges_tl_pk_csr;

307: l_okl_billing_charges_tl_rec.LAST_UPDATED_BY,
308: l_okl_billing_charges_tl_rec.LAST_UPDATE_DATE,
309: l_okl_billing_charges_tl_rec.LAST_UPDATE_LOGIN;
310: x_no_data_found := okl_billing_charges_tl_pk_csr%NOTFOUND;
311: CLOSE okl_billing_charges_tl_pk_csr;
312: RETURN(l_okl_billing_charges_tl_rec);
313: END get_rec;
314:
315: FUNCTION get_rec (

Line 312: RETURN(l_okl_billing_charges_tl_rec);

308: l_okl_billing_charges_tl_rec.LAST_UPDATE_DATE,
309: l_okl_billing_charges_tl_rec.LAST_UPDATE_LOGIN;
310: x_no_data_found := okl_billing_charges_tl_pk_csr%NOTFOUND;
311: CLOSE okl_billing_charges_tl_pk_csr;
312: RETURN(l_okl_billing_charges_tl_rec);
313: END get_rec;
314:
315: FUNCTION get_rec (
316: p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType

Line 316: p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType

312: RETURN(l_okl_billing_charges_tl_rec);
313: END get_rec;
314:
315: FUNCTION get_rec (
316: p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType
317: ) RETURN OklBillingChargesTlRecType IS
318: l_row_notfound BOOLEAN := TRUE;
319: BEGIN
320: RETURN(get_rec(p_okl_billing_charges_tl_rec, l_row_notfound));

Line 320: RETURN(get_rec(p_okl_billing_charges_tl_rec, l_row_notfound));

316: p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType
317: ) RETURN OklBillingChargesTlRecType IS
318: l_row_notfound BOOLEAN := TRUE;
319: BEGIN
320: RETURN(get_rec(p_okl_billing_charges_tl_rec, l_row_notfound));
321: END get_rec;
322: ---------------------------------------------------------------------------
323: -- FUNCTION get_rec for: OKL_BILLING_CHARGES_V
324: ---------------------------------------------------------------------------

Line 1325: l_okl_billing_charges_tl_rec OklBillingChargesTlRecType;

1321: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1322: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1323: l_bchv_rec bchv_rec_type := p_bchv_rec;
1324: l_bch_rec bch_rec_type;
1325: l_okl_billing_charges_tl_rec OklBillingChargesTlRecType;
1326: BEGIN
1327: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
1328: G_PKG_NAME,
1329: p_init_msg_list,

Line 1669: -- insert_row for:OKL_BILLING_CHARGES_TL --

1665: '_PVT'
1666: );
1667: END insert_row;
1668: -------------------------------------------
1669: -- insert_row for:OKL_BILLING_CHARGES_TL --
1670: -------------------------------------------
1671: PROCEDURE insert_row(
1672: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1673: x_return_status OUT NOCOPY VARCHAR2,

Line 1676: p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType,

1672: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1673: x_return_status OUT NOCOPY VARCHAR2,
1674: x_msg_count OUT NOCOPY NUMBER,
1675: x_msg_data OUT NOCOPY VARCHAR2,
1676: p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType,
1677: x_okl_billing_charges_tl_rec OUT NOCOPY OklBillingChargesTlRecType) IS
1678:
1679: l_api_version CONSTANT NUMBER := 1;
1680: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1677: x_okl_billing_charges_tl_rec OUT NOCOPY OklBillingChargesTlRecType) IS

1673: x_return_status OUT NOCOPY VARCHAR2,
1674: x_msg_count OUT NOCOPY NUMBER,
1675: x_msg_data OUT NOCOPY VARCHAR2,
1676: p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType,
1677: x_okl_billing_charges_tl_rec OUT NOCOPY OklBillingChargesTlRecType) IS
1678:
1679: l_api_version CONSTANT NUMBER := 1;
1680: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1681: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 1682: l_okl_billing_charges_tl_rec OklBillingChargesTlRecType := p_okl_billing_charges_tl_rec;

1678:
1679: l_api_version CONSTANT NUMBER := 1;
1680: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1681: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1682: l_okl_billing_charges_tl_rec OklBillingChargesTlRecType := p_okl_billing_charges_tl_rec;
1683: ldefoklbillingchargestlrec OklBillingChargesTlRecType;
1684: CURSOR get_languages IS
1685: SELECT *
1686: FROM FND_LANGUAGES

Line 1689: -- Set_Attributes for:OKL_BILLING_CHARGES_TL --

1685: SELECT *
1686: FROM FND_LANGUAGES
1687: WHERE INSTALLED_FLAG IN ('I', 'B');
1688: -----------------------------------------------
1689: -- Set_Attributes for:OKL_BILLING_CHARGES_TL --
1690: -----------------------------------------------
1691: FUNCTION Set_Attributes (
1692: p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType,
1693: x_okl_billing_charges_tl_rec OUT NOCOPY OklBillingChargesTlRecType

Line 1692: p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType,

1688: -----------------------------------------------
1689: -- Set_Attributes for:OKL_BILLING_CHARGES_TL --
1690: -----------------------------------------------
1691: FUNCTION Set_Attributes (
1692: p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType,
1693: x_okl_billing_charges_tl_rec OUT NOCOPY OklBillingChargesTlRecType
1694: ) RETURN VARCHAR2 IS
1695: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1696: BEGIN

Line 1693: x_okl_billing_charges_tl_rec OUT NOCOPY OklBillingChargesTlRecType

1689: -- Set_Attributes for:OKL_BILLING_CHARGES_TL --
1690: -----------------------------------------------
1691: FUNCTION Set_Attributes (
1692: p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType,
1693: x_okl_billing_charges_tl_rec OUT NOCOPY OklBillingChargesTlRecType
1694: ) RETURN VARCHAR2 IS
1695: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1696: BEGIN
1697: x_okl_billing_charges_tl_rec := p_okl_billing_charges_tl_rec;

Line 1697: x_okl_billing_charges_tl_rec := p_okl_billing_charges_tl_rec;

1693: x_okl_billing_charges_tl_rec OUT NOCOPY OklBillingChargesTlRecType
1694: ) RETURN VARCHAR2 IS
1695: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1696: BEGIN
1697: x_okl_billing_charges_tl_rec := p_okl_billing_charges_tl_rec;
1698: x_okl_billing_charges_tl_rec.LANGUAGE := USERENV('LANG');
1699: x_okl_billing_charges_tl_rec.SOURCE_LANG := USERENV('LANG');
1700: RETURN(l_return_status);
1701: END Set_Attributes;

Line 1698: x_okl_billing_charges_tl_rec.LANGUAGE := USERENV('LANG');

1694: ) RETURN VARCHAR2 IS
1695: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1696: BEGIN
1697: x_okl_billing_charges_tl_rec := p_okl_billing_charges_tl_rec;
1698: x_okl_billing_charges_tl_rec.LANGUAGE := USERENV('LANG');
1699: x_okl_billing_charges_tl_rec.SOURCE_LANG := USERENV('LANG');
1700: RETURN(l_return_status);
1701: END Set_Attributes;
1702: BEGIN

Line 1699: x_okl_billing_charges_tl_rec.SOURCE_LANG := USERENV('LANG');

1695: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1696: BEGIN
1697: x_okl_billing_charges_tl_rec := p_okl_billing_charges_tl_rec;
1698: x_okl_billing_charges_tl_rec.LANGUAGE := USERENV('LANG');
1699: x_okl_billing_charges_tl_rec.SOURCE_LANG := USERENV('LANG');
1700: RETURN(l_return_status);
1701: END Set_Attributes;
1702: BEGIN
1703: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 1714: p_okl_billing_charges_tl_rec, -- IN

1710: RAISE Okl_Api.G_EXCEPTION_ERROR;
1711: END IF;
1712: --- Setting item attributes
1713: l_return_status := Set_Attributes(
1714: p_okl_billing_charges_tl_rec, -- IN
1715: l_okl_billing_charges_tl_rec); -- OUT
1716: --- If any errors happen abort API
1717: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1718: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1715: l_okl_billing_charges_tl_rec); -- OUT

1711: END IF;
1712: --- Setting item attributes
1713: l_return_status := Set_Attributes(
1714: p_okl_billing_charges_tl_rec, -- IN
1715: l_okl_billing_charges_tl_rec); -- OUT
1716: --- If any errors happen abort API
1717: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1718: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1719: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 1723: l_okl_billing_charges_tl_rec.LANGUAGE := l_lang_rec.language_code;

1719: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1720: RAISE Okl_Api.G_EXCEPTION_ERROR;
1721: END IF;
1722: FOR l_lang_rec IN get_languages LOOP
1723: l_okl_billing_charges_tl_rec.LANGUAGE := l_lang_rec.language_code;
1724: INSERT INTO OKL_BILLING_CHARGES_TL(
1725: id,
1726: LANGUAGE,
1727: source_lang,

Line 1724: INSERT INTO OKL_BILLING_CHARGES_TL(

1720: RAISE Okl_Api.G_EXCEPTION_ERROR;
1721: END IF;
1722: FOR l_lang_rec IN get_languages LOOP
1723: l_okl_billing_charges_tl_rec.LANGUAGE := l_lang_rec.language_code;
1724: INSERT INTO OKL_BILLING_CHARGES_TL(
1725: id,
1726: LANGUAGE,
1727: source_lang,
1728: sfwt_flag,

Line 1737: l_okl_billing_charges_tl_rec.id,

1733: last_updated_by,
1734: last_update_date,
1735: last_update_login)
1736: VALUES (
1737: l_okl_billing_charges_tl_rec.id,
1738: l_okl_billing_charges_tl_rec.LANGUAGE,
1739: l_okl_billing_charges_tl_rec.source_lang,
1740: l_okl_billing_charges_tl_rec.sfwt_flag,
1741: l_okl_billing_charges_tl_rec.charge_type,

Line 1738: l_okl_billing_charges_tl_rec.LANGUAGE,

1734: last_update_date,
1735: last_update_login)
1736: VALUES (
1737: l_okl_billing_charges_tl_rec.id,
1738: l_okl_billing_charges_tl_rec.LANGUAGE,
1739: l_okl_billing_charges_tl_rec.source_lang,
1740: l_okl_billing_charges_tl_rec.sfwt_flag,
1741: l_okl_billing_charges_tl_rec.charge_type,
1742: l_okl_billing_charges_tl_rec.description,

Line 1739: l_okl_billing_charges_tl_rec.source_lang,

1735: last_update_login)
1736: VALUES (
1737: l_okl_billing_charges_tl_rec.id,
1738: l_okl_billing_charges_tl_rec.LANGUAGE,
1739: l_okl_billing_charges_tl_rec.source_lang,
1740: l_okl_billing_charges_tl_rec.sfwt_flag,
1741: l_okl_billing_charges_tl_rec.charge_type,
1742: l_okl_billing_charges_tl_rec.description,
1743: l_okl_billing_charges_tl_rec.created_by,

Line 1740: l_okl_billing_charges_tl_rec.sfwt_flag,

1736: VALUES (
1737: l_okl_billing_charges_tl_rec.id,
1738: l_okl_billing_charges_tl_rec.LANGUAGE,
1739: l_okl_billing_charges_tl_rec.source_lang,
1740: l_okl_billing_charges_tl_rec.sfwt_flag,
1741: l_okl_billing_charges_tl_rec.charge_type,
1742: l_okl_billing_charges_tl_rec.description,
1743: l_okl_billing_charges_tl_rec.created_by,
1744: l_okl_billing_charges_tl_rec.creation_date,

Line 1741: l_okl_billing_charges_tl_rec.charge_type,

1737: l_okl_billing_charges_tl_rec.id,
1738: l_okl_billing_charges_tl_rec.LANGUAGE,
1739: l_okl_billing_charges_tl_rec.source_lang,
1740: l_okl_billing_charges_tl_rec.sfwt_flag,
1741: l_okl_billing_charges_tl_rec.charge_type,
1742: l_okl_billing_charges_tl_rec.description,
1743: l_okl_billing_charges_tl_rec.created_by,
1744: l_okl_billing_charges_tl_rec.creation_date,
1745: l_okl_billing_charges_tl_rec.last_updated_by,

Line 1742: l_okl_billing_charges_tl_rec.description,

1738: l_okl_billing_charges_tl_rec.LANGUAGE,
1739: l_okl_billing_charges_tl_rec.source_lang,
1740: l_okl_billing_charges_tl_rec.sfwt_flag,
1741: l_okl_billing_charges_tl_rec.charge_type,
1742: l_okl_billing_charges_tl_rec.description,
1743: l_okl_billing_charges_tl_rec.created_by,
1744: l_okl_billing_charges_tl_rec.creation_date,
1745: l_okl_billing_charges_tl_rec.last_updated_by,
1746: l_okl_billing_charges_tl_rec.last_update_date,

Line 1743: l_okl_billing_charges_tl_rec.created_by,

1739: l_okl_billing_charges_tl_rec.source_lang,
1740: l_okl_billing_charges_tl_rec.sfwt_flag,
1741: l_okl_billing_charges_tl_rec.charge_type,
1742: l_okl_billing_charges_tl_rec.description,
1743: l_okl_billing_charges_tl_rec.created_by,
1744: l_okl_billing_charges_tl_rec.creation_date,
1745: l_okl_billing_charges_tl_rec.last_updated_by,
1746: l_okl_billing_charges_tl_rec.last_update_date,
1747: l_okl_billing_charges_tl_rec.last_update_login);

Line 1744: l_okl_billing_charges_tl_rec.creation_date,

1740: l_okl_billing_charges_tl_rec.sfwt_flag,
1741: l_okl_billing_charges_tl_rec.charge_type,
1742: l_okl_billing_charges_tl_rec.description,
1743: l_okl_billing_charges_tl_rec.created_by,
1744: l_okl_billing_charges_tl_rec.creation_date,
1745: l_okl_billing_charges_tl_rec.last_updated_by,
1746: l_okl_billing_charges_tl_rec.last_update_date,
1747: l_okl_billing_charges_tl_rec.last_update_login);
1748: END LOOP;

Line 1745: l_okl_billing_charges_tl_rec.last_updated_by,

1741: l_okl_billing_charges_tl_rec.charge_type,
1742: l_okl_billing_charges_tl_rec.description,
1743: l_okl_billing_charges_tl_rec.created_by,
1744: l_okl_billing_charges_tl_rec.creation_date,
1745: l_okl_billing_charges_tl_rec.last_updated_by,
1746: l_okl_billing_charges_tl_rec.last_update_date,
1747: l_okl_billing_charges_tl_rec.last_update_login);
1748: END LOOP;
1749: -- Set OUT values

Line 1746: l_okl_billing_charges_tl_rec.last_update_date,

1742: l_okl_billing_charges_tl_rec.description,
1743: l_okl_billing_charges_tl_rec.created_by,
1744: l_okl_billing_charges_tl_rec.creation_date,
1745: l_okl_billing_charges_tl_rec.last_updated_by,
1746: l_okl_billing_charges_tl_rec.last_update_date,
1747: l_okl_billing_charges_tl_rec.last_update_login);
1748: END LOOP;
1749: -- Set OUT values
1750: x_okl_billing_charges_tl_rec := l_okl_billing_charges_tl_rec;

Line 1747: l_okl_billing_charges_tl_rec.last_update_login);

1743: l_okl_billing_charges_tl_rec.created_by,
1744: l_okl_billing_charges_tl_rec.creation_date,
1745: l_okl_billing_charges_tl_rec.last_updated_by,
1746: l_okl_billing_charges_tl_rec.last_update_date,
1747: l_okl_billing_charges_tl_rec.last_update_login);
1748: END LOOP;
1749: -- Set OUT values
1750: x_okl_billing_charges_tl_rec := l_okl_billing_charges_tl_rec;
1751: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1750: x_okl_billing_charges_tl_rec := l_okl_billing_charges_tl_rec;

1746: l_okl_billing_charges_tl_rec.last_update_date,
1747: l_okl_billing_charges_tl_rec.last_update_login);
1748: END LOOP;
1749: -- Set OUT values
1750: x_okl_billing_charges_tl_rec := l_okl_billing_charges_tl_rec;
1751: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1752: EXCEPTION
1753: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1754: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

Line 1803: l_okl_billing_charges_tl_rec OklBillingChargesTlRecType;

1799: l_bchv_rec bchv_rec_type;
1800: l_def_bchv_rec bchv_rec_type;
1801: l_bch_rec bch_rec_type;
1802: lx_bch_rec bch_rec_type;
1803: l_okl_billing_charges_tl_rec OklBillingChargesTlRecType;
1804: lx_okl_billing_charges_tl_rec OklBillingChargesTlRecType;
1805: -------------------------------
1806: -- FUNCTION fill_who_columns --
1807: -------------------------------

Line 1804: lx_okl_billing_charges_tl_rec OklBillingChargesTlRecType;

1800: l_def_bchv_rec bchv_rec_type;
1801: l_bch_rec bch_rec_type;
1802: lx_bch_rec bch_rec_type;
1803: l_okl_billing_charges_tl_rec OklBillingChargesTlRecType;
1804: lx_okl_billing_charges_tl_rec OklBillingChargesTlRecType;
1805: -------------------------------
1806: -- FUNCTION fill_who_columns --
1807: -------------------------------
1808: FUNCTION fill_who_columns (

Line 1892: migrate(l_def_bchv_rec, l_okl_billing_charges_tl_rec);

1888: --------------------------------------
1889: -- Move VIEW record to "Child" records
1890: --------------------------------------
1891: migrate(l_def_bchv_rec, l_bch_rec);
1892: migrate(l_def_bchv_rec, l_okl_billing_charges_tl_rec);
1893: --------------------------------------------
1894: -- Call the INSERT_ROW for each child record
1895: --------------------------------------------
1896: insert_row(

Line 1915: l_okl_billing_charges_tl_rec,

1911: p_init_msg_list,
1912: x_return_status,
1913: x_msg_count,
1914: x_msg_data,
1915: l_okl_billing_charges_tl_rec,
1916: lx_okl_billing_charges_tl_rec
1917: );
1918: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1919: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1916: lx_okl_billing_charges_tl_rec

1912: x_return_status,
1913: x_msg_count,
1914: x_msg_data,
1915: l_okl_billing_charges_tl_rec,
1916: lx_okl_billing_charges_tl_rec
1917: );
1918: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1919: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1920: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 1923: migrate(lx_okl_billing_charges_tl_rec, l_def_bchv_rec);

1919: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1920: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1921: RAISE Okl_Api.G_EXCEPTION_ERROR;
1922: END IF;
1923: migrate(lx_okl_billing_charges_tl_rec, l_def_bchv_rec);
1924: -- Set OUT values
1925: x_bchv_rec := l_def_bchv_rec;
1926: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1927: EXCEPTION

Line 2153: -- lock_row for:OKL_BILLING_CHARGES_TL --

2149: '_PVT'
2150: );
2151: END lock_row;
2152: -----------------------------------------
2153: -- lock_row for:OKL_BILLING_CHARGES_TL --
2154: -----------------------------------------
2155: PROCEDURE lock_row(
2156: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2157: x_return_status OUT NOCOPY VARCHAR2,

Line 2160: p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType) IS

2156: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2157: x_return_status OUT NOCOPY VARCHAR2,
2158: x_msg_count OUT NOCOPY NUMBER,
2159: x_msg_data OUT NOCOPY VARCHAR2,
2160: p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType) IS
2161:
2162: E_Resource_Busy EXCEPTION;
2163: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2164: CURSOR lock_csr (p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType) IS

Line 2164: CURSOR lock_csr (p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType) IS

2160: p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType) IS
2161:
2162: E_Resource_Busy EXCEPTION;
2163: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2164: CURSOR lock_csr (p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType) IS
2165: SELECT *
2166: FROM OKL_BILLING_CHARGES_TL
2167: WHERE ID = p_okl_billing_charges_tl_rec.id
2168: FOR UPDATE NOWAIT;

Line 2166: FROM OKL_BILLING_CHARGES_TL

2162: E_Resource_Busy EXCEPTION;
2163: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2164: CURSOR lock_csr (p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType) IS
2165: SELECT *
2166: FROM OKL_BILLING_CHARGES_TL
2167: WHERE ID = p_okl_billing_charges_tl_rec.id
2168: FOR UPDATE NOWAIT;
2169:
2170: l_api_version CONSTANT NUMBER := 1;

Line 2167: WHERE ID = p_okl_billing_charges_tl_rec.id

2163: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2164: CURSOR lock_csr (p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType) IS
2165: SELECT *
2166: FROM OKL_BILLING_CHARGES_TL
2167: WHERE ID = p_okl_billing_charges_tl_rec.id
2168: FOR UPDATE NOWAIT;
2169:
2170: l_api_version CONSTANT NUMBER := 1;
2171: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 2187: OPEN lock_csr(p_okl_billing_charges_tl_rec);

2183: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2184: RAISE Okl_Api.G_EXCEPTION_ERROR;
2185: END IF;
2186: BEGIN
2187: OPEN lock_csr(p_okl_billing_charges_tl_rec);
2188: FETCH lock_csr INTO l_lock_var;
2189: l_row_notfound := lock_csr%NOTFOUND;
2190: CLOSE lock_csr;
2191: EXCEPTION

Line 2252: l_okl_billing_charges_tl_rec OklBillingChargesTlRecType;

2248: l_api_version CONSTANT NUMBER := 1;
2249: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2250: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2251: l_bch_rec bch_rec_type;
2252: l_okl_billing_charges_tl_rec OklBillingChargesTlRecType;
2253: BEGIN
2254: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
2255: G_PKG_NAME,
2256: p_init_msg_list,

Line 2270: migrate(p_bchv_rec, l_okl_billing_charges_tl_rec);

2266: --------------------------------------
2267: -- Move VIEW record to "Child" records
2268: --------------------------------------
2269: migrate(p_bchv_rec, l_bch_rec);
2270: migrate(p_bchv_rec, l_okl_billing_charges_tl_rec);
2271: --------------------------------------------
2272: -- Call the LOCK_ROW for each child record
2273: --------------------------------------------
2274: lock_row(

Line 2291: l_okl_billing_charges_tl_rec

2287: p_init_msg_list,
2288: x_return_status,
2289: x_msg_count,
2290: x_msg_data,
2291: l_okl_billing_charges_tl_rec
2292: );
2293: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2294: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2295: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 2807: -- update_row for:OKL_BILLING_CHARGES_TL --

2803: '_PVT'
2804: );
2805: END update_row;
2806: -------------------------------------------
2807: -- update_row for:OKL_BILLING_CHARGES_TL --
2808: -------------------------------------------
2809: PROCEDURE update_row(
2810: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2811: x_return_status OUT NOCOPY VARCHAR2,

Line 2814: p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType,

2810: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2811: x_return_status OUT NOCOPY VARCHAR2,
2812: x_msg_count OUT NOCOPY NUMBER,
2813: x_msg_data OUT NOCOPY VARCHAR2,
2814: p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType,
2815: x_okl_billing_charges_tl_rec OUT NOCOPY OklBillingChargesTlRecType) IS
2816:
2817: l_api_version CONSTANT NUMBER := 1;
2818: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2815: x_okl_billing_charges_tl_rec OUT NOCOPY OklBillingChargesTlRecType) IS

2811: x_return_status OUT NOCOPY VARCHAR2,
2812: x_msg_count OUT NOCOPY NUMBER,
2813: x_msg_data OUT NOCOPY VARCHAR2,
2814: p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType,
2815: x_okl_billing_charges_tl_rec OUT NOCOPY OklBillingChargesTlRecType) IS
2816:
2817: l_api_version CONSTANT NUMBER := 1;
2818: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2819: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 2820: l_okl_billing_charges_tl_rec OklBillingChargesTlRecType := p_okl_billing_charges_tl_rec;

2816:
2817: l_api_version CONSTANT NUMBER := 1;
2818: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2819: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2820: l_okl_billing_charges_tl_rec OklBillingChargesTlRecType := p_okl_billing_charges_tl_rec;
2821: ldefoklbillingchargestlrec OklBillingChargesTlRecType;
2822: l_row_notfound BOOLEAN := TRUE;
2823: ----------------------------------
2824: -- FUNCTION populate_new_record --

Line 2827: p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType,

2823: ----------------------------------
2824: -- FUNCTION populate_new_record --
2825: ----------------------------------
2826: FUNCTION populate_new_record (
2827: p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType,
2828: x_okl_billing_charges_tl_rec OUT NOCOPY OklBillingChargesTlRecType
2829: ) RETURN VARCHAR2 IS
2830: l_okl_billing_charges_tl_rec OklBillingChargesTlRecType;
2831: l_row_notfound BOOLEAN := TRUE;

Line 2828: x_okl_billing_charges_tl_rec OUT NOCOPY OklBillingChargesTlRecType

2824: -- FUNCTION populate_new_record --
2825: ----------------------------------
2826: FUNCTION populate_new_record (
2827: p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType,
2828: x_okl_billing_charges_tl_rec OUT NOCOPY OklBillingChargesTlRecType
2829: ) RETURN VARCHAR2 IS
2830: l_okl_billing_charges_tl_rec OklBillingChargesTlRecType;
2831: l_row_notfound BOOLEAN := TRUE;
2832: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 2830: l_okl_billing_charges_tl_rec OklBillingChargesTlRecType;

2826: FUNCTION populate_new_record (
2827: p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType,
2828: x_okl_billing_charges_tl_rec OUT NOCOPY OklBillingChargesTlRecType
2829: ) RETURN VARCHAR2 IS
2830: l_okl_billing_charges_tl_rec OklBillingChargesTlRecType;
2831: l_row_notfound BOOLEAN := TRUE;
2832: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2833: BEGIN
2834: x_okl_billing_charges_tl_rec := p_okl_billing_charges_tl_rec;

Line 2834: x_okl_billing_charges_tl_rec := p_okl_billing_charges_tl_rec;

2830: l_okl_billing_charges_tl_rec OklBillingChargesTlRecType;
2831: l_row_notfound BOOLEAN := TRUE;
2832: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2833: BEGIN
2834: x_okl_billing_charges_tl_rec := p_okl_billing_charges_tl_rec;
2835: -- Get current database values
2836: l_okl_billing_charges_tl_rec := get_rec(p_okl_billing_charges_tl_rec, l_row_notfound);
2837: IF (l_row_notfound) THEN
2838: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 2836: l_okl_billing_charges_tl_rec := get_rec(p_okl_billing_charges_tl_rec, l_row_notfound);

2832: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2833: BEGIN
2834: x_okl_billing_charges_tl_rec := p_okl_billing_charges_tl_rec;
2835: -- Get current database values
2836: l_okl_billing_charges_tl_rec := get_rec(p_okl_billing_charges_tl_rec, l_row_notfound);
2837: IF (l_row_notfound) THEN
2838: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2839: END IF;
2840: IF (x_okl_billing_charges_tl_rec.id = Okl_Api.G_MISS_NUM)

Line 2840: IF (x_okl_billing_charges_tl_rec.id = Okl_Api.G_MISS_NUM)

2836: l_okl_billing_charges_tl_rec := get_rec(p_okl_billing_charges_tl_rec, l_row_notfound);
2837: IF (l_row_notfound) THEN
2838: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2839: END IF;
2840: IF (x_okl_billing_charges_tl_rec.id = Okl_Api.G_MISS_NUM)
2841: THEN
2842: x_okl_billing_charges_tl_rec.id := l_okl_billing_charges_tl_rec.id;
2843: END IF;
2844: IF (x_okl_billing_charges_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)

Line 2842: x_okl_billing_charges_tl_rec.id := l_okl_billing_charges_tl_rec.id;

2838: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2839: END IF;
2840: IF (x_okl_billing_charges_tl_rec.id = Okl_Api.G_MISS_NUM)
2841: THEN
2842: x_okl_billing_charges_tl_rec.id := l_okl_billing_charges_tl_rec.id;
2843: END IF;
2844: IF (x_okl_billing_charges_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)
2845: THEN
2846: x_okl_billing_charges_tl_rec.LANGUAGE := l_okl_billing_charges_tl_rec.LANGUAGE;

Line 2844: IF (x_okl_billing_charges_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)

2840: IF (x_okl_billing_charges_tl_rec.id = Okl_Api.G_MISS_NUM)
2841: THEN
2842: x_okl_billing_charges_tl_rec.id := l_okl_billing_charges_tl_rec.id;
2843: END IF;
2844: IF (x_okl_billing_charges_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)
2845: THEN
2846: x_okl_billing_charges_tl_rec.LANGUAGE := l_okl_billing_charges_tl_rec.LANGUAGE;
2847: END IF;
2848: IF (x_okl_billing_charges_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)

Line 2846: x_okl_billing_charges_tl_rec.LANGUAGE := l_okl_billing_charges_tl_rec.LANGUAGE;

2842: x_okl_billing_charges_tl_rec.id := l_okl_billing_charges_tl_rec.id;
2843: END IF;
2844: IF (x_okl_billing_charges_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)
2845: THEN
2846: x_okl_billing_charges_tl_rec.LANGUAGE := l_okl_billing_charges_tl_rec.LANGUAGE;
2847: END IF;
2848: IF (x_okl_billing_charges_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)
2849: THEN
2850: x_okl_billing_charges_tl_rec.source_lang := l_okl_billing_charges_tl_rec.source_lang;

Line 2848: IF (x_okl_billing_charges_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)

2844: IF (x_okl_billing_charges_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)
2845: THEN
2846: x_okl_billing_charges_tl_rec.LANGUAGE := l_okl_billing_charges_tl_rec.LANGUAGE;
2847: END IF;
2848: IF (x_okl_billing_charges_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)
2849: THEN
2850: x_okl_billing_charges_tl_rec.source_lang := l_okl_billing_charges_tl_rec.source_lang;
2851: END IF;
2852: IF (x_okl_billing_charges_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)

Line 2850: x_okl_billing_charges_tl_rec.source_lang := l_okl_billing_charges_tl_rec.source_lang;

2846: x_okl_billing_charges_tl_rec.LANGUAGE := l_okl_billing_charges_tl_rec.LANGUAGE;
2847: END IF;
2848: IF (x_okl_billing_charges_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)
2849: THEN
2850: x_okl_billing_charges_tl_rec.source_lang := l_okl_billing_charges_tl_rec.source_lang;
2851: END IF;
2852: IF (x_okl_billing_charges_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)
2853: THEN
2854: x_okl_billing_charges_tl_rec.sfwt_flag := l_okl_billing_charges_tl_rec.sfwt_flag;

Line 2852: IF (x_okl_billing_charges_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)

2848: IF (x_okl_billing_charges_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)
2849: THEN
2850: x_okl_billing_charges_tl_rec.source_lang := l_okl_billing_charges_tl_rec.source_lang;
2851: END IF;
2852: IF (x_okl_billing_charges_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)
2853: THEN
2854: x_okl_billing_charges_tl_rec.sfwt_flag := l_okl_billing_charges_tl_rec.sfwt_flag;
2855: END IF;
2856: IF (x_okl_billing_charges_tl_rec.charge_type = Okl_Api.G_MISS_CHAR)

Line 2854: x_okl_billing_charges_tl_rec.sfwt_flag := l_okl_billing_charges_tl_rec.sfwt_flag;

2850: x_okl_billing_charges_tl_rec.source_lang := l_okl_billing_charges_tl_rec.source_lang;
2851: END IF;
2852: IF (x_okl_billing_charges_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)
2853: THEN
2854: x_okl_billing_charges_tl_rec.sfwt_flag := l_okl_billing_charges_tl_rec.sfwt_flag;
2855: END IF;
2856: IF (x_okl_billing_charges_tl_rec.charge_type = Okl_Api.G_MISS_CHAR)
2857: THEN
2858: x_okl_billing_charges_tl_rec.charge_type := l_okl_billing_charges_tl_rec.charge_type;

Line 2856: IF (x_okl_billing_charges_tl_rec.charge_type = Okl_Api.G_MISS_CHAR)

2852: IF (x_okl_billing_charges_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)
2853: THEN
2854: x_okl_billing_charges_tl_rec.sfwt_flag := l_okl_billing_charges_tl_rec.sfwt_flag;
2855: END IF;
2856: IF (x_okl_billing_charges_tl_rec.charge_type = Okl_Api.G_MISS_CHAR)
2857: THEN
2858: x_okl_billing_charges_tl_rec.charge_type := l_okl_billing_charges_tl_rec.charge_type;
2859: END IF;
2860: IF (x_okl_billing_charges_tl_rec.description = Okl_Api.G_MISS_CHAR)

Line 2858: x_okl_billing_charges_tl_rec.charge_type := l_okl_billing_charges_tl_rec.charge_type;

2854: x_okl_billing_charges_tl_rec.sfwt_flag := l_okl_billing_charges_tl_rec.sfwt_flag;
2855: END IF;
2856: IF (x_okl_billing_charges_tl_rec.charge_type = Okl_Api.G_MISS_CHAR)
2857: THEN
2858: x_okl_billing_charges_tl_rec.charge_type := l_okl_billing_charges_tl_rec.charge_type;
2859: END IF;
2860: IF (x_okl_billing_charges_tl_rec.description = Okl_Api.G_MISS_CHAR)
2861: THEN
2862: x_okl_billing_charges_tl_rec.description := l_okl_billing_charges_tl_rec.description;

Line 2860: IF (x_okl_billing_charges_tl_rec.description = Okl_Api.G_MISS_CHAR)

2856: IF (x_okl_billing_charges_tl_rec.charge_type = Okl_Api.G_MISS_CHAR)
2857: THEN
2858: x_okl_billing_charges_tl_rec.charge_type := l_okl_billing_charges_tl_rec.charge_type;
2859: END IF;
2860: IF (x_okl_billing_charges_tl_rec.description = Okl_Api.G_MISS_CHAR)
2861: THEN
2862: x_okl_billing_charges_tl_rec.description := l_okl_billing_charges_tl_rec.description;
2863: END IF;
2864: IF (x_okl_billing_charges_tl_rec.created_by = Okl_Api.G_MISS_NUM)

Line 2862: x_okl_billing_charges_tl_rec.description := l_okl_billing_charges_tl_rec.description;

2858: x_okl_billing_charges_tl_rec.charge_type := l_okl_billing_charges_tl_rec.charge_type;
2859: END IF;
2860: IF (x_okl_billing_charges_tl_rec.description = Okl_Api.G_MISS_CHAR)
2861: THEN
2862: x_okl_billing_charges_tl_rec.description := l_okl_billing_charges_tl_rec.description;
2863: END IF;
2864: IF (x_okl_billing_charges_tl_rec.created_by = Okl_Api.G_MISS_NUM)
2865: THEN
2866: x_okl_billing_charges_tl_rec.created_by := l_okl_billing_charges_tl_rec.created_by;

Line 2864: IF (x_okl_billing_charges_tl_rec.created_by = Okl_Api.G_MISS_NUM)

2860: IF (x_okl_billing_charges_tl_rec.description = Okl_Api.G_MISS_CHAR)
2861: THEN
2862: x_okl_billing_charges_tl_rec.description := l_okl_billing_charges_tl_rec.description;
2863: END IF;
2864: IF (x_okl_billing_charges_tl_rec.created_by = Okl_Api.G_MISS_NUM)
2865: THEN
2866: x_okl_billing_charges_tl_rec.created_by := l_okl_billing_charges_tl_rec.created_by;
2867: END IF;
2868: IF (x_okl_billing_charges_tl_rec.creation_date = Okl_Api.G_MISS_DATE)

Line 2866: x_okl_billing_charges_tl_rec.created_by := l_okl_billing_charges_tl_rec.created_by;

2862: x_okl_billing_charges_tl_rec.description := l_okl_billing_charges_tl_rec.description;
2863: END IF;
2864: IF (x_okl_billing_charges_tl_rec.created_by = Okl_Api.G_MISS_NUM)
2865: THEN
2866: x_okl_billing_charges_tl_rec.created_by := l_okl_billing_charges_tl_rec.created_by;
2867: END IF;
2868: IF (x_okl_billing_charges_tl_rec.creation_date = Okl_Api.G_MISS_DATE)
2869: THEN
2870: x_okl_billing_charges_tl_rec.creation_date := l_okl_billing_charges_tl_rec.creation_date;

Line 2868: IF (x_okl_billing_charges_tl_rec.creation_date = Okl_Api.G_MISS_DATE)

2864: IF (x_okl_billing_charges_tl_rec.created_by = Okl_Api.G_MISS_NUM)
2865: THEN
2866: x_okl_billing_charges_tl_rec.created_by := l_okl_billing_charges_tl_rec.created_by;
2867: END IF;
2868: IF (x_okl_billing_charges_tl_rec.creation_date = Okl_Api.G_MISS_DATE)
2869: THEN
2870: x_okl_billing_charges_tl_rec.creation_date := l_okl_billing_charges_tl_rec.creation_date;
2871: END IF;
2872: IF (x_okl_billing_charges_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)

Line 2870: x_okl_billing_charges_tl_rec.creation_date := l_okl_billing_charges_tl_rec.creation_date;

2866: x_okl_billing_charges_tl_rec.created_by := l_okl_billing_charges_tl_rec.created_by;
2867: END IF;
2868: IF (x_okl_billing_charges_tl_rec.creation_date = Okl_Api.G_MISS_DATE)
2869: THEN
2870: x_okl_billing_charges_tl_rec.creation_date := l_okl_billing_charges_tl_rec.creation_date;
2871: END IF;
2872: IF (x_okl_billing_charges_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)
2873: THEN
2874: x_okl_billing_charges_tl_rec.last_updated_by := l_okl_billing_charges_tl_rec.last_updated_by;

Line 2872: IF (x_okl_billing_charges_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)

2868: IF (x_okl_billing_charges_tl_rec.creation_date = Okl_Api.G_MISS_DATE)
2869: THEN
2870: x_okl_billing_charges_tl_rec.creation_date := l_okl_billing_charges_tl_rec.creation_date;
2871: END IF;
2872: IF (x_okl_billing_charges_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)
2873: THEN
2874: x_okl_billing_charges_tl_rec.last_updated_by := l_okl_billing_charges_tl_rec.last_updated_by;
2875: END IF;
2876: IF (x_okl_billing_charges_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)

Line 2874: x_okl_billing_charges_tl_rec.last_updated_by := l_okl_billing_charges_tl_rec.last_updated_by;

2870: x_okl_billing_charges_tl_rec.creation_date := l_okl_billing_charges_tl_rec.creation_date;
2871: END IF;
2872: IF (x_okl_billing_charges_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)
2873: THEN
2874: x_okl_billing_charges_tl_rec.last_updated_by := l_okl_billing_charges_tl_rec.last_updated_by;
2875: END IF;
2876: IF (x_okl_billing_charges_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)
2877: THEN
2878: x_okl_billing_charges_tl_rec.last_update_date := l_okl_billing_charges_tl_rec.last_update_date;

Line 2876: IF (x_okl_billing_charges_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)

2872: IF (x_okl_billing_charges_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)
2873: THEN
2874: x_okl_billing_charges_tl_rec.last_updated_by := l_okl_billing_charges_tl_rec.last_updated_by;
2875: END IF;
2876: IF (x_okl_billing_charges_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)
2877: THEN
2878: x_okl_billing_charges_tl_rec.last_update_date := l_okl_billing_charges_tl_rec.last_update_date;
2879: END IF;
2880: IF (x_okl_billing_charges_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)

Line 2878: x_okl_billing_charges_tl_rec.last_update_date := l_okl_billing_charges_tl_rec.last_update_date;

2874: x_okl_billing_charges_tl_rec.last_updated_by := l_okl_billing_charges_tl_rec.last_updated_by;
2875: END IF;
2876: IF (x_okl_billing_charges_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)
2877: THEN
2878: x_okl_billing_charges_tl_rec.last_update_date := l_okl_billing_charges_tl_rec.last_update_date;
2879: END IF;
2880: IF (x_okl_billing_charges_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)
2881: THEN
2882: x_okl_billing_charges_tl_rec.last_update_login := l_okl_billing_charges_tl_rec.last_update_login;

Line 2880: IF (x_okl_billing_charges_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)

2876: IF (x_okl_billing_charges_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)
2877: THEN
2878: x_okl_billing_charges_tl_rec.last_update_date := l_okl_billing_charges_tl_rec.last_update_date;
2879: END IF;
2880: IF (x_okl_billing_charges_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)
2881: THEN
2882: x_okl_billing_charges_tl_rec.last_update_login := l_okl_billing_charges_tl_rec.last_update_login;
2883: END IF;
2884: RETURN(l_return_status);

Line 2882: x_okl_billing_charges_tl_rec.last_update_login := l_okl_billing_charges_tl_rec.last_update_login;

2878: x_okl_billing_charges_tl_rec.last_update_date := l_okl_billing_charges_tl_rec.last_update_date;
2879: END IF;
2880: IF (x_okl_billing_charges_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)
2881: THEN
2882: x_okl_billing_charges_tl_rec.last_update_login := l_okl_billing_charges_tl_rec.last_update_login;
2883: END IF;
2884: RETURN(l_return_status);
2885: END populate_new_record;
2886: -----------------------------------------------

Line 2887: -- Set_Attributes for:OKL_BILLING_CHARGES_TL --

2883: END IF;
2884: RETURN(l_return_status);
2885: END populate_new_record;
2886: -----------------------------------------------
2887: -- Set_Attributes for:OKL_BILLING_CHARGES_TL --
2888: -----------------------------------------------
2889: FUNCTION Set_Attributes (
2890: p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType,
2891: x_okl_billing_charges_tl_rec OUT NOCOPY OklBillingChargesTlRecType

Line 2890: p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType,

2886: -----------------------------------------------
2887: -- Set_Attributes for:OKL_BILLING_CHARGES_TL --
2888: -----------------------------------------------
2889: FUNCTION Set_Attributes (
2890: p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType,
2891: x_okl_billing_charges_tl_rec OUT NOCOPY OklBillingChargesTlRecType
2892: ) RETURN VARCHAR2 IS
2893: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2894: BEGIN

Line 2891: x_okl_billing_charges_tl_rec OUT NOCOPY OklBillingChargesTlRecType

2887: -- Set_Attributes for:OKL_BILLING_CHARGES_TL --
2888: -----------------------------------------------
2889: FUNCTION Set_Attributes (
2890: p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType,
2891: x_okl_billing_charges_tl_rec OUT NOCOPY OklBillingChargesTlRecType
2892: ) RETURN VARCHAR2 IS
2893: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2894: BEGIN
2895: x_okl_billing_charges_tl_rec := p_okl_billing_charges_tl_rec;

Line 2895: x_okl_billing_charges_tl_rec := p_okl_billing_charges_tl_rec;

2891: x_okl_billing_charges_tl_rec OUT NOCOPY OklBillingChargesTlRecType
2892: ) RETURN VARCHAR2 IS
2893: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2894: BEGIN
2895: x_okl_billing_charges_tl_rec := p_okl_billing_charges_tl_rec;
2896: x_okl_billing_charges_tl_rec.LANGUAGE := USERENV('LANG');
2897: x_okl_billing_charges_tl_rec.SOURCE_LANG := USERENV('LANG');
2898: RETURN(l_return_status);
2899: END Set_Attributes;

Line 2896: x_okl_billing_charges_tl_rec.LANGUAGE := USERENV('LANG');

2892: ) RETURN VARCHAR2 IS
2893: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2894: BEGIN
2895: x_okl_billing_charges_tl_rec := p_okl_billing_charges_tl_rec;
2896: x_okl_billing_charges_tl_rec.LANGUAGE := USERENV('LANG');
2897: x_okl_billing_charges_tl_rec.SOURCE_LANG := USERENV('LANG');
2898: RETURN(l_return_status);
2899: END Set_Attributes;
2900: BEGIN

Line 2897: x_okl_billing_charges_tl_rec.SOURCE_LANG := USERENV('LANG');

2893: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2894: BEGIN
2895: x_okl_billing_charges_tl_rec := p_okl_billing_charges_tl_rec;
2896: x_okl_billing_charges_tl_rec.LANGUAGE := USERENV('LANG');
2897: x_okl_billing_charges_tl_rec.SOURCE_LANG := USERENV('LANG');
2898: RETURN(l_return_status);
2899: END Set_Attributes;
2900: BEGIN
2901: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 2912: p_okl_billing_charges_tl_rec, -- IN

2908: RAISE Okl_Api.G_EXCEPTION_ERROR;
2909: END IF;
2910: --- Setting item attributes
2911: l_return_status := Set_Attributes(
2912: p_okl_billing_charges_tl_rec, -- IN
2913: l_okl_billing_charges_tl_rec); -- OUT
2914: --- If any errors happen abort API
2915: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2916: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2913: l_okl_billing_charges_tl_rec); -- OUT

2909: END IF;
2910: --- Setting item attributes
2911: l_return_status := Set_Attributes(
2912: p_okl_billing_charges_tl_rec, -- IN
2913: l_okl_billing_charges_tl_rec); -- OUT
2914: --- If any errors happen abort API
2915: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2916: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2917: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 2920: l_return_status := populate_new_record(l_okl_billing_charges_tl_rec, ldefoklbillingchargestlrec);

2916: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2917: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2918: RAISE Okl_Api.G_EXCEPTION_ERROR;
2919: END IF;
2920: l_return_status := populate_new_record(l_okl_billing_charges_tl_rec, ldefoklbillingchargestlrec);
2921: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2922: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2923: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2924: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 2926: UPDATE OKL_BILLING_CHARGES_TL

2922: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2923: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2924: RAISE Okl_Api.G_EXCEPTION_ERROR;
2925: END IF;
2926: UPDATE OKL_BILLING_CHARGES_TL
2927: SET CHARGE_TYPE = ldefoklbillingchargestlrec.charge_type,
2928: DESCRIPTION = ldefoklbillingchargestlrec.description,
2929: CREATED_BY = ldefoklbillingchargestlrec.created_by,
2930: CREATION_DATE = ldefoklbillingchargestlrec.creation_date,

Line 2938: UPDATE OKL_BILLING_CHARGES_TL

2934: WHERE ID = ldefoklbillingchargestlrec.id
2935: --AND SOURCE_LANG = USERENV('LANG');
2936: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
2937:
2938: UPDATE OKL_BILLING_CHARGES_TL
2939: SET SFWT_FLAG = 'Y'
2940: WHERE ID = ldefoklbillingchargestlrec.id
2941: AND SOURCE_LANG <> USERENV('LANG');
2942:

Line 2943: x_okl_billing_charges_tl_rec := ldefoklbillingchargestlrec;

2939: SET SFWT_FLAG = 'Y'
2940: WHERE ID = ldefoklbillingchargestlrec.id
2941: AND SOURCE_LANG <> USERENV('LANG');
2942:
2943: x_okl_billing_charges_tl_rec := ldefoklbillingchargestlrec;
2944: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2945: EXCEPTION
2946: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2947: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

Line 2994: l_okl_billing_charges_tl_rec OklBillingChargesTlRecType;

2990: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2991: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2992: l_bchv_rec bchv_rec_type := p_bchv_rec;
2993: l_def_bchv_rec bchv_rec_type;
2994: l_okl_billing_charges_tl_rec OklBillingChargesTlRecType;
2995: lx_okl_billing_charges_tl_rec OklBillingChargesTlRecType;
2996: l_bch_rec bch_rec_type;
2997: lx_bch_rec bch_rec_type;
2998: -------------------------------

Line 2995: lx_okl_billing_charges_tl_rec OklBillingChargesTlRecType;

2991: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2992: l_bchv_rec bchv_rec_type := p_bchv_rec;
2993: l_def_bchv_rec bchv_rec_type;
2994: l_okl_billing_charges_tl_rec OklBillingChargesTlRecType;
2995: lx_okl_billing_charges_tl_rec OklBillingChargesTlRecType;
2996: l_bch_rec bch_rec_type;
2997: lx_bch_rec bch_rec_type;
2998: -------------------------------
2999: -- FUNCTION fill_who_columns --

Line 3344: migrate(l_def_bchv_rec, l_okl_billing_charges_tl_rec);

3340:
3341: --------------------------------------
3342: -- Move VIEW record to "Child" records
3343: --------------------------------------
3344: migrate(l_def_bchv_rec, l_okl_billing_charges_tl_rec);
3345: migrate(l_def_bchv_rec, l_bch_rec);
3346: --------------------------------------------
3347: -- Call the UPDATE_ROW for each child record
3348: --------------------------------------------

Line 3354: l_okl_billing_charges_tl_rec,

3350: p_init_msg_list,
3351: x_return_status,
3352: x_msg_count,
3353: x_msg_data,
3354: l_okl_billing_charges_tl_rec,
3355: lx_okl_billing_charges_tl_rec
3356: );
3357: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3358: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3355: lx_okl_billing_charges_tl_rec

3351: x_return_status,
3352: x_msg_count,
3353: x_msg_data,
3354: l_okl_billing_charges_tl_rec,
3355: lx_okl_billing_charges_tl_rec
3356: );
3357: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3358: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3359: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 3362: migrate(lx_okl_billing_charges_tl_rec, l_def_bchv_rec);

3358: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3359: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3360: RAISE Okl_Api.G_EXCEPTION_ERROR;
3361: END IF;
3362: migrate(lx_okl_billing_charges_tl_rec, l_def_bchv_rec);
3363: update_row(
3364: p_init_msg_list,
3365: x_return_status,
3366: x_msg_count,

Line 3560: -- delete_row for:OKL_BILLING_CHARGES_TL --

3556: '_PVT'
3557: );
3558: END delete_row;
3559: -------------------------------------------
3560: -- delete_row for:OKL_BILLING_CHARGES_TL --
3561: -------------------------------------------
3562: PROCEDURE delete_row(
3563: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
3564: x_return_status OUT NOCOPY VARCHAR2,

Line 3567: p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType) IS

3563: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
3564: x_return_status OUT NOCOPY VARCHAR2,
3565: x_msg_count OUT NOCOPY NUMBER,
3566: x_msg_data OUT NOCOPY VARCHAR2,
3567: p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType) IS
3568:
3569: l_api_version CONSTANT NUMBER := 1;
3570: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3571: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 3572: l_okl_billing_charges_tl_rec OklBillingChargesTlRecType:= p_okl_billing_charges_tl_rec;

3568:
3569: l_api_version CONSTANT NUMBER := 1;
3570: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3571: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3572: l_okl_billing_charges_tl_rec OklBillingChargesTlRecType:= p_okl_billing_charges_tl_rec;
3573: l_row_notfound BOOLEAN := TRUE;
3574: -----------------------------------------------
3575: -- Set_Attributes for:OKL_BILLING_CHARGES_TL --
3576: -----------------------------------------------

Line 3575: -- Set_Attributes for:OKL_BILLING_CHARGES_TL --

3571: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3572: l_okl_billing_charges_tl_rec OklBillingChargesTlRecType:= p_okl_billing_charges_tl_rec;
3573: l_row_notfound BOOLEAN := TRUE;
3574: -----------------------------------------------
3575: -- Set_Attributes for:OKL_BILLING_CHARGES_TL --
3576: -----------------------------------------------
3577: FUNCTION Set_Attributes (
3578: p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType,
3579: x_okl_billing_charges_tl_rec OUT NOCOPY OklBillingChargesTlRecType

Line 3578: p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType,

3574: -----------------------------------------------
3575: -- Set_Attributes for:OKL_BILLING_CHARGES_TL --
3576: -----------------------------------------------
3577: FUNCTION Set_Attributes (
3578: p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType,
3579: x_okl_billing_charges_tl_rec OUT NOCOPY OklBillingChargesTlRecType
3580: ) RETURN VARCHAR2 IS
3581: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3582: BEGIN

Line 3579: x_okl_billing_charges_tl_rec OUT NOCOPY OklBillingChargesTlRecType

3575: -- Set_Attributes for:OKL_BILLING_CHARGES_TL --
3576: -----------------------------------------------
3577: FUNCTION Set_Attributes (
3578: p_okl_billing_charges_tl_rec IN OklBillingChargesTlRecType,
3579: x_okl_billing_charges_tl_rec OUT NOCOPY OklBillingChargesTlRecType
3580: ) RETURN VARCHAR2 IS
3581: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3582: BEGIN
3583: x_okl_billing_charges_tl_rec := p_okl_billing_charges_tl_rec;

Line 3583: x_okl_billing_charges_tl_rec := p_okl_billing_charges_tl_rec;

3579: x_okl_billing_charges_tl_rec OUT NOCOPY OklBillingChargesTlRecType
3580: ) RETURN VARCHAR2 IS
3581: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3582: BEGIN
3583: x_okl_billing_charges_tl_rec := p_okl_billing_charges_tl_rec;
3584: x_okl_billing_charges_tl_rec.LANGUAGE := USERENV('LANG');
3585: RETURN(l_return_status);
3586: END Set_Attributes;
3587: BEGIN

Line 3584: x_okl_billing_charges_tl_rec.LANGUAGE := USERENV('LANG');

3580: ) RETURN VARCHAR2 IS
3581: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3582: BEGIN
3583: x_okl_billing_charges_tl_rec := p_okl_billing_charges_tl_rec;
3584: x_okl_billing_charges_tl_rec.LANGUAGE := USERENV('LANG');
3585: RETURN(l_return_status);
3586: END Set_Attributes;
3587: BEGIN
3588: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 3599: p_okl_billing_charges_tl_rec, -- IN

3595: RAISE Okl_Api.G_EXCEPTION_ERROR;
3596: END IF;
3597: --- Setting item attributes
3598: l_return_status := Set_Attributes(
3599: p_okl_billing_charges_tl_rec, -- IN
3600: l_okl_billing_charges_tl_rec); -- OUT
3601: --- If any errors happen abort API
3602: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3603: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3600: l_okl_billing_charges_tl_rec); -- OUT

3596: END IF;
3597: --- Setting item attributes
3598: l_return_status := Set_Attributes(
3599: p_okl_billing_charges_tl_rec, -- IN
3600: l_okl_billing_charges_tl_rec); -- OUT
3601: --- If any errors happen abort API
3602: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3603: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3604: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 3607: DELETE FROM OKL_BILLING_CHARGES_TL

3603: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3604: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3605: RAISE Okl_Api.G_EXCEPTION_ERROR;
3606: END IF;
3607: DELETE FROM OKL_BILLING_CHARGES_TL
3608: WHERE ID = l_okl_billing_charges_tl_rec.id;
3609:
3610: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3611: EXCEPTION

Line 3608: WHERE ID = l_okl_billing_charges_tl_rec.id;

3604: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3605: RAISE Okl_Api.G_EXCEPTION_ERROR;
3606: END IF;
3607: DELETE FROM OKL_BILLING_CHARGES_TL
3608: WHERE ID = l_okl_billing_charges_tl_rec.id;
3609:
3610: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3611: EXCEPTION
3612: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

Line 3658: l_okl_billing_charges_tl_rec OklBillingChargesTlRecType;

3654: l_api_version CONSTANT NUMBER := 1;
3655: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3656: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3657: l_bchv_rec bchv_rec_type := p_bchv_rec;
3658: l_okl_billing_charges_tl_rec OklBillingChargesTlRecType;
3659: l_bch_rec bch_rec_type;
3660: BEGIN
3661: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
3662: G_PKG_NAME,

Line 3676: migrate(l_bchv_rec, l_okl_billing_charges_tl_rec);

3672: END IF;
3673: --------------------------------------
3674: -- Move VIEW record to "Child" records
3675: --------------------------------------
3676: migrate(l_bchv_rec, l_okl_billing_charges_tl_rec);
3677: migrate(l_bchv_rec, l_bch_rec);
3678: --------------------------------------------
3679: -- Call the DELETE_ROW for each child record
3680: --------------------------------------------

Line 3686: l_okl_billing_charges_tl_rec

3682: p_init_msg_list,
3683: x_return_status,
3684: x_msg_count,
3685: x_msg_data,
3686: l_okl_billing_charges_tl_rec
3687: );
3688: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3689: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3690: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN