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_QTE_PVT dependencies on OKL_TRX_QUOTES_TL

Line 2884: DELETE FROM OKL_TRX_QUOTES_TL T

2880: -- PROCEDURE add_language
2881: ---------------------------------------------------------------------------
2882: PROCEDURE add_language IS
2883: BEGIN
2884: DELETE FROM OKL_TRX_QUOTES_TL T
2885: WHERE NOT EXISTS (
2886: SELECT NULL
2887: FROM OKL_TRX_QUOTES_ALL_B B
2888: WHERE B.ID = T.ID

Line 2891: UPDATE OKL_TRX_QUOTES_TL T SET (

2887: FROM OKL_TRX_QUOTES_ALL_B B
2888: WHERE B.ID = T.ID
2889: );
2890:
2891: UPDATE OKL_TRX_QUOTES_TL T SET (
2892: COMMENTS) = (SELECT
2893: B.COMMENTS
2894: FROM OKL_TRX_QUOTES_TL B
2895: WHERE B.ID = T.ID

Line 2894: FROM OKL_TRX_QUOTES_TL B

2890:
2891: UPDATE OKL_TRX_QUOTES_TL T SET (
2892: COMMENTS) = (SELECT
2893: B.COMMENTS
2894: FROM OKL_TRX_QUOTES_TL B
2895: WHERE B.ID = T.ID
2896: AND B.LANGUAGE = T.SOURCE_LANG)
2897: WHERE (
2898: T.ID,

Line 2903: FROM OKL_TRX_QUOTES_TL SUBB, OKL_TRX_QUOTES_TL SUBT

2899: T.LANGUAGE)
2900: IN (SELECT
2901: SUBT.ID,
2902: SUBT.LANGUAGE
2903: FROM OKL_TRX_QUOTES_TL SUBB, OKL_TRX_QUOTES_TL SUBT
2904: WHERE SUBB.ID = SUBT.ID
2905: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
2906: AND (SUBB.COMMENTS <> SUBT.COMMENTS
2907: OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)

Line 2911: INSERT INTO OKL_TRX_QUOTES_TL (

2907: OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)
2908: OR (SUBB.COMMENTS IS NOT NULL AND SUBT.COMMENTS IS NULL)
2909: ));
2910:
2911: INSERT INTO OKL_TRX_QUOTES_TL (
2912: ID,
2913: LANGUAGE,
2914: SOURCE_LANG,
2915: SFWT_FLAG,

Line 2933: FROM OKL_TRX_QUOTES_TL B, FND_LANGUAGES L

2929: B.CREATION_DATE,
2930: B.LAST_UPDATED_BY,
2931: B.LAST_UPDATE_DATE,
2932: B.LAST_UPDATE_LOGIN
2933: FROM OKL_TRX_QUOTES_TL B, FND_LANGUAGES L
2934: WHERE L.INSTALLED_FLAG IN ('I', 'B')
2935: AND B.LANGUAGE = USERENV('LANG')
2936: AND NOT EXISTS(
2937: SELECT NULL

Line 2938: FROM OKL_TRX_QUOTES_TL T

2934: WHERE L.INSTALLED_FLAG IN ('I', 'B')
2935: AND B.LANGUAGE = USERENV('LANG')
2936: AND NOT EXISTS(
2937: SELECT NULL
2938: FROM OKL_TRX_QUOTES_TL T
2939: WHERE T.ID = B.ID
2940: AND T.LANGUAGE = L.LANGUAGE_CODE
2941: );
2942:

Line 3153: -- FUNCTION get_rec for: OKL_TRX_QUOTES_TL

3149: BEGIN
3150: RETURN(get_rec(p_qte_rec, l_row_notfound));
3151: END get_rec;
3152: ---------------------------------------------------------------------------
3153: -- FUNCTION get_rec for: OKL_TRX_QUOTES_TL
3154: ---------------------------------------------------------------------------
3155: FUNCTION get_rec (
3156: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type,
3157: x_no_data_found OUT NOCOPY BOOLEAN

Line 3156: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type,

3152: ---------------------------------------------------------------------------
3153: -- FUNCTION get_rec for: OKL_TRX_QUOTES_TL
3154: ---------------------------------------------------------------------------
3155: FUNCTION get_rec (
3156: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type,
3157: x_no_data_found OUT NOCOPY BOOLEAN
3158: ) RETURN okl_trx_quotes_tl_rec_type IS
3159: CURSOR okl_trx_quotes_tl_pk_csr (p_id IN NUMBER,
3160: p_language IN VARCHAR2) IS

Line 3158: ) RETURN okl_trx_quotes_tl_rec_type IS

3154: ---------------------------------------------------------------------------
3155: FUNCTION get_rec (
3156: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type,
3157: x_no_data_found OUT NOCOPY BOOLEAN
3158: ) RETURN okl_trx_quotes_tl_rec_type IS
3159: CURSOR okl_trx_quotes_tl_pk_csr (p_id IN NUMBER,
3160: p_language IN VARCHAR2) IS
3161: SELECT
3162: ID,

Line 3159: CURSOR okl_trx_quotes_tl_pk_csr (p_id IN NUMBER,

3155: FUNCTION get_rec (
3156: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type,
3157: x_no_data_found OUT NOCOPY BOOLEAN
3158: ) RETURN okl_trx_quotes_tl_rec_type IS
3159: CURSOR okl_trx_quotes_tl_pk_csr (p_id IN NUMBER,
3160: p_language IN VARCHAR2) IS
3161: SELECT
3162: ID,
3163: LANGUAGE,

Line 3172: FROM Okl_Trx_Quotes_Tl

3168: CREATION_DATE,
3169: LAST_UPDATED_BY,
3170: LAST_UPDATE_DATE,
3171: LAST_UPDATE_LOGIN
3172: FROM Okl_Trx_Quotes_Tl
3173: WHERE okl_trx_quotes_tl.id = p_id
3174: AND okl_trx_quotes_tl.language = p_language;
3175: l_okl_trx_quotes_tl_pk okl_trx_quotes_tl_pk_csr%ROWTYPE;
3176: l_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;

Line 3173: WHERE okl_trx_quotes_tl.id = p_id

3169: LAST_UPDATED_BY,
3170: LAST_UPDATE_DATE,
3171: LAST_UPDATE_LOGIN
3172: FROM Okl_Trx_Quotes_Tl
3173: WHERE okl_trx_quotes_tl.id = p_id
3174: AND okl_trx_quotes_tl.language = p_language;
3175: l_okl_trx_quotes_tl_pk okl_trx_quotes_tl_pk_csr%ROWTYPE;
3176: l_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;
3177: BEGIN

Line 3174: AND okl_trx_quotes_tl.language = p_language;

3170: LAST_UPDATE_DATE,
3171: LAST_UPDATE_LOGIN
3172: FROM Okl_Trx_Quotes_Tl
3173: WHERE okl_trx_quotes_tl.id = p_id
3174: AND okl_trx_quotes_tl.language = p_language;
3175: l_okl_trx_quotes_tl_pk okl_trx_quotes_tl_pk_csr%ROWTYPE;
3176: l_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;
3177: BEGIN
3178: x_no_data_found := TRUE;

Line 3175: l_okl_trx_quotes_tl_pk okl_trx_quotes_tl_pk_csr%ROWTYPE;

3171: LAST_UPDATE_LOGIN
3172: FROM Okl_Trx_Quotes_Tl
3173: WHERE okl_trx_quotes_tl.id = p_id
3174: AND okl_trx_quotes_tl.language = p_language;
3175: l_okl_trx_quotes_tl_pk okl_trx_quotes_tl_pk_csr%ROWTYPE;
3176: l_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;
3177: BEGIN
3178: x_no_data_found := TRUE;
3179: -- Get current database values

Line 3176: l_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;

3172: FROM Okl_Trx_Quotes_Tl
3173: WHERE okl_trx_quotes_tl.id = p_id
3174: AND okl_trx_quotes_tl.language = p_language;
3175: l_okl_trx_quotes_tl_pk okl_trx_quotes_tl_pk_csr%ROWTYPE;
3176: l_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;
3177: BEGIN
3178: x_no_data_found := TRUE;
3179: -- Get current database values
3180: OPEN okl_trx_quotes_tl_pk_csr (p_okl_trx_quotes_tl_rec.id,

Line 3180: OPEN okl_trx_quotes_tl_pk_csr (p_okl_trx_quotes_tl_rec.id,

3176: l_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;
3177: BEGIN
3178: x_no_data_found := TRUE;
3179: -- Get current database values
3180: OPEN okl_trx_quotes_tl_pk_csr (p_okl_trx_quotes_tl_rec.id,
3181: p_okl_trx_quotes_tl_rec.language);
3182: FETCH okl_trx_quotes_tl_pk_csr INTO
3183: l_okl_trx_quotes_tl_rec.ID,
3184: l_okl_trx_quotes_tl_rec.LANGUAGE,

Line 3181: p_okl_trx_quotes_tl_rec.language);

3177: BEGIN
3178: x_no_data_found := TRUE;
3179: -- Get current database values
3180: OPEN okl_trx_quotes_tl_pk_csr (p_okl_trx_quotes_tl_rec.id,
3181: p_okl_trx_quotes_tl_rec.language);
3182: FETCH okl_trx_quotes_tl_pk_csr INTO
3183: l_okl_trx_quotes_tl_rec.ID,
3184: l_okl_trx_quotes_tl_rec.LANGUAGE,
3185: l_okl_trx_quotes_tl_rec.SOURCE_LANG,

Line 3182: FETCH okl_trx_quotes_tl_pk_csr INTO

3178: x_no_data_found := TRUE;
3179: -- Get current database values
3180: OPEN okl_trx_quotes_tl_pk_csr (p_okl_trx_quotes_tl_rec.id,
3181: p_okl_trx_quotes_tl_rec.language);
3182: FETCH okl_trx_quotes_tl_pk_csr INTO
3183: l_okl_trx_quotes_tl_rec.ID,
3184: l_okl_trx_quotes_tl_rec.LANGUAGE,
3185: l_okl_trx_quotes_tl_rec.SOURCE_LANG,
3186: l_okl_trx_quotes_tl_rec.SFWT_FLAG,

Line 3183: l_okl_trx_quotes_tl_rec.ID,

3179: -- Get current database values
3180: OPEN okl_trx_quotes_tl_pk_csr (p_okl_trx_quotes_tl_rec.id,
3181: p_okl_trx_quotes_tl_rec.language);
3182: FETCH okl_trx_quotes_tl_pk_csr INTO
3183: l_okl_trx_quotes_tl_rec.ID,
3184: l_okl_trx_quotes_tl_rec.LANGUAGE,
3185: l_okl_trx_quotes_tl_rec.SOURCE_LANG,
3186: l_okl_trx_quotes_tl_rec.SFWT_FLAG,
3187: l_okl_trx_quotes_tl_rec.COMMENTS,

Line 3184: l_okl_trx_quotes_tl_rec.LANGUAGE,

3180: OPEN okl_trx_quotes_tl_pk_csr (p_okl_trx_quotes_tl_rec.id,
3181: p_okl_trx_quotes_tl_rec.language);
3182: FETCH okl_trx_quotes_tl_pk_csr INTO
3183: l_okl_trx_quotes_tl_rec.ID,
3184: l_okl_trx_quotes_tl_rec.LANGUAGE,
3185: l_okl_trx_quotes_tl_rec.SOURCE_LANG,
3186: l_okl_trx_quotes_tl_rec.SFWT_FLAG,
3187: l_okl_trx_quotes_tl_rec.COMMENTS,
3188: l_okl_trx_quotes_tl_rec.CREATED_BY,

Line 3185: l_okl_trx_quotes_tl_rec.SOURCE_LANG,

3181: p_okl_trx_quotes_tl_rec.language);
3182: FETCH okl_trx_quotes_tl_pk_csr INTO
3183: l_okl_trx_quotes_tl_rec.ID,
3184: l_okl_trx_quotes_tl_rec.LANGUAGE,
3185: l_okl_trx_quotes_tl_rec.SOURCE_LANG,
3186: l_okl_trx_quotes_tl_rec.SFWT_FLAG,
3187: l_okl_trx_quotes_tl_rec.COMMENTS,
3188: l_okl_trx_quotes_tl_rec.CREATED_BY,
3189: l_okl_trx_quotes_tl_rec.CREATION_DATE,

Line 3186: l_okl_trx_quotes_tl_rec.SFWT_FLAG,

3182: FETCH okl_trx_quotes_tl_pk_csr INTO
3183: l_okl_trx_quotes_tl_rec.ID,
3184: l_okl_trx_quotes_tl_rec.LANGUAGE,
3185: l_okl_trx_quotes_tl_rec.SOURCE_LANG,
3186: l_okl_trx_quotes_tl_rec.SFWT_FLAG,
3187: l_okl_trx_quotes_tl_rec.COMMENTS,
3188: l_okl_trx_quotes_tl_rec.CREATED_BY,
3189: l_okl_trx_quotes_tl_rec.CREATION_DATE,
3190: l_okl_trx_quotes_tl_rec.LAST_UPDATED_BY,

Line 3187: l_okl_trx_quotes_tl_rec.COMMENTS,

3183: l_okl_trx_quotes_tl_rec.ID,
3184: l_okl_trx_quotes_tl_rec.LANGUAGE,
3185: l_okl_trx_quotes_tl_rec.SOURCE_LANG,
3186: l_okl_trx_quotes_tl_rec.SFWT_FLAG,
3187: l_okl_trx_quotes_tl_rec.COMMENTS,
3188: l_okl_trx_quotes_tl_rec.CREATED_BY,
3189: l_okl_trx_quotes_tl_rec.CREATION_DATE,
3190: l_okl_trx_quotes_tl_rec.LAST_UPDATED_BY,
3191: l_okl_trx_quotes_tl_rec.LAST_UPDATE_DATE,

Line 3188: l_okl_trx_quotes_tl_rec.CREATED_BY,

3184: l_okl_trx_quotes_tl_rec.LANGUAGE,
3185: l_okl_trx_quotes_tl_rec.SOURCE_LANG,
3186: l_okl_trx_quotes_tl_rec.SFWT_FLAG,
3187: l_okl_trx_quotes_tl_rec.COMMENTS,
3188: l_okl_trx_quotes_tl_rec.CREATED_BY,
3189: l_okl_trx_quotes_tl_rec.CREATION_DATE,
3190: l_okl_trx_quotes_tl_rec.LAST_UPDATED_BY,
3191: l_okl_trx_quotes_tl_rec.LAST_UPDATE_DATE,
3192: l_okl_trx_quotes_tl_rec.LAST_UPDATE_LOGIN;

Line 3189: l_okl_trx_quotes_tl_rec.CREATION_DATE,

3185: l_okl_trx_quotes_tl_rec.SOURCE_LANG,
3186: l_okl_trx_quotes_tl_rec.SFWT_FLAG,
3187: l_okl_trx_quotes_tl_rec.COMMENTS,
3188: l_okl_trx_quotes_tl_rec.CREATED_BY,
3189: l_okl_trx_quotes_tl_rec.CREATION_DATE,
3190: l_okl_trx_quotes_tl_rec.LAST_UPDATED_BY,
3191: l_okl_trx_quotes_tl_rec.LAST_UPDATE_DATE,
3192: l_okl_trx_quotes_tl_rec.LAST_UPDATE_LOGIN;
3193: x_no_data_found := okl_trx_quotes_tl_pk_csr%NOTFOUND;

Line 3190: l_okl_trx_quotes_tl_rec.LAST_UPDATED_BY,

3186: l_okl_trx_quotes_tl_rec.SFWT_FLAG,
3187: l_okl_trx_quotes_tl_rec.COMMENTS,
3188: l_okl_trx_quotes_tl_rec.CREATED_BY,
3189: l_okl_trx_quotes_tl_rec.CREATION_DATE,
3190: l_okl_trx_quotes_tl_rec.LAST_UPDATED_BY,
3191: l_okl_trx_quotes_tl_rec.LAST_UPDATE_DATE,
3192: l_okl_trx_quotes_tl_rec.LAST_UPDATE_LOGIN;
3193: x_no_data_found := okl_trx_quotes_tl_pk_csr%NOTFOUND;
3194: CLOSE okl_trx_quotes_tl_pk_csr;

Line 3191: l_okl_trx_quotes_tl_rec.LAST_UPDATE_DATE,

3187: l_okl_trx_quotes_tl_rec.COMMENTS,
3188: l_okl_trx_quotes_tl_rec.CREATED_BY,
3189: l_okl_trx_quotes_tl_rec.CREATION_DATE,
3190: l_okl_trx_quotes_tl_rec.LAST_UPDATED_BY,
3191: l_okl_trx_quotes_tl_rec.LAST_UPDATE_DATE,
3192: l_okl_trx_quotes_tl_rec.LAST_UPDATE_LOGIN;
3193: x_no_data_found := okl_trx_quotes_tl_pk_csr%NOTFOUND;
3194: CLOSE okl_trx_quotes_tl_pk_csr;
3195: RETURN(l_okl_trx_quotes_tl_rec);

Line 3192: l_okl_trx_quotes_tl_rec.LAST_UPDATE_LOGIN;

3188: l_okl_trx_quotes_tl_rec.CREATED_BY,
3189: l_okl_trx_quotes_tl_rec.CREATION_DATE,
3190: l_okl_trx_quotes_tl_rec.LAST_UPDATED_BY,
3191: l_okl_trx_quotes_tl_rec.LAST_UPDATE_DATE,
3192: l_okl_trx_quotes_tl_rec.LAST_UPDATE_LOGIN;
3193: x_no_data_found := okl_trx_quotes_tl_pk_csr%NOTFOUND;
3194: CLOSE okl_trx_quotes_tl_pk_csr;
3195: RETURN(l_okl_trx_quotes_tl_rec);
3196: END get_rec;

Line 3193: x_no_data_found := okl_trx_quotes_tl_pk_csr%NOTFOUND;

3189: l_okl_trx_quotes_tl_rec.CREATION_DATE,
3190: l_okl_trx_quotes_tl_rec.LAST_UPDATED_BY,
3191: l_okl_trx_quotes_tl_rec.LAST_UPDATE_DATE,
3192: l_okl_trx_quotes_tl_rec.LAST_UPDATE_LOGIN;
3193: x_no_data_found := okl_trx_quotes_tl_pk_csr%NOTFOUND;
3194: CLOSE okl_trx_quotes_tl_pk_csr;
3195: RETURN(l_okl_trx_quotes_tl_rec);
3196: END get_rec;
3197:

Line 3194: CLOSE okl_trx_quotes_tl_pk_csr;

3190: l_okl_trx_quotes_tl_rec.LAST_UPDATED_BY,
3191: l_okl_trx_quotes_tl_rec.LAST_UPDATE_DATE,
3192: l_okl_trx_quotes_tl_rec.LAST_UPDATE_LOGIN;
3193: x_no_data_found := okl_trx_quotes_tl_pk_csr%NOTFOUND;
3194: CLOSE okl_trx_quotes_tl_pk_csr;
3195: RETURN(l_okl_trx_quotes_tl_rec);
3196: END get_rec;
3197:
3198: FUNCTION get_rec (

Line 3195: RETURN(l_okl_trx_quotes_tl_rec);

3191: l_okl_trx_quotes_tl_rec.LAST_UPDATE_DATE,
3192: l_okl_trx_quotes_tl_rec.LAST_UPDATE_LOGIN;
3193: x_no_data_found := okl_trx_quotes_tl_pk_csr%NOTFOUND;
3194: CLOSE okl_trx_quotes_tl_pk_csr;
3195: RETURN(l_okl_trx_quotes_tl_rec);
3196: END get_rec;
3197:
3198: FUNCTION get_rec (
3199: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type

Line 3199: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type

3195: RETURN(l_okl_trx_quotes_tl_rec);
3196: END get_rec;
3197:
3198: FUNCTION get_rec (
3199: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type
3200: ) RETURN okl_trx_quotes_tl_rec_type IS
3201: l_row_notfound BOOLEAN := TRUE;
3202: BEGIN
3203: RETURN(get_rec(p_okl_trx_quotes_tl_rec, l_row_notfound));

Line 3200: ) RETURN okl_trx_quotes_tl_rec_type IS

3196: END get_rec;
3197:
3198: FUNCTION get_rec (
3199: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type
3200: ) RETURN okl_trx_quotes_tl_rec_type IS
3201: l_row_notfound BOOLEAN := TRUE;
3202: BEGIN
3203: RETURN(get_rec(p_okl_trx_quotes_tl_rec, l_row_notfound));
3204: END get_rec;

Line 3203: RETURN(get_rec(p_okl_trx_quotes_tl_rec, l_row_notfound));

3199: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type
3200: ) RETURN okl_trx_quotes_tl_rec_type IS
3201: l_row_notfound BOOLEAN := TRUE;
3202: BEGIN
3203: RETURN(get_rec(p_okl_trx_quotes_tl_rec, l_row_notfound));
3204: END get_rec;
3205: ---------------------------------------------------------------------------
3206: -- FUNCTION get_rec for: OKL_TRX_QUOTES_V
3207: ---------------------------------------------------------------------------

Line 4516: p_to IN OUT NOCOPY okl_trx_quotes_tl_rec_type

4512: p_to.repo_quote_indicator_yn := p_from.repo_quote_indicator_yn; --AKP:REPO-QUOTE-START-END 6599890
4513: END migrate;
4514: PROCEDURE migrate (
4515: p_from IN qtev_rec_type,
4516: p_to IN OUT NOCOPY okl_trx_quotes_tl_rec_type
4517: ) IS
4518: BEGIN
4519: p_to.id := p_from.id;
4520: p_to.sfwt_flag := p_from.sfwt_flag;

Line 4529: p_from IN okl_trx_quotes_tl_rec_type,

4525: p_to.last_update_date := p_from.last_update_date;
4526: p_to.last_update_login := p_from.last_update_login;
4527: END migrate;
4528: PROCEDURE migrate (
4529: p_from IN okl_trx_quotes_tl_rec_type,
4530: p_to IN OUT NOCOPY qtev_rec_type
4531: ) IS
4532: BEGIN
4533: p_to.id := p_from.id;

Line 4562: l_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;

4558: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
4559: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4560: l_qtev_rec qtev_rec_type := p_qtev_rec;
4561: l_qte_rec qte_rec_type;
4562: l_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;
4563: BEGIN
4564: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
4565: G_PKG_NAME,
4566: p_init_msg_list,

Line 4968: -- insert_row for:OKL_TRX_QUOTES_TL --

4964: '_PVT'
4965: );
4966: END insert_row;
4967: --------------------------------------
4968: -- insert_row for:OKL_TRX_QUOTES_TL --
4969: --------------------------------------
4970: PROCEDURE insert_row(
4971: p_init_msg_list IN VARCHAR2,
4972: x_return_status OUT NOCOPY VARCHAR2,

Line 4975: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type,

4971: p_init_msg_list IN VARCHAR2,
4972: x_return_status OUT NOCOPY VARCHAR2,
4973: x_msg_count OUT NOCOPY NUMBER,
4974: x_msg_data OUT NOCOPY VARCHAR2,
4975: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type,
4976: x_okl_trx_quotes_tl_rec OUT NOCOPY okl_trx_quotes_tl_rec_type) IS
4977:
4978: l_api_version CONSTANT NUMBER := 1;
4979: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 4976: x_okl_trx_quotes_tl_rec OUT NOCOPY okl_trx_quotes_tl_rec_type) IS

4972: x_return_status OUT NOCOPY VARCHAR2,
4973: x_msg_count OUT NOCOPY NUMBER,
4974: x_msg_data OUT NOCOPY VARCHAR2,
4975: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type,
4976: x_okl_trx_quotes_tl_rec OUT NOCOPY okl_trx_quotes_tl_rec_type) IS
4977:
4978: l_api_version CONSTANT NUMBER := 1;
4979: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
4980: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 4981: l_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type := p_okl_trx_quotes_tl_rec;

4977:
4978: l_api_version CONSTANT NUMBER := 1;
4979: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
4980: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4981: l_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type := p_okl_trx_quotes_tl_rec;
4982: l_def_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;
4983: CURSOR get_languages IS
4984: SELECT *
4985: FROM FND_LANGUAGES

Line 4982: l_def_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;

4978: l_api_version CONSTANT NUMBER := 1;
4979: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
4980: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4981: l_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type := p_okl_trx_quotes_tl_rec;
4982: l_def_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;
4983: CURSOR get_languages IS
4984: SELECT *
4985: FROM FND_LANGUAGES
4986: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 4988: -- Set_Attributes for:OKL_TRX_QUOTES_TL --

4984: SELECT *
4985: FROM FND_LANGUAGES
4986: WHERE INSTALLED_FLAG IN ('I', 'B');
4987: ------------------------------------------
4988: -- Set_Attributes for:OKL_TRX_QUOTES_TL --
4989: ------------------------------------------
4990: FUNCTION Set_Attributes (
4991: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type,
4992: x_okl_trx_quotes_tl_rec OUT NOCOPY okl_trx_quotes_tl_rec_type

Line 4991: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type,

4987: ------------------------------------------
4988: -- Set_Attributes for:OKL_TRX_QUOTES_TL --
4989: ------------------------------------------
4990: FUNCTION Set_Attributes (
4991: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type,
4992: x_okl_trx_quotes_tl_rec OUT NOCOPY okl_trx_quotes_tl_rec_type
4993: ) RETURN VARCHAR2 IS
4994: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4995: BEGIN

Line 4992: x_okl_trx_quotes_tl_rec OUT NOCOPY okl_trx_quotes_tl_rec_type

4988: -- Set_Attributes for:OKL_TRX_QUOTES_TL --
4989: ------------------------------------------
4990: FUNCTION Set_Attributes (
4991: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type,
4992: x_okl_trx_quotes_tl_rec OUT NOCOPY okl_trx_quotes_tl_rec_type
4993: ) RETURN VARCHAR2 IS
4994: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4995: BEGIN
4996: x_okl_trx_quotes_tl_rec := p_okl_trx_quotes_tl_rec;

Line 4996: x_okl_trx_quotes_tl_rec := p_okl_trx_quotes_tl_rec;

4992: x_okl_trx_quotes_tl_rec OUT NOCOPY okl_trx_quotes_tl_rec_type
4993: ) RETURN VARCHAR2 IS
4994: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4995: BEGIN
4996: x_okl_trx_quotes_tl_rec := p_okl_trx_quotes_tl_rec;
4997: x_okl_trx_quotes_tl_rec.LANGUAGE := USERENV('LANG');
4998: x_okl_trx_quotes_tl_rec.SOURCE_LANG := USERENV('LANG');
4999: RETURN(l_return_status);
5000: END Set_Attributes;

Line 4997: x_okl_trx_quotes_tl_rec.LANGUAGE := USERENV('LANG');

4993: ) RETURN VARCHAR2 IS
4994: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4995: BEGIN
4996: x_okl_trx_quotes_tl_rec := p_okl_trx_quotes_tl_rec;
4997: x_okl_trx_quotes_tl_rec.LANGUAGE := USERENV('LANG');
4998: x_okl_trx_quotes_tl_rec.SOURCE_LANG := USERENV('LANG');
4999: RETURN(l_return_status);
5000: END Set_Attributes;
5001: BEGIN

