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_IPT_PVT dependencies on OKL_INS_PRODUCTS_V

Line 110: FROM okl_ins_products_v

106: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
107: l_dummy_var VARCHAR2(1) := '?';
108: CURSOR l_iptv_csr IS
109: SELECT 'x'
110: FROM okl_ins_products_v
111: WHERE trunc(date_from) = trunc(p_iptv_rec.date_from)
112: AND ipd_id = p_iptv_rec.ipd_id
113: AND ipt_type = p_iptv_rec.ipt_type
114: AND name = p_iptv_rec.name

Line 714: p_token2_value => 'OKL_INS_PRODUCTS_V',

710: p_msg_name => G_NO_PARENT_RECORD,
711: p_token1 => G_COL_NAME_TOKEN,
712: p_token1_value => 'ipd_id',
713: p_token2 => g_child_table_token,
714: p_token2_value => 'OKL_INS_PRODUCTS_V',
715: p_token3 => g_parent_table_token,
716: p_token3_value => 'OKX_SYSTEM_ITEMS_V');
717: -- notify caller of an error
718: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 768: OKC_API.set_message(G_APP_NAME,G_NO_PARENT_RECORD,G_COL_NAME_TOKEN,'Insurance Type',g_child_table_token,'OKL_INS_PRODUCTS_V',g_parent_table_token,'FND_LOOKUPS');

764: FETCH l_iptv_csr into l_dummy_var;
765: CLOSE l_iptv_csr;
766: -- if l_dummy_var is still set to default ,data was not found
767: IF (l_dummy_var ='?') THEN
768: OKC_API.set_message(G_APP_NAME,G_NO_PARENT_RECORD,G_COL_NAME_TOKEN,'Insurance Type',g_child_table_token,'OKL_INS_PRODUCTS_V',g_parent_table_token,'FND_LOOKUPS');
769:
770: --notify caller of an error
771: x_return_status := OKC_API.G_RET_STS_ERROR;
772: END IF;

Line 934: OKC_API.set_message(G_APP_NAME,G_NO_PARENT_RECORD,G_COL_NAME_TOKEN,'Insurance Type',g_child_table_token,'OKL_INS_PRODUCTS_V',g_parent_table_token,'FND_LOOKUPS');

930: FETCH l_fact_code_csr into l_dummy_var;
931: CLOSE l_fact_code_csr;
932: -- if l_dummy_var is still set to default ,data was not found
933: IF (l_dummy_var ='?') THEN
934: OKC_API.set_message(G_APP_NAME,G_NO_PARENT_RECORD,G_COL_NAME_TOKEN,'Insurance Type',g_child_table_token,'OKL_INS_PRODUCTS_V',g_parent_table_token,'FND_LOOKUPS');
935:
936: --notify caller of an error
937: x_return_status := OKC_API.G_RET_STS_ERROR;
938: END IF;

Line 1002: p_token2_value => 'OKL_INS_PRODUCTS_V',

998: p_msg_name => G_NO_PARENT_RECORD,
999: p_token1 => G_COL_NAME_TOKEN,
1000: p_token1_value => 'isu_id',
1001: p_token2 => g_child_table_token,
1002: p_token2_value => 'OKL_INS_PRODUCTS_V',
1003: p_token3 => g_parent_table_token,
1004: p_token3_value => 'OKX_INS_PROVIDER_V');
1005: -- notify caller of an error
1006: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 1341: -- FUNCTION get_rec for: OKL_INS_PRODUCTS_V

