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_NL_ORG_INFO dependencies on HR_ORGANIZATION_UNITS

Line 173: l_organization_id hr_organization_units.organization_id%type;

169: p_organization_number out nocopy varchar2) IS
170: l_proc varchar2(72) := g_package || '.get_org_data_items';
171: l_all_items_found boolean := FALSE;
172: l_level number;
173: l_organization_id hr_organization_units.organization_id%type;
174: l_region varchar2(255);
175: temp_region varchar2(255);
176: l_organization_number varchar2(255);
177: temp_organization_number varchar2(255);

Line 178: l_org_id hr_organization_units.organization_id%type;

174: l_region varchar2(255);
175: temp_region varchar2(255);
176: l_organization_number varchar2(255);
177: temp_organization_number varchar2(255);
178: l_org_id hr_organization_units.organization_id%type;
179: l_org_information_context
180: hr_organization_information.org_information_context%type;
181: /* Add a check to see if the data item has a value for the org_id supplied
182: - add as a union or separate query */

Line 184: (l_org_id in hr_organization_units.organization_id%type) IS

180: hr_organization_information.org_information_context%type;
181: /* Add a check to see if the data item has a value for the org_id supplied
182: - add as a union or separate query */
183: CURSOR org_data_items
184: (l_org_id in hr_organization_units.organization_id%type) IS
185: select
186: substr(org_information1, 1, 30),
187: substr(org_information2, 1, 30)
188: from

Line 189: hr_organization_units d,

185: select
186: substr(org_information1, 1, 30),
187: substr(org_information2, 1, 30)
188: from
189: hr_organization_units d,
190: hr_organization_information e
191: where
192: d.organization_id = e.organization_id and
193: d.organization_id = l_org_id and

