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_EXTWAR_UTIL_PUB dependencies on OKS_K_RES_TEMP

Line 1746: FROM oks_k_res_temp

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
1747: WHERE status IN
1748: (SELECT code
1749: FROM okc_statuses_v
1750: WHERE ste_code IN('ACTIVE','SIGNED','HOLD'))

Line 1755: FROM oks_k_res_temp

1751: AND contact_id IS NOT NULL;
1752:
1753: CURSOR delete_contact_resource IS
1754: SELECT contact_id,authoring_org_id
1755: FROM oks_k_res_temp
1756: WHERE status IN
1757: (SELECT code
1758: FROM okc_statuses_v
1759: WHERE ste_code = 'ENTERED')

Line 1764: FROM oks_k_res_temp

1760: AND contact_id IS NOT NULL;
1761:
1762: CURSOR contact_resource_in_future IS
1763: SELECT id,contract_number,contract_number_modifier
1764: FROM oks_k_res_temp
1765: WHERE status IN
1766: (SELECT code
1767: FROM okc_statuses_v
1768: WHERE ste_code IN('ACTIVE','SIGNED','HOLD'))

Line 1773: FROM OKS_K_RES_TEMP

1769: AND contact_start_date >= trunc(sysdate) ;
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

Line 2218: INSERT INTO OKS_K_RES_TEMP (id,contract_number,contract_number_modifier,status,

2214: ' State ' || lb_state_code(i) ||
2215: ' Country ' || lb_country_code(i)||
2216: ' Party Id ' || lb_party_id(i) );
2217: END IF;
2218: INSERT INTO OKS_K_RES_TEMP (id,contract_number,contract_number_modifier,status,
2219: authoring_org_id,inv_organization_id,party_id,cpl_id,
2220: party_name,country_code,state_code,contact_id,salesrep_id,
2221: contact_start_date,contact_end_date,contract_start_date,contract_end_date)
2222: values (lb_id(i)

Line 2348: DELETE FROM oks_k_res_temp

2344: ' Invalid salesrep returned for this Contract : ' || l_e_contract_number || ' ' || l_e_contract_number_mod);
2345: END IF;
2346:
2347: --Delete this contract
2348: DELETE FROM oks_k_res_temp
2349: WHERE id = l_winning_tbl(idx4).chr_id;
2350:
2351: NOTIFY_TERRITORY_ADMIN
2352: ( 1,

Line 2370: DELETE FROM oks_k_res_temp a

2366: END IF;
2367:
2368:
2369: -- Delete all contracts which has a salesrep (not end dated),which is same as the resource setup.
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

Line 2373: FROM oks_k_res_temp b,

2369: -- Delete all contracts which has a salesrep (not end dated),which is same as the resource setup.
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

Line 2393: DELETE FROM oks_k_res_temp

2389: NOTIFY_TERRITORY_ADMIN
2390: ( contract_noresource_rec.id,
2391: contract_noresource_rec.Contract_number,
2392: contract_noresource_rec.Contract_number_modifier,l_terr_admin_msg);
2393: DELETE FROM oks_k_res_temp
2394: WHERE id = contract_noresource_rec.id;
2395: fnd_file.put_line(FND_FILE.LOG,'There is no resource setup. Contract Number - '|| contract_noresource_rec.Contract_number);
2396: END LOOP;
2397:

Line 2425: DELETE FROM oks_k_res_temp a

2421: END IF;
2422:
2423:
2424: -- Delete all contracts which has a salesrep with start date in future.
2425: DELETE FROM oks_k_res_temp a
2426: WHERE exists
2427: ( SELECT null
2428: FROM oks_k_res_temp b
2429: WHERE b.id = a.id

Line 2428: FROM oks_k_res_temp b

2424: -- Delete all contracts which has a salesrep with start date in future.
2425: DELETE FROM oks_k_res_temp a
2426: WHERE exists
2427: ( SELECT null
2428: FROM oks_k_res_temp b
2429: WHERE b.id = a.id
2430: AND b.contact_start_date >= trunc(sysdate)
2431: AND b.status IN (SELECT code
2432: FROM okc_statuses_v

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 2440: FROM oks_k_res_temp b

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
2442: );
2443:
2444:

Line 2730: DELETE FROM oks_k_res_temp;

2726: l_ctcv_tbl_in.delete;
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',