Line 4998: x_okl_trx_quotes_tl_rec.SOURCE_LANG := USERENV('LANG');

4994: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4995: BEGIN
4996: x_okl_trx_quotes_tl_rec := p_okl_trx_quotes_tl_rec;
4997: x_okl_trx_quotes_tl_rec.LANGUAGE := USERENV('LANG');
4998: x_okl_trx_quotes_tl_rec.SOURCE_LANG := USERENV('LANG');
4999: RETURN(l_return_status);
5000: END Set_Attributes;
5001: BEGIN
5002: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 5013: p_okl_trx_quotes_tl_rec, -- IN

5009: RAISE OKC_API.G_EXCEPTION_ERROR;
5010: END IF;
5011: --- Setting item attributes
5012: l_return_status := Set_Attributes(
5013: p_okl_trx_quotes_tl_rec, -- IN
5014: l_okl_trx_quotes_tl_rec); -- OUT
5015: --- If any errors happen abort API
5016: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5017: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 5014: l_okl_trx_quotes_tl_rec); -- OUT

5010: END IF;
5011: --- Setting item attributes
5012: l_return_status := Set_Attributes(
5013: p_okl_trx_quotes_tl_rec, -- IN
5014: l_okl_trx_quotes_tl_rec); -- OUT
5015: --- If any errors happen abort API
5016: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5017: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5018: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 5022: l_okl_trx_quotes_tl_rec.language := l_lang_rec.language_code;

