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_ART_PVT dependencies on OKL_ASSET_RETURNS_V

Line 839: p_token2_value => 'OKL_ASSET_RETURNS_V',

835: p_msg_name => G_NO_PARENT_RECORD,
836: p_token1 => G_COL_NAME_TOKEN,
837: p_token1_value => 'security_dep_trx_ap_id',
838: p_token2 => G_CHILD_TABLE_TOKEN,
839: p_token2_value => 'OKL_ASSET_RETURNS_V',
840: p_token3 => G_PARENT_TABLE_TOKEN,
841: p_token3_value => 'OKL_TRX_AP_INVOICES_V');
842:
843: -- notify caller of an error

Line 905: p_token2_value => 'OKL_ASSET_RETURNS_V',

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

Line 972: p_token2_value => 'OKL_ASSET_RETURNS_V',

968: p_msg_name => G_NO_PARENT_RECORD,
969: p_token1 => G_COL_NAME_TOKEN,
970: p_token1_value => 'rna_id',
971: p_token2 => G_CHILD_TABLE_TOKEN,
972: p_token2_value => 'OKL_ASSET_RETURNS_V',
973: p_token3 => G_PARENT_TABLE_TOKEN,
974: p_token3_value => 'OKX_VENDORS_V');
975:
976: -- notify caller of an error

Line 1041: p_token2_value => 'OKL_ASSET_RETURNS_V',

1037: p_msg_name => G_NO_PARENT_RECORD,
1038: p_token1 => G_COL_NAME_TOKEN,
1039: p_token1_value => 'rmr_id',
1040: p_token2 => G_CHILD_TABLE_TOKEN,
1041: p_token2_value => 'OKL_ASSET_RETURNS_V',
1042: p_token3 => G_PARENT_TABLE_TOKEN,
1043: p_token3_value => 'OKL_AM_REMARKET_TEAMS_UV');
1044:
1045: -- notify caller of an error

Line 1110: p_token2_value => 'OKL_ASSET_RETURNS_V',

1106: p_msg_name => G_NO_PARENT_RECORD,
1107: p_token1 => G_COL_NAME_TOKEN,
1108: p_token1_value => 'imr_id',
1109: p_token2 => G_CHILD_TABLE_TOKEN,
1110: p_token2_value => 'OKL_ASSET_RETURNS_V',
1111: p_token3 => G_PARENT_TABLE_TOKEN,
1112: p_token3_value => 'OKX_SYSTEM_ITEMS_V');
1113:
1114: -- notify caller of an error

Line 1452: FROM OKL_ASSET_RETURNS_V

1448: x_return_status out nocopy VARCHAR2) is
1449: -- Cursor to check whether create or update mode
1450: CURSOR okl_cre_upd_csr ( p_id IN NUMBER) IS
1451: SELECT id, ars_code
1452: FROM OKL_ASSET_RETURNS_V
1453: WHERE id = p_id;
1454:
1455: -- Cursor to get ars code if a asset return exists (create mode)
1456: CURSOR okl_ars_cre_csr ( p_kle_id IN NUMBER) IS

Line 1458: FROM OKL_ASSET_RETURNS_V

1454:
1455: -- Cursor to get ars code if a asset return exists (create mode)
1456: CURSOR okl_ars_cre_csr ( p_kle_id IN NUMBER) IS
1457: SELECT ars_code
1458: FROM OKL_ASSET_RETURNS_V
1459: WHERE kle_id = p_kle_id;
1460:
1461: -- Cursor to get ars code if a asset return exists (update mode)
1462: CURSOR okl_ars_upd_csr ( p_id IN NUMBER, p_kle_id IN NUMBER) IS

Line 1464: FROM OKL_ASSET_RETURNS_V

1460:
1461: -- Cursor to get ars code if a asset return exists (update mode)
1462: CURSOR okl_ars_upd_csr ( p_id IN NUMBER, p_kle_id IN NUMBER) IS
1463: SELECT ars_code
1464: FROM OKL_ASSET_RETURNS_V
1465: WHERE kle_id = p_kle_id
1466: AND id <> p_id;
1467:
1468: -- Cursor to get the meaning of the fnd_lookup value

