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 1524: (l_org_id in hr_organization_units.organization_id%type) IS

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

Line 1540: l_organization_id hr_organization_units.organization_id%TYPE;

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

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

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

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

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

Line 1624: l_organization_id hr_organization_units.organization_id%TYPE;

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

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

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

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

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

Line 1702: l_organization_id hr_organization_units.organization_id%TYPE;

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

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

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

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

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

Line 1774: l_organization_id hr_organization_units.organization_id%TYPE;

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

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

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

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

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

Line 1850: l_organization_id hr_organization_units.organization_id%TYPE;

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

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

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

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

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

Line 1925: l_organization_id hr_organization_units.organization_id%TYPE;

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

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

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

Line 2003: l_organization_id hr_organization_units.organization_id%TYPE;

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

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

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

Line 2093: l_organization_id hr_organization_units.organization_id%TYPE;

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

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

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

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

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

Line 2196: l_iza_org_id hr_organization_units.organization_id%TYPE;

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

Line 2234: l_provider_info hr_organization_units.organization_id%type;

2230: FUNCTION Get_SI_Provider_Excl_Info
2231: (p_organization_id NUMBER,p_si_class VARCHAR2,p_assignment_id NUMBER,p_date_earned DATE) RETURN NUMBER IS
2232:
2233: l_proc varchar2(72) := g_package || '.Get_SI_Provider_Excl_Info';
2234: l_provider_info hr_organization_units.organization_id%type;
2235: l_org_id hr_organization_units.organization_id%type;
2236:
2237: -- Cursor which detects whether any Social Insurance type is excluded at the HR Org Level.
2238: CURSOR org_si_excluded

Line 2235: l_org_id hr_organization_units.organization_id%type;

2231: (p_organization_id NUMBER,p_si_class VARCHAR2,p_assignment_id NUMBER,p_date_earned DATE) RETURN NUMBER IS
2232:
2233: l_proc varchar2(72) := g_package || '.Get_SI_Provider_Excl_Info';
2234: l_provider_info hr_organization_units.organization_id%type;
2235: l_org_id hr_organization_units.organization_id%type;
2236:
2237: -- Cursor which detects whether any Social Insurance type is excluded at the HR Org Level.
2238: CURSOR org_si_excluded
2239: (l_org_id in hr_organization_units.organization_id%type,l_si_class varchar2,l_date_earned DATE) IS

Line 2239: (l_org_id in hr_organization_units.organization_id%type,l_si_class varchar2,l_date_earned DATE) IS

2235: l_org_id hr_organization_units.organization_id%type;
2236:
2237: -- Cursor which detects whether any Social Insurance type is excluded at the HR Org Level.
2238: CURSOR org_si_excluded
2239: (l_org_id in hr_organization_units.organization_id%type,l_si_class varchar2,l_date_earned DATE) IS
2240: select
2241: 1
2242: from
2243: hr_organization_information e

Line 2252: l_organization_id hr_organization_units.organization_id%TYPE;

2248: and nvl(fnd_date.canonical_to_date(e.org_INFORMATION2),hr_general.END_OF_TIME);
2249:
2250: v_org_si_excluded org_si_excluded%ROWTYPE;
2251: l_level number;
2252: l_organization_id hr_organization_units.organization_id%TYPE;
2253: l_uwv_not_found number;
2254:
2255: BEGIN
2256:

Line 2339: CURSOR csr_get_lhd_override(l_org_id in hr_organization_units.organization_id%type) IS

2335: AND ses.effective_date BETWEEN paa.effective_start_date
2336: AND paa.effective_end_date
2337: AND session_id = userenv ('sessionid');
2338:
2339: CURSOR csr_get_lhd_override(l_org_id in hr_organization_units.organization_id%type) IS
2340: SELECT hoi.org_information6 lhd_pro_override
2341: FROM hr_organization_information hoi
2342: WHERE hoi.organization_id = l_org_id
2343: AND hoi.org_information_context = 'NL_ORG_INFORMATION'

Line 2428: CURSOR csr_get_bene_rul_sepa(l_org_id IN hr_organization_units.organization_id%TYPE) IS

2424: BETWEEN paa.effective_start_date
2425: AND paa.effective_end_date
2426: AND session_id = userenv ('sessionid');
2427:
2428: CURSOR csr_get_bene_rul_sepa(l_org_id IN hr_organization_units.organization_id%TYPE) IS
2429: SELECT hoi.org_information7 benefi_rule
2430: FROM hr_organization_information hoi
2431: WHERE hoi.organization_id = l_org_id
2432: AND hoi.org_information_context = 'NL_ORG_INFORMATION'