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_V

Line 14: G_VIEW CONSTANT VARCHAR2(200) := 'OKL_TXL_QUOTE_LINES_V';

10: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
11: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
12:
13:
14: G_VIEW CONSTANT VARCHAR2(200) := 'OKL_TXL_QUOTE_LINES_V';
15: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
16: G_EXCEPTION_STOP_VALIDATION EXCEPTION;
17: G_RETURN_STATUS VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
18:

Line 27: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_V table

23: -- Business Rules : If transaction currency <> functional currency, then
24: -- conversion columns are mandatory
25: -- Else If transaction currency = functional currency,
26: -- then conversion columns should all be NULL
27: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_V table
28: -- Version : 1.0
29: -- History : 15-DEC-2002 BAKUCHIB :Added new procedure
30: -- End of comments
31:

Line 119: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_V table

115: -- Start of comments
116: -- Procedure Name : validate_currency_code
117: -- Description : Validation of Currency Code
118: -- Business Rules :
119: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_V table
120: -- Version : 1.0
121: -- History : 15-DEC-2002 BAKUCHIB :Added new procedure
122: -- End of comments
123:

Line 170: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_V table

166: -- Start of comments
167: -- Procedure Name : validate_currency_con_code
168: -- Description : Validation of Currency Conversion Code
169: -- Business Rules :
170: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_V table
171: -- Version : 1.0
172: -- History : 15-DEC-2002 BAKUCHIB :Added new procedure
173: -- End of comments
174:

Line 221: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_V table

217: -- Start of comments
218: -- Procedure Name : validate_currency_con_type
219: -- Description : Validation of Currency Conversion type
220: -- Business Rules :
221: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_V table
222: -- Version : 1.0
223: -- History : 15-DEC-2002 BAKUCHIB :Added new procedure
224: -- End of comments
225:

Line 535: p_token2_value => 'OKL_TXL_QUOTE_LINES_V',

531: p_msg_name => g_no_parent_record,
532: p_token1 => g_col_name_token,
533: p_token1_value => 'sty_id',
534: p_token2 => g_child_table_token,
535: p_token2_value => 'OKL_TXL_QUOTE_LINES_V',
536: p_token3 => g_parent_table_token,
537: p_token3_value => 'OKL_STRM_TYPE_V');
538:
539: -- notify caller of an error

Line 897: p_token2_value => 'OKL_TXL_QUOTE_LINES_V',

893: p_msg_name => G_NO_PARENT_RECORD,
894: p_token1 => G_COL_NAME_TOKEN,
895: p_token1_value => 'qte_id',
896: p_token2 => G_CHILD_TABLE_TOKEN,
897: p_token2_value => 'OKL_TXL_QUOTE_LINES_V',
898: p_token3 => G_PARENT_TABLE_TOKEN,
899: p_token3_value => 'OKL_TRX_QUOTES_V');
900:
901: -- notify caller of an error

Line 1346: -- FUNCTION get_rec for: OKL_TXL_QUOTE_LINES_V

1342: BEGIN
1343: RETURN(get_rec(p_okl_txl_quote_lines_tl_rec, l_row_notfound));
1344: END get_rec;
1345: ---------------------------------------------------------------------------
1346: -- FUNCTION get_rec for: OKL_TXL_QUOTE_LINES_V
1347: ---------------------------------------------------------------------------
1348: -- Start of comments
1349: -- Function Name : get_rec
1350: -- Description : get record structure of OKL_TXL_QUOTE_LINES_V table

Line 1350: -- Description : get record structure of OKL_TXL_QUOTE_LINES_V table

1346: -- FUNCTION get_rec for: OKL_TXL_QUOTE_LINES_V
1347: ---------------------------------------------------------------------------
1348: -- Start of comments
1349: -- Function Name : get_rec
1350: -- Description : get record structure of OKL_TXL_QUOTE_LINES_V table
1351: -- Business Rules :
1352: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_V table
1353: -- Version : 1.0
1354: -- History : 18-DEC-2002 BAKUCHIB 2667636 Modified

Line 1352: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_V table

1348: -- Start of comments
1349: -- Function Name : get_rec
1350: -- Description : get record structure of OKL_TXL_QUOTE_LINES_V table
1351: -- Business Rules :
1352: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_V table
1353: -- Version : 1.0
1354: -- History : 18-DEC-2002 BAKUCHIB 2667636 Modified
1355: -- : Added columns Currency code, currency Conversion_code
1356: -- Currency conversion type, currency conversion date

Line 1429: FROM Okl_Txl_Quote_Lines_V