5018: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5019: RAISE OKC_API.G_EXCEPTION_ERROR;
5020: END IF;
5021: FOR l_lang_rec IN get_languages LOOP
5022: l_okl_trx_quotes_tl_rec.language := l_lang_rec.language_code;
5023: INSERT INTO OKL_TRX_QUOTES_TL(
5024: id,
5025: language,
5026: source_lang,

Line 5023: INSERT INTO OKL_TRX_QUOTES_TL(

5019: RAISE OKC_API.G_EXCEPTION_ERROR;
5020: END IF;
5021: FOR l_lang_rec IN get_languages LOOP
5022: l_okl_trx_quotes_tl_rec.language := l_lang_rec.language_code;
5023: INSERT INTO OKL_TRX_QUOTES_TL(
5024: id,
5025: language,
5026: source_lang,
5027: sfwt_flag,

Line 5035: l_okl_trx_quotes_tl_rec.id,

5031: last_updated_by,
5032: last_update_date,
5033: last_update_login)
5034: VALUES (
5035: l_okl_trx_quotes_tl_rec.id,
5036: l_okl_trx_quotes_tl_rec.language,
5037: l_okl_trx_quotes_tl_rec.source_lang,
5038: l_okl_trx_quotes_tl_rec.sfwt_flag,
5039: l_okl_trx_quotes_tl_rec.comments,

Line 5036: l_okl_trx_quotes_tl_rec.language,

5032: last_update_date,
5033: last_update_login)
5034: VALUES (
5035: l_okl_trx_quotes_tl_rec.id,
5036: l_okl_trx_quotes_tl_rec.language,
5037: l_okl_trx_quotes_tl_rec.source_lang,
5038: l_okl_trx_quotes_tl_rec.sfwt_flag,
5039: l_okl_trx_quotes_tl_rec.comments,
5040: l_okl_trx_quotes_tl_rec.created_by,

Line 5037: l_okl_trx_quotes_tl_rec.source_lang,

5033: last_update_login)
5034: VALUES (
5035: l_okl_trx_quotes_tl_rec.id,
5036: l_okl_trx_quotes_tl_rec.language,
5037: l_okl_trx_quotes_tl_rec.source_lang,
5038: l_okl_trx_quotes_tl_rec.sfwt_flag,
5039: l_okl_trx_quotes_tl_rec.comments,
5040: l_okl_trx_quotes_tl_rec.created_by,
5041: l_okl_trx_quotes_tl_rec.creation_date,

Line 5038: l_okl_trx_quotes_tl_rec.sfwt_flag,

5034: VALUES (
5035: l_okl_trx_quotes_tl_rec.id,
5036: l_okl_trx_quotes_tl_rec.language,
5037: l_okl_trx_quotes_tl_rec.source_lang,
5038: l_okl_trx_quotes_tl_rec.sfwt_flag,
5039: l_okl_trx_quotes_tl_rec.comments,
5040: l_okl_trx_quotes_tl_rec.created_by,
5041: l_okl_trx_quotes_tl_rec.creation_date,
5042: l_okl_trx_quotes_tl_rec.last_updated_by,

Line 5039: l_okl_trx_quotes_tl_rec.comments,

5035: l_okl_trx_quotes_tl_rec.id,
5036: l_okl_trx_quotes_tl_rec.language,
5037: l_okl_trx_quotes_tl_rec.source_lang,
5038: l_okl_trx_quotes_tl_rec.sfwt_flag,
5039: l_okl_trx_quotes_tl_rec.comments,
5040: l_okl_trx_quotes_tl_rec.created_by,
5041: l_okl_trx_quotes_tl_rec.creation_date,
5042: l_okl_trx_quotes_tl_rec.last_updated_by,
5043: l_okl_trx_quotes_tl_rec.last_update_date,

Line 5040: l_okl_trx_quotes_tl_rec.created_by,

5036: l_okl_trx_quotes_tl_rec.language,
5037: l_okl_trx_quotes_tl_rec.source_lang,
5038: l_okl_trx_quotes_tl_rec.sfwt_flag,
5039: l_okl_trx_quotes_tl_rec.comments,
5040: l_okl_trx_quotes_tl_rec.created_by,
5041: l_okl_trx_quotes_tl_rec.creation_date,
5042: l_okl_trx_quotes_tl_rec.last_updated_by,
5043: l_okl_trx_quotes_tl_rec.last_update_date,
5044: l_okl_trx_quotes_tl_rec.last_update_login);

Line 5041: l_okl_trx_quotes_tl_rec.creation_date,

5037: l_okl_trx_quotes_tl_rec.source_lang,
5038: l_okl_trx_quotes_tl_rec.sfwt_flag,
5039: l_okl_trx_quotes_tl_rec.comments,
5040: l_okl_trx_quotes_tl_rec.created_by,
5041: l_okl_trx_quotes_tl_rec.creation_date,
5042: l_okl_trx_quotes_tl_rec.last_updated_by,
5043: l_okl_trx_quotes_tl_rec.last_update_date,
5044: l_okl_trx_quotes_tl_rec.last_update_login);
5045: END LOOP;

Line 5042: l_okl_trx_quotes_tl_rec.last_updated_by,

5038: l_okl_trx_quotes_tl_rec.sfwt_flag,
5039: l_okl_trx_quotes_tl_rec.comments,
5040: l_okl_trx_quotes_tl_rec.created_by,
5041: l_okl_trx_quotes_tl_rec.creation_date,
5042: l_okl_trx_quotes_tl_rec.last_updated_by,
5043: l_okl_trx_quotes_tl_rec.last_update_date,
5044: l_okl_trx_quotes_tl_rec.last_update_login);
5045: END LOOP;
5046: -- Set OUT values

Line 5043: l_okl_trx_quotes_tl_rec.last_update_date,

5039: l_okl_trx_quotes_tl_rec.comments,
5040: l_okl_trx_quotes_tl_rec.created_by,
5041: l_okl_trx_quotes_tl_rec.creation_date,
5042: l_okl_trx_quotes_tl_rec.last_updated_by,
5043: l_okl_trx_quotes_tl_rec.last_update_date,
5044: l_okl_trx_quotes_tl_rec.last_update_login);
5045: END LOOP;
5046: -- Set OUT values
5047: x_okl_trx_quotes_tl_rec := l_okl_trx_quotes_tl_rec;

