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_TQL_PVT dependencies on OKL_TXL_QUOTE_LINES_B

Line 1128: -- FUNCTION get_rec for: OKL_TXL_QUOTE_LINES_B

1124:
1125: END add_language;
1126:
1127: ---------------------------------------------------------------------------
1128: -- FUNCTION get_rec for: OKL_TXL_QUOTE_LINES_B
1129: ---------------------------------------------------------------------------
1130: -- Start of comments
1131: -- Function Name : get_rec
1132: -- Description : get record structure of OKL_TXL_QUOTE_LINES_B table

Line 1132: -- Description : get record structure of OKL_TXL_QUOTE_LINES_B table

1128: -- FUNCTION get_rec for: OKL_TXL_QUOTE_LINES_B
1129: ---------------------------------------------------------------------------
1130: -- Start of comments
1131: -- Function Name : get_rec
1132: -- Description : get record structure of OKL_TXL_QUOTE_LINES_B table
1133: -- Business Rules :
1134: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_B table
1135: -- Version : 1.0
1136: -- History : 18-DEC-2002 BAKUCHIB 2667636 Modified

Line 1134: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_B table

1130: -- Start of comments
1131: -- Function Name : get_rec
1132: -- Description : get record structure of OKL_TXL_QUOTE_LINES_B table
1133: -- Business Rules :
1134: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_B table
1135: -- Version : 1.0
1136: -- History : 18-DEC-2002 BAKUCHIB 2667636 Modified
1137: -- : Added columns Currency code, currency Conversion_code
1138: -- Currency conversion type, currency conversion date

Line 1210: FROM Okl_Txl_Quote_Lines_B

1206: CURRENCY_CONVERSION_DATE,
1207: -- BAKUCHIB 2667636 End
1208: DUE_DATE, -- PAGARG 4161133
1209: try_id -- rmunjulu Sales_Tax_Enhancement
1210: FROM Okl_Txl_Quote_Lines_B
1211: WHERE okl_txl_quote_lines_b.id = p_id;
1212: l_tql_pk tql_pk_csr%ROWTYPE;
1213: l_tql_rec tql_rec_type;
1214: BEGIN

Line 1211: WHERE okl_txl_quote_lines_b.id = p_id;

1207: -- BAKUCHIB 2667636 End
1208: DUE_DATE, -- PAGARG 4161133
1209: try_id -- rmunjulu Sales_Tax_Enhancement
1210: FROM Okl_Txl_Quote_Lines_B
1211: WHERE okl_txl_quote_lines_b.id = p_id;
1212: l_tql_pk tql_pk_csr%ROWTYPE;
1213: l_tql_rec tql_rec_type;
1214: BEGIN
1215: x_no_data_found := TRUE;

Line 1966: -- to record structure of OKL_TXL_QUOTE_LINES_B table

1962: ---------------------------------------------------------------------------
1963: -- Start of comments
1964: -- Procedure Name : Migrate
1965: -- Description : Migrate record structure of OKL_TXL_QUOTE_LINES_V table
1966: -- to record structure of OKL_TXL_QUOTE_LINES_B table
1967: -- Business Rules :
1968: -- Parameters : IN Record structure of OKL_TXL_QUOTE_LINES_V table
1969: -- IN OUT Record structure of OKL_TXL_QUOTE_LINES_B table
1970: -- Version : 1.0

Line 1969: -- IN OUT Record structure of OKL_TXL_QUOTE_LINES_B table

1965: -- Description : Migrate record structure of OKL_TXL_QUOTE_LINES_V table
1966: -- to record structure of OKL_TXL_QUOTE_LINES_B table
1967: -- Business Rules :
1968: -- Parameters : IN Record structure of OKL_TXL_QUOTE_LINES_V table
1969: -- IN OUT Record structure of OKL_TXL_QUOTE_LINES_B table
1970: -- Version : 1.0
1971: -- History : 18-DEC-2002 BAKUCHIB 2667636 Modified
1972: -- : Added columns Currency code, currency Conversion_code
1973: -- Currency conversion type, currency conversion date

Line 2049: -- Description : Migrate record structure of OKL_TXL_QUOTE_LINES_B table

2045: END migrate;
2046:
2047: -- Start of comments
2048: -- Procedure Name : Migrate
2049: -- Description : Migrate record structure of OKL_TXL_QUOTE_LINES_B table
2050: -- to record structure of OKL_TXL_QUOTE_LINES_V table
2051: -- Business Rules :
2052: -- Parameters : IN Record structure of OKL_TXL_QUOTE_LINES_B table
2053: -- IN OUT Record structure of OKL_TXL_QUOTE_LINES_V table

Line 2052: -- Parameters : IN Record structure of OKL_TXL_QUOTE_LINES_B table

2048: -- Procedure Name : Migrate
2049: -- Description : Migrate record structure of OKL_TXL_QUOTE_LINES_B table
2050: -- to record structure of OKL_TXL_QUOTE_LINES_V table
2051: -- Business Rules :
2052: -- Parameters : IN Record structure of OKL_TXL_QUOTE_LINES_B table
2053: -- IN OUT Record structure of OKL_TXL_QUOTE_LINES_V table
2054: -- Version : 1.0
2055: -- History : 18-DEC-2002 BAKUCHIB 2667636 Modified
2056: -- : Added columns Currency code, currency Conversion_code

