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 3276: INSERT INTO OKL_TXL_QUOTE_LINES_B(

3272: END LOOP;
3273:
3274: -- Bulk insert into base table
3275: FORALL i in 1..l_tabsize
3276: INSERT INTO OKL_TXL_QUOTE_LINES_B(
3277: id,
3278: sty_id,
3279: kle_id,
3280: qlt_code,

Line 3469: -- lock_row for:OKL_TXL_QUOTE_LINES_B --

3465: ---------------------------------------------------------------------------
3466: -- PROCEDURE lock_row
3467: ---------------------------------------------------------------------------
3468: ----------------------------------------
3469: -- lock_row for:OKL_TXL_QUOTE_LINES_B --
3470: ----------------------------------------
3471: PROCEDURE lock_row(
3472: p_init_msg_list IN VARCHAR2,
3473: x_return_status OUT NOCOPY VARCHAR2,

Line 3482: FROM OKL_TXL_QUOTE_LINES_B

3478: E_Resource_Busy EXCEPTION;
3479: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3480: CURSOR lock_csr (p_tql_rec IN tql_rec_type) IS
3481: SELECT OBJECT_VERSION_NUMBER
3482: FROM OKL_TXL_QUOTE_LINES_B
3483: WHERE ID = p_tql_rec.id
3484: AND OBJECT_VERSION_NUMBER = p_tql_rec.object_version_number
3485: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3486:

Line 3489: FROM OKL_TXL_QUOTE_LINES_B

3485: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3486:
3487: CURSOR lchk_csr (p_tql_rec IN tql_rec_type) IS
3488: SELECT OBJECT_VERSION_NUMBER
3489: FROM OKL_TXL_QUOTE_LINES_B
3490: WHERE ID = p_tql_rec.id;
3491: l_api_version CONSTANT NUMBER := 1;
3492: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3493: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3494: l_object_version_number OKL_TXL_QUOTE_LINES_B.OBJECT_VERSION_NUMBER%TYPE;

3490: WHERE ID = p_tql_rec.id;
3491: l_api_version CONSTANT NUMBER := 1;
3492: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3493: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3494: l_object_version_number OKL_TXL_QUOTE_LINES_B.OBJECT_VERSION_NUMBER%TYPE;
3495: lc_object_version_number OKL_TXL_QUOTE_LINES_B.OBJECT_VERSION_NUMBER%TYPE;
3496: l_row_notfound BOOLEAN := FALSE;
3497: lc_row_notfound BOOLEAN := FALSE;
3498: BEGIN

Line 3495: lc_object_version_number OKL_TXL_QUOTE_LINES_B.OBJECT_VERSION_NUMBER%TYPE;

3491: l_api_version CONSTANT NUMBER := 1;
3492: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3493: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3494: l_object_version_number OKL_TXL_QUOTE_LINES_B.OBJECT_VERSION_NUMBER%TYPE;
3495: lc_object_version_number OKL_TXL_QUOTE_LINES_B.OBJECT_VERSION_NUMBER%TYPE;
3496: l_row_notfound BOOLEAN := FALSE;
3497: lc_row_notfound BOOLEAN := FALSE;
3498: BEGIN
3499: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3838: -- update_row for:OKL_TXL_QUOTE_LINES_B --

3834: ---------------------------------------------------------------------------
3835: -- PROCEDURE update_row
3836: ---------------------------------------------------------------------------
3837: ------------------------------------------
3838: -- update_row for:OKL_TXL_QUOTE_LINES_B --
3839: ------------------------------------------
3840: -- Start of comments
3841: -- Procedure Name : update_row
3842: -- Description : Update Row into OKL_TXL_QUOTE_LINES_B table

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

3838: -- update_row for:OKL_TXL_QUOTE_LINES_B --
3839: ------------------------------------------
3840: -- Start of comments
3841: -- Procedure Name : update_row
3842: -- Description : Update Row into OKL_TXL_QUOTE_LINES_B table
3843: -- Business Rules :
3844: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_B table
3845: -- Version : 1.0
3846: -- History : 18-DEC-2002 BAKUCHIB 2667636 Modified

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

3840: -- Start of comments
3841: -- Procedure Name : update_row
3842: -- Description : Update Row into OKL_TXL_QUOTE_LINES_B table
3843: -- Business Rules :
3844: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_B table
3845: -- Version : 1.0
3846: -- History : 18-DEC-2002 BAKUCHIB 2667636 Modified
3847: -- : Added columns Currency code, currency Conversion_code
3848: -- Currency conversion type, currency conversion date

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

3867: -- FUNCTION populate_new_record --
3868: ----------------------------------
3869: -- Start of comments
3870: -- Function Name : populate_new_record
3871: -- Description : Populate new record into OKL_TXL_QUOTE_LINES_B table
3872: -- Business Rules :
3873: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_B table
3874: -- Version : 1.0
3875: -- History : 18-DEC-2002 BAKUCHIB 2667636

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

3869: -- Start of comments
3870: -- Function Name : populate_new_record
3871: -- Description : Populate new record into OKL_TXL_QUOTE_LINES_B table
3872: -- Business Rules :
3873: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_B table
3874: -- Version : 1.0
3875: -- History : 18-DEC-2002 BAKUCHIB 2667636
3876: -- : Added columns Currency code, currency Conversion_code
3877: -- Currency conversion type, currency conversion date

Line 4143: -- Set_Attributes for:OKL_TXL_QUOTE_LINES_B --

4139: END IF;
4140: RETURN(l_return_status);
4141: END populate_new_record;
4142: ----------------------------------------------
4143: -- Set_Attributes for:OKL_TXL_QUOTE_LINES_B --
4144: ----------------------------------------------
4145: FUNCTION Set_Attributes (
4146: p_tql_rec IN tql_rec_type,
4147: x_tql_rec OUT NOCOPY tql_rec_type

Line 4180: UPDATE OKL_TXL_QUOTE_LINES_B

4176: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4177: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4178: RAISE OKC_API.G_EXCEPTION_ERROR;
4179: END IF;
4180: UPDATE OKL_TXL_QUOTE_LINES_B
4181: SET STY_ID = l_def_tql_rec.sty_id,
4182: KLE_ID = l_def_tql_rec.kle_id,
4183: QLT_CODE = l_def_tql_rec.qlt_code,
4184: QTE_ID = l_def_tql_rec.qte_id,

Line 5032: -- delete_row for:OKL_TXL_QUOTE_LINES_B --

5028: ---------------------------------------------------------------------------
5029: -- PROCEDURE delete_row
5030: ---------------------------------------------------------------------------
5031: ------------------------------------------
5032: -- delete_row for:OKL_TXL_QUOTE_LINES_B --
5033: ------------------------------------------
5034: PROCEDURE delete_row(
5035: p_init_msg_list IN VARCHAR2,
5036: x_return_status OUT NOCOPY VARCHAR2,

Line 5056: DELETE FROM OKL_TXL_QUOTE_LINES_B

5052: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5053: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5054: RAISE OKC_API.G_EXCEPTION_ERROR;
5055: END IF;
5056: DELETE FROM OKL_TXL_QUOTE_LINES_B
5057: WHERE ID = l_tql_rec.id;
5058:
5059: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
5060: EXCEPTION