APPS.OKS_COVERAGES_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 2234: SELECT pr.ID FROM OKC_K_PARTY_ROLES_B pr

2230: FROM OKC_React_Intervals
2231: WHERE Rul_Id =P_Rule_Id;
2232:
2233: CURSOR Kprl_Cur(P_cle_Id IN NUMBER) IS
2234: SELECT pr.ID FROM OKC_K_PARTY_ROLES_B pr
2235: ,OKC_K_LINES_V lv
2236: WHERE pr.cle_Id=P_cle_Id
2237: And pr.cle_id = lv.id
2238: And pr.dnz_chr_id = lv.dnz_chr_id;

Line 3828: SELECT pr.ID FROM OKC_K_PARTY_ROLES_B pr

3824: FROM OKC_React_Intervals
3825: WHERE Rul_Id =P_Rule_Id;
3826:
3827: CURSOR Kprl_Cur(P_cle_Id IN NUMBER) IS
3828: SELECT pr.ID FROM OKC_K_PARTY_ROLES_B pr
3829: ,OKC_K_LINES_V lv
3830: WHERE pr.cle_Id=P_cle_Id
3831: And pr.cle_id = lv.id
3832: And pr.dnz_chr_id = lv.dnz_chr_id;

Line 4557: OKC_K_PARTY_ROLES_B party,

4553: ocv.cro_code cro_code,
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)

Line 10453: l_old_party_id OKC_K_PARTY_ROLES_B.ID%TYPE;

10449: l_old_rt_id OKC_K_LINES_B.ID%TYPE;
10450: l_new_rt_id OKC_K_LINES_B.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;

Line 10454: l_new_party_id OKC_K_PARTY_ROLES_B.ID%TYPE;

10450: l_new_rt_id OKC_K_LINES_B.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;

Line 10814: -- This function is called by copy_standard_coverage for insertion into okc_k_party_roles_b table

10810: return x_return_status;
10811:
10812: END CREATE_OKC_ITEM;
10813:
10814: -- This function is called by copy_standard_coverage for insertion into okc_k_party_roles_b table
10815: FUNCTION CREATE_OKC_PARTY(p_new_party_id NUMBER,
10816: p_old_party_id NUMBER,
10817: p_cle_id NUMBER) return VARCHAR2 IS
10818:

Line 10823: INSERT INTO okc_k_party_roles_b

10819: x_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
10820:
10821: BEGIN
10822:
10823: INSERT INTO okc_k_party_roles_b
10824: ( ID,
10825: CHR_ID,
10826: CLE_ID,
10827: DNZ_CHR_ID,

Line 10911: FROM OKC_K_PARTY_ROLES_B

10907: CUST_ACCT_ID,
10908: p_old_party_id ORIG_SYSTEM_ID1,
10909: ORIG_SYSTEM_REFERENCE1,
10910: ORIG_SYSTEM_SOURCE_CODE
10911: FROM OKC_K_PARTY_ROLES_B
10912: WHERE ID= p_old_party_id;
10913:
10914: -- insert into tl table
10915: INSERT INTO okc_k_party_roles_tl