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.HR_DE_ORG_INFO dependencies on PER_ASSIGNMENTS_F

Line 366: FUNCTION get_liab_prov_details (p_assignment_id in per_assignments_f.assignment_id%TYPE,

362:
363: CALLED IN : SQL for view HR_DE_WORK_INCIDENTS_REPORT.
364: -----------------------------------------------------------------------------------*/
365:
366: FUNCTION get_liab_prov_details (p_assignment_id in per_assignments_f.assignment_id%TYPE,
367: p_incident_date in date)
368: RETURN VARCHAR2 IS
369: l_exempt varchar2(5);
370: l_liab_prov hr_organization_units.organization_id%TYPE;

Line 399: FROM per_assignments_f

395: -- Querying organization recorded on the assignment
396: -- dbms_output.put_line('In Function get_liab_prov_details for assg id '||p_assignment_id);
397: l_inc_date := p_incident_date;
398: SELECT unique(organization_id) INTO l_org_id
399: FROM per_assignments_f
400: WHERE assignment_id = p_assignment_id
401: AND primary_flag = 'Y'
402: AND p_incident_date BETWEEN effective_start_date and effective_end_date;
403: -- Querying employee has Workers Liability details recorded against the assignment SCL

Line 406: (SELECT unique(soft_coding_keyflex_id) FROM per_assignments_f WHERE assignment_id = p_assignment_id and p_incident_date BETWEEN effective_start_date AND effective_end_date);

402: AND p_incident_date BETWEEN effective_start_date and effective_end_date;
403: -- Querying employee has Workers Liability details recorded against the assignment SCL
404: SELECT substr(segment2,1,5), substr(segment3,1,15) INTO l_exempt, l_liab_prov FROM Hr_soft_coding_keyflex
405: WHERE soft_coding_keyflex_id =
406: (SELECT unique(soft_coding_keyflex_id) FROM per_assignments_f WHERE assignment_id = p_assignment_id and p_incident_date BETWEEN effective_start_date AND effective_end_date);
407: IF SQL%FOUND THEN
408: IF l_exempt = 'N' THEN
409: SELECT org.name, NVL(orl.org_link_information3, 'NULL') INTO l_name, l_membership_no
410: FROM hr_de_organization_links orl, hr_organization_units org

Line 466: FUNCTION get_liab_prov_name(p_assignment_id in per_assignments_f.assignment_id%TYPE)

462: /* Wrapper Functions returning details
463: 1)Name of Provider
464: 2)Membership no from string returned above */
465: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ --
466: FUNCTION get_liab_prov_name(p_assignment_id in per_assignments_f.assignment_id%TYPE)
467: RETURN VARCHAR2 IS
468: org_name hr_organization_units.name%TYPE;
469: BEGIN
470: IF g_assg_id = p_assignment_id THEN

Line 478: FUNCTION get_liab_prov_membership_no(p_assignment_id in per_assignments_f.assignment_id%TYPE)

474: RETURN NULL;
475: END IF;
476: END get_liab_prov_name;
477: ---
478: FUNCTION get_liab_prov_membership_no(p_assignment_id in per_assignments_f.assignment_id%TYPE)
479: RETURN VARCHAR2 IS
480: mem_no varchar2(50);
481: BEGIN
482: IF g_assg_id = p_assignment_id THEN

Line 496: FUNCTION get_location(p_assignment_id in per_assignments_f.assignment_id%TYPE)

492: /* -------------------------------------------------------------------------------------
493: Get Location for organization id returned by above function
494: ------------------------------------------------------------------------------------*/
495:
496: FUNCTION get_location(p_assignment_id in per_assignments_f.assignment_id%TYPE)
497: RETURN VARCHAR2 IS
498: l_loc_id hr_locations.location_id%TYPE;
499: l_add_1 varchar2(240); --hr_locations.address_line_1%TYPE;
500: l_add_2 varchar2(240); --hr_locations.address_line_2%TYPE;

Line 562: FUNCTION get_addr_line1 (p_assignment_id in per_assignments_f.assignment_id%TYPE)

558: END get_location;
559:
560: /* Wrapper Functions returning individual components of Location Address */
561: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ --
562: FUNCTION get_addr_line1 (p_assignment_id in per_assignments_f.assignment_id%TYPE)
563: RETURN VARCHAR2 IS
564: l_line1 varchar2(240);
565:
566: BEGIN

Line 579: FUNCTION get_addr_line2 (p_assignment_id in per_assignments_f.assignment_id%TYPE)

575: END IF;
576: RETURN NULL;
577: END get_addr_line1;
578: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ --
579: FUNCTION get_addr_line2 (p_assignment_id in per_assignments_f.assignment_id%TYPE)
580: RETURN VARCHAR2 IS
581: l_line2 varchar2(240);
582:
583: BEGIN

Line 596: FUNCTION get_addr_line3 (p_assignment_id in per_assignments_f.assignment_id%TYPE)

592: END IF;
593: RETURN NULL;
594: END get_addr_line2;
595: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ --
596: FUNCTION get_addr_line3 (p_assignment_id in per_assignments_f.assignment_id%TYPE)
597: RETURN VARCHAR2 IS
598: l_line3 varchar2(240);
599:
600: BEGIN

Line 613: FUNCTION get_town (p_assignment_id in per_assignments_f.assignment_id%TYPE)

609: END IF;
610: RETURN NULL;
611: END get_addr_line3;
612: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ --
613: FUNCTION get_town (p_assignment_id in per_assignments_f.assignment_id%TYPE)
614: RETURN VARCHAR2 IS
615: l_town varchar2(30);
616:
617: BEGIN

Line 630: FUNCTION get_country (p_assignment_id in per_assignments_f.assignment_id%TYPE)

626: END IF;
627: RETURN NULL;
628: END get_town;
629: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ --
630: FUNCTION get_country (p_assignment_id in per_assignments_f.assignment_id%TYPE)
631: RETURN VARCHAR2 IS
632: l_country varchar2(60);
633:
634: BEGIN

Line 647: FUNCTION get_postal_code(p_assignment_id in per_assignments_f.assignment_id%TYPE)

643: END IF;
644: RETURN NULL;
645: END get_country;
646: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ --
647: FUNCTION get_postal_code(p_assignment_id in per_assignments_f.assignment_id%TYPE)
648: RETURN VARCHAR2 IS
649: l_postal_code varchar2(30);
650:
651: BEGIN

Line 680: FUNCTION get_liab_prov_details2(p_assignment_id in per_assignments_f.assignment_id%TYPE,

676: CALLED IN : SQL for view HR_DE_WORK_INCIDENTS_REPORT.
677:
678: -----------------------------------------------------------------------------------*/
679:
680: FUNCTION get_liab_prov_details2(p_assignment_id in per_assignments_f.assignment_id%TYPE,
681: p_incident_date in date)
682: RETURN VARCHAR2 IS
683: l_cc varchar2(30);
684: l_e_bet varchar2(30);

Line 692: FROM per_assignments_f

688: l_inc_date date;
689:
690: BEGIN
691: SELECT unique(organization_id) INTO l_org_id
692: FROM per_assignments_f
693: WHERE assignment_id = p_assignment_id
694: AND primary_flag = 'Y'
695: AND p_incident_date BETWEEN effective_start_date and effective_end_date;
696: -- dbms_output.put_line(' Function details2 calling get_org_data_items for '||l_org_id);

Line 735: FUNCTION get_supervising_off (p_assignment_id in per_assignments_f.assignment_id%TYPE,

731:
732: CALLED IN : SQL for view HR_DE_WORK_INCIDENTS_REPORT.
733: -----------------------------------------------------------------------------------*/
734:
735: FUNCTION get_supervising_off (p_assignment_id in per_assignments_f.assignment_id%TYPE,
736: p_incident_date in date)
737: RETURN VARCHAR2 IS
738: l_sup_off hr_organization_units.organization_id%TYPE;
739: l_org_id hr_organization_units.organization_id%TYPE;

Line 761: FROM per_assignments_f

757: BEGIN
758: -- Querying organization recorded on the assignment
759: -- dbms_output.put_line('In Function get_supervising_off for assg id '||p_assignment_id||' on '||p_incident_date);
760: SELECT unique(organization_id) INTO l_org_id
761: FROM per_assignments_f
762: WHERE assignment_id = p_assignment_id
763: AND primary_flag = 'Y'
764: AND p_incident_date BETWEEN effective_start_date and effective_end_date;
765:

Line 806: FUNCTION get_supervising_off_name(p_assignment_id in per_assignments_f.assignment_id%TYPE)

802: END get_supervising_off;
803:
804: /* Wrapper Functions returning Supervising Off Org Name */
805: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ --
806: FUNCTION get_supervising_off_name(p_assignment_id in per_assignments_f.assignment_id%TYPE)
807: RETURN VARCHAR2 IS
808: org_name hr_organization_units.name%TYPE;
809: BEGIN
810: IF g_assg_id = p_assignment_id THEN