Line 2325: -- insert_row for:OKL_TXL_QUOTE_LINES_B --

2321: ---------------------------------------------------------------------------
2322: -- PROCEDURE insert_row
2323: ---------------------------------------------------------------------------
2324: ------------------------------------------
2325: -- insert_row for:OKL_TXL_QUOTE_LINES_B --
2326: ------------------------------------------
2327: -- Start of comments
2328: -- Procedure Name : insert_row
2329: -- Description : Insert Row into OKL_TXL_QUOTE_LINES_B table

Line 2329: -- Description : Insert Row into OKL_TXL_QUOTE_LINES_B table

2325: -- insert_row for:OKL_TXL_QUOTE_LINES_B --
2326: ------------------------------------------
2327: -- Start of comments
2328: -- Procedure Name : insert_row
2329: -- Description : Insert Row into OKL_TXL_QUOTE_LINES_B table
2330: -- Business Rules :
2331: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_B table
2332: -- Version : 1.0
2333: -- History : 18-DEC-2002 BAKUCHIB 2667636 Modified

Line 2331: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_B table

2327: -- Start of comments
2328: -- Procedure Name : insert_row
2329: -- Description : Insert Row into OKL_TXL_QUOTE_LINES_B table
2330: -- Business Rules :
2331: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_B table
2332: -- Version : 1.0
2333: -- History : 18-DEC-2002 BAKUCHIB 2667636 Modified
2334: -- : Added columns Currency code, currency Conversion_code
2335: -- Currency conversion type, currency conversion date

Line 2353: -- Set_Attributes for:OKL_TXL_QUOTE_LINES_B --