1337: BEGIN
1338: RETURN(get_rec(p_okl_ins_products_tl_rec, l_row_notfound));
1339: END get_rec;
1340: ---------------------------------------------------------------------------
1341: -- FUNCTION get_rec for: OKL_INS_PRODUCTS_V
1342: ---------------------------------------------------------------------------
1343: FUNCTION get_rec (
1344: p_iptv_rec IN iptv_rec_type,
1345: x_no_data_found OUT NOCOPY BOOLEAN

Line 1389: FROM Okl_Ins_Products_V

1385: CREATION_DATE,
1386: LAST_UPDATED_BY,
1387: LAST_UPDATE_DATE,
1388: LAST_UPDATE_LOGIN
1389: FROM Okl_Ins_Products_V
1390: WHERE okl_ins_products_v.id = p_id;
1391: l_okl_iptv_pk okl_iptv_pk_csr%ROWTYPE;
1392: l_iptv_rec iptv_rec_type;
1393: BEGIN

Line 1390: WHERE okl_ins_products_v.id = p_id;

1386: LAST_UPDATED_BY,
1387: LAST_UPDATE_DATE,
1388: LAST_UPDATE_LOGIN
1389: FROM Okl_Ins_Products_V
1390: WHERE okl_ins_products_v.id = p_id;
1391: l_okl_iptv_pk okl_iptv_pk_csr%ROWTYPE;
1392: l_iptv_rec iptv_rec_type;
1393: BEGIN
1394: x_no_data_found := TRUE;

Line 1450: -- FUNCTION null_out_defaults for: OKL_INS_PRODUCTS_V --

1446: BEGIN
1447: RETURN(get_rec(p_iptv_rec, l_row_notfound));
1448: END get_rec;
1449: --------------------------------------------------------
1450: -- FUNCTION null_out_defaults for: OKL_INS_PRODUCTS_V --
1451: --------------------------------------------------------
1452: FUNCTION null_out_defaults (
1453: p_iptv_rec IN iptv_rec_type
1454: ) RETURN iptv_rec_type IS

Line 1580: -- Validate_Attributes for:OKL_INS_PRODUCTS_V --

1576: ---------------------------------------------------------------------------
1577: -- PROCEDURE Validate_Attributes
1578: ---------------------------------------------------------------------------
1579: ------------------------------------------------
1580: -- Validate_Attributes for:OKL_INS_PRODUCTS_V --
1581: ------------------------------------------------
1582: FUNCTION Validate_Attributes (
1583: p_iptv_rec IN iptv_rec_type
1584: ) RETURN VARCHAR2 IS

Line 1845: -- Validate_Record for:OKL_INS_PRODUCTS_V --

1841: ---------------------------------------------------------------------------
1842: -- PROCEDURE Validate_Record
1843: ---------------------------------------------------------------------------
1844: --------------------------------------------
1845: -- Validate_Record for:OKL_INS_PRODUCTS_V --
1846: --------------------------------------------
1847: FUNCTION Validate_Record (
1848: p_iptv_rec IN iptv_rec_type
1849: ) RETURN VARCHAR2 IS

Line 2074: -- Validate_update_Record for:OKL_INS_PRODUCTS_V --

2070: ---------------------------------------------------------------------------
2071: -- PROCEDURE Validate_update_Record
2072: ---------------------------------------------------------------------------
2073: --------------------------------------------
2074: -- Validate_update_Record for:OKL_INS_PRODUCTS_V --
2075: --------------------------------------------
2076: FUNCTION Validate_update_Record (
2077: p_iptv_rec IN iptv_rec_type
2078: ) RETURN VARCHAR2 IS

Line 2256: -- validate_row for:OKL_INS_PRODUCTS_V --

2252: ---------------------------------------------------------------------------
2253: -- PROCEDURE validate_row
2254: ---------------------------------------------------------------------------
2255: -----------------------------------------
2256: -- validate_row for:OKL_INS_PRODUCTS_V --
2257: -----------------------------------------
2258: PROCEDURE validate_row(
2259: p_api_version IN NUMBER,
2260: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2671: -- insert_row for:OKL_INS_PRODUCTS_V --

2667: '_PVT'
2668: );
2669: END insert_row;
2670: ---------------------------------------
2671: -- insert_row for:OKL_INS_PRODUCTS_V --
2672: ---------------------------------------
2673: PROCEDURE insert_row(
2674: p_api_version IN NUMBER,
2675: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2706: -- Set_Attributes for:OKL_INS_PRODUCTS_V --

2702: l_iptv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2703: RETURN(l_iptv_rec);
2704: END fill_who_columns;
2705: -------------------------------------------
2706: -- Set_Attributes for:OKL_INS_PRODUCTS_V --
2707: -------------------------------------------
2708: FUNCTION Set_Attributes (
2709: p_iptv_rec IN iptv_rec_type,
2710: x_iptv_rec OUT NOCOPY iptv_rec_type

Line 3086: -- lock_row for:OKL_INS_PRODUCTS_V --

3082: '_PVT'
3083: );
3084: END lock_row;
3085: -------------------------------------
3086: -- lock_row for:OKL_INS_PRODUCTS_V --
3087: -------------------------------------
3088: PROCEDURE lock_row(
3089: p_api_version IN NUMBER,
3090: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3706: -- update_row for:OKL_INS_PRODUCTS_V --

3702: '_PVT'
3703: );
3704: END update_row;
3705: ---------------------------------------
3706: -- update_row for:OKL_INS_PRODUCTS_V --
3707: ---------------------------------------
3708: PROCEDURE update_row(
3709: p_api_version IN NUMBER,
3710: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3918: -- Set_Attributes for:OKL_INS_PRODUCTS_V --

3914: END IF;
3915: RETURN(l_return_status);
3916: END populate_new_record;
3917: -------------------------------------------
3918: -- Set_Attributes for:OKL_INS_PRODUCTS_V --
3919: -------------------------------------------
3920: FUNCTION Set_Attributes (
3921: p_iptv_rec IN iptv_rec_type,
3922: x_iptv_rec OUT NOCOPY iptv_rec_type

Line 4254: -- delete_row for:OKL_INS_PRODUCTS_V --

4250: '_PVT'
4251: );
4252: END delete_row;
4253: ---------------------------------------
4254: -- delete_row for:OKL_INS_PRODUCTS_V --
4255: ---------------------------------------
4256: PROCEDURE delete_row(
4257: p_api_version IN NUMBER,
4258: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,