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_IPY_PVT dependencies on OKL_INS_POLICIES_V

Line 177: FROM okl_ins_policies_v

173: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
174: l_dummy_var VARCHAR2(1) := '?';
175: CURSOR l_ipyv_csr IS
176: SELECT 'x'
177: FROM okl_ins_policies_v
178: WHERE ipy_type = 'THIRD_PARTY_POLICY'
179: AND ipy_type = p_ipyv_rec.ipy_type
180: AND policy_number = p_ipyv_rec.policy_number
181: AND ID <> p_ipyv_rec.id

Line 205: -- FUNCTION get_rec for: OKL_INS_POLICIES_V

201: END validate_thirdparty_duplicates;
202:
203:
204: ---------------------------------------------------------------------------
205: -- FUNCTION get_rec for: OKL_INS_POLICIES_V
206: ---------------------------------------------------------------------------
207: FUNCTION get_rec (
208: p_ipyv_rec IN ipyv_rec_type,
209: x_no_data_found OUT NOCOPY BOOLEAN

Line 291: FROM Okl_Ins_Policies_V

287: LAST_UPDATE_LOGIN,
288: -- Bug: 4567777 PAGARG new column for Lease Application Functionality impact
289: LEASE_APPLICATION_ID,
290: LEGAL_ENTITY_ID
291: FROM Okl_Ins_Policies_V
292: WHERE okl_ins_policies_v.id = p_id;
293: l_okl_ipyv_pk okl_ipyv_pk_csr%ROWTYPE;
294: l_ipyv_rec ipyv_rec_type;
295: BEGIN

Line 292: WHERE okl_ins_policies_v.id = p_id;

288: -- Bug: 4567777 PAGARG new column for Lease Application Functionality impact
289: LEASE_APPLICATION_ID,
290: LEGAL_ENTITY_ID
291: FROM Okl_Ins_Policies_V
292: WHERE okl_ins_policies_v.id = p_id;
293: l_okl_ipyv_pk okl_ipyv_pk_csr%ROWTYPE;
294: l_ipyv_rec ipyv_rec_type;
295: BEGIN
296: x_no_data_found := TRUE;

Line 683: -- FUNCTION null_out_defaults for: OKL_INS_POLICIES_V

679: BEGIN
680: RETURN(get_rec(p_okl_ins_policies_tl_rec, l_row_not_found));
681: END get_rec;
682: ---------------------------------------------------------------------------
683: -- FUNCTION null_out_defaults for: OKL_INS_POLICIES_V
684: ---------------------------------------------------------------------------
685: FUNCTION null_out_defaults (
686: p_ipyv_rec IN ipyv_rec_type
687: ) RETURN ipyv_rec_type IS

Line 1028: OKC_API.set_message(G_APP_NAME,G_NO_PARENT_RECORD,G_COL_NAME_TOKEN,'Territory Code',g_child_table_token,'OKL_INS_POLICIES_V',g_parent_table_token,'FND_TERRITORIES_VL');

1024: FETCH l_terr_csr INTO l_dummy_var ;
1025: CLOSE l_terr_csr ;
1026: -- if l_dummy_var is still set to default ,data was not found
1027: IF (l_dummy_var ='?') THEN
1028: OKC_API.set_message(G_APP_NAME,G_NO_PARENT_RECORD,G_COL_NAME_TOKEN,'Territory Code',g_child_table_token,'OKL_INS_POLICIES_V',g_parent_table_token,'FND_TERRITORIES_VL');
1029: --notify caller of an error
1030: x_return_status := OKC_API.G_RET_STS_ERROR;
1031: END IF;
1032: EXCEPTION

Line 1077: 'OKL_INS_POLICIES_V' ,

1073: G_NO_PARENT_RECORD,
1074: g_col_name_token,
1075: 'Payment Frequency',
1076: g_child_table_token ,
1077: 'OKL_INS_POLICIES_V' ,
1078: g_parent_table_token ,
1079: 'FND_LOOKUPS');
1080: x_return_status := OKC_API.G_RET_STS_ERROR;
1081: END IF;

Line 1128: 'OKL_INS_POLICIES_V' ,

1124: g_no_parent_record,
1125: g_col_name_token,
1126: 'Agent Address',
1127: g_child_table_token ,
1128: 'OKL_INS_POLICIES_V' ,
1129: g_parent_table_token ,
1130: 'OKL_INS_PARTYSITES_V');
1131: x_return_status := OKC_API.G_RET_STS_ERROR;
1132: END IF;