Line 1928: -- FUNCTION get_rec for: OKL_ASSET_RETURNS_V

1924: BEGIN
1925: RETURN(get_rec(p_okl_asset_returns_tl_rec, l_row_notfound));
1926: END get_rec;
1927: ---------------------------------------------------------------------------
1928: -- FUNCTION get_rec for: OKL_ASSET_RETURNS_V
1929: ---------------------------------------------------------------------------
1930: -- Start of comments
1931: --
1932: -- Function Name : get_rec

Line 1933: -- Description : for: OKL_ASSET_RETURNS_V

1929: ---------------------------------------------------------------------------
1930: -- Start of comments
1931: --
1932: -- Function Name : get_rec
1933: -- Description : for: OKL_ASSET_RETURNS_V
1934: -- Business Rules :
1935: -- Parameters :
1936: -- Version : 1.0
1937: -- History : RABHUPAT 16-DEC-2002 2667636

Line 2015: FROM Okl_Asset_Returns_V

2011: -- Legal Entity Changes End
2012: -- DJANASWA Loan Repossession proj start
2013: ASSET_FMV_AMOUNT
2014: -- Loan Repossession proj end
2015: FROM Okl_Asset_Returns_V
2016: WHERE okl_asset_returns_v.id = p_id;
2017: l_okl_artv_pk okl_artv_pk_csr%ROWTYPE;
2018: l_artv_rec artv_rec_type;
2019: BEGIN

Line 2016: WHERE okl_asset_returns_v.id = p_id;

2012: -- DJANASWA Loan Repossession proj start
2013: ASSET_FMV_AMOUNT
2014: -- Loan Repossession proj end
2015: FROM Okl_Asset_Returns_V
2016: WHERE okl_asset_returns_v.id = p_id;
2017: l_okl_artv_pk okl_artv_pk_csr%ROWTYPE;
2018: l_artv_rec artv_rec_type;
2019: BEGIN
2020: x_no_data_found := TRUE;

Line 2107: -- FUNCTION null_out_defaults for: OKL_ASSET_RETURNS_V --

2103: RETURN(get_rec(p_artv_rec, l_row_notfound));
2104: END get_rec;
2105:
2106: ---------------------------------------------------------
2107: -- FUNCTION null_out_defaults for: OKL_ASSET_RETURNS_V --
2108: ---------------------------------------------------------
2109: -- Start of comments
2110: --
2111: -- Function Name : null_out_defaults

Line 2112: -- Description : for: OKL_ASSET_RETURNS_V

2108: ---------------------------------------------------------
2109: -- Start of comments
2110: --
2111: -- Function Name : null_out_defaults
2112: -- Description : for: OKL_ASSET_RETURNS_V
2113: -- Business Rules :
2114: -- Parameters :
2115: -- Version : 1.0
2116: -- History : RABHUPAT 16-DEC-2002 2667636

Line 2311: -- Validate_Attributes for:OKL_ASSET_RETURNS_V --

2307: ---------------------------------------------------------------------------
2308: -- PROCEDURE Validate_Attributes
2309: ---------------------------------------------------------------------------
2310: -------------------------------------------------
2311: -- Validate_Attributes for:OKL_ASSET_RETURNS_V --
2312: -------------------------------------------------
2313: -- Start of comments
2314: --
2315: -- Procedure Name : validate_attributes

Line 2316: -- Description : for:OKL_ASSET_RETURNS_V

2312: -------------------------------------------------
2313: -- Start of comments
2314: --
2315: -- Procedure Name : validate_attributes
2316: -- Description : for:OKL_ASSET_RETURNS_V
2317: -- Business Rules :
2318: -- Parameters :
2319: -- Version : 1.0
2320: -- History : RABHUPAT 16-DEC-2002 2667636

Line 2559: -- Validate_Record for:OKL_ASSET_RETURNS_V --

2555: ---------------------------------------------------------------------------
2556: -- PROCEDURE Validate_Record
2557: ---------------------------------------------------------------------------
2558: ---------------------------------------------
2559: -- Validate_Record for:OKL_ASSET_RETURNS_V --
2560: ---------------------------------------------
2561: -- Start of comments
2562: --
2563: -- Function Name : Validate_Record

