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.OKC_CPL_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 74: FROM OKC_K_PARTY_ROLES_B B

70:
71: DELETE FROM OKC_K_PARTY_ROLES_TL T
72: WHERE NOT EXISTS (
73: SELECT NULL
74: FROM OKC_K_PARTY_ROLES_B B
75: WHERE B.ID = T.ID
76: );
77:
78: UPDATE OKC_K_PARTY_ROLES_TL T SET (

Line 142: FROM OKC_K_PARTY_ROLES_BH B

138: /*
139: DELETE FROM OKC_K_PARTY_ROLES_TLH T
140: WHERE NOT EXISTS (
141: SELECT NULL
142: FROM OKC_K_PARTY_ROLES_BH B
143: WHERE B.ID = T.ID
144: AND B.MAJOR_VERSION = T.MAJOR_VERSION
145: );
146:

Line 222: -- FUNCTION get_rec for: OKC_K_PARTY_ROLES_B

218:
219: END add_language;
220:
221: ---------------------------------------------------------------------------
222: -- FUNCTION get_rec for: OKC_K_PARTY_ROLES_B
223: ---------------------------------------------------------------------------
224: FUNCTION get_rec (
225: p_cpl_rec IN cpl_rec_type,
226: x_no_data_found OUT NOCOPY BOOLEAN

Line 273: FROM Okc_K_Party_Roles_B

269: ORIG_SYSTEM_ID1,
270: ORIG_SYSTEM_REFERENCE1,
271: ORIG_SYSTEM_SOURCE_CODE
272: -- R12 Data Model Changes 4485150 End
273: FROM Okc_K_Party_Roles_B
274: WHERE okc_k_party_roles_b.id = p_id;
275: l_cpl_pk cpl_pk_csr%ROWTYPE;
276: l_cpl_rec cpl_rec_type;
277: BEGIN

Line 274: WHERE okc_k_party_roles_b.id = p_id;

270: ORIG_SYSTEM_REFERENCE1,
271: ORIG_SYSTEM_SOURCE_CODE
272: -- R12 Data Model Changes 4485150 End
273: FROM Okc_K_Party_Roles_B
274: WHERE okc_k_party_roles_b.id = p_id;
275: l_cpl_pk cpl_pk_csr%ROWTYPE;
276: l_cpl_rec cpl_rec_type;
277: BEGIN
278:

Line 788: from OKC_K_PARTY_ROLES_B

784: p_cplv_rec IN CPLV_REC_TYPE) is
785: l_dummy_var varchar2(1) := '?';
786: cursor l_cpl_csr is
787: select 'x'
788: from OKC_K_PARTY_ROLES_B
789: where id = p_cplv_rec.cpl_id;
790: begin
791:
792: IF (l_debug = 'Y') THEN

Line 971: FROM OKC_K_PARTY_ROLES_B PARTY

967: --Duplicate Party Role Check
968: --Only for service Contract
969: CURSOR l_Duplicate_role_csr IS
970: SELECT 'x'
971: FROM OKC_K_PARTY_ROLES_B PARTY
972: WHERE PARTY.DNZ_CHR_ID = p_cplv_rec.chr_id
973: AND PARTY.CLE_ID IS NULL
974: AND PARTY.RLE_CODE = p_cplv_rec.rle_code ;
975: --Bug#3101222 */

Line 1467: FROM OKC_K_PARTY_ROLES_B

1463: l_dummy varchar2(1) := '?';
1464:
1465: CURSOR l_party_csr IS
1466: SELECT '!'
1467: FROM OKC_K_PARTY_ROLES_B
1468: WHERE Id <> NVL(p_cplv_rec.id,-99999)
1469: AND dnz_chr_id = p_cplv_rec.dnz_chr_id
1470: AND cle_id IS NULL
1471: AND primary_yn = 'Y';

Line 1732: cursor c1(p_chr_id okc_k_party_roles_b.chr_id%TYPE,

1728: and buy_or_sell = p_intent;
1729: --
1730:
1731:
1732: cursor c1(p_chr_id okc_k_party_roles_b.chr_id%TYPE,
1733: p_rle_code okc_k_party_roles_b.rle_code%TYPE,
1734: p_jtot_object1_code okc_k_party_roles_b.jtot_object1_code%TYPE,
1735: p_object1_id1 okc_k_party_roles_b.object1_id1%TYPE,
1736: p_object1_id2 okc_k_party_roles_b.object1_id2%TYPE) is

Line 1733: p_rle_code okc_k_party_roles_b.rle_code%TYPE,

1729: --
1730:
1731:
1732: cursor c1(p_chr_id okc_k_party_roles_b.chr_id%TYPE,
1733: p_rle_code okc_k_party_roles_b.rle_code%TYPE,
1734: p_jtot_object1_code okc_k_party_roles_b.jtot_object1_code%TYPE,
1735: p_object1_id1 okc_k_party_roles_b.object1_id1%TYPE,
1736: p_object1_id2 okc_k_party_roles_b.object1_id2%TYPE) is
1737: select id

Line 1734: p_jtot_object1_code okc_k_party_roles_b.jtot_object1_code%TYPE,

1730:
1731:
1732: cursor c1(p_chr_id okc_k_party_roles_b.chr_id%TYPE,
1733: p_rle_code okc_k_party_roles_b.rle_code%TYPE,
1734: p_jtot_object1_code okc_k_party_roles_b.jtot_object1_code%TYPE,
1735: p_object1_id1 okc_k_party_roles_b.object1_id1%TYPE,
1736: p_object1_id2 okc_k_party_roles_b.object1_id2%TYPE) is
1737: select id
1738: from okc_k_party_roles_b

Line 1735: p_object1_id1 okc_k_party_roles_b.object1_id1%TYPE,

1731:
1732: cursor c1(p_chr_id okc_k_party_roles_b.chr_id%TYPE,
1733: p_rle_code okc_k_party_roles_b.rle_code%TYPE,
1734: p_jtot_object1_code okc_k_party_roles_b.jtot_object1_code%TYPE,
1735: p_object1_id1 okc_k_party_roles_b.object1_id1%TYPE,
1736: p_object1_id2 okc_k_party_roles_b.object1_id2%TYPE) is
1737: select id
1738: from okc_k_party_roles_b
1739: where chr_id = p_chr_id

Line 1736: p_object1_id2 okc_k_party_roles_b.object1_id2%TYPE) is

1732: cursor c1(p_chr_id okc_k_party_roles_b.chr_id%TYPE,
1733: p_rle_code okc_k_party_roles_b.rle_code%TYPE,
1734: p_jtot_object1_code okc_k_party_roles_b.jtot_object1_code%TYPE,
1735: p_object1_id1 okc_k_party_roles_b.object1_id1%TYPE,
1736: p_object1_id2 okc_k_party_roles_b.object1_id2%TYPE) is
1737: select id
1738: from okc_k_party_roles_b
1739: where chr_id = p_chr_id
1740: and rle_code = p_rle_code

Line 1738: from okc_k_party_roles_b

1734: p_jtot_object1_code okc_k_party_roles_b.jtot_object1_code%TYPE,
1735: p_object1_id1 okc_k_party_roles_b.object1_id1%TYPE,
1736: p_object1_id2 okc_k_party_roles_b.object1_id2%TYPE) is
1737: select id
1738: from okc_k_party_roles_b
1739: where chr_id = p_chr_id
1740: and rle_code = p_rle_code
1741: and jtot_object1_code = p_jtot_object1_code
1742: and object1_id1 = p_object1_id1