Line 1179: 'OKL_INS_POLICIES_V' ,

1175: g_no_parent_record,
1176: g_col_name_token,
1177: 'Agency Address',
1178: g_child_table_token ,
1179: 'OKL_INS_POLICIES_V' ,
1180: g_parent_table_token ,
1181: 'OKL_INS_PARTYSITES_V');
1182: x_return_status := OKC_API.G_RET_STS_ERROR;
1183: END IF;

Line 1230: 'OKL_INS_POLICIES_V' ,

1226: g_no_parent_record,
1227: g_col_name_token,
1228: 'Insurance Agent',
1229: g_child_table_token ,
1230: 'OKL_INS_POLICIES_V' ,
1231: g_parent_table_token ,
1232: 'HZ_PARTIES'); --Bug:3825159
1233: x_return_status := OKC_API.G_RET_STS_ERROR;
1234: END IF;

Line 1291: 'OKL_INS_POLICIES_V' ,

1287: g_no_parent_record,
1288: g_col_name_token,
1289: 'Insurance Provider',
1290: g_child_table_token ,
1291: 'OKL_INS_POLICIES_V' ,
1292: g_parent_table_token ,
1293: 'HZ_PARTIES'); --Bug:3825159
1294: x_return_status := OKC_API.G_RET_STS_ERROR;
1295: END IF;

Line 1343: 'OKL_INS_POLICIES_V' ,

1339: g_no_parent_record,
1340: g_col_name_token,
1341: 'Insurance Product',
1342: g_child_table_token ,
1343: 'OKL_INS_POLICIES_V' ,
1344: g_parent_table_token ,
1345: 'OKL_INS_PRODUCTS_V');
1346: x_return_status := OKC_API.G_RET_STS_ERROR;
1347: END IF;

Line 1369: FROM OKL_INS_POLICIES_V

1365: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1366: l_dummy_var VARCHAR2(1) := '?' ;
1367: CURSOR l_ipy_csr IS
1368: SELECT 'x'
1369: FROM OKL_INS_POLICIES_V
1370: WHERE id = p_ipyv_rec.ipy_id ;
1371: BEGIN
1372: -- initialize return status
1373: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 1386: 'OKL_INS_POLICIES_V' ,

1382: g_no_parent_record,
1383: g_col_name_token,
1384: 'Policy Number',
1385: g_child_table_token ,
1386: 'OKL_INS_POLICIES_V' ,
1387: g_parent_table_token ,
1388: 'OKL_INS_POLICIES_V');
1389: x_return_status := OKC_API.G_RET_STS_ERROR;
1390: END IF;

Line 1388: 'OKL_INS_POLICIES_V');

1384: 'Policy Number',
1385: g_child_table_token ,
1386: 'OKL_INS_POLICIES_V' ,
1387: g_parent_table_token ,
1388: 'OKL_INS_POLICIES_V');
1389: x_return_status := OKC_API.G_RET_STS_ERROR;
1390: END IF;
1391: END IF;
1392: EXCEPTION

Line 1438: 'OKL_INS_POLICIES_V' ,

1434: g_no_parent_record,
1435: g_col_name_token,
1436: 'Policy Type',
1437: g_child_table_token ,
1438: 'OKL_INS_POLICIES_V' ,
1439: g_parent_table_token ,
1440: 'FND_LOOKUPS');
1441: x_return_status := OKC_API.G_RET_STS_ERROR;
1442: END IF;

Line 1485: 'OKL_INS_POLICIES_V' ,

1481: g_no_parent_record,
1482: g_col_name_token,
1483: 'Cancellation Reason',
1484: g_child_table_token ,
1485: 'OKL_INS_POLICIES_V' ,
1486: g_parent_table_token ,
1487: 'FND_LOOKUPS');
1488: x_return_status := OKC_API.G_RET_STS_ERROR;
1489: END IF;

Line 1537: 'OKL_INS_POLICIES_V' ,

1533: g_no_parent_record,
1534: g_col_name_token,
1535: 'Status',
1536: g_child_table_token ,
1537: 'OKL_INS_POLICIES_V' ,
1538: g_parent_table_token ,
1539: 'FND_LOOKUPS');
1540: x_return_status := OKC_API.G_RET_STS_ERROR;
1541: END IF;

