DBA Data[Home] [Help]

APPS.PER_IN_ORG_INFO_LEG_HOOK dependencies on HR_API

Line 2900: IF p_name <> hr_api.g_varchar2 THEN

2896: CLOSE c_org_id;
2897:
2898: pay_in_utils.set_location(g_debug,l_procedure,20);
2899:
2900: IF p_name <> hr_api.g_varchar2 THEN
2901: l_name := p_name;
2902: END IF;
2903:
2904: IF p_location_id <> hr_api.g_number THEN

Line 2904: IF p_location_id <> hr_api.g_number THEN

2900: IF p_name <> hr_api.g_varchar2 THEN
2901: l_name := p_name;
2902: END IF;
2903:
2904: IF p_location_id <> hr_api.g_number THEN
2905: l_location_id := p_location_id;
2906: END IF;
2907:
2908: IF p_date_from <> hr_api.g_date THEN

Line 2908: IF p_date_from <> hr_api.g_date THEN

2904: IF p_location_id <> hr_api.g_number THEN
2905: l_location_id := p_location_id;
2906: END IF;
2907:
2908: IF p_date_from <> hr_api.g_date THEN
2909: l_date_from := p_date_from;
2910: END IF;
2911:
2912: IF p_date_to <> hr_api.g_date THEN

Line 2912: IF p_date_to <> hr_api.g_date THEN

2908: IF p_date_from <> hr_api.g_date THEN
2909: l_date_from := p_date_from;
2910: END IF;
2911:
2912: IF p_date_to <> hr_api.g_date THEN
2913: l_date_to := p_date_to;
2914: END IF;
2915:
2916: check_org_internal

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

4253: CLOSE c_org_id;
4254:
4255: pay_in_utils.set_location(g_debug,l_procedure,20);
4256:
4257: IF NVL (p_org_information1,'X') <> hr_api.g_varchar2 THEN
4258: l_org_information1 := p_org_information1;
4259: END IF;
4260:
4261: IF p_org_information2 <> hr_api.g_varchar2 THEN

Line 4261: IF p_org_information2 <> hr_api.g_varchar2 THEN

4257: IF NVL (p_org_information1,'X') <> hr_api.g_varchar2 THEN
4258: l_org_information1 := p_org_information1;
4259: END IF;
4260:
4261: IF p_org_information2 <> hr_api.g_varchar2 THEN
4262: l_org_information2 := p_org_information2;
4263: END IF;
4264:
4265: IF p_org_information3 <> hr_api.g_varchar2 THEN

Line 4265: IF p_org_information3 <> hr_api.g_varchar2 THEN

4261: IF p_org_information2 <> hr_api.g_varchar2 THEN
4262: l_org_information2 := p_org_information2;
4263: END IF;
4264:
4265: IF p_org_information3 <> hr_api.g_varchar2 THEN
4266: l_org_information3 := p_org_information3;
4267: END IF;
4268:
4269: IF p_org_information4 <> hr_api.g_varchar2 THEN

Line 4269: IF p_org_information4 <> hr_api.g_varchar2 THEN

4265: IF p_org_information3 <> hr_api.g_varchar2 THEN
4266: l_org_information3 := p_org_information3;
4267: END IF;
4268:
4269: IF p_org_information4 <> hr_api.g_varchar2 THEN
4270: l_org_information4 := p_org_information4;
4271: END IF;
4272:
4273: IF NVL(p_org_information5,'X') <> hr_api.g_varchar2 THEN

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

4269: IF p_org_information4 <> hr_api.g_varchar2 THEN
4270: l_org_information4 := p_org_information4;
4271: END IF;
4272:
4273: IF NVL(p_org_information5,'X') <> hr_api.g_varchar2 THEN
4274: l_org_information5 := p_org_information5;
4275: END IF;
4276:
4277: IF p_org_information6 <> hr_api.g_varchar2 THEN

Line 4277: IF p_org_information6 <> hr_api.g_varchar2 THEN

4273: IF NVL(p_org_information5,'X') <> hr_api.g_varchar2 THEN
4274: l_org_information5 := p_org_information5;
4275: END IF;
4276:
4277: IF p_org_information6 <> hr_api.g_varchar2 THEN
4278: l_org_information6 := p_org_information6;
4279: END IF;
4280:
4281: IF p_org_information7 <> hr_api.g_varchar2 THEN

Line 4281: IF p_org_information7 <> hr_api.g_varchar2 THEN

4277: IF p_org_information6 <> hr_api.g_varchar2 THEN
4278: l_org_information6 := p_org_information6;
4279: END IF;
4280:
4281: IF p_org_information7 <> hr_api.g_varchar2 THEN
4282: l_org_information7 := p_org_information7;
4283: END IF;
4284:
4285: IF p_org_information8 <> hr_api.g_varchar2 THEN

Line 4285: IF p_org_information8 <> hr_api.g_varchar2 THEN

4281: IF p_org_information7 <> hr_api.g_varchar2 THEN
4282: l_org_information7 := p_org_information7;
4283: END IF;
4284:
4285: IF p_org_information8 <> hr_api.g_varchar2 THEN
4286: l_org_information8 := p_org_information8;
4287: END IF;
4288:
4289: IF nvl(p_org_information9,'X') <> hr_api.g_varchar2 THEN

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

4285: IF p_org_information8 <> hr_api.g_varchar2 THEN
4286: l_org_information8 := p_org_information8;
4287: END IF;
4288:
4289: IF nvl(p_org_information9,'X') <> hr_api.g_varchar2 THEN
4290: l_org_information9 := p_org_information9;
4291: END IF;
4292: IF nvl(p_org_information10,'X') <> hr_api.g_varchar2 THEN
4293: l_org_information10 := p_org_information10;

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