Line 1745: cursor c2(p_cle_id okc_k_party_roles_b.cle_id%TYPE,

1741: and jtot_object1_code = p_jtot_object1_code
1742: and object1_id1 = p_object1_id1
1743: and object1_id2 = p_object1_id2;
1744:
1745: cursor c2(p_cle_id okc_k_party_roles_b.cle_id%TYPE,
1746: p_rle_code okc_k_party_roles_b.rle_code%TYPE,
1747: p_jtot_object1_code okc_k_party_roles_b.jtot_object1_code%TYPE,
1748: p_object1_id1 okc_k_party_roles_b.object1_id1%TYPE,
1749: p_object1_id2 okc_k_party_roles_b.object1_id2%TYPE) is

Line 1746: p_rle_code okc_k_party_roles_b.rle_code%TYPE,

1742: and object1_id1 = p_object1_id1
1743: and object1_id2 = p_object1_id2;
1744:
1745: cursor c2(p_cle_id okc_k_party_roles_b.cle_id%TYPE,
1746: p_rle_code okc_k_party_roles_b.rle_code%TYPE,
1747: p_jtot_object1_code okc_k_party_roles_b.jtot_object1_code%TYPE,
1748: p_object1_id1 okc_k_party_roles_b.object1_id1%TYPE,
1749: p_object1_id2 okc_k_party_roles_b.object1_id2%TYPE) is
1750: select id

Line 1747: p_jtot_object1_code okc_k_party_roles_b.jtot_object1_code%TYPE,

1743: and object1_id2 = p_object1_id2;
1744:
1745: cursor c2(p_cle_id okc_k_party_roles_b.cle_id%TYPE,
1746: p_rle_code okc_k_party_roles_b.rle_code%TYPE,
1747: p_jtot_object1_code okc_k_party_roles_b.jtot_object1_code%TYPE,
1748: p_object1_id1 okc_k_party_roles_b.object1_id1%TYPE,
1749: p_object1_id2 okc_k_party_roles_b.object1_id2%TYPE) is
1750: select id
1751: from okc_k_party_roles_b

Line 1748: p_object1_id1 okc_k_party_roles_b.object1_id1%TYPE,

1744:
1745: cursor c2(p_cle_id okc_k_party_roles_b.cle_id%TYPE,
1746: p_rle_code okc_k_party_roles_b.rle_code%TYPE,
1747: p_jtot_object1_code okc_k_party_roles_b.jtot_object1_code%TYPE,
1748: p_object1_id1 okc_k_party_roles_b.object1_id1%TYPE,
1749: p_object1_id2 okc_k_party_roles_b.object1_id2%TYPE) is
1750: select id
1751: from okc_k_party_roles_b
1752: where cle_id = p_cle_id

Line 1749: p_object1_id2 okc_k_party_roles_b.object1_id2%TYPE) is

