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_V

Line 9: G_VIEW CONSTANT VARCHAR2(200) := 'OKL_TRX_QUOTES_V';

5: G_UPPER_CASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPER_CASE_REQUIRED';
6: --G_INVALID_END_DATE CONSTANT VARCHAR2(200) := 'INVALID_END_DATE';
7: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
8: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
9: G_VIEW CONSTANT VARCHAR2(200) := 'OKL_TRX_QUOTES_V';
10:
11: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
12: --------------------------------------------------------------------------------
13: -- Start of comments

Line 882: FROM OKL_TRX_QUOTES_V

878: ,x_return_status OUT NOCOPY VARCHAR2) IS
879: -- select the ID of the parent record from the parent
880: CURSOR okl_qtev_csr (p_consolidated_qte_id IN NUMBER) IS
881: SELECT 'x'
882: FROM OKL_TRX_QUOTES_V
883: WHERE ID = p_consolidated_qte_id;
884:
885: l_dummy_var VARCHAR2(1) := '?';
886:

Line 906: ,p_token2_value => 'OKL_TRX_QUOTES_V'

902: ,p_msg_name => G_NO_PARENT_RECORD
903: ,p_token1 => G_COL_NAME_TOKEN
904: ,p_token1_value => 'consolidated_qte_id'
905: ,p_token2 => G_CHILD_TABLE_TOKEN
906: ,p_token2_value => 'OKL_TRX_QUOTES_V'
907: ,p_token3 => G_PARENT_TABLE_TOKEN
908: ,p_token3_value => 'OKL_TRX_QUOTES_V');
909:
910: -- notify caller of an error

Line 908: ,p_token3_value => 'OKL_TRX_QUOTES_V');

904: ,p_token1_value => 'consolidated_qte_id'
905: ,p_token2 => G_CHILD_TABLE_TOKEN
906: ,p_token2_value => 'OKL_TRX_QUOTES_V'
907: ,p_token3 => G_PARENT_TABLE_TOKEN
908: ,p_token3_value => 'OKL_TRX_QUOTES_V');
909:
910: -- notify caller of an error
911: x_return_status := OKC_API.G_RET_STS_ERROR;
912:

Line 981: ,p_token3_value => 'OKL_TRX_QUOTES_V');

977: ,p_token1_value => 'khr_id'
978: ,p_token2 => 'CHILD_TABLE'
979: ,p_token2_value => 'OKL_K_HEADERS_V'
980: ,p_token3 => 'PARENT_TABLE'
981: ,p_token3_value => 'OKL_TRX_QUOTES_V');
982:
983: -- notify caller of an error
984: x_return_status := OKC_API.G_RET_STS_ERROR;
985:

Line 1052: ,p_token2_value => 'OKL_TRX_QUOTES_V'

1048: ,p_msg_name => G_NO_PARENT_RECORD
1049: ,p_token1 => G_COL_NAME_TOKEN
1050: ,p_token1_value => 'pdt_id'
1051: ,p_token2 => G_CHILD_TABLE_TOKEN
1052: ,p_token2_value => 'OKL_TRX_QUOTES_V'
1053: ,p_token3 => G_PARENT_TABLE_TOKEN
1054: ,p_token3_value => 'OKL_PRODUCTS_V');
1055:
1056: -- notify caller of an error

Line 2467: ,p_token2_value => 'OKL_TRX_QUOTES_V'

2463: ,p_msg_name => G_NO_PARENT_RECORD
2464: ,p_token1 => G_COL_NAME_TOKEN
2465: ,p_token1_value => 'art_id'
2466: ,p_token2 => G_CHILD_TABLE_TOKEN
2467: ,p_token2_value => 'OKL_TRX_QUOTES_V'
2468: ,p_token3 => G_PARENT_TABLE_TOKEN
2469: ,p_token3_value => 'OKL_ASSET_RETURNS_V');
2470:
2471: -- notify caller of an error

