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_B

Line 411: -- FUNCTION get_rec for: OKL_INS_POLICIES_B

407: BEGIN
408: RETURN(get_rec(p_ipyv_rec, l_row_not_found));
409: END get_rec;
410: ---------------------------------------------------------------------------
411: -- FUNCTION get_rec for: OKL_INS_POLICIES_B
412: ---------------------------------------------------------------------------
413: FUNCTION get_rec (
414: p_ipy_rec IN ipy_rec_type,
415: x_no_data_found OUT NOCOPY BOOLEAN

Line 492: FROM Okl_Ins_Policies_B

488: LAST_UPDATE_LOGIN,
489: -- Bug: 4567777 PAGARG new column for Lease Application Functionality impact
490: LEASE_APPLICATION_ID,
491: LEGAL_ENTITY_ID
492: FROM Okl_Ins_Policies_B
493: WHERE okl_ins_policies_b.id = p_id;
494: l_ipy_pk ipy_pk_csr%ROWTYPE;
495: l_ipy_rec ipy_rec_type;
496: BEGIN

Line 493: WHERE okl_ins_policies_b.id = p_id;

489: -- Bug: 4567777 PAGARG new column for Lease Application Functionality impact
490: LEASE_APPLICATION_ID,
491: LEGAL_ENTITY_ID
492: FROM Okl_Ins_Policies_B
493: WHERE okl_ins_policies_b.id = p_id;
494: l_ipy_pk ipy_pk_csr%ROWTYPE;
495: l_ipy_rec ipy_rec_type;
496: BEGIN
497: x_no_data_found := TRUE;

Line 3424: -- insert_row for:OKL_INS_POLICIES_B --

3420: ---------------------------------------------------------------------------
3421: -- PROCEDURE insert_row
3422: ---------------------------------------------------------------------------
3423: ---------------------------------------
3424: -- insert_row for:OKL_INS_POLICIES_B --
3425: ---------------------------------------
3426: PROCEDURE insert_row(
3427: p_init_msg_list IN VARCHAR2 ,
3428: x_return_status OUT NOCOPY VARCHAR2,

Line 3439: -- Set_Attributes for:OKL_INS_POLICIES_B --

3435: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3436: l_ipy_rec ipy_rec_type := p_ipy_rec;
3437: l_def_ipy_rec ipy_rec_type;
3438: -------------------------------------------
3439: -- Set_Attributes for:OKL_INS_POLICIES_B --
3440: -------------------------------------------
3441: FUNCTION Set_Attributes (
3442: p_ipy_rec IN ipy_rec_type,
3443: x_ipy_rec OUT NOCOPY ipy_rec_type

Line 3486: INSERT INTO OKL_INS_POLICIES_B(

3482: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3483: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3484: RAISE OKC_API.G_EXCEPTION_ERROR;
3485: END IF;
3486: INSERT INTO OKL_INS_POLICIES_B(
3487: id,
3488: ipy_type,
3489: name_of_insured,
3490: policy_number,

Line 4148: -- lock_row for:OKL_INS_POLICIES_B --

4144: ---------------------------------------------------------------------------
4145: -- PROCEDURE lock_row
4146: ---------------------------------------------------------------------------
4147: -------------------------------------
4148: -- lock_row for:OKL_INS_POLICIES_B --
4149: -------------------------------------
4150: PROCEDURE lock_row(
4151: p_init_msg_list IN VARCHAR2 ,
4152: x_return_status OUT NOCOPY VARCHAR2,

Line 4160: FROM OKL_INS_POLICIES_B

4156: E_Resource_Busy EXCEPTION;
4157: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
4158: CURSOR lock_csr (p_ipy_rec IN ipy_rec_type) IS
4159: SELECT OBJECT_VERSION_NUMBER
4160: FROM OKL_INS_POLICIES_B
4161: WHERE ID = p_ipy_rec.id
4162: AND OBJECT_VERSION_NUMBER = p_ipy_rec.object_version_number
4163: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
4164: CURSOR lchk_csr (p_ipy_rec IN ipy_rec_type) IS

Line 4166: FROM OKL_INS_POLICIES_B

4162: AND OBJECT_VERSION_NUMBER = p_ipy_rec.object_version_number
4163: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
4164: CURSOR lchk_csr (p_ipy_rec IN ipy_rec_type) IS
4165: SELECT OBJECT_VERSION_NUMBER
4166: FROM OKL_INS_POLICIES_B
4167: WHERE ID = p_ipy_rec.id;
4168: l_api_version CONSTANT NUMBER := 1;
4169: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
4170: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 4171: l_object_version_number OKL_INS_POLICIES_B.OBJECT_VERSION_NUMBER%TYPE;

4167: WHERE ID = p_ipy_rec.id;
4168: l_api_version CONSTANT NUMBER := 1;
4169: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
4170: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4171: l_object_version_number OKL_INS_POLICIES_B.OBJECT_VERSION_NUMBER%TYPE;
4172: lc_object_version_number OKL_INS_POLICIES_B.OBJECT_VERSION_NUMBER%TYPE;
4173: l_row_notfound BOOLEAN := FALSE;
4174: lc_row_notfound BOOLEAN := FALSE;
4175: BEGIN

Line 4172: lc_object_version_number OKL_INS_POLICIES_B.OBJECT_VERSION_NUMBER%TYPE;

4168: l_api_version CONSTANT NUMBER := 1;
4169: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
4170: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4171: l_object_version_number OKL_INS_POLICIES_B.OBJECT_VERSION_NUMBER%TYPE;
4172: lc_object_version_number OKL_INS_POLICIES_B.OBJECT_VERSION_NUMBER%TYPE;
4173: l_row_notfound BOOLEAN := FALSE;
4174: lc_row_notfound BOOLEAN := FALSE;
4175: BEGIN
4176: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 4586: -- update_row for:OKL_INS_POLICIES_B --

4582: ---------------------------------------------------------------------------
4583: -- PROCEDURE update_row
4584: ---------------------------------------------------------------------------
4585: ---------------------------------------
4586: -- update_row for:OKL_INS_POLICIES_B --
4587: ---------------------------------------
4588: PROCEDURE update_row(
4589: p_init_msg_list IN VARCHAR2 ,
4590: x_return_status OUT NOCOPY VARCHAR2,

Line 4909: -- Set_Attributes for:OKL_INS_POLICIES_B --

4905: END IF;
4906: RETURN(l_return_status);
4907: END populate_new_record;
4908: -------------------------------------------
4909: -- Set_Attributes for:OKL_INS_POLICIES_B --
4910: -------------------------------------------
4911: FUNCTION Set_Attributes (
4912: p_ipy_rec IN ipy_rec_type,
4913: x_ipy_rec OUT NOCOPY ipy_rec_type

Line 4956: UPDATE OKL_INS_POLICIES_B

4952: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4953: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4954: RAISE OKC_API.G_EXCEPTION_ERROR;
4955: END IF;
4956: UPDATE OKL_INS_POLICIES_B
4957: SET IPY_TYPE = l_def_ipy_rec.ipy_type,
4958: NAME_OF_INSURED = l_def_ipy_rec.name_of_insured,
4959: POLICY_NUMBER = l_def_ipy_rec.policy_number,
4960: INSURANCE_FACTOR = l_def_ipy_rec.insurance_factor,

Line 5915: -- delete_row for:OKL_INS_POLICIES_B --

5911: ---------------------------------------------------------------------------
5912: -- PROCEDURE delete_row
5913: ---------------------------------------------------------------------------
5914: ---------------------------------------
5915: -- delete_row for:OKL_INS_POLICIES_B --
5916: ---------------------------------------
5917: PROCEDURE delete_row(
5918: p_init_msg_list IN VARCHAR2 ,
5919: x_return_status OUT NOCOPY VARCHAR2,

Line 5938: DELETE FROM OKL_INS_POLICIES_B

5934: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5935: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5936: RAISE OKC_API.G_EXCEPTION_ERROR;
5937: END IF;
5938: DELETE FROM OKL_INS_POLICIES_B
5939: WHERE ID = p_ipy_rec.id;
5940: x_return_status := l_return_status;
5941: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
5942: EXCEPTION