1425: CURRENCY_CONVERSION_DATE,
1426: -- BAKUCHIB 2667636 End
1427: DUE_DATE, -- PAGARG 4161133
1428: try_id -- rmunjulu Sales_Tax_Enhancement
1429: FROM Okl_Txl_Quote_Lines_V
1430: WHERE okl_txl_quote_lines_v.id = p_id;
1431: l_okl_tqlv_pk okl_tqlv_pk_csr%ROWTYPE;
1432: l_tqlv_rec tqlv_rec_type;
1433: BEGIN

Line 1430: WHERE okl_txl_quote_lines_v.id = p_id;

1426: -- BAKUCHIB 2667636 End
1427: DUE_DATE, -- PAGARG 4161133
1428: try_id -- rmunjulu Sales_Tax_Enhancement
1429: FROM Okl_Txl_Quote_Lines_V
1430: WHERE okl_txl_quote_lines_v.id = p_id;
1431: l_okl_tqlv_pk okl_tqlv_pk_csr%ROWTYPE;
1432: l_tqlv_rec tqlv_rec_type;
1433: BEGIN
1434: x_no_data_found := TRUE;

Line 1515: -- FUNCTION null_out_defaults for: OKL_TXL_QUOTE_LINES_V --

1511: RETURN(get_rec(p_tqlv_rec, l_row_notfound));
1512: END get_rec;
1513:
1514: -----------------------------------------------------------
1515: -- FUNCTION null_out_defaults for: OKL_TXL_QUOTE_LINES_V --
1516: -----------------------------------------------------------
1517: -- Start of comments
1518: -- Function Name : null_out_defaults
1519: -- Description : Null out record structure of OKL_TXL_QUOTE_LINES_V table

Line 1519: -- Description : Null out record structure of OKL_TXL_QUOTE_LINES_V table

1515: -- FUNCTION null_out_defaults for: OKL_TXL_QUOTE_LINES_V --
1516: -----------------------------------------------------------
1517: -- Start of comments
1518: -- Function Name : null_out_defaults
1519: -- Description : Null out record structure of OKL_TXL_QUOTE_LINES_V table
1520: -- Business Rules :
1521: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_V table
1522: -- Version : 1.0
1523: -- History : 18-DEC-2002 BAKUCHIB 2667636 Modified

Line 1521: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_V table

1517: -- Start of comments
1518: -- Function Name : null_out_defaults
1519: -- Description : Null out record structure of OKL_TXL_QUOTE_LINES_V table
1520: -- Business Rules :
1521: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_V table
1522: -- Version : 1.0
1523: -- History : 18-DEC-2002 BAKUCHIB 2667636 Modified
1524: -- : Added columns Currency code, currency Conversion_code
1525: -- Currency conversion type, currency conversion date

Line 1730: -- Validate_Attributes for:OKL_TXL_QUOTE_LINES_V --

1726: ---------------------------------------------------------------------------
1727: -- PROCEDURE Validate_Attributes
1728: ---------------------------------------------------------------------------
1729: ---------------------------------------------------
1730: -- Validate_Attributes for:OKL_TXL_QUOTE_LINES_V --
1731: ---------------------------------------------------
1732: -- Start of comments
1733: -- Function Name : Validate_Attributes
1734: -- Description : Validate Attributes of record structure of

Line 1735: -- OKL_TXL_QUOTE_LINES_V table

1731: ---------------------------------------------------
1732: -- Start of comments
1733: -- Function Name : Validate_Attributes
1734: -- Description : Validate Attributes of record structure of
1735: -- OKL_TXL_QUOTE_LINES_V table
1736: -- Business Rules :
1737: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_V table
1738: -- Version : 1.0
1739: -- History : 18-DEC-2002 BAKUCHIB 2667636 Modified

Line 1737: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_V table

1733: -- Function Name : Validate_Attributes
1734: -- Description : Validate Attributes of record structure of
1735: -- OKL_TXL_QUOTE_LINES_V table
1736: -- Business Rules :
1737: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_V table
1738: -- Version : 1.0
1739: -- History : 18-DEC-2002 BAKUCHIB 2667636 Modified
1740: -- : Added Procedure for validation of Currency code,
1741: -- currency Conversion_code and Currency conversion type

Line 1925: -- Validate_Record for:OKL_TXL_QUOTE_LINES_V --

1921: ---------------------------------------------------------------------------
1922: -- PROCEDURE Validate_Record
1923: ---------------------------------------------------------------------------
1924: -----------------------------------------------
1925: -- Validate_Record for:OKL_TXL_QUOTE_LINES_V --
1926: -----------------------------------------------
1927: -- Start of comments
1928: -- Function Name : Validate_Record
1929: -- Description : Validate Record of record structure of

Line 1930: -- OKL_TXL_QUOTE_LINES_V table