Line 1585: 'OKL_INS_POLICIES_V' ,

1581: g_no_parent_record,
1582: g_col_name_token,
1583: 'Contract Line ID',
1584: g_child_table_token ,
1585: 'OKL_INS_POLICIES_V' ,
1586: g_parent_table_token ,
1587: 'OKL_K_LINES_V');
1588: x_return_status := OKC_API.G_RET_STS_ERROR;
1589: END IF;

Line 1633: 'OKL_INS_POLICIES_V' ,

1629: g_no_parent_record,
1630: g_col_name_token,
1631: 'Contract Id',
1632: g_child_table_token ,
1633: 'OKL_INS_POLICIES_V' ,
1634: g_parent_table_token ,
1635: 'OKL_K_HEADERS_V');
1636: x_return_status := OKC_API.G_RET_STS_ERROR;
1637: END IF;

Line 1680: 'OKL_INS_POLICIES_V' ,

1676: g_no_parent_record,
1677: g_col_name_token,
1678: 'Contract Id',
1679: g_child_table_token ,
1680: 'OKL_INS_POLICIES_V' ,
1681: g_parent_table_token ,
1682: 'OKL_LEASE_APPLICATIONS_V');
1683: x_return_status := OKC_API.G_RET_STS_ERROR;
1684: END IF;

Line 1745: 'OKL_INS_POLICIES_V' ,

1741: g_no_parent_record,
1742: g_col_name_token,
1743: 'Policy Type',
1744: g_child_table_token ,
1745: 'OKL_INS_POLICIES_V' ,
1746: g_parent_table_token ,
1747: 'FND_LOOKUPS');
1748: WHEN OTHERS THEN
1749: -- store SQL error message on message stack for caller

Line 2437: -- Validate_Attributes for:OKL_INS_POLICIES_V --

2433: ---------------------------------------------------------------------------
2434: -- FUNCTION Validate_Attributes
2435: ---------------------------------------------------------------------------
2436: ------------------------------------------------
2437: -- Validate_Attributes for:OKL_INS_POLICIES_V --
2438: ------------------------------------------------
2439: FUNCTION Validate_Attributes (
2440: p_ipyv_rec IN ipyv_rec_type
2441: ) RETURN VARCHAR2 IS

Line 2894: FROM okl_ins_policies_v

2890: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2891: l_dummy_var VARCHAR2(1) := '?';
2892: CURSOR l_ipyv_csr IS
2893: SELECT 'x'
2894: FROM okl_ins_policies_v
2895: WHERE khr_id = p_ipyv_rec.khr_id
2896: AND ID <> p_ipyv_rec.ID
2897: AND IPY_TYPE ='THIRD_PARTY_POLICY';
2898: BEGIN

Line 2921: -- Validate Record for:OKL_INS_POLICIES_V --

2917: ---------------------------------------------------------------------------
2918: -- PROCEDURE Validate_Record
2919: ---------------------------------------------------------------------------
2920: --------------------------------------------
2921: -- Validate Record for:OKL_INS_POLICIES_V --
2922: --------------------------------------------
2923: ------------------------------------
2924: -- FUNCTION validate_foreign_keys --
2925: ------------------------------------

Line 3191: -- validate_row for:OKL_INS_POLICIES_V --