Line 5044: l_okl_trx_quotes_tl_rec.last_update_login);

5040: l_okl_trx_quotes_tl_rec.created_by,
5041: l_okl_trx_quotes_tl_rec.creation_date,
5042: l_okl_trx_quotes_tl_rec.last_updated_by,
5043: l_okl_trx_quotes_tl_rec.last_update_date,
5044: l_okl_trx_quotes_tl_rec.last_update_login);
5045: END LOOP;
5046: -- Set OUT values
5047: x_okl_trx_quotes_tl_rec := l_okl_trx_quotes_tl_rec;
5048: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 5047: x_okl_trx_quotes_tl_rec := l_okl_trx_quotes_tl_rec;

5043: l_okl_trx_quotes_tl_rec.last_update_date,
5044: l_okl_trx_quotes_tl_rec.last_update_login);
5045: END LOOP;
5046: -- Set OUT values
5047: x_okl_trx_quotes_tl_rec := l_okl_trx_quotes_tl_rec;
5048: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
5049: EXCEPTION
5050: WHEN OKC_API.G_EXCEPTION_ERROR THEN
5051: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 5112: l_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;

5108: l_qtev_rec qtev_rec_type;
5109: l_def_qtev_rec qtev_rec_type;
5110: l_qte_rec qte_rec_type;
5111: lx_qte_rec qte_rec_type;
5112: l_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;
5113: lx_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;
5114: -------------------------------
5115: -- FUNCTION fill_who_columns --
5116: -------------------------------

Line 5113: lx_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;

5109: l_def_qtev_rec qtev_rec_type;
5110: l_qte_rec qte_rec_type;
5111: lx_qte_rec qte_rec_type;
5112: l_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;
5113: lx_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;
5114: -------------------------------
5115: -- FUNCTION fill_who_columns --
5116: -------------------------------
5117: FUNCTION fill_who_columns (

Line 5245: migrate(l_def_qtev_rec, l_okl_trx_quotes_tl_rec);

5241: --------------------------------------
5242: -- Move VIEW record to "Child" records
5243: --------------------------------------
5244: migrate(l_def_qtev_rec, l_qte_rec);
5245: migrate(l_def_qtev_rec, l_okl_trx_quotes_tl_rec);
5246: --------------------------------------------
5247: -- Call the INSERT_ROW for each child record
5248: --------------------------------------------
5249: insert_row(

Line 5268: l_okl_trx_quotes_tl_rec,

5264: p_init_msg_list,
5265: x_return_status,
5266: x_msg_count,
5267: x_msg_data,
5268: l_okl_trx_quotes_tl_rec,
5269: lx_okl_trx_quotes_tl_rec
5270: );
5271: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5272: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 5269: lx_okl_trx_quotes_tl_rec

5265: x_return_status,
5266: x_msg_count,
5267: x_msg_data,
5268: l_okl_trx_quotes_tl_rec,
5269: lx_okl_trx_quotes_tl_rec
5270: );
5271: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5272: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5273: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 5276: migrate(lx_okl_trx_quotes_tl_rec, l_def_qtev_rec);

5272: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5273: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5274: RAISE OKC_API.G_EXCEPTION_ERROR;
5275: END IF;
5276: migrate(lx_okl_trx_quotes_tl_rec, l_def_qtev_rec);
5277: -- Set OUT values
5278: x_qtev_rec := l_def_qtev_rec;
5279: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
5280: EXCEPTION

Line 5507: -- lock_row for:OKL_TRX_QUOTES_TL --

5503: '_PVT'
5504: );
5505: END lock_row;
5506: ------------------------------------
5507: -- lock_row for:OKL_TRX_QUOTES_TL --
5508: ------------------------------------
5509: PROCEDURE lock_row(
5510: p_init_msg_list IN VARCHAR2,
5511: x_return_status OUT NOCOPY VARCHAR2,

Line 5514: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type) IS

5510: p_init_msg_list IN VARCHAR2,
5511: x_return_status OUT NOCOPY VARCHAR2,
5512: x_msg_count OUT NOCOPY NUMBER,
5513: x_msg_data OUT NOCOPY VARCHAR2,
5514: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type) IS
5515:
5516: E_Resource_Busy EXCEPTION;
5517: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
5518: CURSOR lock_csr (p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type) IS

Line 5518: CURSOR lock_csr (p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type) IS

5514: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type) IS
5515:
5516: E_Resource_Busy EXCEPTION;
5517: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
5518: CURSOR lock_csr (p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type) IS
5519: SELECT *
5520: FROM OKL_TRX_QUOTES_TL
5521: WHERE ID = p_okl_trx_quotes_tl_rec.id
5522: FOR UPDATE NOWAIT;

Line 5520: FROM OKL_TRX_QUOTES_TL

5516: E_Resource_Busy EXCEPTION;
5517: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
5518: CURSOR lock_csr (p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type) IS
5519: SELECT *
5520: FROM OKL_TRX_QUOTES_TL
5521: WHERE ID = p_okl_trx_quotes_tl_rec.id
5522: FOR UPDATE NOWAIT;
5523:
5524: l_api_version CONSTANT NUMBER := 1;

Line 5521: WHERE ID = p_okl_trx_quotes_tl_rec.id

5517: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
5518: CURSOR lock_csr (p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type) IS
5519: SELECT *
5520: FROM OKL_TRX_QUOTES_TL
5521: WHERE ID = p_okl_trx_quotes_tl_rec.id
5522: FOR UPDATE NOWAIT;
5523:
5524: l_api_version CONSTANT NUMBER := 1;
5525: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 5541: OPEN lock_csr(p_okl_trx_quotes_tl_rec);

5537: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5538: RAISE OKC_API.G_EXCEPTION_ERROR;
5539: END IF;
5540: BEGIN
5541: OPEN lock_csr(p_okl_trx_quotes_tl_rec);
5542: FETCH lock_csr INTO l_lock_var;
5543: l_row_notfound := lock_csr%NOTFOUND;
5544: CLOSE lock_csr;
5545: EXCEPTION

Line 5606: l_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;

5602: l_api_version CONSTANT NUMBER := 1;
5603: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
5604: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5605: l_qte_rec qte_rec_type;
5606: l_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;
5607: BEGIN
5608: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
5609: G_PKG_NAME,
5610: p_init_msg_list,

