APPS.JTF_RESOURCE_UTL dependencies on JTF_RS_RESOURCE_EXTNS

Line 225: FROM jtf_rs_resource_extns

221: ) IS
222:
223: CURSOR c_resource_id IS
224: SELECT resource_id
225: FROM jtf_rs_resource_extns
226: WHERE resource_id = p_resource_id
227: AND ( end_date_active is null OR
228: trunc(end_date_active) >= trunc(sysdate) );
229:

Line 232: FROM jtf_rs_resource_extns

228: trunc(end_date_active) >= trunc(sysdate) );
229:
230: CURSOR c_resource_number IS
231: SELECT resource_id
232: FROM jtf_rs_resource_extns
233: WHERE resource_number = p_resource_number
234: AND ( end_date_active is null OR
235: trunc(end_date_active) >= trunc(sysdate) );
236:

Line 410: l_category jtf_rs_resource_extns.category%TYPE;

406: (p_category IN VARCHAR2,
407: x_return_status OUT NOCOPY VARCHAR2
408: ) IS
409:
410: l_category jtf_rs_resource_extns.category%TYPE;
411:
412: -- fix for performance bug # 4956628
413: -- SQL ID : 14841989 from SQL Repository
414: -- mofified the below cusror to change

Line 477: FROM jtf_rs_resource_extns

473: ) IS
474:
475: CURSOR c_emp_dup_source_id IS
476: SELECT 1
477: FROM jtf_rs_resource_extns
478: WHERE source_id = p_source_id
479: AND category = 'EMPLOYEE';
480: /* Removed the below code for bug # 3455951 */
481: /*

Line 484: FROM jtf_rs_resource_extns

480: /* Removed the below code for bug # 3455951 */
481: /*
482: CURSOR c_cwk_dup_source_id IS
483: SELECT 1
484: FROM jtf_rs_resource_extns
485: WHERE source_id = p_source_id
486: AND category = 'WORKER';
487: */
488: CURSOR c_ven_dup_source_id IS

Line 490: FROM jtf_rs_resource_extns

486: AND category = 'WORKER';
487: */
488: CURSOR c_ven_dup_source_id IS
489: SELECT 1
490: FROM jtf_rs_resource_extns
491: WHERE source_id = p_source_id
492: AND category = 'VENUE';
493:
494: CURSOR c_party_dup_source_id IS

Line 496: FROM jtf_rs_resource_extns

492: AND category = 'VENUE';
493:
494: CURSOR c_party_dup_source_id IS
495: SELECT 1
496: FROM jtf_rs_resource_extns
497: WHERE source_id = p_source_id
498: AND category = 'PARTY';
499:
500: CURSOR c_vend_dup_source_id IS

Line 502: FROM jtf_rs_resource_extns

498: AND category = 'PARTY';
499:
500: CURSOR c_vend_dup_source_id IS
501: SELECT 1
502: FROM jtf_rs_resource_extns
503: WHERE source_id = p_source_id
504: AND category = 'SUPPLIER_CONTACT';
505:
506: CURSOR c_partner_dup_source_id IS

Line 508: FROM jtf_rs_resource_extns

504: AND category = 'SUPPLIER_CONTACT';
505:
506: CURSOR c_partner_dup_source_id IS
507: SELECT 1
508: FROM jtf_rs_resource_extns
509: WHERE source_id = p_source_id
510: AND nvl(address_id,-99) = nvl(p_address_id,-99) --uncommented this to accomodate migr 09/25
511: AND category = 'PARTNER';
512:

Line 769: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;

765: (p_support_site_id IN NUMBER,
766: x_return_status OUT NOCOPY VARCHAR2
767: ) IS
768:
769: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
770:
771: CURSOR c_support_site_id IS
772: SELECT hps.party_site_id
773: FROM hz_party_sites hps,

Line 1202: FROM jtf_rs_resource_extns a

1198: L_RES_END_DATE DATE;
1199:
1200: CURSOR c_get_res_dates_cr (l_resource_id IN NUMBER, l_org_id IN NUMBER) IS
1201: SELECT a.start_date_active, nvl(a.end_date_active,TO_DATE('12/31/4712','MM/DD/RRRR'))
1202: FROM jtf_rs_resource_extns a
1203: , jtf_rs_salesreps b
1204: WHERE a.resource_id = b.resource_id
1205: AND b.resource_id = l_resource_id
1206: AND b.org_id = l_org_id

Line 1211: FROM jtf_rs_resource_extns a

1207: ;
1208:
1209: CURSOR c_get_res_dates_upd (l_salesrep_id IN NUMBER, l_org_id IN NUMBER) IS
1210: SELECT a.start_date_active, nvl(a.end_date_active,TO_DATE('12/31/4712','MM/DD/RRRR'))
1211: FROM jtf_rs_resource_extns a
1212: , jtf_rs_salesreps b
1213: WHERE a.resource_id = b.resource_id
1214: AND b.salesrep_id = l_salesrep_id
1215: AND b.org_id = l_org_id

Line 1469: FROM jtf_rs_resource_extns

1465:
1466: CURSOR c_res_existence(c_resource_id IN NUMBER)
1467: IS
1468: SELECT 'X'
1469: FROM jtf_rs_resource_extns
1470: WHERE resource_id = c_resource_id;
1471:
1472: l_temp varchar2(1);
1473:

Line 1514: Changed the object existence validation for 'RS_INDIVIDUAL' to jtf_rs_resource_extns from jtf_objects,

1510: close object_dtls_cur;
1511: end if;
1512: x_return_status := fnd_api.g_ret_sts_success;
1513: /* Added the below code to fix the bug # 3357906
1514: Changed the object existence validation for 'RS_INDIVIDUAL' to jtf_rs_resource_extns from jtf_objects,
1515: because we do not have enough time to investigate the impact of changing the
1516: jtf_objects definition for the object type 'RS_INDIVIDUAL'. */
1517: if l_object_code = 'RS_INDIVIDUAL' then
1518: