DBA Data[Home] [Help]

APPS.GHR_PDI_BUS dependencies on GHR_PDI_SHD

Line 77: l_api_updating := ghr_pdi_shd.api_updating(

73: -- b) The category_category value has changed
74: -- c) A record is being inserted.
75: --
76:
77: l_api_updating := ghr_pdi_shd.api_updating(
78: p_position_description_id => p_position_description_id,
79: p_object_version_number => p_object_version_number);
80:
81: IF (l_api_updating

Line 83: ((nvl(ghr_pdi_shd.g_old_rec.category,hr_api.g_varchar2)

79: p_object_version_number => p_object_version_number);
80:
81: IF (l_api_updating
82: AND
83: ((nvl(ghr_pdi_shd.g_old_rec.category,hr_api.g_varchar2)
84: <> nvl(p_category,hr_api.g_varchar2))))
85: OR
86: NOT l_api_updating THEN
87:

Line 147: l_api_updating := ghr_pdi_shd.api_updating(

143: -- b) The flsa_category value has changed
144: -- c) A record is being inserted.
145: --
146:
147: l_api_updating := ghr_pdi_shd.api_updating(
148: p_position_description_id => p_position_description_id,
149: p_object_version_number => p_object_version_number);
150:
151: IF (l_api_updating

Line 153: ((nvl(ghr_pdi_shd.g_old_rec.flsa,hr_api.g_varchar2)

149: p_object_version_number => p_object_version_number);
150:
151: IF (l_api_updating
152: AND
153: ((nvl(ghr_pdi_shd.g_old_rec.flsa,hr_api.g_varchar2)
154: <> nvl(p_flsa,hr_api.g_varchar2))))
155: OR
156: NOT l_api_updating THEN
157:

Line 224: l_api_updating := ghr_pdi_shd.api_updating(

220: -- b) The financial_statement value has changed
221: -- c) A record is being inserted.
222: --
223:
224: l_api_updating := ghr_pdi_shd.api_updating(
225: p_position_description_id => p_position_description_id,
226: p_object_version_number => p_object_version_number);
227:
228: IF (l_api_updating

Line 230: ((nvl(ghr_pdi_shd.g_old_rec.financial_statement,hr_api.g_varchar2)

226: p_object_version_number => p_object_version_number);
227:
228: IF (l_api_updating
229: AND
230: ((nvl(ghr_pdi_shd.g_old_rec.financial_statement,hr_api.g_varchar2)
231: <> nvl(p_financial_statement,hr_api.g_varchar2))))
232: OR
233: NOT l_api_updating THEN
234: --

Line 302: l_api_updating := ghr_pdi_shd.api_updating(

298: -- b) The flsa_category value has changed
299: -- c) A record is being inserted.
300: --
301:
302: l_api_updating := ghr_pdi_shd.api_updating(
303: p_position_description_id => p_position_description_id,
304: p_object_version_number => p_object_version_number);
305:
306: IF (l_api_updating

Line 308: ((nvl(ghr_pdi_shd.g_old_rec.subject_to_ia_action,hr_api.g_varchar2)

304: p_object_version_number => p_object_version_number);
305:
306: IF (l_api_updating
307: AND
308: ((nvl(ghr_pdi_shd.g_old_rec.subject_to_ia_action,hr_api.g_varchar2)
309: <> nvl(p_sub_to_ia_action,hr_api.g_varchar2))))
310: OR
311: NOT l_api_updating THEN
312: --

Line 380: l_api_updating := ghr_pdi_shd.api_updating(

376: -- b) The flsa_category value has changed
377: -- c) A record is being inserted.
378: --
379:
380: l_api_updating := ghr_pdi_shd.api_updating(
381: p_position_description_id => p_position_description_id,
382: p_object_version_number => p_object_version_number);
383:
384: IF (l_api_updating

Line 386: ((nvl(ghr_pdi_shd.g_old_rec.position_status,hr_api.g_number)

382: p_object_version_number => p_object_version_number);
383:
384: IF (l_api_updating
385: AND
386: ((nvl(ghr_pdi_shd.g_old_rec.position_status,hr_api.g_number)
387: <> nvl(p_position_status,hr_api.g_number))))
388: OR
389: NOT l_api_updating THEN
390:

Line 459: l_api_updating := ghr_pdi_shd.api_updating(

455: -- b) The flsa_category value has changed
456: -- c) A record is being inserted.
457: --
458:
459: l_api_updating := ghr_pdi_shd.api_updating(
460: p_position_description_id => p_position_description_id,
461: p_object_version_number => p_object_version_number);
462:
463: IF (l_api_updating

Line 465: ((nvl(ghr_pdi_shd.g_old_rec.position_is,hr_api.g_varchar2)

461: p_object_version_number => p_object_version_number);
462:
463: IF (l_api_updating
464: AND
465: ((nvl(ghr_pdi_shd.g_old_rec.position_is,hr_api.g_varchar2)
466: <> nvl(p_position_is,hr_api.g_varchar2))))
467: OR
468: NOT l_api_updating THEN
469:

Line 537: l_api_updating := ghr_pdi_shd.api_updating(

533: -- b) The Position Sensitivity value has changed
534: -- c) A record is being inserted.
535: --
536:
537: l_api_updating := ghr_pdi_shd.api_updating(
538: p_position_description_id => p_position_description_id,
539: p_object_version_number => p_object_version_number);
540:
541: IF (l_api_updating

Line 543: ((nvl(ghr_pdi_shd.g_old_rec.position_sensitivity,hr_api.g_varchar2)

539: p_object_version_number => p_object_version_number);
540:
541: IF (l_api_updating
542: AND
543: ((nvl(ghr_pdi_shd.g_old_rec.position_sensitivity,hr_api.g_varchar2)
544: <> nvl(p_position_sensitivity,hr_api.g_varchar2))))
545: OR
546: NOT l_api_updating THEN
547:

Line 615: l_api_updating := ghr_pdi_shd.api_updating(

611: -- b) Thecomp level value has changed
612: -- c) A record is being inserted.
613: --
614:
615: l_api_updating := ghr_pdi_shd.api_updating(
616: p_position_description_id => p_position_description_id,
617: p_object_version_number => p_object_version_number);
618:
619: IF (l_api_updating

Line 621: ((nvl(ghr_pdi_shd.g_old_rec.competitive_level,hr_api.g_varchar2)

617: p_object_version_number => p_object_version_number);
618:
619: IF (l_api_updating
620: AND
621: ((nvl(ghr_pdi_shd.g_old_rec.competitive_level,hr_api.g_varchar2)
622: <> nvl(p_competitive_level,hr_api.g_varchar2))))
623: OR
624: NOT l_api_updating THEN
625:

Line 694: l_api_updating := ghr_pdi_shd.api_updating(

690: -- b) The career ladder value has changed
691: -- c) A record is being inserted.
692: --
693:
694: l_api_updating := ghr_pdi_shd.api_updating(
695: p_position_description_id => p_position_description_id,
696: p_object_version_number => p_object_version_number);
697:
698: IF (l_api_updating

Line 700: ((nvl(ghr_pdi_shd.g_old_rec.career_ladder,hr_api.g_varchar2)

696: p_object_version_number => p_object_version_number);
697:
698: IF (l_api_updating
699: AND
700: ((nvl(ghr_pdi_shd.g_old_rec.career_ladder,hr_api.g_varchar2)
701: <> nvl(p_career_ladder,hr_api.g_varchar2))))
702: OR
703: NOT l_api_updating THEN
704:

Line 768: Procedure chk_non_updateable_args(p_rec IN ghr_pdi_shd.g_rec_type)

764: --------------------------------------------------------------------
765: --
766:
767:
768: Procedure chk_non_updateable_args(p_rec IN ghr_pdi_shd.g_rec_type)
769:
770: IS
771:
772: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';

Line 788: IF not ghr_pdi_shd.api_updating

784: -- Only proceed with the validation if the row exists for
785: -- the current record in the HR schema.
786: --
787:
788: IF not ghr_pdi_shd.api_updating
789: (p_position_description_id => p_rec.position_description_id,
790: p_object_version_number => p_rec.object_version_number)
791: THEN
792:

Line 807: <> NVL(ghr_pdi_shd.g_old_rec.date_to,hr_api.g_date)

803:
804: -- To be changed in the screens to base it on the user role.
805:
806: IF NVL(p_rec.date_to, hr_api.g_date)
807: <> NVL(ghr_pdi_shd.g_old_rec.date_to,hr_api.g_date)
808: THEN
809:
810: l_argument := 'date_to';
811: RAISE l_error;

Line 817: <> NVL(ghr_pdi_shd.g_old_rec.opm_cert_num,hr_api.g_number)

813:
814: */
815:
816: IF NVL(p_rec.opm_cert_num, hr_api.g_number)
817: <> NVL(ghr_pdi_shd.g_old_rec.opm_cert_num,hr_api.g_number)
818: THEN
819:
820: l_argument := 'opm_cert_num';
821: RAISE l_error;

Line 846: Procedure insert_validate(p_rec in ghr_pdi_shd.g_rec_type) is

842:
843: -- ----------------------------------------------------------------------------
844: -- |---------------------------< insert_validate >----------------------------|
845: -- ----------------------------------------------------------------------------
846: Procedure insert_validate(p_rec in ghr_pdi_shd.g_rec_type) is
847: --
848: l_proc varchar2(72) := g_package||'insert_validate';
849: --
850: Begin

Line 934: Procedure update_validate(p_rec in ghr_pdi_shd.g_rec_type) is

930: --
931: -- ----------------------------------------------------------------------------
932: -- |---------------------------< update_validate >----------------------------|
933: -- ----------------------------------------------------------------------------
934: Procedure update_validate(p_rec in ghr_pdi_shd.g_rec_type) is
935: --
936: l_proc varchar2(72) := g_package||'update_validate';
937: --
938: Begin

Line 1014: Procedure delete_validate(p_rec in ghr_pdi_shd.g_rec_type) is

1010: --
1011: -- ----------------------------------------------------------------------------
1012: -- |---------------------------< delete_validate >----------------------------|
1013: -- ----------------------------------------------------------------------------
1014: Procedure delete_validate(p_rec in ghr_pdi_shd.g_rec_type) is
1015: --
1016: l_proc varchar2(72) := g_package||'delete_validate';
1017: --
1018: Begin