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.OKS_COVERAGES_PVT dependencies on OKC_CONTACTS

Line 564: FROM OKC_CONTACTS_V

560: OBJECT1_ID1,
561: OBJECT1_ID2,
562: JTOT_OBJECT1_CODE,
563: resource_class
564: FROM OKC_CONTACTS_V
565: WHERE cpl_id=P_cpl_Id;
566: --------------------------------------------
567:
568: CURSOR CUR_ItemDet(P_Id IN NUMBER) IS

Line 2241: SELECT ID FROM OKC_CONTACTS

2237: And pr.cle_id = lv.id
2238: And pr.dnz_chr_id = lv.dnz_chr_id;
2239:
2240: CURSOR Contact_Cur(P_cpl_Id IN NUMBER) IS
2241: SELECT ID FROM OKC_CONTACTS
2242: WHERE cpl_Id=P_cpl_Id;
2243:
2244: /*
2245: CURSOR TRule_Cur( P_Rgp_Id IN NUMBER,

Line 3835: SELECT ID FROM OKC_CONTACTS

3831: And pr.cle_id = lv.id
3832: And pr.dnz_chr_id = lv.dnz_chr_id;
3833:
3834: CURSOR Contact_Cur(P_cpl_Id IN NUMBER) IS
3835: SELECT ID FROM OKC_CONTACTS
3836: WHERE cpl_Id=P_cpl_Id;
3837:
3838: CURSOR TRule_Cur( P_Rgp_Id IN NUMBER,
3839: P_Rule_Type IN Varchar2) IS

Line 4558: OKC_CONTACTS_V ocv,

4554: ocv.object1_id1 res_id,
4555: ocv.resource_class resource_class
4556: FROM OKC_K_LINES_V lines,
4557: OKC_K_PARTY_ROLES_B party,
4558: OKC_CONTACTS_V ocv,
4559: OKC_K_ITEMS_V items
4560: WHERE lines.id = p_bp_line_id
4561: AND lines.lse_id IN (3,16,21)
4562: AND party.cle_id = lines.id

Line 9420: Select id,dnz_chr_id,cro_code,cpl_id,primary_yn,resource_class from OKC_CONTACTS

9416: And dnz_chr_id = p_dnz_chr_id;
9417:
9418:
9419: Cursor cur_contact (P_id NUMBER) IS
9420: Select id,dnz_chr_id,cro_code,cpl_id,primary_yn,resource_class from OKC_CONTACTS
9421: Where cpl_id = p_id;
9422:
9423: -- Billing Type --
9424: Cursor cur_bill_type (p_id NUMBER) IS

Line 9827: -- OKC_CONTACTS --

9823: l_cplv_tbl_in(cnt).rle_code := rec_part.rle_code;
9824:
9825: cnt :=cnt+1;
9826: End if;
9827: -- OKC_CONTACTS --
9828: cnt1 :=0;
9829: For rec_con in cur_contact (rec_part.id) LOOP
9830: If rec_con.dnz_chr_id <>p_dnz_chr_id then
9831: l_ctcv_tbl_in(cnt1).id := rec_con.id;

Line 9850: -- OKC_CONTACTS --

9846: x_msg_data => l_msg_data,
9847: p_ctcv_tbl => l_ctcv_tbl_in,
9848: x_ctcv_tbl => l_ctcv_tbl_out );
9849: End if;
9850: -- OKC_CONTACTS --
9851: End LOOP; -- End Party Roles
9852: End LOOP; -- End Bp
9853: If cnt>0 then
9854: okc_contract_party_pub.update_k_party_role (

Line 10425: FROM OKC_CONTACTS_V

10421: cr_ptrl_det Cur_PTRLDet%rowtype;
10422: -------------------------------------------------
10423: CURSOR Cur_contactDet(P_cpl_id IN NUMBER) IS
10424: SELECT ID
10425: FROM OKC_CONTACTS_V
10426: WHERE cpl_id=P_cpl_Id;
10427: -------------------------------------------------
10428: CURSOR Cur_childline_br(P_cle_Id IN NUMBER) IS
10429: SELECT ID

Line 10445: l_old_contact_id OKC_CONTACTS.ID%TYPE;

10441: l_new_rt_item_id OKC_K_ITEMS.ID%TYPE;
10442: l_old_rt_item_id OKC_K_ITEMS.ID%TYPE;
10443: l_old_party_id OKC_K_PARTY_ROLES_B.ID%TYPE;
10444: l_new_party_id OKC_K_PARTY_ROLES_B.ID%TYPE;
10445: l_old_contact_id OKC_CONTACTS.ID%TYPE;
10446: l_new_contact_id OKC_CONTACTS.ID%TYPE;
10447: l_old_bt_id OKC_K_LINES_B.ID%TYPE;
10448: l_new_bt_id OKC_K_LINES_B.ID%TYPE;
10449: l_old_br_id OKC_K_LINES_B.ID%TYPE;

Line 10446: l_new_contact_id OKC_CONTACTS.ID%TYPE;

10442: l_old_rt_item_id OKC_K_ITEMS.ID%TYPE;
10443: l_old_party_id OKC_K_PARTY_ROLES_B.ID%TYPE;
10444: l_new_party_id OKC_K_PARTY_ROLES_B.ID%TYPE;
10445: l_old_contact_id OKC_CONTACTS.ID%TYPE;
10446: l_new_contact_id OKC_CONTACTS.ID%TYPE;
10447: l_old_bt_id OKC_K_LINES_B.ID%TYPE;
10448: l_new_bt_id OKC_K_LINES_B.ID%TYPE;
10449: l_old_br_id OKC_K_LINES_B.ID%TYPE;
10450: l_new_br_id OKC_K_LINES_B.ID%TYPE;

Line 10949: -- This function is called by copy_standard_coverage for insertion into okc_contacts table

10945: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
10946: return x_return_status;
10947: END CREATE_OKC_PARTY;
10948:
10949: -- This function is called by copy_standard_coverage for insertion into okc_contacts table
10950: FUNCTION CREATE_OKC_CONTACT(p_new_cpl_id NUMBER,
10951: p_old_cpl_id NUMBER) return VARCHAR2 IS
10952:
10953:

Line 10958: INSERT INTO okc_contacts

10954: x_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
10955:
10956: BEGIN
10957:
10958: INSERT INTO okc_contacts
10959: ( ID,
10960: CPL_ID,
10961: CRO_CODE,
10962: DNZ_CHR_ID,

Line 11034: FROM OKC_CONTACTS

11030: PRIMARY_YN,
11031: RESOURCE_CLASS,
11032: SALES_GROUP_ID
11033: --ID --ORIG_SYSTEM_ID
11034: FROM OKC_CONTACTS
11035: WHERE cpl_id = p_old_cpl_id;
11036:
11037:
11038: RETURN x_return_status;

Line 11179: -- okc_contacts

11175: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
11176: THEN
11177: RAISE G_EXCEPTION_HALT_VALIDATION;
11178: END IF;
11179: -- okc_contacts
11180: l_return_status := CREATE_OKC_CONTACT(l_new_party_id,l_old_party_id);
11181: IF (G_DEBUG_ENABLED = 'Y') THEN
11182: okc_debug.log('AFTER CREATE_OKC_CONTACT'||l_return_status, 2);
11183: END IF;