2349: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2350: l_tql_rec tql_rec_type := p_tql_rec;
2351: l_def_tql_rec tql_rec_type;
2352: ----------------------------------------------
2353: -- Set_Attributes for:OKL_TXL_QUOTE_LINES_B --
2354: ----------------------------------------------
2355: FUNCTION Set_Attributes (
2356: p_tql_rec IN tql_rec_type,
2357: x_tql_rec OUT NOCOPY tql_rec_type

Line 2387: INSERT INTO OKL_TXL_QUOTE_LINES_B(

2383: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2384: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2385: RAISE OKC_API.G_EXCEPTION_ERROR;
2386: END IF;
2387: INSERT INTO OKL_TXL_QUOTE_LINES_B(
2388: id,
2389: sty_id,
2390: kle_id,
2391: qlt_code,

Line 3270: INSERT INTO OKL_TXL_QUOTE_LINES_B(

3266: END LOOP;
3267:
3268: -- Bulk insert into base table
3269: FORALL i in 1..l_tabsize
3270: INSERT INTO OKL_TXL_QUOTE_LINES_B(
3271: id,
3272: sty_id,
3273: kle_id,
3274: qlt_code,

Line 3459: -- lock_row for:OKL_TXL_QUOTE_LINES_B --

3455: ---------------------------------------------------------------------------
3456: -- PROCEDURE lock_row
3457: ---------------------------------------------------------------------------
3458: ----------------------------------------
3459: -- lock_row for:OKL_TXL_QUOTE_LINES_B --
3460: ----------------------------------------
3461: PROCEDURE lock_row(
3462: p_init_msg_list IN VARCHAR2,
3463: x_return_status OUT NOCOPY VARCHAR2,

Line 3472: FROM OKL_TXL_QUOTE_LINES_B

3468: E_Resource_Busy EXCEPTION;
3469: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3470: CURSOR lock_csr (p_tql_rec IN tql_rec_type) IS
3471: SELECT OBJECT_VERSION_NUMBER
3472: FROM OKL_TXL_QUOTE_LINES_B
3473: WHERE ID = p_tql_rec.id
3474: AND OBJECT_VERSION_NUMBER = p_tql_rec.object_version_number
3475: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3476:

Line 3479: FROM OKL_TXL_QUOTE_LINES_B

3475: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3476:
3477: CURSOR lchk_csr (p_tql_rec IN tql_rec_type) IS
3478: SELECT OBJECT_VERSION_NUMBER
3479: FROM OKL_TXL_QUOTE_LINES_B
3480: WHERE ID = p_tql_rec.id;
3481: l_api_version CONSTANT NUMBER := 1;
3482: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3483: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3484: l_object_version_number OKL_TXL_QUOTE_LINES_B.OBJECT_VERSION_NUMBER%TYPE;

3480: WHERE ID = p_tql_rec.id;
3481: l_api_version CONSTANT NUMBER := 1;
3482: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3483: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3484: l_object_version_number OKL_TXL_QUOTE_LINES_B.OBJECT_VERSION_NUMBER%TYPE;
3485: lc_object_version_number OKL_TXL_QUOTE_LINES_B.OBJECT_VERSION_NUMBER%TYPE;
3486: l_row_notfound BOOLEAN := FALSE;
3487: lc_row_notfound BOOLEAN := FALSE;
3488: BEGIN

Line 3485: lc_object_version_number OKL_TXL_QUOTE_LINES_B.OBJECT_VERSION_NUMBER%TYPE;

3481: l_api_version CONSTANT NUMBER := 1;
3482: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3483: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3484: l_object_version_number OKL_TXL_QUOTE_LINES_B.OBJECT_VERSION_NUMBER%TYPE;
3485: lc_object_version_number OKL_TXL_QUOTE_LINES_B.OBJECT_VERSION_NUMBER%TYPE;
3486: l_row_notfound BOOLEAN := FALSE;
3487: lc_row_notfound BOOLEAN := FALSE;
3488: BEGIN
3489: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3828: -- update_row for:OKL_TXL_QUOTE_LINES_B --

3824: ---------------------------------------------------------------------------
3825: -- PROCEDURE update_row
3826: ---------------------------------------------------------------------------
3827: ------------------------------------------
3828: -- update_row for:OKL_TXL_QUOTE_LINES_B --
3829: ------------------------------------------
3830: -- Start of comments
3831: -- Procedure Name : update_row
3832: -- Description : Update Row into OKL_TXL_QUOTE_LINES_B table

Line 3832: -- Description : Update Row into OKL_TXL_QUOTE_LINES_B table

3828: -- update_row for:OKL_TXL_QUOTE_LINES_B --
3829: ------------------------------------------
3830: -- Start of comments
3831: -- Procedure Name : update_row
3832: -- Description : Update Row into OKL_TXL_QUOTE_LINES_B table
3833: -- Business Rules :
3834: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_B table
3835: -- Version : 1.0
3836: -- History : 18-DEC-2002 BAKUCHIB 2667636 Modified

Line 3834: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_B table

3830: -- Start of comments
3831: -- Procedure Name : update_row
3832: -- Description : Update Row into OKL_TXL_QUOTE_LINES_B table
3833: -- Business Rules :
3834: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_B table
3835: -- Version : 1.0
3836: -- History : 18-DEC-2002 BAKUCHIB 2667636 Modified
3837: -- : Added columns Currency code, currency Conversion_code
3838: -- Currency conversion type, currency conversion date

Line 3861: -- Description : Populate new record into OKL_TXL_QUOTE_LINES_B table

3857: -- FUNCTION populate_new_record --
3858: ----------------------------------
3859: -- Start of comments
3860: -- Function Name : populate_new_record
3861: -- Description : Populate new record into OKL_TXL_QUOTE_LINES_B table
3862: -- Business Rules :
3863: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_B table
3864: -- Version : 1.0
3865: -- History : 18-DEC-2002 BAKUCHIB 2667636

Line 3863: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_B table

3859: -- Start of comments
3860: -- Function Name : populate_new_record
3861: -- Description : Populate new record into OKL_TXL_QUOTE_LINES_B table
3862: -- Business Rules :
3863: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_B table
3864: -- Version : 1.0
3865: -- History : 18-DEC-2002 BAKUCHIB 2667636
3866: -- : Added columns Currency code, currency Conversion_code
3867: -- Currency conversion type, currency conversion date

Line 4133: -- Set_Attributes for:OKL_TXL_QUOTE_LINES_B --

4129: END IF;
4130: RETURN(l_return_status);
4131: END populate_new_record;
4132: ----------------------------------------------
4133: -- Set_Attributes for:OKL_TXL_QUOTE_LINES_B --
4134: ----------------------------------------------
4135: FUNCTION Set_Attributes (
4136: p_tql_rec IN tql_rec_type,
4137: x_tql_rec OUT NOCOPY tql_rec_type

Line 4170: UPDATE OKL_TXL_QUOTE_LINES_B

4166: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4167: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4168: RAISE OKC_API.G_EXCEPTION_ERROR;
4169: END IF;
4170: UPDATE OKL_TXL_QUOTE_LINES_B
4171: SET STY_ID = l_def_tql_rec.sty_id,
4172: KLE_ID = l_def_tql_rec.kle_id,
4173: QLT_CODE = l_def_tql_rec.qlt_code,
4174: QTE_ID = l_def_tql_rec.qte_id,

Line 5022: -- delete_row for:OKL_TXL_QUOTE_LINES_B --

5018: ---------------------------------------------------------------------------
5019: -- PROCEDURE delete_row
5020: ---------------------------------------------------------------------------
5021: ------------------------------------------
5022: -- delete_row for:OKL_TXL_QUOTE_LINES_B --
5023: ------------------------------------------
5024: PROCEDURE delete_row(
5025: p_init_msg_list IN VARCHAR2,
5026: x_return_status OUT NOCOPY VARCHAR2,

Line 5046: DELETE FROM OKL_TXL_QUOTE_LINES_B

5042: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5043: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5044: RAISE OKC_API.G_EXCEPTION_ERROR;
5045: END IF;
5046: DELETE FROM OKL_TXL_QUOTE_LINES_B
5047: WHERE ID = l_tql_rec.id;
5048:
5049: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
5050: EXCEPTION