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 HR_ORGANIZATION_UNITS

Line 182: FROM hr_organization_units d

178: SELECT SUBSTR(org_information1, 1, 30) cc
179: ,SUBSTR(org_information1, 1, 30) eb
180: ,SUBSTR(org_information2, 1, 30) pb
181: ,org_information_context ctx
182: FROM hr_organization_units d
183: ,hr_organization_information e
184: WHERE d.organization_id = e.organization_id
185: AND d.organization_id = p_org_id
186: AND e.org_information_context IN ('DE_CHAMBER_CONTRIBUTION','DE_HR_ORG_INFO');

Line 278: PROCEDURE get_insurance_providers (p_org_id in hr_organization_units.organization_id%TYPE

274: to the caller |
275: ---------------------------------------------------------------------------------------------*/
276: -- nocopy not used as the table should not be very large.
277: -- Since nocopy change is made mandatory previous comment is ignored.
278: PROCEDURE get_insurance_providers (p_org_id in hr_organization_units.organization_id%TYPE
279: ,p_Insurance_providers_Table out nocopy Insurance_providers_table) IS
280:
281: l_organization_id hr_organization_units.organization_id%type;
282: l_record_count integer := 0;

Line 281: l_organization_id hr_organization_units.organization_id%type;

277: -- Since nocopy change is made mandatory previous comment is ignored.
278: PROCEDURE get_insurance_providers (p_org_id in hr_organization_units.organization_id%TYPE
279: ,p_Insurance_providers_Table out nocopy Insurance_providers_table) IS
280:
281: l_organization_id hr_organization_units.organization_id%type;
282: l_record_count integer := 0;
283: --l_record_count2 integer := 0;
284: l_duplicate varchar2(1) := 'N';
285: l_default varchar2(1) := 'N';

Line 289: cursor c_insurance_providers (c_org_id hr_organization_units.organization_id%type) is

285: l_default varchar2(1) := 'N';
286: l_Insurance_providers_Table Insurance_providers_table;
287: l_proc varchar2(72) := g_package || 'get_insurance_providers';
288:
289: cursor c_insurance_providers (c_org_id hr_organization_units.organization_id%type) is
290: select HL.ORG_LINK_INFORMATION1 status,
291: HL.CHILD_ORGANIZATION_ID child_org_id,
292: HL.ORG_LINK_INFORMATION2 Class_Of_Risk,
293: HL.ORG_LINK_INFORMATION3 Membership_Number,

Line 297: HR_ORGANIZATION_UNITS HU

293: HL.ORG_LINK_INFORMATION3 Membership_Number,
294: HU.NAME Name
295: from
296: HR_DE_ORGANIZATION_LINKS HL,
297: HR_ORGANIZATION_UNITS HU
298: where
299: Parent_Organization_id = c_org_id -- the internal org id
300: and Org_link_information_category = 'DE_LIABILITY_INSURANCE'
301: and HL.ORG_LINK_INFORMATION1 <> 'DE_INACTIVE'

Line 346: PROCEDURE chk_for_org_in_hierarchy(p_org_id in hr_organization_units.organization_id%TYPE,

342: The following procedure checks if the Organization passed in exists in the Prima
343: ry Hierarchy. Called in HREMEA.pll to validate the Organization Name on the Assi
344: gnment form
345: --------------------------------------------------------------------------------*/
346: PROCEDURE chk_for_org_in_hierarchy(p_org_id in hr_organization_units.organization_id%TYPE,
347: p_exists out nocopy varchar2) IS
348: l_organization_id hr_organization_units.organization_id%TYPE;
349: l_level number;
350: BEGIN

Line 348: l_organization_id hr_organization_units.organization_id%TYPE;

344: gnment form
345: --------------------------------------------------------------------------------*/
346: PROCEDURE chk_for_org_in_hierarchy(p_org_id in hr_organization_units.organization_id%TYPE,
347: p_exists out nocopy varchar2) IS
348: l_organization_id hr_organization_units.organization_id%TYPE;
349: l_level number;
350: BEGIN
351: p_exists := org_exists_in_hierarchy(p_org_id);
352: END chk_for_org_in_hierarchy;

Line 370: l_liab_prov hr_organization_units.organization_id%TYPE;

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;
371: l_org_id hr_organization_units.organization_id%TYPE;
372: l_membership_no varchar2(50);
373: l_duplicate varchar2(1);
374: l_record_count integer := 0;

Line 371: l_org_id hr_organization_units.organization_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;
371: l_org_id hr_organization_units.organization_id%TYPE;
372: l_membership_no varchar2(50);
373: l_duplicate varchar2(1);
374: l_record_count integer := 0;
375: l_default varchar2(1) := 'N';

Line 376: l_name hr_organization_units.name%TYPE;

372: l_membership_no varchar2(50);
373: l_duplicate varchar2(1);
374: l_record_count integer := 0;
375: l_default varchar2(1) := 'N';
376: l_name hr_organization_units.name%TYPE;
377: l_inc_date date;
378:
379: cursor c_ins_providers (c_org_id hr_organization_units.organization_id%type) is
380: select HL.ORG_LINK_INFORMATION1 status,

Line 379: cursor c_ins_providers (c_org_id hr_organization_units.organization_id%type) is

375: l_default varchar2(1) := 'N';
376: l_name hr_organization_units.name%TYPE;
377: l_inc_date date;
378:
379: cursor c_ins_providers (c_org_id hr_organization_units.organization_id%type) is
380: select HL.ORG_LINK_INFORMATION1 status,
381: Rpad(HL.CHILD_ORGANIZATION_ID, 15, ' ') child_org_id,
382: HL.ORG_LINK_INFORMATION2 Class_Of_Risk,
383: HL.ORG_LINK_INFORMATION3 Membership_Number,

Line 387: HR_ORGANIZATION_UNITS HU

383: HL.ORG_LINK_INFORMATION3 Membership_Number,
384: rpad(HU.NAME, 240, ' ') Name
385: from
386: HR_DE_ORGANIZATION_LINKS HL,
387: HR_ORGANIZATION_UNITS HU
388: where
389: Parent_Organization_id = c_org_id -- the internal org id
390: and Org_link_information_category = 'DE_LIABILITY_INSURANCE'
391: and HL.CHILD_ORGANIZATION_ID = HU.ORGANIZATION_ID;

Line 410: FROM hr_de_organization_links orl, hr_organization_units org

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
411: WHERE orl.parent_organization_id = l_org_id
412: AND orl.child_organization_id = l_liab_prov
413: AND org.organization_id = l_liab_prov;
414: -- Copy to Global package variables

Line 468: org_name hr_organization_units.name%TYPE;

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
471: org_name := SUBSTR(g_liab_prov, 17, 240);
472: RETURN org_name;

Line 506: l_org_id hr_organization_units.organization_id%type;

502: l_town hr_locations.town_or_city%TYPE;
503: l_country hr_locations.country%TYPE;
504: l_post hr_locations.postal_code%TYPE;
505: l_loc varchar2(861);
506: l_org_id hr_organization_units.organization_id%type;
507: l_sqlcode number;
508: l_mssg varchar2(100);
509:
510: CURSOR C_location (c_org_id hr_organization_units.organization_id%type) IS

Line 510: CURSOR C_location (c_org_id hr_organization_units.organization_id%type) IS

506: l_org_id hr_organization_units.organization_id%type;
507: l_sqlcode number;
508: l_mssg varchar2(100);
509:
510: CURSOR C_location (c_org_id hr_organization_units.organization_id%type) IS
511: SELECT rpad(nvl(LOC.location_id, 999999), 15, ' ') location_id,
512: rpad(nvl(LOC.address_line_1, 'XXXXXX'), 240, ' ') address_line_1,
513: rpad(nvl(LOC.address_line_2, 'XXXXXX'), 240, ' ') address_line_2,
514: rpad(nvl(LOC.address_line_3, 'XXXXXX'), 240, ' ') address_line_3,

Line 522: FROM hr_organization_units ORG WHERE ORG.organization_id = c_org_id);

518: -- INTO l_loc_id, l_add_1, l_add_2, l_add_3, l_town , l_country, l_post
519: -- INTO location_table
520: FROM hr_locations LOC WHERE LOC.location_id =
521: (select ORG.location_id
522: FROM hr_organization_units ORG WHERE ORG.organization_id = c_org_id);
523:
524:
525: BEGIN
526: -- dbms_output.put_line('In Function get_location for assg id '||p_assignment_id);

Line 686: l_org_id hr_organization_units.organization_id%TYPE;

682: RETURN VARCHAR2 IS
683: l_cc varchar2(30);
684: l_e_bet varchar2(30);
685: l_p_bet varchar2(30);
686: l_org_id hr_organization_units.organization_id%TYPE;
687: l_all varchar2(100);
688: l_inc_date date;
689:
690: BEGIN

Line 738: l_sup_off hr_organization_units.organization_id%TYPE;

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;
740: l_inc_date date;
741: l_record_count integer := 0;
742: l_name hr_organization_units.name%TYPE;

Line 739: l_org_id hr_organization_units.organization_id%TYPE;

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;
740: l_inc_date date;
741: l_record_count integer := 0;
742: l_name hr_organization_units.name%TYPE;
743: l_sqlcode number;

Line 742: l_name hr_organization_units.name%TYPE;

738: l_sup_off hr_organization_units.organization_id%TYPE;
739: l_org_id hr_organization_units.organization_id%TYPE;
740: l_inc_date date;
741: l_record_count integer := 0;
742: l_name hr_organization_units.name%TYPE;
743: l_sqlcode number;
744: l_mssg varchar2(100);
745:
746: cursor c_sup_off (c_org_id hr_organization_units.organization_id%type) IS

Line 746: cursor c_sup_off (c_org_id hr_organization_units.organization_id%type) IS

742: l_name hr_organization_units.name%TYPE;
743: l_sqlcode number;
744: l_mssg varchar2(100);
745:
746: cursor c_sup_off (c_org_id hr_organization_units.organization_id%type) IS
747: SELECT Rpad(HL.CHILD_ORGANIZATION_ID, 15, ' ') child_org_id,
748: Rpad(HU.NAME, 240, ' ') Name
749: FROM
750: HR_DE_ORGANIZATION_LINKS HL,

Line 751: HR_ORGANIZATION_UNITS HU

747: SELECT Rpad(HL.CHILD_ORGANIZATION_ID, 15, ' ') child_org_id,
748: Rpad(HU.NAME, 240, ' ') Name
749: FROM
750: HR_DE_ORGANIZATION_LINKS HL,
751: HR_ORGANIZATION_UNITS HU
752: WHERE
753: Parent_Organization_id = c_org_id -- the internal org id
754: AND Org_link_type = 'DE_WRK_INC_SUP_OFF'
755: AND HL.CHILD_ORGANIZATION_ID = HU.ORGANIZATION_ID;

Line 808: org_name hr_organization_units.name%TYPE;

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
811: org_name := SUBSTR(g_super_off, 17, 240);
812: RETURN org_name;