3187: ---------------------------------------------------------------------------
3188: -- PROCEDURE validate_row
3189: ---------------------------------------------------------------------------
3190: -----------------------------------------
3191: -- validate_row for:OKL_INS_POLICIES_V --
3192: -----------------------------------------
3193: PROCEDURE validate_row(
3194: p_api_version IN NUMBER,
3195: p_init_msg_list IN VARCHAR2 ,

Line 3267: -- PL/SQL TBL validate_row for:OKL_INS_POLICIES_V --

3263: '_PVT'
3264: );
3265: END validate_row;
3266: ----------------------------------------------------
3267: -- PL/SQL TBL validate_row for:OKL_INS_POLICIES_V --
3268: ----------------------------------------------------
3269: PROCEDURE validate_row(
3270: p_api_version IN NUMBER,
3271: p_init_msg_list IN VARCHAR2 ,

Line 3361: -- PL/SQL TBL validate_row for:OKL_INS_POLICIES_V --

3357: '_PVT'
3358: );
3359: END validate_row;
3360: ----------------------------------------------------
3361: -- PL/SQL TBL validate_row for:OKL_INS_POLICIES_V --
3362: ----------------------------------------------------
3363: PROCEDURE validate_row(
3364: p_api_version IN NUMBER,
3365: p_init_msg_list IN VARCHAR2 ,

Line 3791: -- insert_row for :OKL_INS_POLICIES_V --

3787: '_PVT'
3788: );
3789: END insert_row;
3790: ----------------------------------------
3791: -- insert_row for :OKL_INS_POLICIES_V --
3792: ----------------------------------------
3793: PROCEDURE insert_row(
3794: p_api_version IN NUMBER,
3795: p_init_msg_list IN VARCHAR2 ,

Line 3826: -- Set_Attributes for:OKL_INS_POLICIES_V --

3822: l_ipyv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
3823: RETURN(l_ipyv_rec);
3824: END fill_who_columns;
3825: -------------------------------------------
3826: -- Set_Attributes for:OKL_INS_POLICIES_V --
3827: -------------------------------------------
3828: FUNCTION Set_Attributes (
3829: p_ipyv_rec IN ipyv_rec_type,
3830: x_ipyv_rec OUT NOCOPY ipyv_rec_type

Line 3856: -- Set_adjustedby_Id for:OKL_INS_POLICIES_V --

3852: RETURN(l_return_status);
3853: END Set_Attributes;
3854:
3855: -------------------------------------------
3856: -- Set_adjustedby_Id for:OKL_INS_POLICIES_V --
3857: --added as a fix for bug 2513901
3858: -------------------------------------------
3859: FUNCTION set_adjustedby_id(
3860: p_ipyv_rec IN ipyv_rec_type

Line 4335: -- lock_row for: OKL_INS_POLICIES_V --

4331: '_PVT'
4332: );
4333: END lock_row;
4334: --------------------------------------
4335: -- lock_row for: OKL_INS_POLICIES_V --
4336: --------------------------------------
4337: PROCEDURE lock_row(
4338: p_api_version IN NUMBER,
4339: p_init_msg_list IN VARCHAR2 ,

Line 5245: -- update_row for:OKL_INS_POLICIES_V --

5241: '_PVT'
5242: );
5243: END update_row;
5244: ---------------------------------------
5245: -- update_row for:OKL_INS_POLICIES_V --
5246: ---------------------------------------
5247: PROCEDURE update_row(
5248: p_api_version IN NUMBER,
5249: p_init_msg_list IN VARCHAR2 ,

Line 5603: -- Set_Attributes for:OKL_INS_POLICIES_V --

5599: END IF;
5600: RETURN(l_return_status);
5601: END populate_new_record;
5602: -------------------------------------------
5603: -- Set_Attributes for:OKL_INS_POLICIES_V --
5604: -------------------------------------------
5605: FUNCTION Set_Attributes (
5606: p_ipyv_rec IN ipyv_rec_type,
5607: x_ipyv_rec OUT NOCOPY ipyv_rec_type

Line 6035: -- delete_row for:OKL_INS_POLICIES_V --

6031: '_PVT'
6032: );
6033: END delete_row;
6034: ---------------------------------------
6035: -- delete_row for:OKL_INS_POLICIES_V --
6036: ---------------------------------------
6037: PROCEDURE delete_row(
6038: p_api_version IN NUMBER,
6039: p_init_msg_list IN VARCHAR2 ,

Line 6130: -- PL/SQL TBL delete_row for:OKL_INS_POLICIES_V --

6126: '_PVT'
6127: );
6128: END delete_row;
6129: --------------------------------------------------
6130: -- PL/SQL TBL delete_row for:OKL_INS_POLICIES_V --
6131: --------------------------------------------------
6132: PROCEDURE delete_row(
6133: p_api_version IN NUMBER,
6134: p_init_msg_list IN VARCHAR2 ,

Line 6224: -- PL/SQL TBL delete_row for:OKL_INS_POLICIES_V --

6220: '_PVT'
6221: );
6222: END delete_row;
6223: --------------------------------------------------
6224: -- PL/SQL TBL delete_row for:OKL_INS_POLICIES_V --
6225: --------------------------------------------------
6226: PROCEDURE delete_row(
6227: p_api_version IN NUMBER,
6228: p_init_msg_list IN VARCHAR2 ,