Line 5624: migrate(p_qtev_rec, l_okl_trx_quotes_tl_rec);

5620: --------------------------------------
5621: -- Move VIEW record to "Child" records
5622: --------------------------------------
5623: migrate(p_qtev_rec, l_qte_rec);
5624: migrate(p_qtev_rec, l_okl_trx_quotes_tl_rec);
5625: --------------------------------------------
5626: -- Call the LOCK_ROW for each child record
5627: --------------------------------------------
5628: lock_row(

Line 5645: l_okl_trx_quotes_tl_rec

5641: p_init_msg_list,
5642: x_return_status,
5643: x_msg_count,
5644: x_msg_data,
5645: l_okl_trx_quotes_tl_rec
5646: );
5647: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5648: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5649: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 6325: -- update_row for:OKL_TRX_QUOTES_TL --

6321: '_PVT'
6322: );
6323: END update_row;
6324: --------------------------------------
6325: -- update_row for:OKL_TRX_QUOTES_TL --
6326: --------------------------------------
6327: PROCEDURE update_row(
6328: p_init_msg_list IN VARCHAR2,
6329: x_return_status OUT NOCOPY VARCHAR2,

Line 6332: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type,

6328: p_init_msg_list IN VARCHAR2,
6329: x_return_status OUT NOCOPY VARCHAR2,
6330: x_msg_count OUT NOCOPY NUMBER,
6331: x_msg_data OUT NOCOPY VARCHAR2,
6332: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type,
6333: x_okl_trx_quotes_tl_rec OUT NOCOPY okl_trx_quotes_tl_rec_type) IS
6334:
6335: l_api_version CONSTANT NUMBER := 1;
6336: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 6333: x_okl_trx_quotes_tl_rec OUT NOCOPY okl_trx_quotes_tl_rec_type) IS

6329: x_return_status OUT NOCOPY VARCHAR2,
6330: x_msg_count OUT NOCOPY NUMBER,
6331: x_msg_data OUT NOCOPY VARCHAR2,
6332: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type,
6333: x_okl_trx_quotes_tl_rec OUT NOCOPY okl_trx_quotes_tl_rec_type) IS
6334:
6335: l_api_version CONSTANT NUMBER := 1;
6336: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
6337: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 6338: l_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type := p_okl_trx_quotes_tl_rec;

6334:
6335: l_api_version CONSTANT NUMBER := 1;
6336: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
6337: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
6338: l_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type := p_okl_trx_quotes_tl_rec;
6339: l_def_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;
6340: l_row_notfound BOOLEAN := TRUE;
6341: ----------------------------------
6342: -- FUNCTION populate_new_record --

Line 6339: l_def_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;

6335: l_api_version CONSTANT NUMBER := 1;
6336: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
6337: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
6338: l_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type := p_okl_trx_quotes_tl_rec;
6339: l_def_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;
6340: l_row_notfound BOOLEAN := TRUE;
6341: ----------------------------------
6342: -- FUNCTION populate_new_record --
6343: ----------------------------------

Line 6345: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type,

6341: ----------------------------------
6342: -- FUNCTION populate_new_record --
6343: ----------------------------------
6344: FUNCTION populate_new_record (
6345: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type,
6346: x_okl_trx_quotes_tl_rec OUT NOCOPY okl_trx_quotes_tl_rec_type
6347: ) RETURN VARCHAR2 IS
6348: l_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;
6349: l_row_notfound BOOLEAN := TRUE;

Line 6346: x_okl_trx_quotes_tl_rec OUT NOCOPY okl_trx_quotes_tl_rec_type

6342: -- FUNCTION populate_new_record --
6343: ----------------------------------
6344: FUNCTION populate_new_record (
6345: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type,
6346: x_okl_trx_quotes_tl_rec OUT NOCOPY okl_trx_quotes_tl_rec_type
6347: ) RETURN VARCHAR2 IS
6348: l_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;
6349: l_row_notfound BOOLEAN := TRUE;
6350: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 6348: l_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;

6344: FUNCTION populate_new_record (
6345: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type,
6346: x_okl_trx_quotes_tl_rec OUT NOCOPY okl_trx_quotes_tl_rec_type
6347: ) RETURN VARCHAR2 IS
6348: l_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;
6349: l_row_notfound BOOLEAN := TRUE;
6350: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
6351: BEGIN
6352: x_okl_trx_quotes_tl_rec := p_okl_trx_quotes_tl_rec;

Line 6352: x_okl_trx_quotes_tl_rec := p_okl_trx_quotes_tl_rec;

6348: l_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;
6349: l_row_notfound BOOLEAN := TRUE;
6350: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
6351: BEGIN
6352: x_okl_trx_quotes_tl_rec := p_okl_trx_quotes_tl_rec;
6353: -- Get current database values
6354: l_okl_trx_quotes_tl_rec := get_rec(p_okl_trx_quotes_tl_rec, l_row_notfound);
6355: IF (l_row_notfound) THEN
6356: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 6354: l_okl_trx_quotes_tl_rec := get_rec(p_okl_trx_quotes_tl_rec, l_row_notfound);

6350: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
6351: BEGIN
6352: x_okl_trx_quotes_tl_rec := p_okl_trx_quotes_tl_rec;
6353: -- Get current database values
6354: l_okl_trx_quotes_tl_rec := get_rec(p_okl_trx_quotes_tl_rec, l_row_notfound);
6355: IF (l_row_notfound) THEN
6356: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
6357: END IF;
6358: IF (x_okl_trx_quotes_tl_rec.id = OKC_API.G_MISS_NUM)

Line 6358: IF (x_okl_trx_quotes_tl_rec.id = OKC_API.G_MISS_NUM)

6354: l_okl_trx_quotes_tl_rec := get_rec(p_okl_trx_quotes_tl_rec, l_row_notfound);
6355: IF (l_row_notfound) THEN
6356: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
6357: END IF;
6358: IF (x_okl_trx_quotes_tl_rec.id = OKC_API.G_MISS_NUM)
6359: THEN
6360: x_okl_trx_quotes_tl_rec.id := l_okl_trx_quotes_tl_rec.id;
6361: END IF;
6362: IF (x_okl_trx_quotes_tl_rec.language = OKC_API.G_MISS_CHAR)

Line 6360: x_okl_trx_quotes_tl_rec.id := l_okl_trx_quotes_tl_rec.id;

6356: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
6357: END IF;
6358: IF (x_okl_trx_quotes_tl_rec.id = OKC_API.G_MISS_NUM)
6359: THEN
6360: x_okl_trx_quotes_tl_rec.id := l_okl_trx_quotes_tl_rec.id;
6361: END IF;
6362: IF (x_okl_trx_quotes_tl_rec.language = OKC_API.G_MISS_CHAR)
6363: THEN
6364: x_okl_trx_quotes_tl_rec.language := l_okl_trx_quotes_tl_rec.language;

Line 6362: IF (x_okl_trx_quotes_tl_rec.language = OKC_API.G_MISS_CHAR)

