DBA Data[Home] [Help]

APPS.PER_IN_ORG_INFO_LEG_HOOK dependencies on HR_API

Line 2510: IF p_name <> hr_api.g_varchar2 THEN

2506: CLOSE c_org_id;
2507:
2508: pay_in_utils.set_location(g_debug,l_procedure,20);
2509:
2510: IF p_name <> hr_api.g_varchar2 THEN
2511: l_name := p_name;
2512: END IF;
2513:
2514: IF p_location_id <> hr_api.g_number THEN

Line 2514: IF p_location_id <> hr_api.g_number THEN

2510: IF p_name <> hr_api.g_varchar2 THEN
2511: l_name := p_name;
2512: END IF;
2513:
2514: IF p_location_id <> hr_api.g_number THEN
2515: l_location_id := p_location_id;
2516: END IF;
2517:
2518: IF p_date_from <> hr_api.g_date THEN

Line 2518: IF p_date_from <> hr_api.g_date THEN

2514: IF p_location_id <> hr_api.g_number THEN
2515: l_location_id := p_location_id;
2516: END IF;
2517:
2518: IF p_date_from <> hr_api.g_date THEN
2519: l_date_from := p_date_from;
2520: END IF;
2521:
2522: IF p_date_to <> hr_api.g_date THEN

Line 2522: IF p_date_to <> hr_api.g_date THEN

2518: IF p_date_from <> hr_api.g_date THEN
2519: l_date_from := p_date_from;
2520: END IF;
2521:
2522: IF p_date_to <> hr_api.g_date THEN
2523: l_date_to := p_date_to;
2524: END IF;
2525:
2526: check_org_internal

Line 3851: IF NVL (p_org_information1,'X') <> hr_api.g_varchar2 THEN

3847: CLOSE c_org_id;
3848:
3849: pay_in_utils.set_location(g_debug,l_procedure,20);
3850:
3851: IF NVL (p_org_information1,'X') <> hr_api.g_varchar2 THEN
3852: l_org_information1 := p_org_information1;
3853: END IF;
3854:
3855: IF p_org_information2 <> hr_api.g_varchar2 THEN

Line 3855: IF p_org_information2 <> hr_api.g_varchar2 THEN

3851: IF NVL (p_org_information1,'X') <> hr_api.g_varchar2 THEN
3852: l_org_information1 := p_org_information1;
3853: END IF;
3854:
3855: IF p_org_information2 <> hr_api.g_varchar2 THEN
3856: l_org_information2 := p_org_information2;
3857: END IF;
3858:
3859: IF p_org_information3 <> hr_api.g_varchar2 THEN

Line 3859: IF p_org_information3 <> hr_api.g_varchar2 THEN

3855: IF p_org_information2 <> hr_api.g_varchar2 THEN
3856: l_org_information2 := p_org_information2;
3857: END IF;
3858:
3859: IF p_org_information3 <> hr_api.g_varchar2 THEN
3860: l_org_information3 := p_org_information3;
3861: END IF;
3862:
3863: IF p_org_information4 <> hr_api.g_varchar2 THEN

Line 3863: IF p_org_information4 <> hr_api.g_varchar2 THEN

3859: IF p_org_information3 <> hr_api.g_varchar2 THEN
3860: l_org_information3 := p_org_information3;
3861: END IF;
3862:
3863: IF p_org_information4 <> hr_api.g_varchar2 THEN
3864: l_org_information4 := p_org_information4;
3865: END IF;
3866:
3867: IF NVL(p_org_information5,'X') <> hr_api.g_varchar2 THEN

Line 3867: IF NVL(p_org_information5,'X') <> hr_api.g_varchar2 THEN

3863: IF p_org_information4 <> hr_api.g_varchar2 THEN
3864: l_org_information4 := p_org_information4;
3865: END IF;
3866:
3867: IF NVL(p_org_information5,'X') <> hr_api.g_varchar2 THEN
3868: l_org_information5 := p_org_information5;
3869: END IF;
3870:
3871: IF p_org_information6 <> hr_api.g_varchar2 THEN

Line 3871: IF p_org_information6 <> hr_api.g_varchar2 THEN

3867: IF NVL(p_org_information5,'X') <> hr_api.g_varchar2 THEN
3868: l_org_information5 := p_org_information5;
3869: END IF;
3870:
3871: IF p_org_information6 <> hr_api.g_varchar2 THEN
3872: l_org_information6 := p_org_information6;
3873: END IF;
3874:
3875: IF p_org_information7 <> hr_api.g_varchar2 THEN

Line 3875: IF p_org_information7 <> hr_api.g_varchar2 THEN

3871: IF p_org_information6 <> hr_api.g_varchar2 THEN
3872: l_org_information6 := p_org_information6;
3873: END IF;
3874:
3875: IF p_org_information7 <> hr_api.g_varchar2 THEN
3876: l_org_information7 := p_org_information7;
3877: END IF;
3878:
3879: IF p_org_information8 <> hr_api.g_varchar2 THEN

Line 3879: IF p_org_information8 <> hr_api.g_varchar2 THEN

3875: IF p_org_information7 <> hr_api.g_varchar2 THEN
3876: l_org_information7 := p_org_information7;
3877: END IF;
3878:
3879: IF p_org_information8 <> hr_api.g_varchar2 THEN
3880: l_org_information8 := p_org_information8;
3881: END IF;
3882:
3883: IF nvl(p_org_information9,'X') <> hr_api.g_varchar2 THEN

Line 3883: IF nvl(p_org_information9,'X') <> hr_api.g_varchar2 THEN