4288:
4289: IF nvl(p_org_information9,'X') <> hr_api.g_varchar2 THEN
4290: l_org_information9 := p_org_information9;
4291: END IF;
4292: IF nvl(p_org_information10,'X') <> hr_api.g_varchar2 THEN
4293: l_org_information10 := p_org_information10;
4294: END IF;
4295:
4296: IF NVL(p_org_information11,'X') <> hr_api.g_varchar2 THEN

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

4292: IF nvl(p_org_information10,'X') <> hr_api.g_varchar2 THEN
4293: l_org_information10 := p_org_information10;
4294: END IF;
4295:
4296: IF NVL(p_org_information11,'X') <> hr_api.g_varchar2 THEN
4297: l_org_information11 := p_org_information11;
4298: END IF;
4299:
4300: IF NVL(p_org_information12,'X') <> hr_api.g_varchar2 THEN

Line 4300: IF NVL(p_org_information12,'X') <> hr_api.g_varchar2 THEN

4296: IF NVL(p_org_information11,'X') <> hr_api.g_varchar2 THEN
4297: l_org_information11 := p_org_information11;
4298: END IF;
4299:
4300: IF NVL(p_org_information12,'X') <> hr_api.g_varchar2 THEN
4301: l_org_information12 := p_org_information12;
4302: END IF;
4303:
4304: IF NVL(p_org_information13,'X') <> hr_api.g_varchar2 THEN

Line 4304: IF NVL(p_org_information13,'X') <> hr_api.g_varchar2 THEN

4300: IF NVL(p_org_information12,'X') <> hr_api.g_varchar2 THEN
4301: l_org_information12 := p_org_information12;
4302: END IF;
4303:
4304: IF NVL(p_org_information13,'X') <> hr_api.g_varchar2 THEN
4305: l_org_information13 := p_org_information13;
4306: END IF;
4307:
4308: IF NVL (p_org_information14,'X') <> hr_api.g_varchar2 THEN

Line 4308: IF NVL (p_org_information14,'X') <> hr_api.g_varchar2 THEN

4304: IF NVL(p_org_information13,'X') <> hr_api.g_varchar2 THEN
4305: l_org_information13 := p_org_information13;
4306: END IF;
4307:
4308: IF NVL (p_org_information14,'X') <> hr_api.g_varchar2 THEN
4309: l_org_information14 := p_org_information14;
4310: END IF;
4311:
4312: IF NVL (p_org_information15,'X') <> hr_api.g_varchar2 THEN

Line 4312: IF NVL (p_org_information15,'X') <> hr_api.g_varchar2 THEN

4308: IF NVL (p_org_information14,'X') <> hr_api.g_varchar2 THEN
4309: l_org_information14 := p_org_information14;
4310: END IF;
4311:
4312: IF NVL (p_org_information15,'X') <> hr_api.g_varchar2 THEN
4313: l_org_information15 := p_org_information15;
4314: END IF;
4315:
4316: IF p_org_information16 <> hr_api.g_varchar2 THEN

Line 4316: IF p_org_information16 <> hr_api.g_varchar2 THEN

4312: IF NVL (p_org_information15,'X') <> hr_api.g_varchar2 THEN
4313: l_org_information15 := p_org_information15;
4314: END IF;
4315:
4316: IF p_org_information16 <> hr_api.g_varchar2 THEN
4317: l_org_information16 := p_org_information16;
4318: END IF;
4319:
4320: IF p_org_information17 <> hr_api.g_varchar2 THEN

Line 4320: IF p_org_information17 <> hr_api.g_varchar2 THEN

4316: IF p_org_information16 <> hr_api.g_varchar2 THEN
4317: l_org_information16 := p_org_information16;
4318: END IF;
4319:
4320: IF p_org_information17 <> hr_api.g_varchar2 THEN
4321: l_org_information17 := p_org_information17;
4322: END IF;
4323:
4324: IF p_org_information18 <> hr_api.g_varchar2 THEN

Line 4324: IF p_org_information18 <> hr_api.g_varchar2 THEN

4320: IF p_org_information17 <> hr_api.g_varchar2 THEN
4321: l_org_information17 := p_org_information17;
4322: END IF;
4323:
4324: IF p_org_information18 <> hr_api.g_varchar2 THEN
4325: l_org_information18 := p_org_information18;
4326: END IF;
4327:
4328: IF p_org_information19 <> hr_api.g_varchar2 THEN

Line 4328: IF p_org_information19 <> hr_api.g_varchar2 THEN

4324: IF p_org_information18 <> hr_api.g_varchar2 THEN
4325: l_org_information18 := p_org_information18;
4326: END IF;
4327:
4328: IF p_org_information19 <> hr_api.g_varchar2 THEN
4329: l_org_information19 := p_org_information19;
4330: END IF;
4331:
4332: IF p_org_information20 <> hr_api.g_varchar2 THEN

Line 4332: IF p_org_information20 <> hr_api.g_varchar2 THEN

4328: IF p_org_information19 <> hr_api.g_varchar2 THEN
4329: l_org_information19 := p_org_information19;
4330: END IF;
4331:
4332: IF p_org_information20 <> hr_api.g_varchar2 THEN
4333: l_org_information20 := p_org_information20;
4334: END IF;
4335:
4336: IF (p_org_info_type_code = 'PER_IN_PROF_TAX_DF') THEN