Line 3206: -- FUNCTION get_rec for: OKL_TRX_QUOTES_V

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: ---------------------------------------------------------------------------
3208: -- Start of comments
3209: -- Function Name : get_rec
3210: -- Description : get record structure of OKL_TRX_QUOTE_V table

Line 3310: FROM Okl_Trx_Quotes_V

3306: PERDIEM_AMOUNT, --SANAHUJA -- LOANS_ENHACEMENTS
3307: -- BAKUCHIB 2667636 End
3308: LEGAL_ENTITY_ID, --DKAGRAWA added for LE update
3309: REPO_QUOTE_INDICATOR_YN --AKP:REPO-QUOTE-START-END 6599890
3310: FROM Okl_Trx_Quotes_V
3311: WHERE okl_trx_quotes_v.id = p_id;
3312: l_okl_qtev_pk okl_qtev_pk_csr%ROWTYPE;
3313: l_qtev_rec qtev_rec_type;
3314: BEGIN

Line 3311: WHERE okl_trx_quotes_v.id = p_id;

3307: -- BAKUCHIB 2667636 End
3308: LEGAL_ENTITY_ID, --DKAGRAWA added for LE update
3309: REPO_QUOTE_INDICATOR_YN --AKP:REPO-QUOTE-START-END 6599890
3310: FROM Okl_Trx_Quotes_V
3311: WHERE okl_trx_quotes_v.id = p_id;
3312: l_okl_qtev_pk okl_qtev_pk_csr%ROWTYPE;
3313: l_qtev_rec qtev_rec_type;
3314: BEGIN
3315: x_no_data_found := TRUE;

Line 3418: -- FUNCTION null_out_defaults for: OKL_TRX_QUOTES_V --

3414: RETURN(get_rec(p_qtev_rec, l_row_notfound));
3415: END get_rec;
3416:
3417: ------------------------------------------------------
3418: -- FUNCTION null_out_defaults for: OKL_TRX_QUOTES_V --
3419: ------------------------------------------------------
3420: -- Start of comments
3421: -- Function Name : null_out_defaults
3422: -- Description : Null out record structure of OKL_TRX_QUOTE_V table

Line 3693: -- Validate_Attributes for:OKL_TRX_QUOTES_V --

3689: ---------------------------------------------------------------------------
3690: -- PROCEDURE Validate_Attributes
3691: ---------------------------------------------------------------------------
3692: ----------------------------------------------
3693: -- Validate_Attributes for:OKL_TRX_QUOTES_V --
3694: ----------------------------------------------
3695: -- Start of comments
3696: -- Function Name : Validate_Attributes
3697: -- Description : Validate Attributes of record structure of

Line 4004: FROM OKL_TRX_QUOTES_V

4000:
4001: -- select the quote record matching the unique key value
4002: CURSOR okl_qtev_csr (p_quote_number IN NUMBER, p_id IN NUMBER) IS
4003: SELECT 'x'
4004: FROM OKL_TRX_QUOTES_V
4005: WHERE QUOTE_NUMBER = p_quote_number
4006: AND ID <> nvl(p_id, -99999);
4007:
4008: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 4064: -- Validate_Record for:OKL_TRX_QUOTES_V --

4060: ---------------------------------------------------------------------------
4061: -- PROCEDURE Validate_Record
4062: ---------------------------------------------------------------------------
4063: ------------------------------------------
4064: -- Validate_Record for:OKL_TRX_QUOTES_V --
4065: ------------------------------------------
4066: -- Start of comments
4067: -- Function Name : Validate_Record
4068: -- Description : Validate Record of record structure of

Line 4162: -- Validate_Attributes for:OKL_TRX_QUOTES_V --