1745: cursor c2(p_cle_id okc_k_party_roles_b.cle_id%TYPE,
1746: p_rle_code okc_k_party_roles_b.rle_code%TYPE,
1747: p_jtot_object1_code okc_k_party_roles_b.jtot_object1_code%TYPE,
1748: p_object1_id1 okc_k_party_roles_b.object1_id1%TYPE,
1749: p_object1_id2 okc_k_party_roles_b.object1_id2%TYPE) is
1750: select id
1751: from okc_k_party_roles_b
1752: where cle_id = p_cle_id
1753: and rle_code = p_rle_code

Line 1751: from okc_k_party_roles_b

1747: p_jtot_object1_code okc_k_party_roles_b.jtot_object1_code%TYPE,
1748: p_object1_id1 okc_k_party_roles_b.object1_id1%TYPE,
1749: p_object1_id2 okc_k_party_roles_b.object1_id2%TYPE) is
1750: select id
1751: from okc_k_party_roles_b
1752: where cle_id = p_cle_id
1753: and rle_code = p_rle_code
1754: and jtot_object1_code = p_jtot_object1_code
1755: and object1_id1 = p_object1_id1

Line 2253: -- insert_row for:OKC_K_PARTY_ROLES_B --

2249: ---------------------------------------------------------------------------
2250: -- PROCEDURE insert_row
2251: ---------------------------------------------------------------------------
2252: ----------------------------------------
2253: -- insert_row for:OKC_K_PARTY_ROLES_B --
2254: ----------------------------------------
2255: PROCEDURE insert_row(
2256: p_init_msg_list IN VARCHAR2 ,
2257: x_return_status OUT NOCOPY VARCHAR2,

Line 2269: -- Set_Attributes for:OKC_K_PARTY_ROLES_B --

2265: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2266: l_cpl_rec cpl_rec_type := p_cpl_rec;
2267: l_def_cpl_rec cpl_rec_type;
2268: --------------------------------------------
2269: -- Set_Attributes for:OKC_K_PARTY_ROLES_B --
2270: --------------------------------------------
2271: FUNCTION Set_Attributes (
2272: p_cpl_rec IN cpl_rec_type,
2273: x_cpl_rec OUT NOCOPY cpl_rec_type

Line 2330: INSERT INTO OKC_K_PARTY_ROLES_B(

2326: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2327: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2328: RAISE OKC_API.G_EXCEPTION_ERROR;
2329: END IF;
2330: INSERT INTO OKC_K_PARTY_ROLES_B(
2331: id,
2332: cpl_id,
2333: chr_id,
2334: cle_id,

Line 2932: -- lock_row for:OKC_K_PARTY_ROLES_B --

2928: ---------------------------------------------------------------------------
2929: -- PROCEDURE lock_row
2930: ---------------------------------------------------------------------------
2931: --------------------------------------
2932: -- lock_row for:OKC_K_PARTY_ROLES_B --
2933: --------------------------------------
2934: PROCEDURE lock_row(
2935: p_init_msg_list IN VARCHAR2 ,
2936: x_return_status OUT NOCOPY VARCHAR2,

Line 2945: FROM OKC_K_PARTY_ROLES_B

2941: E_Resource_Busy EXCEPTION;
2942: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2943: CURSOR lock_csr (p_cpl_rec IN cpl_rec_type) IS
2944: SELECT OBJECT_VERSION_NUMBER
2945: FROM OKC_K_PARTY_ROLES_B
2946: WHERE ID = p_cpl_rec.id
2947: AND OBJECT_VERSION_NUMBER = p_cpl_rec.object_version_number
2948: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2949:

Line 2952: FROM OKC_K_PARTY_ROLES_B

2948: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2949:
2950: CURSOR lchk_csr (p_cpl_rec IN cpl_rec_type) IS
2951: SELECT OBJECT_VERSION_NUMBER
2952: FROM OKC_K_PARTY_ROLES_B
2953: WHERE ID = p_cpl_rec.id;
2954: l_api_version CONSTANT NUMBER := 1;
2955: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2956: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2957: l_object_version_number OKC_K_PARTY_ROLES_B.OBJECT_VERSION_NUMBER%TYPE;

2953: WHERE ID = p_cpl_rec.id;
2954: l_api_version CONSTANT NUMBER := 1;
2955: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2956: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2957: l_object_version_number OKC_K_PARTY_ROLES_B.OBJECT_VERSION_NUMBER%TYPE;
2958: lc_object_version_number OKC_K_PARTY_ROLES_B.OBJECT_VERSION_NUMBER%TYPE;
2959: l_row_notfound BOOLEAN := FALSE;
2960: lc_row_notfound BOOLEAN := FALSE;
2961: BEGIN

Line 2958: lc_object_version_number OKC_K_PARTY_ROLES_B.OBJECT_VERSION_NUMBER%TYPE;

2954: l_api_version CONSTANT NUMBER := 1;
2955: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2956: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2957: l_object_version_number OKC_K_PARTY_ROLES_B.OBJECT_VERSION_NUMBER%TYPE;
2958: lc_object_version_number OKC_K_PARTY_ROLES_B.OBJECT_VERSION_NUMBER%TYPE;
2959: l_row_notfound BOOLEAN := FALSE;
2960: lc_row_notfound BOOLEAN := FALSE;
2961: BEGIN
2962:

Line 3445: -- update_row for:OKC_K_PARTY_ROLES_B --

3441: ---------------------------------------------------------------------------
3442: -- PROCEDURE update_row
3443: ---------------------------------------------------------------------------
3444: ----------------------------------------
3445: -- update_row for:OKC_K_PARTY_ROLES_B --
3446: ----------------------------------------
3447: PROCEDURE update_row(
3448: p_init_msg_list IN VARCHAR2 ,
3449: x_return_status OUT NOCOPY VARCHAR2,

Line 3665: -- Set_Attributes for:OKC_K_PARTY_ROLES_B --

3661: RETURN(l_return_status);
3662:
3663: END populate_new_record;
3664: --------------------------------------------
3665: -- Set_Attributes for:OKC_K_PARTY_ROLES_B --
3666: --------------------------------------------
3667: FUNCTION Set_Attributes (
3668: p_cpl_rec IN cpl_rec_type,
3669: x_cpl_rec OUT NOCOPY cpl_rec_type

Line 3711: UPDATE OKC_K_PARTY_ROLES_B

3707: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3708: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3709: RAISE OKC_API.G_EXCEPTION_ERROR;
3710: END IF;
3711: UPDATE OKC_K_PARTY_ROLES_B
3712: SET CPL_ID = l_def_cpl_rec.cpl_id,CHR_ID = l_def_cpl_rec.chr_id,
3713: CLE_ID = l_def_cpl_rec.cle_id,
3714: DNZ_CHR_ID = l_def_cpl_rec.dnz_chr_id,
3715: RLE_CODE = l_def_cpl_rec.rle_code,

Line 4537: -- delete_row for:OKC_K_PARTY_ROLES_B --

4533: ---------------------------------------------------------------------------
4534: -- PROCEDURE delete_row
4535: ---------------------------------------------------------------------------
4536: ----------------------------------------
4537: -- delete_row for:OKC_K_PARTY_ROLES_B --
4538: ----------------------------------------
4539: PROCEDURE delete_row(
4540: p_init_msg_list IN VARCHAR2 ,
4541: x_return_status OUT NOCOPY VARCHAR2,

Line 4567: DELETE FROM OKC_K_PARTY_ROLES_B

4563: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4564: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4565: RAISE OKC_API.G_EXCEPTION_ERROR;
4566: END IF;
4567: DELETE FROM OKC_K_PARTY_ROLES_B
4568: WHERE ID = l_cpl_rec.id;
4569:
4570: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
4571:

Line 5079: INTO OKC_K_PARTY_ROLES_B

5075: END LOOP;
5076:
5077: FORALL i in 1..l_tabsize
5078: INSERT
5079: INTO OKC_K_PARTY_ROLES_B
5080: (
5081: id,
5082: cpl_id,
5083: chr_id,

Line 5243: INSERT INTO okc_k_party_roles_bh

5239: okc_debug.Set_Indentation('OKC_CPL_PVT');
5240: okc_debug.log('16300: Entered create_version', 2);
5241: END IF;
5242:
5243: INSERT INTO okc_k_party_roles_bh
5244: (
5245: major_version,
5246: id,
5247: chr_id,

Line 5338: FROM okc_k_party_roles_b

5334: -- orig_system_reference1,
5335: -- orig_system_source_code
5336: -- R12 Data Model Changes 4485150 End
5337:
5338: FROM okc_k_party_roles_b
5339: WHERE dnz_chr_id = p_chr_id;
5340:
5341: --------------------------------
5342: -- Version TL Table

Line 5375: from okc_k_party_roles_b

5371: alias,
5372: last_update_login
5373: FROM okc_k_party_roles_tl
5374: WHERE id in (select id
5375: from okc_k_party_roles_b
5376: where dnz_chr_id = p_chr_id);
5377:
5378: IF (l_debug = 'Y') THEN
5379: okc_debug.log('16400: Leaving create_version', 2);

Line 5454: FROM okc_k_party_roles_bh

5450: alias,
5451: last_update_login
5452: FROM okc_k_party_roles_tlh
5453: WHERE id in (SELECT id
5454: FROM okc_k_party_roles_bh
5455: WHERE dnz_chr_id = p_chr_id)
5456: AND major_version = p_major_version;
5457:
5458: ----------------------------------------

Line 5462: INSERT INTO okc_k_party_roles_b

5458: ----------------------------------------
5459: -- Restoring Base Table
5460: ----------------------------------------
5461:
5462: INSERT INTO okc_k_party_roles_b
5463: (
5464: id,
5465: chr_id,
5466: cle_id,

Line 5554: FROM okc_k_party_roles_bh

5550: /* orig_system_id1,
5551: orig_system_reference1,
5552: orig_system_source_code */
5553: -- R12 Data Model Changes 4485150 End
5554: FROM okc_k_party_roles_bh
5555: WHERE dnz_chr_id = p_chr_id
5556: AND major_version = p_major_version;
5557:
5558: IF (l_debug = 'Y') THEN