Line 242: (p_org_id in hr_organization_units.organization_id%TYPE,

238: The following procedure checks if the Organization passed in exists in the
239: Primary Hierarchy.
240: --------------------------------------------------------------------------*/
241: PROCEDURE chk_for_org_in_hierarchy
242: (p_org_id in hr_organization_units.organization_id%TYPE,
243: p_exists out nocopy varchar2) IS
244: l_organization_id hr_organization_units.organization_id%TYPE;
245: l_level number;
246: l_proc varchar2(72) := g_package || '.chk_for_org_in_hierarchy';

Line 244: l_organization_id hr_organization_units.organization_id%TYPE;

240: --------------------------------------------------------------------------*/
241: PROCEDURE chk_for_org_in_hierarchy
242: (p_org_id in hr_organization_units.organization_id%TYPE,
243: p_exists out nocopy varchar2) IS
244: l_organization_id hr_organization_units.organization_id%TYPE;
245: l_level number;
246: l_proc varchar2(72) := g_package || '.chk_for_org_in_hierarchy';
247: BEGIN
248: hr_utility.set_location('Entering ' || l_proc, 100);

Line 258: (p_org_id in hr_organization_units.organization_id%TYPE,

254: -- Function checks to see if organization belongs to the same region from
255: -- the Org Hierarchy
256: --
257: FUNCTION Check_Org_In_Region
258: (p_org_id in hr_organization_units.organization_id%TYPE,
259: p_region in varchar2)
260: RETURN hr_organization_units.organization_id%TYPE IS
261: l_organization_id hr_organization_units.organization_id%TYPE;
262: l_level number;

Line 260: RETURN hr_organization_units.organization_id%TYPE IS

256: --
257: FUNCTION Check_Org_In_Region
258: (p_org_id in hr_organization_units.organization_id%TYPE,
259: p_region in varchar2)
260: RETURN hr_organization_units.organization_id%TYPE IS
261: l_organization_id hr_organization_units.organization_id%TYPE;
262: l_level number;
263:
264: CURSOR cur_Region

Line 261: l_organization_id hr_organization_units.organization_id%TYPE;

257: FUNCTION Check_Org_In_Region
258: (p_org_id in hr_organization_units.organization_id%TYPE,
259: p_region in varchar2)
260: RETURN hr_organization_units.organization_id%TYPE IS
261: l_organization_id hr_organization_units.organization_id%TYPE;
262: l_level number;
263:
264: CURSOR cur_Region
265: (vp_Organization_ID in hr_organization_units.organization_id%TYPE,

Line 265: (vp_Organization_ID in hr_organization_units.organization_id%TYPE,

261: l_organization_id hr_organization_units.organization_id%TYPE;
262: l_level number;
263:
264: CURSOR cur_Region
265: (vp_Organization_ID in hr_organization_units.organization_id%TYPE,
266: vp_region in varchar2) IS
267: SELECT Organization_id,
268: org_information1 Region
269: FROM Hr_Organization_information

Line 347: (l_org_id in hr_organization_units.organization_id%type,l_si_type varchar2,l_assgn_id NUMBER) IS

343: -- Cursor which fetches Social Insurance Provider overridden at the Assignment Level
344: -- ordering the records by the si class order (A record for a Individual SI type would be
345: -- ordered higher than a AMI record).
346: CURSOR asg_provider
347: (l_org_id in hr_organization_units.organization_id%type,l_si_type varchar2,l_assgn_id NUMBER) IS
348: select pae.aei_information8 provider,
349: decode(pae.aei_information3,'AMI',0,1) si_class_order
350: from per_assignment_extra_info pae
351: ,fnd_sessions s

Line 370: (l_org_id in hr_organization_units.organization_id%type,

366: -- and which offers si class ordering the records first by the Primary provider Flag
367: -- and then by the si class order(A record for a Individual SI type would be
368: -- ordered higher than a AMI record).
369: CURSOR org_uwv_provider
370: (l_org_id in hr_organization_units.organization_id%type,
371: l_uwv_id in hr_organization_units.organization_id%type,
372: l_si_type varchar2) IS
373: select
374: e.org_information_id,

Line 371: l_uwv_id in hr_organization_units.organization_id%type,

367: -- and then by the si class order(A record for a Individual SI type would be
368: -- ordered higher than a AMI record).
369: CURSOR org_uwv_provider
370: (l_org_id in hr_organization_units.organization_id%type,
371: l_uwv_id in hr_organization_units.organization_id%type,
372: l_si_type varchar2) IS
373: select
374: e.org_information_id,
375: e.org_information4 provider,nvl(e.org_information7,'N') p_flag,

Line 398: l_organization_id hr_organization_units.organization_id%TYPE;

394:
395: v_asg_provider asg_provider%ROWTYPE;
396: v_org_uwv_provider org_uwv_provider%ROWTYPE;
397: l_level number;
398: l_organization_id hr_organization_units.organization_id%TYPE;
399: l_org_found boolean := false;
400: l_uwv_org_id hr_organization_units.organization_id%TYPE;
401: l_org_info_id hr_organization_units.organization_id%TYPE;
402: BEGIN

Line 400: l_uwv_org_id hr_organization_units.organization_id%TYPE;

396: v_org_uwv_provider org_uwv_provider%ROWTYPE;
397: l_level number;
398: l_organization_id hr_organization_units.organization_id%TYPE;
399: l_org_found boolean := false;
400: l_uwv_org_id hr_organization_units.organization_id%TYPE;
401: l_org_info_id hr_organization_units.organization_id%TYPE;
402: BEGIN
403: /* Fetch Override Ins Provider at the Asg Level*/
404: OPEN asg_provider(p_organization_id,p_si_type,p_assignment_id);

Line 401: l_org_info_id hr_organization_units.organization_id%TYPE;

397: l_level number;
398: l_organization_id hr_organization_units.organization_id%TYPE;
399: l_org_found boolean := false;
400: l_uwv_org_id hr_organization_units.organization_id%TYPE;
401: l_org_info_id hr_organization_units.organization_id%TYPE;
402: BEGIN
403: /* Fetch Override Ins Provider at the Asg Level*/
404: OPEN asg_provider(p_organization_id,p_si_type,p_assignment_id);
405: FETCH asg_provider INTO v_asg_provider;

Line 482: l_provider_info hr_organization_units.organization_id%type;

478: FUNCTION Get_SI_Provider_Info
479: (p_organization_id NUMBER,p_si_type VARCHAR2,p_assignment_id NUMBER) RETURN NUMBER IS
480:
481: l_proc varchar2(72) := g_package || '.Get_SI_Provider_Info';
482: l_provider_info hr_organization_units.organization_id%type;
483: l_org_id hr_organization_units.organization_id%type;
484:
485:
486: --

Line 483: l_org_id hr_organization_units.organization_id%type;

479: (p_organization_id NUMBER,p_si_type VARCHAR2,p_assignment_id NUMBER) RETURN NUMBER IS
480:
481: l_proc varchar2(72) := g_package || '.Get_SI_Provider_Info';
482: l_provider_info hr_organization_units.organization_id%type;
483: l_org_id hr_organization_units.organization_id%type;
484:
485:
486: --
487: -- Cursor which fetches Social Insurance Provider overridden at the Assignment Level

Line 491: (l_org_id in hr_organization_units.organization_id%type,l_si_type varchar2,l_assgn_id NUMBER) IS

487: -- Cursor which fetches Social Insurance Provider overridden at the Assignment Level
488: -- ordering the records by the si class order (A record for a Individual SI type would be
489: -- ordered higher than a AMI record).
490: CURSOR asg_provider
491: (l_org_id in hr_organization_units.organization_id%type,l_si_type varchar2,l_assgn_id NUMBER) IS
492: select pae.aei_information8 provider,
493: decode(pae.aei_information3,'AMI',0,1) si_class_order
494: from per_assignment_extra_info pae
495: ,fnd_sessions s

Line 515: (l_org_id in hr_organization_units.organization_id%type,l_si_type varchar2) IS

511: -- and which offers SI type ordering the records first by the Primary provider Flag
512: -- and then by the si class order(A record for a Individual SI type would be
513: -- ordered higher than a AMI record).
514: CURSOR org_uwv_provider
515: (l_org_id in hr_organization_units.organization_id%type,l_si_type varchar2) IS
516: select
517: e.org_information4 provider,nvl(e.org_information7,'N') p_flag,
518: decode(e.org_information3,'AMI',0,1) si_class_order
519: from

Line 539: l_organization_id hr_organization_units.organization_id%TYPE;

535:
536: v_asg_provider asg_provider%ROWTYPE;
537: v_org_uwv_provider org_uwv_provider%ROWTYPE;
538: l_level number;
539: l_organization_id hr_organization_units.organization_id%TYPE;
540: l_uwv_found boolean := false;
541: l_uwv_org_id hr_organization_units.organization_id%TYPE;
542: BEGIN
543: /* Fetch Override Ins Provider at the Asg Level*/

Line 541: l_uwv_org_id hr_organization_units.organization_id%TYPE;

537: v_org_uwv_provider org_uwv_provider%ROWTYPE;
538: l_level number;
539: l_organization_id hr_organization_units.organization_id%TYPE;
540: l_uwv_found boolean := false;
541: l_uwv_org_id hr_organization_units.organization_id%TYPE;
542: BEGIN
543: /* Fetch Override Ins Provider at the Asg Level*/
544: OPEN asg_provider(p_organization_id,p_si_type,p_assignment_id);
545: FETCH asg_provider INTO v_asg_provider;

Line 632: l_provider_id hr_organization_units.organization_id%TYPE;

628: ses.effective_date between paa.effective_start_date and paa.effective_end_date and
629: session_id = userenv('sessionid');
630:
631: l_org_id per_all_assignments_f.organization_id%TYPE;
632: l_provider_id hr_organization_units.organization_id%TYPE;
633:
634: BEGIN
635:
636: OPEN get_org_id(p_assignment_id);

Line 659: (l_uwv_org_id in hr_organization_units.organization_id%type,

655: -- Cursor to see if the organization belongs to the current
656: -- named hierarchy.
657: --
658: CURSOR org_uwv_provider
659: (l_uwv_org_id in hr_organization_units.organization_id%type,
660: l_org_id in hr_organization_units.organization_id%type) IS
661: select
662: e.org_information4 provider
663: from

Line 660: l_org_id in hr_organization_units.organization_id%type) IS

656: -- named hierarchy.
657: --
658: CURSOR org_uwv_provider
659: (l_uwv_org_id in hr_organization_units.organization_id%type,
660: l_org_id in hr_organization_units.organization_id%type) IS
661: select
662: e.org_information4 provider
663: from
664: hr_organization_information e

Line 676: l_organization_id hr_organization_units.organization_id%TYPE;

672: --
673: l_uwv_found varchar2(1) := 'N';
674: l_proc varchar2(72) := g_package || '.check_uwv_org_in_hierarchy';
675: l_level number;
676: l_organization_id hr_organization_units.organization_id%TYPE;
677: v_org_uwv_provider org_uwv_provider%ROWTYPE;
678: BEGIN
679: l_uwv_found := 'N';
680: IF org_hierarchy%ISOPEN THEN

Line 765: (l_org_id in hr_organization_units.organization_id%type) IS

761: --
762: --Cursor which fetches Tax Information for the given HR Organization
763: --
764: CURSOR Avg_Days_Per_Month
765: (l_org_id in hr_organization_units.organization_id%type) IS
766: select
767: e.org_information_id,
768: e.org_information5 Avg_days_Per_Month
769: from

Line 781: l_organization_id hr_organization_units.organization_id%TYPE;

777: --
778: l_avg_days Number;
779: v_avg_days Avg_Days_Per_Month%ROWTYPE;
780: l_org_id per_all_assignments_f.organization_id%TYPE;
781: l_organization_id hr_organization_units.organization_id%TYPE;
782: l_level number;
783:
784: BEGIN
785: --

Line 851: (l_org_id in hr_organization_units.organization_id%type) IS

847: --
848: -- Cursor which fetches Tax Information for the given HR Organization
849: --
850: CURSOR tax_organization
851: (l_org_id in hr_organization_units.organization_id%type) IS
852: select
853: e.org_information_id,
854: e.org_information4 tax_information
855: from

Line 868: l_org_id in hr_organization_units.organization_id%type) IS

864: --
865: -- Cursor which fetches Tax Organization list for the given HR Organization
866: --
867: CURSOR tax_org_hierarchy(l_org_struct_version_id in per_org_structure_versions.org_structure_version_id%type,
868: l_org_id in hr_organization_units.organization_id%type) IS
869: SELECT tax_org_id,lev from hr_organization_information e,(
870: SELECT l_org_id tax_org_id,0 lev from dual
871: UNION
872: SELECT distinct organization_id_parent

Line 889: l_tax_org_id hr_organization_units.organization_id%TYPE;

885: ORDER BY lev;
886:
887: v_tax_org tax_organization%ROWTYPE;
888: l_level number;
889: l_tax_org_id hr_organization_units.organization_id%TYPE;
890:
891: BEGIN
892: l_tax_org_id := NULL;
893:

Line 940: (l_org_id in hr_organization_units.organization_id%type) IS

936: --
937: --
938:
939: CURSOR Working_hours_Per_Week
940: (l_org_id in hr_organization_units.organization_id%type) IS
941: select
942: e.org_information_id,
943: e.org_information7 working_hours
944: from

Line 956: l_organization_id hr_organization_units.organization_id%TYPE;

952: --
953: l_working_hrs Number;
954: v_hrs_per_week Working_hours_Per_Week%ROWTYPE;
955: l_org_id per_all_assignments_f.organization_id%TYPE;
956: l_organization_id hr_organization_units.organization_id%TYPE;
957: l_level number;
958:
959: BEGIN
960: --

Line 1033: (l_org_id in hr_organization_units.organization_id%type) IS

1029: --
1030: --Cursor which fetches Part Time Percetage Method for the given HR Organization
1031: --
1032: CURSOR Part_Time_Percentage_Method
1033: (l_org_id in hr_organization_units.organization_id%type) IS
1034: select
1035: e.org_information_id,
1036: e.org_information8 Part_Time_Percentage_Method
1037: from

Line 1049: l_organization_id hr_organization_units.organization_id%TYPE;

1045: --
1046: l_part_time_per Number;
1047: v_part_time_per Part_Time_Percentage_Method%ROWTYPE;
1048: l_org_id per_all_assignments_f.organization_id%TYPE;
1049: l_organization_id hr_organization_units.organization_id%TYPE;
1050: l_level number;
1051:
1052: BEGIN
1053: --

Line 1130: (l_org_id in hr_organization_units.organization_id%type) IS

1126: --
1127: --Cursor which fetches lunar 5 week month wage method for the given HR Organization
1128: --
1129: CURSOR Lunar_5_Week_Month_Wage_Method
1130: (l_org_id in hr_organization_units.organization_id%type) IS
1131: select
1132: e.org_information_id,
1133: e.org_information9 Lunar_5_Week_Month_Wage_Method
1134: from

Line 1146: l_organization_id hr_organization_units.organization_id%TYPE;

1142: --
1143: l_lunar_method Number;
1144: v_lunar_method Lunar_5_Week_Month_Wage_Method%ROWTYPE;
1145: l_org_id per_all_assignments_f.organization_id%TYPE;
1146: l_organization_id hr_organization_units.organization_id%TYPE;
1147: l_level number;
1148:
1149: BEGIN
1150: --

Line 1226: (l_org_id in hr_organization_units.organization_id%type) IS

1222: --
1223: --
1224:
1225: CURSOR cur_Pro_Tax_Table
1226: (l_org_id in hr_organization_units.organization_id%type) IS
1227: select
1228: e.org_information_id,
1229: e.org_information10 Proration_Tax_Table
1230: from

Line 1242: l_organization_id hr_organization_units.organization_id%TYPE;

1238: --
1239: l_Pro_Tax_Table hr_organization_information.ORG_INFORMATION10%TYPE;
1240: v_Pro_Tax_Table cur_Pro_Tax_Table%ROWTYPE;
1241: l_org_id per_all_assignments_f.organization_id%TYPE;
1242: l_organization_id hr_organization_units.organization_id%TYPE;
1243: l_level number;
1244:
1245: BEGIN
1246: --

Line 1323: l_provider_info hr_organization_units.organization_id%type;

1319: FUNCTION Get_ER_SI_Prov_HR_Org_ID
1320: (p_organization_id NUMBER,p_si_type VARCHAR2,p_assignment_id NUMBER) RETURN NUMBER IS
1321:
1322: l_proc varchar2(72) := g_package || '.Get_SI_Provider_Info';
1323: l_provider_info hr_organization_units.organization_id%type;
1324: l_org_id hr_organization_units.organization_id%type;
1325:
1326:
1327: --

Line 1324: l_org_id hr_organization_units.organization_id%type;

1320: (p_organization_id NUMBER,p_si_type VARCHAR2,p_assignment_id NUMBER) RETURN NUMBER IS
1321:
1322: l_proc varchar2(72) := g_package || '.Get_SI_Provider_Info';
1323: l_provider_info hr_organization_units.organization_id%type;
1324: l_org_id hr_organization_units.organization_id%type;
1325:
1326:
1327: --
1328: -- Cursor which fetches Social Insurance Provider overridden at the Assignment Level

Line 1332: (l_org_id in hr_organization_units.organization_id%type,l_si_type varchar2,l_assgn_id NUMBER) IS

1328: -- Cursor which fetches Social Insurance Provider overridden at the Assignment Level
1329: -- ordering the records by the si class order (A record for a Individual SI type would be
1330: -- ordered higher than a AMI record).
1331: CURSOR asg_provider
1332: (l_org_id in hr_organization_units.organization_id%type,l_si_type varchar2,l_assgn_id NUMBER) IS
1333: select pae.aei_information8 provider,
1334: decode(pae.aei_information3,'AMI',0,1) si_class_order
1335: from per_assignment_extra_info pae
1336: ,fnd_sessions s

Line 1356: (l_org_id in hr_organization_units.organization_id%type,l_si_type varchar2) IS

1352: -- and which offers SI type ordering the records first by the Primary provider Flag
1353: -- and then by the si class order(A record for a Individual SI type would be
1354: -- ordered higher than a AMI record).
1355: CURSOR org_uwv_provider
1356: (l_org_id in hr_organization_units.organization_id%type,l_si_type varchar2) IS
1357: select
1358: e.org_information4 provider,nvl(e.org_information7,'N') p_flag,
1359: decode(e.org_information3,'AMI',0,1) si_class_order
1360: from

Line 1380: l_organization_id hr_organization_units.organization_id%TYPE;

1376:
1377: v_asg_provider asg_provider%ROWTYPE;
1378: v_org_uwv_provider org_uwv_provider%ROWTYPE;
1379: l_level number;
1380: l_organization_id hr_organization_units.organization_id%TYPE;
1381: l_uwv_found boolean := false;
1382: l_uwv_org_id hr_organization_units.organization_id%TYPE;
1383: l_er_org_id hr_organization_units.organization_id%TYPE;
1384: BEGIN

Line 1382: l_uwv_org_id hr_organization_units.organization_id%TYPE;

1378: v_org_uwv_provider org_uwv_provider%ROWTYPE;
1379: l_level number;
1380: l_organization_id hr_organization_units.organization_id%TYPE;
1381: l_uwv_found boolean := false;
1382: l_uwv_org_id hr_organization_units.organization_id%TYPE;
1383: l_er_org_id hr_organization_units.organization_id%TYPE;
1384: BEGIN
1385: /* Fetch Override Ins Provider at the Asg Level*/
1386: OPEN asg_provider(p_organization_id,p_si_type,p_assignment_id);

Line 1383: l_er_org_id hr_organization_units.organization_id%TYPE;

1379: l_level number;
1380: l_organization_id hr_organization_units.organization_id%TYPE;
1381: l_uwv_found boolean := false;
1382: l_uwv_org_id hr_organization_units.organization_id%TYPE;
1383: l_er_org_id hr_organization_units.organization_id%TYPE;
1384: BEGIN
1385: /* Fetch Override Ins Provider at the Asg Level*/
1386: OPEN asg_provider(p_organization_id,p_si_type,p_assignment_id);
1387: FETCH asg_provider INTO v_asg_provider;

Line 1523: (l_org_id in hr_organization_units.organization_id%type) IS

1519: --
1520: --Cursor which fetches Tax Information for the given HR Organization
1521: --
1522: CURSOR csr_Parental_Leave_Perc
1523: (l_org_id in hr_organization_units.organization_id%type) IS
1524: select
1525: e.org_information_id,
1526: e.org_information11 Parental_Leave_Perc
1527: from

Line 1539: l_organization_id hr_organization_units.organization_id%TYPE;

1535: --
1536: l_parental_leave_perc Number;
1537: v_csr_par_leave csr_Parental_Leave_Perc%ROWTYPE;
1538: l_org_id per_all_assignments_f.organization_id%TYPE;
1539: l_organization_id hr_organization_units.organization_id%TYPE;
1540: l_level number;
1541:
1542: BEGIN
1543: --

Line 1605: (p_org_id in hr_organization_units.organization_id%type) RETURN Varchar2 IS

1601: END Get_Parental_Leave_Wage_Perc;
1602:
1603: -- Start CBS Reporting Frequency
1604: FUNCTION Get_Reporting_Frequency
1605: (p_org_id in hr_organization_units.organization_id%type) RETURN Varchar2 IS
1606: CURSOR csr_cbs_rep_freq
1607: (l_org_id in hr_organization_units.organization_id%type) IS
1608: select
1609: e.org_information_id,

Line 1607: (l_org_id in hr_organization_units.organization_id%type) IS

1603: -- Start CBS Reporting Frequency
1604: FUNCTION Get_Reporting_Frequency
1605: (p_org_id in hr_organization_units.organization_id%type) RETURN Varchar2 IS
1606: CURSOR csr_cbs_rep_freq
1607: (l_org_id in hr_organization_units.organization_id%type) IS
1608: select
1609: e.org_information_id,
1610: e.org_information15 cbs_reporting_frequency
1611: from

Line 1623: l_organization_id hr_organization_units.organization_id%TYPE;

1619: --
1620: l_cbs_Rep_Freq hr_organization_information.ORG_INFORMATION15%TYPE;
1621: v_Rep_Freq_Table csr_cbs_rep_freq%ROWTYPE;
1622: l_org_id per_all_assignments_f.organization_id%TYPE;
1623: l_organization_id hr_organization_units.organization_id%TYPE;
1624: l_level number;
1625: BEGIN
1626: --
1627: --

Line 1683: (p_org_id in hr_organization_units.organization_id%type) RETURN Varchar2 IS

1679: --
1680: -- Start Customer Number
1681: --
1682: FUNCTION Get_customer_number
1683: (p_org_id in hr_organization_units.organization_id%type) RETURN Varchar2 IS
1684: CURSOR csr_customer_number
1685: (l_org_id in hr_organization_units.organization_id%type) IS
1686: select
1687: e.org_information_id,

Line 1685: (l_org_id in hr_organization_units.organization_id%type) IS

1681: --
1682: FUNCTION Get_customer_number
1683: (p_org_id in hr_organization_units.organization_id%type) RETURN Varchar2 IS
1684: CURSOR csr_customer_number
1685: (l_org_id in hr_organization_units.organization_id%type) IS
1686: select
1687: e.org_information_id,
1688: e.org_information16 cbs_cust_number
1689: from

Line 1701: l_organization_id hr_organization_units.organization_id%TYPE;

1697: --
1698: l_cbs_cust_num hr_organization_information.ORG_INFORMATION16%TYPE;
1699: v_cust_num_table csr_customer_number%ROWTYPE;
1700: l_org_id per_all_assignments_f.organization_id%TYPE;
1701: l_organization_id hr_organization_units.organization_id%TYPE;
1702: l_level number;
1703: BEGIN
1704: --
1705: --

Line 1755: (p_org_id in hr_organization_units.organization_id%type) RETURN Varchar2 IS

1751: --
1752: -- Start Company Unit
1753: --
1754: FUNCTION Get_company_unit
1755: (p_org_id in hr_organization_units.organization_id%type) RETURN Varchar2 IS
1756: CURSOR csr_company_unit
1757: (l_org_id in hr_organization_units.organization_id%type) IS
1758: select
1759: e.org_information_id,

Line 1757: (l_org_id in hr_organization_units.organization_id%type) IS

1753: --
1754: FUNCTION Get_company_unit
1755: (p_org_id in hr_organization_units.organization_id%type) RETURN Varchar2 IS
1756: CURSOR csr_company_unit
1757: (l_org_id in hr_organization_units.organization_id%type) IS
1758: select
1759: e.org_information_id,
1760: e.org_information18 cbs_company_unit
1761: from

Line 1773: l_organization_id hr_organization_units.organization_id%TYPE;

1769: --
1770: l_cbs_company_unit hr_organization_information.ORG_INFORMATION18%TYPE;
1771: v_company_unit_table csr_company_unit%ROWTYPE;
1772: l_org_id per_all_assignments_f.organization_id%TYPE;
1773: l_organization_id hr_organization_units.organization_id%TYPE;
1774: l_level number;
1775: BEGIN
1776: --
1777: --

Line 1831: (p_org_id in hr_organization_units.organization_id%type) RETURN Varchar2 IS

1827: END Get_company_unit;
1828: --
1829: -- Start Get_Public_Sector_Org
1830: FUNCTION Get_Public_Sector_Org
1831: (p_org_id in hr_organization_units.organization_id%type) RETURN Varchar2 IS
1832: CURSOR csr_public_sector_info
1833: (l_org_id in hr_organization_units.organization_id%type) IS
1834: select
1835: e.org_information_id,

Line 1833: (l_org_id in hr_organization_units.organization_id%type) IS

1829: -- Start Get_Public_Sector_Org
1830: FUNCTION Get_Public_Sector_Org
1831: (p_org_id in hr_organization_units.organization_id%type) RETURN Varchar2 IS
1832: CURSOR csr_public_sector_info
1833: (l_org_id in hr_organization_units.organization_id%type) IS
1834: select
1835: e.org_information_id,
1836: e.org_information17 cbs_public_sector_org
1837: from

Line 1849: l_organization_id hr_organization_units.organization_id%TYPE;

1845: --
1846: l_cbs_public_sector hr_organization_information.ORG_INFORMATION17%TYPE;
1847: v_public_sector_Table csr_public_sector_info%ROWTYPE;
1848: l_org_id per_all_assignments_f.organization_id%TYPE;
1849: l_organization_id hr_organization_units.organization_id%TYPE;
1850: l_level number;
1851: BEGIN
1852: --
1853: --

Line 1906: (p_org_id in hr_organization_units.organization_id%type) RETURN Varchar2 IS

1902:
1903: -- Function which returns Full Sickness Wage Paid Indicator for the given organization
1904: -- If the value is not specified for the given organization it performs the tree walk.
1905: FUNCTION Get_Full_Sickness_Wage_Paid
1906: (p_org_id in hr_organization_units.organization_id%type) RETURN Varchar2 IS
1907: CURSOR csr_full_wage_paid
1908: (l_org_id in hr_organization_units.organization_id%type) IS
1909: select
1910: e.org_information_id,

Line 1908: (l_org_id in hr_organization_units.organization_id%type) IS

1904: -- If the value is not specified for the given organization it performs the tree walk.
1905: FUNCTION Get_Full_Sickness_Wage_Paid
1906: (p_org_id in hr_organization_units.organization_id%type) RETURN Varchar2 IS
1907: CURSOR csr_full_wage_paid
1908: (l_org_id in hr_organization_units.organization_id%type) IS
1909: select
1910: e.org_information_id,
1911: e.org_information19 full_sick_wage_paid
1912: from

Line 1924: l_organization_id hr_organization_units.organization_id%TYPE;

1920: --
1921: l_full_wage_paid hr_organization_information.ORG_INFORMATION17%TYPE;
1922: v_full_sick_wage csr_full_wage_paid%ROWTYPE;
1923: l_org_id per_all_assignments_f.organization_id%TYPE;
1924: l_organization_id hr_organization_units.organization_id%TYPE;
1925: l_level number;
1926: BEGIN
1927: --
1928: --

Line 1986: (l_org_id in hr_organization_units.organization_id%type) IS

1982: where paa.assignment_id = p_assignment_id and
1983: ses.effective_date between paa.effective_start_date and paa.effective_end_date and
1984: session_id = userenv('sessionid');
1985: CURSOR csr_IZA_Weekly_Hours
1986: (l_org_id in hr_organization_units.organization_id%type) IS
1987: select
1988: e.org_information_id,
1989: e.org_information20 IZA_Weekly_Hours
1990: from

Line 2002: l_organization_id hr_organization_units.organization_id%TYPE;

1998: --
1999: l_IZA_Weekly_Hours hr_organization_information.ORG_INFORMATION20%TYPE;
2000: v_IZA_Weekly_Hours_table csr_IZA_Weekly_Hours%ROWTYPE;
2001: l_org_id per_all_assignments_f.organization_id%TYPE;
2002: l_organization_id hr_organization_units.organization_id%TYPE;
2003: l_level number;
2004: BEGIN
2005: --
2006: --Determine the Organization Id of the Employees Assignment

Line 2076: (l_org_id in hr_organization_units.organization_id%type) IS

2072: ses.effective_date between paa.effective_start_date and paa.effective_end_date and
2073: session_id = userenv('sessionid');
2074: --
2075: CURSOR csr_IZA_Monthly_Hours
2076: (l_org_id in hr_organization_units.organization_id%type) IS
2077: select
2078: e.org_information_id,
2079: e.org_information12 IZA_Monthly_Hours
2080: from

Line 2092: l_organization_id hr_organization_units.organization_id%TYPE;

2088: --
2089: l_IZA_Monthly_Hours hr_organization_information.ORG_INFORMATION12%TYPE;
2090: v_IZA_Monthly_Hours_table csr_IZA_Monthly_Hours%ROWTYPE;
2091: l_org_id per_all_assignments_f.organization_id%TYPE;
2092: l_organization_id hr_organization_units.organization_id%TYPE;
2093: l_level number;
2094: BEGIN
2095: --
2096: --Determine the Organization Id of the Employees Assignment

Line 2159: (l_org_id in hr_organization_units.organization_id%type) IS

2155: --
2156: -- Cursor which fetches IZA Information for the given HR Organization
2157: --
2158: CURSOR iza_organization
2159: (l_org_id in hr_organization_units.organization_id%type) IS
2160: select
2161: e.org_information_id,
2162: e.org_information1 iza_information
2163: from

Line 2176: l_org_id in hr_organization_units.organization_id%type) IS

2172: --
2173: -- Cursor which fetches IZA Organization list for the given HR Organization
2174: --
2175: CURSOR iza_org_hierarchy(l_org_struct_version_id in per_org_structure_versions.org_structure_version_id%type,
2176: l_org_id in hr_organization_units.organization_id%type) IS
2177: SELECT iza_org_id,lev from hr_organization_information e,(
2178: SELECT l_org_id iza_org_id,0 lev from dual
2179: UNION
2180: SELECT distinct organization_id_parent

Line 2195: l_iza_org_id hr_organization_units.organization_id%TYPE;

2191: ORDER BY lev;
2192:
2193: v_iza_org iza_organization%ROWTYPE;
2194: l_level number;
2195: l_iza_org_id hr_organization_units.organization_id%TYPE;
2196:
2197: BEGIN
2198: l_iza_org_id := NULL;
2199: