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 10443: l_old_party_id OKC_K_PARTY_ROLES_B.ID%TYPE;

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

Line 10444: l_new_party_id OKC_K_PARTY_ROLES_B.ID%TYPE;

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

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

10800: return x_return_status;
10801:
10802: END CREATE_OKC_ITEM;
10803:
10804: -- This function is called by copy_standard_coverage for insertion into okc_k_party_roles_b table
10805: FUNCTION CREATE_OKC_PARTY(p_new_party_id NUMBER,
10806: p_old_party_id NUMBER,
10807: p_cle_id NUMBER) return VARCHAR2 IS
10808:

Line 10813: INSERT INTO okc_k_party_roles_b

10809: x_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
10810:
10811: BEGIN
10812:
10813: INSERT INTO okc_k_party_roles_b
10814: ( ID,
10815: CHR_ID,
10816: CLE_ID,
10817: DNZ_CHR_ID,

Line 10901: FROM OKC_K_PARTY_ROLES_B

10897: CUST_ACCT_ID,
10898: p_old_party_id ORIG_SYSTEM_ID1,
10899: ORIG_SYSTEM_REFERENCE1,
10900: ORIG_SYSTEM_SOURCE_CODE
10901: FROM OKC_K_PARTY_ROLES_B
10902: WHERE ID= p_old_party_id;
10903:
10904: -- insert into tl table
10905: INSERT INTO okc_k_party_roles_tl