1926: -----------------------------------------------
1927: -- Start of comments
1928: -- Function Name : Validate_Record
1929: -- Description : Validate Record of record structure of
1930: -- OKL_TXL_QUOTE_LINES_V table
1931: -- Business Rules :
1932: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_V table
1933: -- Version : 1.0
1934: -- History : 18-DEC-2002 BAKUCHIB 2667636 Modified

Line 1932: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_V table

1928: -- Function Name : Validate_Record
1929: -- Description : Validate Record of record structure of
1930: -- OKL_TXL_QUOTE_LINES_V table
1931: -- Business Rules :
1932: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_V table
1933: -- Version : 1.0
1934: -- History : 18-DEC-2002 BAKUCHIB 2667636 Modified
1935: -- Added Procedure to validate Currency conversion Code,type
1936: -- ,rate and Date aganist currency code

Line 1965: -- Description : Migrate record structure of OKL_TXL_QUOTE_LINES_V table

1961: -- PROCEDURE Migrate
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

Line 1968: -- Parameters : IN Record structure of OKL_TXL_QUOTE_LINES_V table

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
1971: -- History : 18-DEC-2002 BAKUCHIB 2667636 Modified
1972: -- : Added columns Currency code, currency Conversion_code

Line 2050: -- to record structure of OKL_TXL_QUOTE_LINES_V table

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
2054: -- Version : 1.0

Line 2053: -- IN OUT Record structure of OKL_TXL_QUOTE_LINES_V table

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
2057: -- Currency conversion type, currency conversion date

Line 2163: -- validate_row for:OKL_TXL_QUOTE_LINES_V --

2159: ---------------------------------------------------------------------------
2160: -- PROCEDURE validate_row
2161: ---------------------------------------------------------------------------
2162: --------------------------------------------
2163: -- validate_row for:OKL_TXL_QUOTE_LINES_V --
2164: --------------------------------------------
2165: PROCEDURE validate_row(
2166: p_api_version IN NUMBER,
2167: p_init_msg_list IN VARCHAR2,

Line 2662: -- insert_row for:OKL_TXL_QUOTE_LINES_V --

2658: '_PVT'
2659: );
2660: END insert_row;
2661: ------------------------------------------
2662: -- insert_row for:OKL_TXL_QUOTE_LINES_V --
2663: ------------------------------------------
2664: -- Start of comments
2665: -- Procedure Name : insert_row
2666: -- Description : Insert Row into OKL_TXL_QUOTE_LINES_V View

Line 2666: -- Description : Insert Row into OKL_TXL_QUOTE_LINES_V View

2662: -- insert_row for:OKL_TXL_QUOTE_LINES_V --
2663: ------------------------------------------
2664: -- Start of comments
2665: -- Procedure Name : insert_row
2666: -- Description : Insert Row into OKL_TXL_QUOTE_LINES_V View
2667: -- Business Rules :
2668: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_V table
2669: -- Version : 1.0
2670: -- History : 18-DEC-2002 BAKUCHIB 2667636 Modified

Line 2668: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_V table

2664: -- Start of comments
2665: -- Procedure Name : insert_row
2666: -- Description : Insert Row into OKL_TXL_QUOTE_LINES_V View
2667: -- Business Rules :
2668: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_V table
2669: -- Version : 1.0
2670: -- History : 18-DEC-2002 BAKUCHIB 2667636 Modified
2671: -- : In set Attributes function defaulted the
2672: -- currency Conversion_code to Functional Currency Code.

Line 2717: -- Set_Attributes for:OKL_TXL_QUOTE_LINES_V --