3879: IF p_org_information8 <> hr_api.g_varchar2 THEN
3880: l_org_information8 := p_org_information8;
3881: END IF;
3882:
3883: IF nvl(p_org_information9,'X') <> hr_api.g_varchar2 THEN
3884: l_org_information9 := p_org_information9;
3885: END IF;
3886: IF nvl(p_org_information10,'X') <> hr_api.g_varchar2 THEN
3887: l_org_information10 := p_org_information10;

Line 3886: IF nvl(p_org_information10,'X') <> hr_api.g_varchar2 THEN

3882:
3883: IF nvl(p_org_information9,'X') <> hr_api.g_varchar2 THEN
3884: l_org_information9 := p_org_information9;
3885: END IF;
3886: IF nvl(p_org_information10,'X') <> hr_api.g_varchar2 THEN
3887: l_org_information10 := p_org_information10;
3888: END IF;
3889:
3890: IF NVL(p_org_information11,'X') <> hr_api.g_varchar2 THEN

Line 3890: IF NVL(p_org_information11,'X') <> hr_api.g_varchar2 THEN

3886: IF nvl(p_org_information10,'X') <> hr_api.g_varchar2 THEN
3887: l_org_information10 := p_org_information10;
3888: END IF;
3889:
3890: IF NVL(p_org_information11,'X') <> hr_api.g_varchar2 THEN
3891: l_org_information11 := p_org_information11;
3892: END IF;
3893:
3894: IF p_org_information12 <> hr_api.g_varchar2 THEN

Line 3894: IF p_org_information12 <> hr_api.g_varchar2 THEN

3890: IF NVL(p_org_information11,'X') <> hr_api.g_varchar2 THEN
3891: l_org_information11 := p_org_information11;
3892: END IF;
3893:
3894: IF p_org_information12 <> hr_api.g_varchar2 THEN
3895: l_org_information12 := p_org_information12;
3896: END IF;
3897:
3898: IF p_org_information13 <> hr_api.g_varchar2 THEN

Line 3898: IF p_org_information13 <> hr_api.g_varchar2 THEN

3894: IF p_org_information12 <> hr_api.g_varchar2 THEN
3895: l_org_information12 := p_org_information12;
3896: END IF;
3897:
3898: IF p_org_information13 <> hr_api.g_varchar2 THEN
3899: l_org_information13 := p_org_information13;
3900: END IF;
3901:
3902: IF p_org_information14 <> hr_api.g_varchar2 THEN

Line 3902: IF p_org_information14 <> hr_api.g_varchar2 THEN

3898: IF p_org_information13 <> hr_api.g_varchar2 THEN
3899: l_org_information13 := p_org_information13;
3900: END IF;
3901:
3902: IF p_org_information14 <> hr_api.g_varchar2 THEN
3903: l_org_information14 := p_org_information14;
3904: END IF;
3905:
3906: IF p_org_information15 <> hr_api.g_varchar2 THEN

Line 3906: IF p_org_information15 <> hr_api.g_varchar2 THEN

3902: IF p_org_information14 <> hr_api.g_varchar2 THEN
3903: l_org_information14 := p_org_information14;
3904: END IF;
3905:
3906: IF p_org_information15 <> hr_api.g_varchar2 THEN
3907: l_org_information15 := p_org_information15;
3908: END IF;
3909:
3910: IF p_org_information16 <> hr_api.g_varchar2 THEN

Line 3910: IF p_org_information16 <> hr_api.g_varchar2 THEN

3906: IF p_org_information15 <> hr_api.g_varchar2 THEN
3907: l_org_information15 := p_org_information15;
3908: END IF;
3909:
3910: IF p_org_information16 <> hr_api.g_varchar2 THEN
3911: l_org_information16 := p_org_information16;
3912: END IF;
3913:
3914: IF p_org_information17 <> hr_api.g_varchar2 THEN

Line 3914: IF p_org_information17 <> hr_api.g_varchar2 THEN

3910: IF p_org_information16 <> hr_api.g_varchar2 THEN
3911: l_org_information16 := p_org_information16;
3912: END IF;
3913:
3914: IF p_org_information17 <> hr_api.g_varchar2 THEN
3915: l_org_information17 := p_org_information17;
3916: END IF;
3917:
3918: IF p_org_information18 <> hr_api.g_varchar2 THEN

Line 3918: IF p_org_information18 <> hr_api.g_varchar2 THEN

3914: IF p_org_information17 <> hr_api.g_varchar2 THEN
3915: l_org_information17 := p_org_information17;
3916: END IF;
3917:
3918: IF p_org_information18 <> hr_api.g_varchar2 THEN
3919: l_org_information18 := p_org_information18;
3920: END IF;
3921:
3922: IF p_org_information19 <> hr_api.g_varchar2 THEN

Line 3922: IF p_org_information19 <> hr_api.g_varchar2 THEN

3918: IF p_org_information18 <> hr_api.g_varchar2 THEN
3919: l_org_information18 := p_org_information18;
3920: END IF;
3921:
3922: IF p_org_information19 <> hr_api.g_varchar2 THEN
3923: l_org_information19 := p_org_information19;
3924: END IF;
3925:
3926: IF p_org_information20 <> hr_api.g_varchar2 THEN

Line 3926: IF p_org_information20 <> hr_api.g_varchar2 THEN

3922: IF p_org_information19 <> hr_api.g_varchar2 THEN
3923: l_org_information19 := p_org_information19;
3924: END IF;
3925:
3926: IF p_org_information20 <> hr_api.g_varchar2 THEN
3927: l_org_information20 := p_org_information20;
3928: END IF;
3929:
3930: IF (p_org_info_type_code = 'PER_IN_PROF_TAX_DF') THEN