4158: ---------------------------------------------------------------------------
4159: -- PROCEDURE Validate_Attributes
4160: ---------------------------------------------------------------------------
4161: ----------------------------------------------
4162: -- Validate_Attributes for:OKL_TRX_QUOTES_V --
4163: ----------------------------------------------
4164: FUNCTION Validate_Attributes (
4165: p_qtev_rec IN qtev_rec_type
4166: ) RETURN VARCHAR2 IS

Line 4212: -- Validate_Record for:OKL_TRX_QUOTES_V --

4208: ---------------------------------------------------------------------------
4209: -- PROCEDURE Validate_Record
4210: ---------------------------------------------------------------------------
4211: ------------------------------------------
4212: -- Validate_Record for:OKL_TRX_QUOTES_V --
4213: ------------------------------------------
4214: FUNCTION Validate_Record (
4215: p_qtev_rec IN qtev_rec_type
4216: ) RETURN VARCHAR2 IS

Line 4547: -- validate_row for:OKL_TRX_QUOTES_V --

4543: ---------------------------------------------------------------------------
4544: -- PROCEDURE validate_row
4545: ---------------------------------------------------------------------------
4546: ---------------------------------------
4547: -- validate_row for:OKL_TRX_QUOTES_V --
4548: ---------------------------------------
4549: PROCEDURE validate_row(
4550: p_api_version IN NUMBER,
4551: p_init_msg_list IN VARCHAR2,

Line 5082: -- insert_row for:OKL_TRX_QUOTES_V --

5078: '_PVT'
5079: );
5080: END insert_row;
5081: -------------------------------------
5082: -- insert_row for:OKL_TRX_QUOTES_V --
5083: -------------------------------------
5084: -- Start of comments
5085: -- Procedure Name : insert_row
5086: -- Description : Insert Row into OKL_TRX_QUOTE_V View

Line 5130: -- Set_Attributes for:OKL_TRX_QUOTES_V --

5126: l_qtev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
5127: RETURN(l_qtev_rec);
5128: END fill_who_columns;
5129: -----------------------------------------
5130: -- Set_Attributes for:OKL_TRX_QUOTES_V --
5131: -----------------------------------------
5132: FUNCTION Set_Attributes (
5133: p_qtev_rec IN qtev_rec_type,
5134: x_qtev_rec OUT NOCOPY qtev_rec_type

Line 5592: -- lock_row for:OKL_TRX_QUOTES_V --

5588: '_PVT'
5589: );
5590: END lock_row;
5591: -----------------------------------
5592: -- lock_row for:OKL_TRX_QUOTES_V --
5593: -----------------------------------
5594: PROCEDURE lock_row(
5595: p_api_version IN NUMBER,
5596: p_init_msg_list IN VARCHAR2,

Line 6492: -- update_row for:OKL_TRX_QUOTES_V --

6488: '_PVT'
6489: );
6490: END update_row;
6491: -------------------------------------
6492: -- update_row for:OKL_TRX_QUOTES_V --
6493: -------------------------------------
6494: -- Start of comments
6495: -- Procedure Name : update_row
6496: -- Description : Update Row into OKL_TRX_QUOTE_V table

Line 6905: -- Set_Attributes for:OKL_TRX_QUOTES_V --

6901:
6902: RETURN(l_return_status);
6903: END populate_new_record;
6904: -----------------------------------------
6905: -- Set_Attributes for:OKL_TRX_QUOTES_V --
6906: -----------------------------------------
6907: FUNCTION Set_Attributes (
6908: p_qtev_rec IN qtev_rec_type,
6909: x_qtev_rec OUT NOCOPY qtev_rec_type

Line 7266: -- delete_row for:OKL_TRX_QUOTES_V --

7262: '_PVT'
7263: );
7264: END delete_row;
7265: -------------------------------------
7266: -- delete_row for:OKL_TRX_QUOTES_V --
7267: -------------------------------------
7268: PROCEDURE delete_row(
7269: p_api_version IN NUMBER,
7270: p_init_msg_list IN VARCHAR2,