2713: l_tqlv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2714: RETURN(l_tqlv_rec);
2715: END fill_who_columns;
2716: ----------------------------------------------
2717: -- Set_Attributes for:OKL_TXL_QUOTE_LINES_V --
2718: ----------------------------------------------
2719: FUNCTION Set_Attributes (
2720: p_tqlv_rec IN tqlv_rec_type,
2721: x_tqlv_rec OUT NOCOPY tqlv_rec_type

Line 2974: -- insert_row for:OKL_TXL_QUOTE_LINES_V --

2970:
2971: -- PAGARG Bug 4299668 Declare table of records to define arrays used in bulk insert
2972: -- **Start**
2973: ------------------------------------------
2974: -- insert_row for:OKL_TXL_QUOTE_LINES_V --
2975: ------------------------------------------
2976: -- Start of comments
2977: -- Procedure Name : insert_row_bulk
2978: -- Description : Insert Row into OKL_TXL_QUOTE_LINES_V View

Line 2978: -- Description : Insert Row into OKL_TXL_QUOTE_LINES_V View

2974: -- insert_row for:OKL_TXL_QUOTE_LINES_V --
2975: ------------------------------------------
2976: -- Start of comments
2977: -- Procedure Name : insert_row_bulk
2978: -- Description : Insert Row into OKL_TXL_QUOTE_LINES_V View
2979: -- Business Rules :
2980: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_V table
2981: -- Version : 1.0
2982: -- History : 12-Apr-2005 PAGARG 4299668 created for bulk insert

Line 2980: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_V table

2976: -- Start of comments
2977: -- Procedure Name : insert_row_bulk
2978: -- Description : Insert Row into OKL_TXL_QUOTE_LINES_V View
2979: -- Business Rules :
2980: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_V table
2981: -- Version : 1.0
2982: -- History : 12-Apr-2005 PAGARG 4299668 created for bulk insert
2983: -- End of comments
2984: PROCEDURE insert_row_bulk(

Line 3660: -- lock_row for:OKL_TXL_QUOTE_LINES_V --

3656: '_PVT'
3657: );
3658: END lock_row;
3659: ----------------------------------------
3660: -- lock_row for:OKL_TXL_QUOTE_LINES_V --
3661: ----------------------------------------
3662: PROCEDURE lock_row(
3663: p_api_version IN NUMBER,
3664: p_init_msg_list IN VARCHAR2,

Line 4451: -- update_row for:OKL_TXL_QUOTE_LINES_V --

4447: '_PVT'
4448: );
4449: END update_row;
4450: ------------------------------------------
4451: -- update_row for:OKL_TXL_QUOTE_LINES_V --
4452: ------------------------------------------
4453: -- Start of comments
4454: -- Procedure Name : update_row
4455: -- Description : Update Row into OKL_TXL_QUOTE_LINES_V table

Line 4455: -- Description : Update Row into OKL_TXL_QUOTE_LINES_V table

4451: -- update_row for:OKL_TXL_QUOTE_LINES_V --
4452: ------------------------------------------
4453: -- Start of comments
4454: -- Procedure Name : update_row
4455: -- Description : Update Row into OKL_TXL_QUOTE_LINES_V table
4456: -- Business Rules :
4457: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_V table
4458: -- Version : 1.0
4459: -- History : 18-DEC-2002 BAKUCHIB 2667636 Modified

Line 4457: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_V table

4453: -- Start of comments
4454: -- Procedure Name : update_row
4455: -- Description : Update Row into OKL_TXL_QUOTE_LINES_V table
4456: -- Business Rules :
4457: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_V table
4458: -- Version : 1.0
4459: -- History : 18-DEC-2002 BAKUCHIB 2667636 Modified
4460: -- : Added columns Currency code, currency Conversion_code
4461: -- Currency conversion type, currency conversion date

Line 4506: -- Description : Populate new record into OKL_TXL_QUOTE_LINES_V table

4502: -- FUNCTION populate_new_record --
4503: ----------------------------------
4504: -- Start of comments
4505: -- Function Name : populate_new_record
4506: -- Description : Populate new record into OKL_TXL_QUOTE_LINES_V table
4507: -- Business Rules :
4508: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_V table
4509: -- Version : 1.0
4510: -- History : 18-DEC-2002 BAKUCHIB 2667636 Modified

Line 4508: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_V table

4504: -- Start of comments
4505: -- Function Name : populate_new_record
4506: -- Description : Populate new record into OKL_TXL_QUOTE_LINES_V table
4507: -- Business Rules :
4508: -- Parameters : Record structure of OKL_TXL_QUOTE_LINES_V table
4509: -- Version : 1.0
4510: -- History : 18-DEC-2002 BAKUCHIB 2667636 Modified
4511: -- : Added columns Currency code, currency Conversion_code
4512: -- Currency conversion type, currency conversion date

Line 4789: -- Set_Attributes for:OKL_TXL_QUOTE_LINES_V --

4785: END IF;
4786: RETURN(l_return_status);
4787: END populate_new_record;
4788: ----------------------------------------------
4789: -- Set_Attributes for:OKL_TXL_QUOTE_LINES_V --
4790: ----------------------------------------------
4791: FUNCTION Set_Attributes (
4792: p_tqlv_rec IN tqlv_rec_type,
4793: x_tqlv_rec OUT NOCOPY tqlv_rec_type

Line 5177: -- delete_row for:OKL_TXL_QUOTE_LINES_V --

5173: '_PVT'
5174: );
5175: END delete_row;
5176: ------------------------------------------
5177: -- delete_row for:OKL_TXL_QUOTE_LINES_V --
5178: ------------------------------------------
5179: PROCEDURE delete_row(
5180: p_api_version IN NUMBER,
5181: p_init_msg_list IN VARCHAR2,