Line 2564: -- Description : for:OKL_ASSET_RETURNS_V

2560: ---------------------------------------------
2561: -- Start of comments
2562: --
2563: -- Function Name : Validate_Record
2564: -- Description : for:OKL_ASSET_RETURNS_V
2565: -- Business Rules :
2566: -- Parameters :
2567: -- Version : 1.0
2568: -- History : RABHUPAT 16-DEC-2002 2667636

Line 2831: -- validate_row for:OKL_ASSET_RETURNS_V --

2827: ---------------------------------------------------------------------------
2828: -- PROCEDURE validate_row
2829: ---------------------------------------------------------------------------
2830: ------------------------------------------
2831: -- validate_row for:OKL_ASSET_RETURNS_V --
2832: ------------------------------------------
2833: PROCEDURE validate_row(
2834: p_api_version IN NUMBER,
2835: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3340: -- insert_row for:OKL_ASSET_RETURNS_V --

3336: '_PVT'
3337: );
3338: END insert_row;
3339: ----------------------------------------
3340: -- insert_row for:OKL_ASSET_RETURNS_V --
3341: ----------------------------------------
3342: -- Start of comments
3343: --
3344: -- Procedure Name : insert_row

Line 3345: -- Description : for OKL_ASSET_RETURNS_V

3341: ----------------------------------------
3342: -- Start of comments
3343: --
3344: -- Procedure Name : insert_row
3345: -- Description : for OKL_ASSET_RETURNS_V
3346: -- Business Rules :
3347: -- Parameters :
3348: -- Version : 1.0
3349: -- History : RABHUPAT 16-DEC-2002 2667636

Line 3386: -- Set_Attributes for:OKL_ASSET_RETURNS_V --

3382: l_artv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
3383: RETURN(l_artv_rec);
3384: END fill_who_columns;
3385: --------------------------------------------
3386: -- Set_Attributes for:OKL_ASSET_RETURNS_V --
3387: --------------------------------------------
3388: FUNCTION Set_Attributes (
3389: p_artv_rec IN artv_rec_type,
3390: x_artv_rec OUT NOCOPY artv_rec_type

Line 3832: -- lock_row for:OKL_ASSET_RETURNS_V --

3828: '_PVT'
3829: );
3830: END lock_row;
3831: --------------------------------------
3832: -- lock_row for:OKL_ASSET_RETURNS_V --
3833: --------------------------------------
3834: PROCEDURE lock_row(
3835: p_api_version IN NUMBER,
3836: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 4620: -- update_row for:OKL_ASSET_RETURNS_V --

4616: '_PVT'
4617: );
4618: END update_row;
4619: ----------------------------------------
4620: -- update_row for:OKL_ASSET_RETURNS_V --
4621: ----------------------------------------
4622: -- Start of comments
4623: --
4624: -- Procedure Name : update_row

Line 4625: -- Description : for OKL_ASSET_RETURNS_V

4621: ----------------------------------------
4622: -- Start of comments
4623: --
4624: -- Procedure Name : update_row
4625: -- Description : for OKL_ASSET_RETURNS_V
4626: -- Business Rules :
4627: -- Parameters :
4628: -- Version : 1.0
4629: -- History : RABHUPAT 16-DEC-2002 2667636

Line 4942: -- Set_Attributes for:OKL_ASSET_RETURNS_V --

4938: -- Loan Repossession proj end
4939: RETURN(l_return_status);
4940: END populate_new_record;
4941: --------------------------------------------
4942: -- Set_Attributes for:OKL_ASSET_RETURNS_V --
4943: --------------------------------------------
4944: FUNCTION Set_Attributes (
4945: p_artv_rec IN artv_rec_type,
4946: x_artv_rec OUT NOCOPY artv_rec_type

Line 5301: -- delete_row for:OKL_ASSET_RETURNS_V --

5297: '_PVT'
5298: );
5299: END delete_row;
5300: ----------------------------------------
5301: -- delete_row for:OKL_ASSET_RETURNS_V --
5302: ----------------------------------------
5303: PROCEDURE delete_row(
5304: p_api_version IN NUMBER,
5305: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,