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 412: l_category jtf_rs_resource_extns.category%TYPE;

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

Line 479: FROM jtf_rs_resource_extns

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

Line 486: FROM jtf_rs_resource_extns

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

Line 492: FROM jtf_rs_resource_extns

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

Line 498: FROM jtf_rs_resource_extns

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

Line 504: FROM jtf_rs_resource_extns

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

Line 510: FROM jtf_rs_resource_extns

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

Line 771: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;

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

Line 1206: FROM jtf_rs_resource_extns a

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

Line 1215: FROM jtf_rs_resource_extns a

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

Line 1473: FROM jtf_rs_resource_extns

1469:
1470: CURSOR c_res_existence(c_resource_id IN NUMBER)
1471: IS
1472: SELECT 'X'
1473: FROM jtf_rs_resource_extns
1474: WHERE resource_id = c_resource_id;
1475:
1476: l_temp varchar2(1);
1477:

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

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