6358: IF (x_okl_trx_quotes_tl_rec.id = OKC_API.G_MISS_NUM)
6359: THEN
6360: x_okl_trx_quotes_tl_rec.id := l_okl_trx_quotes_tl_rec.id;
6361: END IF;
6362: IF (x_okl_trx_quotes_tl_rec.language = OKC_API.G_MISS_CHAR)
6363: THEN
6364: x_okl_trx_quotes_tl_rec.language := l_okl_trx_quotes_tl_rec.language;
6365: END IF;
6366: IF (x_okl_trx_quotes_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

Line 6364: x_okl_trx_quotes_tl_rec.language := l_okl_trx_quotes_tl_rec.language;

6360: x_okl_trx_quotes_tl_rec.id := l_okl_trx_quotes_tl_rec.id;
6361: END IF;
6362: IF (x_okl_trx_quotes_tl_rec.language = OKC_API.G_MISS_CHAR)
6363: THEN
6364: x_okl_trx_quotes_tl_rec.language := l_okl_trx_quotes_tl_rec.language;
6365: END IF;
6366: IF (x_okl_trx_quotes_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
6367: THEN
6368: x_okl_trx_quotes_tl_rec.source_lang := l_okl_trx_quotes_tl_rec.source_lang;

Line 6366: IF (x_okl_trx_quotes_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

6362: IF (x_okl_trx_quotes_tl_rec.language = OKC_API.G_MISS_CHAR)
6363: THEN
6364: x_okl_trx_quotes_tl_rec.language := l_okl_trx_quotes_tl_rec.language;
6365: END IF;
6366: IF (x_okl_trx_quotes_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
6367: THEN
6368: x_okl_trx_quotes_tl_rec.source_lang := l_okl_trx_quotes_tl_rec.source_lang;
6369: END IF;
6370: IF (x_okl_trx_quotes_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

Line 6368: x_okl_trx_quotes_tl_rec.source_lang := l_okl_trx_quotes_tl_rec.source_lang;

6364: x_okl_trx_quotes_tl_rec.language := l_okl_trx_quotes_tl_rec.language;
6365: END IF;
6366: IF (x_okl_trx_quotes_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
6367: THEN
6368: x_okl_trx_quotes_tl_rec.source_lang := l_okl_trx_quotes_tl_rec.source_lang;
6369: END IF;
6370: IF (x_okl_trx_quotes_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
6371: THEN
6372: x_okl_trx_quotes_tl_rec.sfwt_flag := l_okl_trx_quotes_tl_rec.sfwt_flag;

Line 6370: IF (x_okl_trx_quotes_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

6366: IF (x_okl_trx_quotes_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
6367: THEN
6368: x_okl_trx_quotes_tl_rec.source_lang := l_okl_trx_quotes_tl_rec.source_lang;
6369: END IF;
6370: IF (x_okl_trx_quotes_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
6371: THEN
6372: x_okl_trx_quotes_tl_rec.sfwt_flag := l_okl_trx_quotes_tl_rec.sfwt_flag;
6373: END IF;
6374: IF (x_okl_trx_quotes_tl_rec.comments = OKC_API.G_MISS_CHAR)

Line 6372: x_okl_trx_quotes_tl_rec.sfwt_flag := l_okl_trx_quotes_tl_rec.sfwt_flag;

6368: x_okl_trx_quotes_tl_rec.source_lang := l_okl_trx_quotes_tl_rec.source_lang;
6369: END IF;
6370: IF (x_okl_trx_quotes_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
6371: THEN
6372: x_okl_trx_quotes_tl_rec.sfwt_flag := l_okl_trx_quotes_tl_rec.sfwt_flag;
6373: END IF;
6374: IF (x_okl_trx_quotes_tl_rec.comments = OKC_API.G_MISS_CHAR)
6375: THEN
6376: x_okl_trx_quotes_tl_rec.comments := l_okl_trx_quotes_tl_rec.comments;

Line 6374: IF (x_okl_trx_quotes_tl_rec.comments = OKC_API.G_MISS_CHAR)

6370: IF (x_okl_trx_quotes_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
6371: THEN
6372: x_okl_trx_quotes_tl_rec.sfwt_flag := l_okl_trx_quotes_tl_rec.sfwt_flag;
6373: END IF;
6374: IF (x_okl_trx_quotes_tl_rec.comments = OKC_API.G_MISS_CHAR)
6375: THEN
6376: x_okl_trx_quotes_tl_rec.comments := l_okl_trx_quotes_tl_rec.comments;
6377: END IF;
6378: IF (x_okl_trx_quotes_tl_rec.created_by = OKC_API.G_MISS_NUM)

Line 6376: x_okl_trx_quotes_tl_rec.comments := l_okl_trx_quotes_tl_rec.comments;

6372: x_okl_trx_quotes_tl_rec.sfwt_flag := l_okl_trx_quotes_tl_rec.sfwt_flag;
6373: END IF;
6374: IF (x_okl_trx_quotes_tl_rec.comments = OKC_API.G_MISS_CHAR)
6375: THEN
6376: x_okl_trx_quotes_tl_rec.comments := l_okl_trx_quotes_tl_rec.comments;
6377: END IF;
6378: IF (x_okl_trx_quotes_tl_rec.created_by = OKC_API.G_MISS_NUM)
6379: THEN
6380: x_okl_trx_quotes_tl_rec.created_by := l_okl_trx_quotes_tl_rec.created_by;

Line 6378: IF (x_okl_trx_quotes_tl_rec.created_by = OKC_API.G_MISS_NUM)

6374: IF (x_okl_trx_quotes_tl_rec.comments = OKC_API.G_MISS_CHAR)
6375: THEN
6376: x_okl_trx_quotes_tl_rec.comments := l_okl_trx_quotes_tl_rec.comments;
6377: END IF;
6378: IF (x_okl_trx_quotes_tl_rec.created_by = OKC_API.G_MISS_NUM)
6379: THEN
6380: x_okl_trx_quotes_tl_rec.created_by := l_okl_trx_quotes_tl_rec.created_by;
6381: END IF;
6382: IF (x_okl_trx_quotes_tl_rec.creation_date = OKC_API.G_MISS_DATE)

Line 6380: x_okl_trx_quotes_tl_rec.created_by := l_okl_trx_quotes_tl_rec.created_by;

6376: x_okl_trx_quotes_tl_rec.comments := l_okl_trx_quotes_tl_rec.comments;
6377: END IF;
6378: IF (x_okl_trx_quotes_tl_rec.created_by = OKC_API.G_MISS_NUM)
6379: THEN
6380: x_okl_trx_quotes_tl_rec.created_by := l_okl_trx_quotes_tl_rec.created_by;
6381: END IF;
6382: IF (x_okl_trx_quotes_tl_rec.creation_date = OKC_API.G_MISS_DATE)
6383: THEN
6384: x_okl_trx_quotes_tl_rec.creation_date := l_okl_trx_quotes_tl_rec.creation_date;

Line 6382: IF (x_okl_trx_quotes_tl_rec.creation_date = OKC_API.G_MISS_DATE)

6378: IF (x_okl_trx_quotes_tl_rec.created_by = OKC_API.G_MISS_NUM)
6379: THEN
6380: x_okl_trx_quotes_tl_rec.created_by := l_okl_trx_quotes_tl_rec.created_by;
6381: END IF;
6382: IF (x_okl_trx_quotes_tl_rec.creation_date = OKC_API.G_MISS_DATE)
6383: THEN
6384: x_okl_trx_quotes_tl_rec.creation_date := l_okl_trx_quotes_tl_rec.creation_date;
6385: END IF;
6386: IF (x_okl_trx_quotes_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 6384: x_okl_trx_quotes_tl_rec.creation_date := l_okl_trx_quotes_tl_rec.creation_date;

6380: x_okl_trx_quotes_tl_rec.created_by := l_okl_trx_quotes_tl_rec.created_by;
6381: END IF;
6382: IF (x_okl_trx_quotes_tl_rec.creation_date = OKC_API.G_MISS_DATE)
6383: THEN
6384: x_okl_trx_quotes_tl_rec.creation_date := l_okl_trx_quotes_tl_rec.creation_date;
6385: END IF;
6386: IF (x_okl_trx_quotes_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
6387: THEN
6388: x_okl_trx_quotes_tl_rec.last_updated_by := l_okl_trx_quotes_tl_rec.last_updated_by;

Line 6386: IF (x_okl_trx_quotes_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

6382: IF (x_okl_trx_quotes_tl_rec.creation_date = OKC_API.G_MISS_DATE)
6383: THEN
6384: x_okl_trx_quotes_tl_rec.creation_date := l_okl_trx_quotes_tl_rec.creation_date;
6385: END IF;
6386: IF (x_okl_trx_quotes_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
6387: THEN
6388: x_okl_trx_quotes_tl_rec.last_updated_by := l_okl_trx_quotes_tl_rec.last_updated_by;
6389: END IF;
6390: IF (x_okl_trx_quotes_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 6388: x_okl_trx_quotes_tl_rec.last_updated_by := l_okl_trx_quotes_tl_rec.last_updated_by;

6384: x_okl_trx_quotes_tl_rec.creation_date := l_okl_trx_quotes_tl_rec.creation_date;
6385: END IF;
6386: IF (x_okl_trx_quotes_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
6387: THEN
6388: x_okl_trx_quotes_tl_rec.last_updated_by := l_okl_trx_quotes_tl_rec.last_updated_by;
6389: END IF;
6390: IF (x_okl_trx_quotes_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
6391: THEN
6392: x_okl_trx_quotes_tl_rec.last_update_date := l_okl_trx_quotes_tl_rec.last_update_date;

Line 6390: IF (x_okl_trx_quotes_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

6386: IF (x_okl_trx_quotes_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
6387: THEN
6388: x_okl_trx_quotes_tl_rec.last_updated_by := l_okl_trx_quotes_tl_rec.last_updated_by;
6389: END IF;
6390: IF (x_okl_trx_quotes_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
6391: THEN
6392: x_okl_trx_quotes_tl_rec.last_update_date := l_okl_trx_quotes_tl_rec.last_update_date;
6393: END IF;
6394: IF (x_okl_trx_quotes_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 6392: x_okl_trx_quotes_tl_rec.last_update_date := l_okl_trx_quotes_tl_rec.last_update_date;

6388: x_okl_trx_quotes_tl_rec.last_updated_by := l_okl_trx_quotes_tl_rec.last_updated_by;
6389: END IF;
6390: IF (x_okl_trx_quotes_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
6391: THEN
6392: x_okl_trx_quotes_tl_rec.last_update_date := l_okl_trx_quotes_tl_rec.last_update_date;
6393: END IF;
6394: IF (x_okl_trx_quotes_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
6395: THEN
6396: x_okl_trx_quotes_tl_rec.last_update_login := l_okl_trx_quotes_tl_rec.last_update_login;

Line 6394: IF (x_okl_trx_quotes_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

6390: IF (x_okl_trx_quotes_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
6391: THEN
6392: x_okl_trx_quotes_tl_rec.last_update_date := l_okl_trx_quotes_tl_rec.last_update_date;
6393: END IF;
6394: IF (x_okl_trx_quotes_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
6395: THEN
6396: x_okl_trx_quotes_tl_rec.last_update_login := l_okl_trx_quotes_tl_rec.last_update_login;
6397: END IF;
6398: RETURN(l_return_status);

Line 6396: x_okl_trx_quotes_tl_rec.last_update_login := l_okl_trx_quotes_tl_rec.last_update_login;

6392: x_okl_trx_quotes_tl_rec.last_update_date := l_okl_trx_quotes_tl_rec.last_update_date;
6393: END IF;
6394: IF (x_okl_trx_quotes_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
6395: THEN
6396: x_okl_trx_quotes_tl_rec.last_update_login := l_okl_trx_quotes_tl_rec.last_update_login;
6397: END IF;
6398: RETURN(l_return_status);
6399: END populate_new_record;
6400: ------------------------------------------

Line 6401: -- Set_Attributes for:OKL_TRX_QUOTES_TL --

6397: END IF;
6398: RETURN(l_return_status);
6399: END populate_new_record;
6400: ------------------------------------------
6401: -- Set_Attributes for:OKL_TRX_QUOTES_TL --
6402: ------------------------------------------
6403: FUNCTION Set_Attributes (
6404: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type,
6405: x_okl_trx_quotes_tl_rec OUT NOCOPY okl_trx_quotes_tl_rec_type

Line 6404: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type,

6400: ------------------------------------------
6401: -- Set_Attributes for:OKL_TRX_QUOTES_TL --
6402: ------------------------------------------
6403: FUNCTION Set_Attributes (
6404: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type,
6405: x_okl_trx_quotes_tl_rec OUT NOCOPY okl_trx_quotes_tl_rec_type
6406: ) RETURN VARCHAR2 IS
6407: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
6408: BEGIN

Line 6405: x_okl_trx_quotes_tl_rec OUT NOCOPY okl_trx_quotes_tl_rec_type

6401: -- Set_Attributes for:OKL_TRX_QUOTES_TL --
6402: ------------------------------------------
6403: FUNCTION Set_Attributes (
6404: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type,
6405: x_okl_trx_quotes_tl_rec OUT NOCOPY okl_trx_quotes_tl_rec_type
6406: ) RETURN VARCHAR2 IS
6407: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
6408: BEGIN
6409: x_okl_trx_quotes_tl_rec := p_okl_trx_quotes_tl_rec;

Line 6409: x_okl_trx_quotes_tl_rec := p_okl_trx_quotes_tl_rec;

6405: x_okl_trx_quotes_tl_rec OUT NOCOPY okl_trx_quotes_tl_rec_type
6406: ) RETURN VARCHAR2 IS
6407: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
6408: BEGIN
6409: x_okl_trx_quotes_tl_rec := p_okl_trx_quotes_tl_rec;
6410: x_okl_trx_quotes_tl_rec.LANGUAGE := USERENV('LANG');
6411: x_okl_trx_quotes_tl_rec.SOURCE_LANG := USERENV('LANG');
6412: RETURN(l_return_status);
6413: END Set_Attributes;

Line 6410: x_okl_trx_quotes_tl_rec.LANGUAGE := USERENV('LANG');

6406: ) RETURN VARCHAR2 IS
6407: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
6408: BEGIN
6409: x_okl_trx_quotes_tl_rec := p_okl_trx_quotes_tl_rec;
6410: x_okl_trx_quotes_tl_rec.LANGUAGE := USERENV('LANG');
6411: x_okl_trx_quotes_tl_rec.SOURCE_LANG := USERENV('LANG');
6412: RETURN(l_return_status);
6413: END Set_Attributes;
6414: BEGIN

Line 6411: x_okl_trx_quotes_tl_rec.SOURCE_LANG := USERENV('LANG');

6407: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
6408: BEGIN
6409: x_okl_trx_quotes_tl_rec := p_okl_trx_quotes_tl_rec;
6410: x_okl_trx_quotes_tl_rec.LANGUAGE := USERENV('LANG');
6411: x_okl_trx_quotes_tl_rec.SOURCE_LANG := USERENV('LANG');
6412: RETURN(l_return_status);
6413: END Set_Attributes;
6414: BEGIN
6415: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 6426: p_okl_trx_quotes_tl_rec, -- IN

6422: RAISE OKC_API.G_EXCEPTION_ERROR;
6423: END IF;
6424: --- Setting item attributes
6425: l_return_status := Set_Attributes(
6426: p_okl_trx_quotes_tl_rec, -- IN
6427: l_okl_trx_quotes_tl_rec); -- OUT
6428: --- If any errors happen abort API
6429: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6430: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 6427: l_okl_trx_quotes_tl_rec); -- OUT

6423: END IF;
6424: --- Setting item attributes
6425: l_return_status := Set_Attributes(
6426: p_okl_trx_quotes_tl_rec, -- IN
6427: l_okl_trx_quotes_tl_rec); -- OUT
6428: --- If any errors happen abort API
6429: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6430: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6431: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 6434: l_return_status := populate_new_record(l_okl_trx_quotes_tl_rec, l_def_okl_trx_quotes_tl_rec);

6430: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6431: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
6432: RAISE OKC_API.G_EXCEPTION_ERROR;
6433: END IF;
6434: l_return_status := populate_new_record(l_okl_trx_quotes_tl_rec, l_def_okl_trx_quotes_tl_rec);
6435: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6436: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6437: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
6438: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 6440: UPDATE OKL_TRX_QUOTES_TL

6436: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6437: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
6438: RAISE OKC_API.G_EXCEPTION_ERROR;
6439: END IF;
6440: UPDATE OKL_TRX_QUOTES_TL
6441: SET COMMENTS = l_def_okl_trx_quotes_tl_rec.comments,
6442: SOURCE_LANG = l_def_okl_trx_quotes_tl_rec.source_lang,--Fix fro bug 3637102
6443: CREATED_BY = l_def_okl_trx_quotes_tl_rec.created_by,
6444: CREATION_DATE = l_def_okl_trx_quotes_tl_rec.creation_date,

Line 6441: SET COMMENTS = l_def_okl_trx_quotes_tl_rec.comments,

6437: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
6438: RAISE OKC_API.G_EXCEPTION_ERROR;
6439: END IF;
6440: UPDATE OKL_TRX_QUOTES_TL
6441: SET COMMENTS = l_def_okl_trx_quotes_tl_rec.comments,
6442: SOURCE_LANG = l_def_okl_trx_quotes_tl_rec.source_lang,--Fix fro bug 3637102
6443: CREATED_BY = l_def_okl_trx_quotes_tl_rec.created_by,
6444: CREATION_DATE = l_def_okl_trx_quotes_tl_rec.creation_date,
6445: LAST_UPDATED_BY = l_def_okl_trx_quotes_tl_rec.last_updated_by,

Line 6442: SOURCE_LANG = l_def_okl_trx_quotes_tl_rec.source_lang,--Fix fro bug 3637102

6438: RAISE OKC_API.G_EXCEPTION_ERROR;
6439: END IF;
6440: UPDATE OKL_TRX_QUOTES_TL
6441: SET COMMENTS = l_def_okl_trx_quotes_tl_rec.comments,
6442: SOURCE_LANG = l_def_okl_trx_quotes_tl_rec.source_lang,--Fix fro bug 3637102
6443: CREATED_BY = l_def_okl_trx_quotes_tl_rec.created_by,
6444: CREATION_DATE = l_def_okl_trx_quotes_tl_rec.creation_date,
6445: LAST_UPDATED_BY = l_def_okl_trx_quotes_tl_rec.last_updated_by,
6446: LAST_UPDATE_DATE = l_def_okl_trx_quotes_tl_rec.last_update_date,

Line 6443: CREATED_BY = l_def_okl_trx_quotes_tl_rec.created_by,

6439: END IF;
6440: UPDATE OKL_TRX_QUOTES_TL
6441: SET COMMENTS = l_def_okl_trx_quotes_tl_rec.comments,
6442: SOURCE_LANG = l_def_okl_trx_quotes_tl_rec.source_lang,--Fix fro bug 3637102
6443: CREATED_BY = l_def_okl_trx_quotes_tl_rec.created_by,
6444: CREATION_DATE = l_def_okl_trx_quotes_tl_rec.creation_date,
6445: LAST_UPDATED_BY = l_def_okl_trx_quotes_tl_rec.last_updated_by,
6446: LAST_UPDATE_DATE = l_def_okl_trx_quotes_tl_rec.last_update_date,
6447: LAST_UPDATE_LOGIN = l_def_okl_trx_quotes_tl_rec.last_update_login

Line 6444: CREATION_DATE = l_def_okl_trx_quotes_tl_rec.creation_date,

6440: UPDATE OKL_TRX_QUOTES_TL
6441: SET COMMENTS = l_def_okl_trx_quotes_tl_rec.comments,
6442: SOURCE_LANG = l_def_okl_trx_quotes_tl_rec.source_lang,--Fix fro bug 3637102
6443: CREATED_BY = l_def_okl_trx_quotes_tl_rec.created_by,
6444: CREATION_DATE = l_def_okl_trx_quotes_tl_rec.creation_date,
6445: LAST_UPDATED_BY = l_def_okl_trx_quotes_tl_rec.last_updated_by,
6446: LAST_UPDATE_DATE = l_def_okl_trx_quotes_tl_rec.last_update_date,
6447: LAST_UPDATE_LOGIN = l_def_okl_trx_quotes_tl_rec.last_update_login
6448: WHERE ID = l_def_okl_trx_quotes_tl_rec.id

Line 6445: LAST_UPDATED_BY = l_def_okl_trx_quotes_tl_rec.last_updated_by,

6441: SET COMMENTS = l_def_okl_trx_quotes_tl_rec.comments,
6442: SOURCE_LANG = l_def_okl_trx_quotes_tl_rec.source_lang,--Fix fro bug 3637102
6443: CREATED_BY = l_def_okl_trx_quotes_tl_rec.created_by,
6444: CREATION_DATE = l_def_okl_trx_quotes_tl_rec.creation_date,
6445: LAST_UPDATED_BY = l_def_okl_trx_quotes_tl_rec.last_updated_by,
6446: LAST_UPDATE_DATE = l_def_okl_trx_quotes_tl_rec.last_update_date,
6447: LAST_UPDATE_LOGIN = l_def_okl_trx_quotes_tl_rec.last_update_login
6448: WHERE ID = l_def_okl_trx_quotes_tl_rec.id
6449: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);--Fix for bug 3637102

Line 6446: LAST_UPDATE_DATE = l_def_okl_trx_quotes_tl_rec.last_update_date,

6442: SOURCE_LANG = l_def_okl_trx_quotes_tl_rec.source_lang,--Fix fro bug 3637102
6443: CREATED_BY = l_def_okl_trx_quotes_tl_rec.created_by,
6444: CREATION_DATE = l_def_okl_trx_quotes_tl_rec.creation_date,
6445: LAST_UPDATED_BY = l_def_okl_trx_quotes_tl_rec.last_updated_by,
6446: LAST_UPDATE_DATE = l_def_okl_trx_quotes_tl_rec.last_update_date,
6447: LAST_UPDATE_LOGIN = l_def_okl_trx_quotes_tl_rec.last_update_login
6448: WHERE ID = l_def_okl_trx_quotes_tl_rec.id
6449: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);--Fix for bug 3637102
6450: --AND SOURCE_LANG = USERENV('LANG');

Line 6447: LAST_UPDATE_LOGIN = l_def_okl_trx_quotes_tl_rec.last_update_login

6443: CREATED_BY = l_def_okl_trx_quotes_tl_rec.created_by,
6444: CREATION_DATE = l_def_okl_trx_quotes_tl_rec.creation_date,
6445: LAST_UPDATED_BY = l_def_okl_trx_quotes_tl_rec.last_updated_by,
6446: LAST_UPDATE_DATE = l_def_okl_trx_quotes_tl_rec.last_update_date,
6447: LAST_UPDATE_LOGIN = l_def_okl_trx_quotes_tl_rec.last_update_login
6448: WHERE ID = l_def_okl_trx_quotes_tl_rec.id
6449: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);--Fix for bug 3637102
6450: --AND SOURCE_LANG = USERENV('LANG');
6451:

Line 6448: WHERE ID = l_def_okl_trx_quotes_tl_rec.id

6444: CREATION_DATE = l_def_okl_trx_quotes_tl_rec.creation_date,
6445: LAST_UPDATED_BY = l_def_okl_trx_quotes_tl_rec.last_updated_by,
6446: LAST_UPDATE_DATE = l_def_okl_trx_quotes_tl_rec.last_update_date,
6447: LAST_UPDATE_LOGIN = l_def_okl_trx_quotes_tl_rec.last_update_login
6448: WHERE ID = l_def_okl_trx_quotes_tl_rec.id
6449: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);--Fix for bug 3637102
6450: --AND SOURCE_LANG = USERENV('LANG');
6451:
6452: UPDATE OKL_TRX_QUOTES_TL

Line 6452: UPDATE OKL_TRX_QUOTES_TL

6448: WHERE ID = l_def_okl_trx_quotes_tl_rec.id
6449: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);--Fix for bug 3637102
6450: --AND SOURCE_LANG = USERENV('LANG');
6451:
6452: UPDATE OKL_TRX_QUOTES_TL
6453: SET SFWT_FLAG = 'Y'
6454: WHERE ID = l_def_okl_trx_quotes_tl_rec.id
6455: AND SOURCE_LANG <> USERENV('LANG');
6456:

Line 6454: WHERE ID = l_def_okl_trx_quotes_tl_rec.id

6450: --AND SOURCE_LANG = USERENV('LANG');
6451:
6452: UPDATE OKL_TRX_QUOTES_TL
6453: SET SFWT_FLAG = 'Y'
6454: WHERE ID = l_def_okl_trx_quotes_tl_rec.id
6455: AND SOURCE_LANG <> USERENV('LANG');
6456:
6457: x_okl_trx_quotes_tl_rec := l_def_okl_trx_quotes_tl_rec;
6458: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 6457: x_okl_trx_quotes_tl_rec := l_def_okl_trx_quotes_tl_rec;

6453: SET SFWT_FLAG = 'Y'
6454: WHERE ID = l_def_okl_trx_quotes_tl_rec.id
6455: AND SOURCE_LANG <> USERENV('LANG');
6456:
6457: x_okl_trx_quotes_tl_rec := l_def_okl_trx_quotes_tl_rec;
6458: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
6459: EXCEPTION
6460: WHEN OKC_API.G_EXCEPTION_ERROR THEN
6461: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 6519: l_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;

6515: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
6516: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
6517: l_qtev_rec qtev_rec_type := p_qtev_rec;
6518: l_def_qtev_rec qtev_rec_type;
6519: l_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;
6520: lx_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;
6521: l_qte_rec qte_rec_type;
6522: lx_qte_rec qte_rec_type;
6523: -------------------------------

Line 6520: lx_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;

6516: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
6517: l_qtev_rec qtev_rec_type := p_qtev_rec;
6518: l_def_qtev_rec qtev_rec_type;
6519: l_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;
6520: lx_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;
6521: l_qte_rec qte_rec_type;
6522: lx_qte_rec qte_rec_type;
6523: -------------------------------
6524: -- FUNCTION fill_who_columns --

Line 6965: migrate(l_def_qtev_rec, l_okl_trx_quotes_tl_rec);

6961:
6962: --------------------------------------
6963: -- Move VIEW record to "Child" records
6964: --------------------------------------
6965: migrate(l_def_qtev_rec, l_okl_trx_quotes_tl_rec);
6966: migrate(l_def_qtev_rec, l_qte_rec);
6967: --------------------------------------------
6968: -- Call the UPDATE_ROW for each child record
6969: --------------------------------------------

Line 6975: l_okl_trx_quotes_tl_rec,

6971: p_init_msg_list,
6972: x_return_status,
6973: x_msg_count,
6974: x_msg_data,
6975: l_okl_trx_quotes_tl_rec,
6976: lx_okl_trx_quotes_tl_rec
6977: );
6978: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6979: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 6976: lx_okl_trx_quotes_tl_rec

6972: x_return_status,
6973: x_msg_count,
6974: x_msg_data,
6975: l_okl_trx_quotes_tl_rec,
6976: lx_okl_trx_quotes_tl_rec
6977: );
6978: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6979: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6980: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 6983: migrate(lx_okl_trx_quotes_tl_rec, l_def_qtev_rec);

6979: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6980: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6981: RAISE OKC_API.G_EXCEPTION_ERROR;
6982: END IF;
6983: migrate(lx_okl_trx_quotes_tl_rec, l_def_qtev_rec);
6984: update_row(
6985: p_init_msg_list,
6986: x_return_status,
6987: x_msg_count,

Line 7182: -- delete_row for:OKL_TRX_QUOTES_TL --

7178: '_PVT'
7179: );
7180: END delete_row;
7181: --------------------------------------
7182: -- delete_row for:OKL_TRX_QUOTES_TL --
7183: --------------------------------------
7184: PROCEDURE delete_row(
7185: p_init_msg_list IN VARCHAR2,
7186: x_return_status OUT NOCOPY VARCHAR2,

Line 7189: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type) IS

7185: p_init_msg_list IN VARCHAR2,
7186: x_return_status OUT NOCOPY VARCHAR2,
7187: x_msg_count OUT NOCOPY NUMBER,
7188: x_msg_data OUT NOCOPY VARCHAR2,
7189: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type) IS
7190:
7191: l_api_version CONSTANT NUMBER := 1;
7192: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
7193: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 7194: l_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type:= p_okl_trx_quotes_tl_rec;

7190:
7191: l_api_version CONSTANT NUMBER := 1;
7192: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
7193: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7194: l_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type:= p_okl_trx_quotes_tl_rec;
7195: l_row_notfound BOOLEAN := TRUE;
7196: ------------------------------------------
7197: -- Set_Attributes for:OKL_TRX_QUOTES_TL --
7198: ------------------------------------------

Line 7197: -- Set_Attributes for:OKL_TRX_QUOTES_TL --

7193: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7194: l_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type:= p_okl_trx_quotes_tl_rec;
7195: l_row_notfound BOOLEAN := TRUE;
7196: ------------------------------------------
7197: -- Set_Attributes for:OKL_TRX_QUOTES_TL --
7198: ------------------------------------------
7199: FUNCTION Set_Attributes (
7200: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type,
7201: x_okl_trx_quotes_tl_rec OUT NOCOPY okl_trx_quotes_tl_rec_type

Line 7200: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type,

7196: ------------------------------------------
7197: -- Set_Attributes for:OKL_TRX_QUOTES_TL --
7198: ------------------------------------------
7199: FUNCTION Set_Attributes (
7200: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type,
7201: x_okl_trx_quotes_tl_rec OUT NOCOPY okl_trx_quotes_tl_rec_type
7202: ) RETURN VARCHAR2 IS
7203: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7204: BEGIN

Line 7201: x_okl_trx_quotes_tl_rec OUT NOCOPY okl_trx_quotes_tl_rec_type

7197: -- Set_Attributes for:OKL_TRX_QUOTES_TL --
7198: ------------------------------------------
7199: FUNCTION Set_Attributes (
7200: p_okl_trx_quotes_tl_rec IN okl_trx_quotes_tl_rec_type,
7201: x_okl_trx_quotes_tl_rec OUT NOCOPY okl_trx_quotes_tl_rec_type
7202: ) RETURN VARCHAR2 IS
7203: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7204: BEGIN
7205: x_okl_trx_quotes_tl_rec := p_okl_trx_quotes_tl_rec;

Line 7205: x_okl_trx_quotes_tl_rec := p_okl_trx_quotes_tl_rec;

7201: x_okl_trx_quotes_tl_rec OUT NOCOPY okl_trx_quotes_tl_rec_type
7202: ) RETURN VARCHAR2 IS
7203: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7204: BEGIN
7205: x_okl_trx_quotes_tl_rec := p_okl_trx_quotes_tl_rec;
7206: x_okl_trx_quotes_tl_rec.LANGUAGE := USERENV('LANG');
7207: RETURN(l_return_status);
7208: END Set_Attributes;
7209: BEGIN

Line 7206: x_okl_trx_quotes_tl_rec.LANGUAGE := USERENV('LANG');

7202: ) RETURN VARCHAR2 IS
7203: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7204: BEGIN
7205: x_okl_trx_quotes_tl_rec := p_okl_trx_quotes_tl_rec;
7206: x_okl_trx_quotes_tl_rec.LANGUAGE := USERENV('LANG');
7207: RETURN(l_return_status);
7208: END Set_Attributes;
7209: BEGIN
7210: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 7221: p_okl_trx_quotes_tl_rec, -- IN

7217: RAISE OKC_API.G_EXCEPTION_ERROR;
7218: END IF;
7219: --- Setting item attributes
7220: l_return_status := Set_Attributes(
7221: p_okl_trx_quotes_tl_rec, -- IN
7222: l_okl_trx_quotes_tl_rec); -- OUT
7223: --- If any errors happen abort API
7224: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7225: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 7222: l_okl_trx_quotes_tl_rec); -- OUT

7218: END IF;
7219: --- Setting item attributes
7220: l_return_status := Set_Attributes(
7221: p_okl_trx_quotes_tl_rec, -- IN
7222: l_okl_trx_quotes_tl_rec); -- OUT
7223: --- If any errors happen abort API
7224: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7225: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7226: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 7229: DELETE FROM OKL_TRX_QUOTES_TL

7225: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7226: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
7227: RAISE OKC_API.G_EXCEPTION_ERROR;
7228: END IF;
7229: DELETE FROM OKL_TRX_QUOTES_TL
7230: WHERE ID = l_okl_trx_quotes_tl_rec.id;
7231:
7232: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
7233: EXCEPTION

Line 7230: WHERE ID = l_okl_trx_quotes_tl_rec.id;

7226: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
7227: RAISE OKC_API.G_EXCEPTION_ERROR;
7228: END IF;
7229: DELETE FROM OKL_TRX_QUOTES_TL
7230: WHERE ID = l_okl_trx_quotes_tl_rec.id;
7231:
7232: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
7233: EXCEPTION
7234: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 7280: l_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;

7276: l_api_version CONSTANT NUMBER := 1;
7277: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
7278: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7279: l_qtev_rec qtev_rec_type := p_qtev_rec;
7280: l_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;
7281: l_qte_rec qte_rec_type;
7282: BEGIN
7283: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
7284: G_PKG_NAME,

Line 7298: migrate(l_qtev_rec, l_okl_trx_quotes_tl_rec);

7294: END IF;
7295: --------------------------------------
7296: -- Move VIEW record to "Child" records
7297: --------------------------------------
7298: migrate(l_qtev_rec, l_okl_trx_quotes_tl_rec);
7299: migrate(l_qtev_rec, l_qte_rec);
7300: --------------------------------------------
7301: -- Call the DELETE_ROW for each child record
7302: --------------------------------------------

Line 7308: l_okl_trx_quotes_tl_rec

7304: p_init_msg_list,
7305: x_return_status,
7306: x_msg_count,
7307: x_msg_data,
7308: l_okl_trx_quotes_tl_rec
7309: );
7310: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7311: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7312: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN