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 9430: Select id,dnz_chr_id,cro_code,cpl_id,primary_yn,resource_class from OKC_CONTACTS

9426: And dnz_chr_id = p_dnz_chr_id;
9427:
9428:
9429: Cursor cur_contact (P_id NUMBER) IS
9430: Select id,dnz_chr_id,cro_code,cpl_id,primary_yn,resource_class from OKC_CONTACTS
9431: Where cpl_id = p_id;
9432:
9433: -- Billing Type --
9434: Cursor cur_bill_type (p_id NUMBER) IS

Line 9837: -- OKC_CONTACTS --

9833: l_cplv_tbl_in(cnt).rle_code := rec_part.rle_code;
9834:
9835: cnt :=cnt+1;
9836: End if;
9837: -- OKC_CONTACTS --
9838: cnt1 :=0;
9839: For rec_con in cur_contact (rec_part.id) LOOP
9840: If rec_con.dnz_chr_id <>p_dnz_chr_id then
9841: l_ctcv_tbl_in(cnt1).id := rec_con.id;

Line 9860: -- OKC_CONTACTS --

9856: x_msg_data => l_msg_data,
9857: p_ctcv_tbl => l_ctcv_tbl_in,
9858: x_ctcv_tbl => l_ctcv_tbl_out );
9859: End if;
9860: -- OKC_CONTACTS --
9861: End LOOP; -- End Party Roles
9862: End LOOP; -- End Bp
9863: If cnt>0 then
9864: okc_contract_party_pub.update_k_party_role (

Line 10435: FROM OKC_CONTACTS_V

10431: cr_ptrl_det Cur_PTRLDet%rowtype;
10432: -------------------------------------------------
10433: CURSOR Cur_contactDet(P_cpl_id IN NUMBER) IS
10434: SELECT ID
10435: FROM OKC_CONTACTS_V
10436: WHERE cpl_id=P_cpl_Id;
10437: -------------------------------------------------
10438: CURSOR Cur_childline_br(P_cle_Id IN NUMBER) IS
10439: SELECT ID

Line 10455: l_old_contact_id OKC_CONTACTS.ID%TYPE;

10451: l_new_rt_item_id OKC_K_ITEMS.ID%TYPE;
10452: l_old_rt_item_id OKC_K_ITEMS.ID%TYPE;
10453: l_old_party_id OKC_K_PARTY_ROLES_B.ID%TYPE;
10454: l_new_party_id OKC_K_PARTY_ROLES_B.ID%TYPE;
10455: l_old_contact_id OKC_CONTACTS.ID%TYPE;
10456: l_new_contact_id OKC_CONTACTS.ID%TYPE;
10457: l_old_bt_id OKC_K_LINES_B.ID%TYPE;
10458: l_new_bt_id OKC_K_LINES_B.ID%TYPE;
10459: l_old_br_id OKC_K_LINES_B.ID%TYPE;

Line 10456: l_new_contact_id OKC_CONTACTS.ID%TYPE;

10452: l_old_rt_item_id OKC_K_ITEMS.ID%TYPE;
10453: l_old_party_id OKC_K_PARTY_ROLES_B.ID%TYPE;
10454: l_new_party_id OKC_K_PARTY_ROLES_B.ID%TYPE;
10455: l_old_contact_id OKC_CONTACTS.ID%TYPE;
10456: l_new_contact_id OKC_CONTACTS.ID%TYPE;
10457: l_old_bt_id OKC_K_LINES_B.ID%TYPE;
10458: l_new_bt_id OKC_K_LINES_B.ID%TYPE;
10459: l_old_br_id OKC_K_LINES_B.ID%TYPE;
10460: l_new_br_id OKC_K_LINES_B.ID%TYPE;

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

10955: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
10956: return x_return_status;
10957: END CREATE_OKC_PARTY;
10958:
10959: -- This function is called by copy_standard_coverage for insertion into okc_contacts table
10960: FUNCTION CREATE_OKC_CONTACT(p_new_cpl_id NUMBER,
10961: p_old_cpl_id NUMBER) return VARCHAR2 IS
10962:
10963:

Line 10970: INSERT INTO okc_contacts

10966: BEGIN
10967:
10968: /*cgopinee bugfix for 6882512-Addded dnz_ste_code*/
10969:
10970: INSERT INTO okc_contacts
10971: ( ID,
10972: CPL_ID,
10973: CRO_CODE,
10974: DNZ_CHR_ID,

Line 11048: FROM OKC_CONTACTS

11044: RESOURCE_CLASS,
11045: SALES_GROUP_ID,
11046: DNZ_STE_CODE
11047: --ID --ORIG_SYSTEM_ID
11048: FROM OKC_CONTACTS
11049: WHERE cpl_id = p_old_cpl_id;
11050:
11051:
11052: RETURN x_return_status;

Line 11193: -- okc_contacts

11189: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
11190: THEN
11191: RAISE G_EXCEPTION_HALT_VALIDATION;
11192: END IF;
11193: -- okc_contacts
11194: l_return_status := CREATE_OKC_CONTACT(l_new_party_id,l_old_party_id);
11195: IF (G_DEBUG_ENABLED = 'Y') THEN
11196: okc_debug.log('AFTER CREATE_OKC_CONTACT'||l_return_status, 2);
11197: END IF;