APPS.OKS_EXTWAR_UTIL_PUB dependencies on OKS_JTF_RES_TEMP

Line 1742: FROM oks_jtf_res_temp;

1738:
1739: CURSOR create_contact_resource IS
1740: SELECT chr_id,resource_id,user_id,
1741: salesrep_id,org_id
1742: FROM oks_jtf_res_temp;
1743:
1744: CURSOR update_contact_resource IS
1745: SELECT contact_id,authoring_org_id
1746: FROM oks_k_res_temp

Line 1774: WHERE id not in (SELECT chr_id FROM OKS_JTF_RES_TEMP);

1770:
1771: CURSOR contract_noresource IS
1772: SELECT id,contract_number, contract_number_modifier,party_name
1773: FROM OKS_K_RES_TEMP
1774: WHERE id not in (SELECT chr_id FROM OKS_JTF_RES_TEMP);
1775:
1776: CURSOR get_contract_num_mod(p_chr_id NUMBER) IS
1777: SELECT contract_number, contract_number_modifier
1778: FROM okc_k_headers_b

Line 2326: INSERT INTO OKS_JTF_RES_TEMP (chr_id,resource_id,user_id,salesrep_id

2322: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2323: ' Contract selected to insert into JTF_RES_TEMP : ' || l_winning_tbl(idx4).chr_id);
2324: END IF;
2325:
2326: INSERT INTO OKS_JTF_RES_TEMP (chr_id,resource_id,user_id,salesrep_id
2327: ,org_id,inv_organization_id,contract_start_date,contract_end_date)
2328: values(l_winning_tbl(idx4).chr_id
2329: ,l_winning_tbl(idx4).resource_id
2330: ,l_winning_tbl(idx4).user_id

Line 2374: oks_jtf_res_temp c

2370: DELETE FROM oks_k_res_temp a
2371: WHERE exists
2372: ( SELECT null
2373: FROM oks_k_res_temp b,
2374: oks_jtf_res_temp c
2375: WHERE b.id = a.id
2376: AND b.salesrep_id = c.salesrep_id
2377: AND c.chr_id = a.id
2378: );

Line 2436: -- Now delete those contracts from oks_jtf_res_temp which are deleted from oks_k_res_temp

2432: FROM okc_statuses_v
2433: WHERE ste_code IN('ACTIVE','SIGNED','HOLD'))
2434: );
2435:
2436: -- Now delete those contracts from oks_jtf_res_temp which are deleted from oks_k_res_temp
2437: DELETE FROM oks_jtf_res_temp a
2438: WHERE not exists
2439: ( SELECT null
2440: FROM oks_k_res_temp b

Line 2437: DELETE FROM oks_jtf_res_temp a

2433: WHERE ste_code IN('ACTIVE','SIGNED','HOLD'))
2434: );
2435:
2436: -- Now delete those contracts from oks_jtf_res_temp which are deleted from oks_k_res_temp
2437: DELETE FROM oks_jtf_res_temp a
2438: WHERE not exists
2439: ( SELECT null
2440: FROM oks_k_res_temp b
2441: WHERE a.chr_id = b.id

Line 2731: DELETE FROM oks_jtf_res_temp;

2727: l_ctcv_tbl_in_del.delete;
2728: l_ctcv_tbl_in_upd.delete;
2729:
2730: DELETE FROM oks_k_res_temp;
2731: DELETE FROM oks_jtf_res_temp;
2732:
2733: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2734: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2735: 'Completed Processing *****');