APPS.PQP_PTY_BUS dependencies on PQP_PTY_SHD

Line 49: nvl(pqp_pty_shd.g_old_rec.contribution_conversion_rule,

45: -- another not null value.
46: -- b) During insert, the type_id is not null.
47: --
48: if (((p_pension_type_id is not null) and
49: nvl(pqp_pty_shd.g_old_rec.contribution_conversion_rule,
50: hr_api.g_varchar2) <> nvl(p_contribution_conversion_rule,
51: hr_api.g_varchar2))
52: or
53: (p_pension_type_id is null)) then

Line 118: nvl(pqp_pty_shd.g_old_rec.threshold_conversion_rule,

114: -- another not null value.
115: -- b) During insert, the type_id is not null.
116: --
117: if (((p_pension_type_id is not null) and
118: nvl(pqp_pty_shd.g_old_rec.threshold_conversion_rule,
119: hr_api.g_varchar2) <> nvl(p_threshold_conversion_rule,
120: hr_api.g_varchar2))
121: or
122: (p_pension_type_id is null)) then

Line 188: nvl(pqp_pty_shd.g_old_rec.pension_category,

184: -- another not null value.
185: -- b) During insert, the type_id is not null.
186: --
187: if (((p_pension_type_id is not null) and
188: nvl(pqp_pty_shd.g_old_rec.pension_category,
189: hr_api.g_varchar2) <> nvl(p_pension_category,
190: hr_api.g_varchar2))
191: or
192: (p_pension_type_id is null)) then

Line 259: nvl(pqp_pty_shd.g_old_rec.pension_provider_type,

255: -- another not null value.
256: -- b) During insert, the type_id is not null.
257: --
258: if (((p_pension_type_id is not null) and
259: nvl(pqp_pty_shd.g_old_rec.pension_provider_type,
260: hr_api.g_varchar2) <> nvl(p_pension_provider_type,
261: hr_api.g_varchar2))
262: or
263: (p_pension_type_id is null)) then

Line 327: nvl(pqp_pty_shd.g_old_rec.salary_calculation_method,

323: -- another not null value.
324: -- b) During insert, the type_id is not null.
325: --
326: if (((p_pension_type_id is not null) and
327: nvl(pqp_pty_shd.g_old_rec.salary_calculation_method,
328: hr_api.g_varchar2) <> nvl(p_salary_calculation_method,
329: hr_api.g_varchar2))
330: or
331: (p_pension_type_id is null)) then

Line 589: nvl(pqp_pty_shd.g_old_rec.special_pension_type_code,

585: -- another not null value.
586: -- b) During insert, the type_id is not null.
587: --
588: if (((p_pension_type_id is not null) and
589: nvl(pqp_pty_shd.g_old_rec.special_pension_type_code,
590: hr_api.g_varchar2) <> nvl(p_special_pension_type_code,
591: hr_api.g_varchar2))
592: or
593: (p_pension_type_id is null)) then

Line 658: nvl(pqp_pty_shd.g_old_rec.pension_sub_category,

654: -- another not null value.
655: -- b) During insert, the type_id is not null.
656: --
657: if (((p_pension_type_id is not null) and
658: nvl(pqp_pty_shd.g_old_rec.pension_sub_category,
659: hr_api.g_varchar2) <> nvl(p_pension_sub_category,
660: hr_api.g_varchar2))
661: or
662: (p_pension_type_id is null)) then

Line 727: nvl(pqp_pty_shd.g_old_rec.pension_basis_calc_method,

723: -- another not null value.
724: -- b) During insert, the type_id is not null.
725: --
726: if (((p_pension_type_id is not null) and
727: nvl(pqp_pty_shd.g_old_rec.pension_basis_calc_method,
728: hr_api.g_varchar2) <> nvl(p_pension_basis_calc_method,
729: hr_api.g_varchar2))
730: or
731: (p_pension_type_id is null)) then

Line 796: nvl(pqp_pty_shd.g_old_rec.previous_year_bonus_included,

792: -- another not null value.
793: -- b) During insert, the type_id is not null.
794: --
795: if (((p_pension_type_id is not null) and
796: nvl(pqp_pty_shd.g_old_rec.previous_year_bonus_included,
797: hr_api.g_varchar2) <> nvl(p_previous_year_bonus_included,
798: hr_api.g_varchar2))
799: or
800: (p_pension_type_id is null)) then

Line 865: nvl(pqp_pty_shd.g_old_rec.recurring_bonus_period,

861: -- another not null value.
862: -- b) During insert, the type_id is not null.
863: --
864: if (((p_pension_type_id is not null) and
865: nvl(pqp_pty_shd.g_old_rec.recurring_bonus_period,
866: hr_api.g_varchar2) <> nvl(p_recurring_bonus_period,
867: hr_api.g_varchar2))
868: or
869: (p_pension_type_id is null)) then

Line 934: nvl(pqp_pty_shd.g_old_rec.non_recurring_bonus_period,

930: -- another not null value.
931: -- b) During insert, the type_id is not null.
932: --
933: if (((p_pension_type_id is not null) and
934: nvl(pqp_pty_shd.g_old_rec.non_recurring_bonus_period,
935: hr_api.g_varchar2) <> nvl(p_non_recurring_bonus_period,
936: hr_api.g_varchar2))
937: or
938: (p_pension_type_id is null)) then

Line 1031: nvl(pqp_pty_shd.g_old_rec.pension_salary_balance,

1027: -- another not null value.
1028: -- b) During insert, the type_id is not null.
1029: --
1030: if (((p_pension_type_id is not null) and
1031: nvl(pqp_pty_shd.g_old_rec.pension_salary_balance,
1032: hr_api.g_number) <> nvl(p_pension_salary_balance,
1033: hr_api.g_number))
1034: or
1035: (p_pension_type_id is null)) then

Line 1106: nvl(pqp_pty_shd.g_old_rec.ee_age_threshold,

1102: -- another not null value.
1103: -- b) During insert, the type_id is not null.
1104: --
1105: if (((p_pension_type_id is not null) and
1106: nvl(pqp_pty_shd.g_old_rec.ee_age_threshold,
1107: hr_api.g_varchar2) <> nvl(p_ee_age_threshold,
1108: hr_api.g_varchar2))
1109: or
1110: (p_pension_type_id is null)) then

Line 1175: nvl(pqp_pty_shd.g_old_rec.er_age_threshold,

1171: -- another not null value.
1172: -- b) During insert, the type_id is not null.
1173: --
1174: if (((p_pension_type_id is not null) and
1175: nvl(pqp_pty_shd.g_old_rec.er_age_threshold,
1176: hr_api.g_varchar2) <> nvl(p_er_age_threshold,
1177: hr_api.g_varchar2))
1178: or
1179: (p_pension_type_id is null)) then

Line 1244: nvl(pqp_pty_shd.g_old_rec.ee_age_contribution,

1240: -- another not null value.
1241: -- b) During insert, the type_id is not null.
1242: --
1243: if (((p_pension_type_id is not null) and
1244: nvl(pqp_pty_shd.g_old_rec.ee_age_contribution,
1245: hr_api.g_varchar2) <> nvl(p_ee_age_contribution,
1246: hr_api.g_varchar2))
1247: or
1248: (p_pension_type_id is null)) then

Line 1313: nvl(pqp_pty_shd.g_old_rec.er_age_contribution,

1309: -- another not null value.
1310: -- b) During insert, the type_id is not null.
1311: --
1312: if (((p_pension_type_id is not null) and
1313: nvl(pqp_pty_shd.g_old_rec.er_age_contribution,
1314: hr_api.g_varchar2) <> nvl(p_er_age_contribution,
1315: hr_api.g_varchar2))
1316: or
1317: (p_pension_type_id is null)) then

Line 1571: (p_rec in pqp_pty_shd.g_rec_type

1567: -- Internal Row Handler Use Only.
1568: --
1569: -- ----------------------------------------------------------------------------
1570: procedure chk_ddf
1571: (p_rec in pqp_pty_shd.g_rec_type
1572: ) is
1573: --
1574: l_proc varchar2(72) := g_package || 'chk_ddf';
1575: --

Line 1580: nvl(pqp_pty_shd.g_old_rec.pty_information_category, hr_api.g_varchar2) <>

1576: begin
1577: hr_utility.set_location('Entering:'||l_proc,10);
1578: --
1579: if ((p_rec.pension_type_id is not null) and (
1580: nvl(pqp_pty_shd.g_old_rec.pty_information_category, hr_api.g_varchar2) <>
1581: nvl(p_rec.pty_information_category, hr_api.g_varchar2) or
1582: nvl(pqp_pty_shd.g_old_rec.pty_information1, hr_api.g_varchar2) <>
1583: nvl(p_rec.pty_information1, hr_api.g_varchar2) or
1584: nvl(pqp_pty_shd.g_old_rec.pty_information2, hr_api.g_varchar2) <>

Line 1582: nvl(pqp_pty_shd.g_old_rec.pty_information1, hr_api.g_varchar2) <>

1578: --
1579: if ((p_rec.pension_type_id is not null) and (
1580: nvl(pqp_pty_shd.g_old_rec.pty_information_category, hr_api.g_varchar2) <>
1581: nvl(p_rec.pty_information_category, hr_api.g_varchar2) or
1582: nvl(pqp_pty_shd.g_old_rec.pty_information1, hr_api.g_varchar2) <>
1583: nvl(p_rec.pty_information1, hr_api.g_varchar2) or
1584: nvl(pqp_pty_shd.g_old_rec.pty_information2, hr_api.g_varchar2) <>
1585: nvl(p_rec.pty_information2, hr_api.g_varchar2) or
1586: nvl(pqp_pty_shd.g_old_rec.pty_information3, hr_api.g_varchar2) <>

Line 1584: nvl(pqp_pty_shd.g_old_rec.pty_information2, hr_api.g_varchar2) <>

1580: nvl(pqp_pty_shd.g_old_rec.pty_information_category, hr_api.g_varchar2) <>
1581: nvl(p_rec.pty_information_category, hr_api.g_varchar2) or
1582: nvl(pqp_pty_shd.g_old_rec.pty_information1, hr_api.g_varchar2) <>
1583: nvl(p_rec.pty_information1, hr_api.g_varchar2) or
1584: nvl(pqp_pty_shd.g_old_rec.pty_information2, hr_api.g_varchar2) <>
1585: nvl(p_rec.pty_information2, hr_api.g_varchar2) or
1586: nvl(pqp_pty_shd.g_old_rec.pty_information3, hr_api.g_varchar2) <>
1587: nvl(p_rec.pty_information3, hr_api.g_varchar2) or
1588: nvl(pqp_pty_shd.g_old_rec.pty_information4, hr_api.g_varchar2) <>

Line 1586: nvl(pqp_pty_shd.g_old_rec.pty_information3, hr_api.g_varchar2) <>

1582: nvl(pqp_pty_shd.g_old_rec.pty_information1, hr_api.g_varchar2) <>
1583: nvl(p_rec.pty_information1, hr_api.g_varchar2) or
1584: nvl(pqp_pty_shd.g_old_rec.pty_information2, hr_api.g_varchar2) <>
1585: nvl(p_rec.pty_information2, hr_api.g_varchar2) or
1586: nvl(pqp_pty_shd.g_old_rec.pty_information3, hr_api.g_varchar2) <>
1587: nvl(p_rec.pty_information3, hr_api.g_varchar2) or
1588: nvl(pqp_pty_shd.g_old_rec.pty_information4, hr_api.g_varchar2) <>
1589: nvl(p_rec.pty_information4, hr_api.g_varchar2) or
1590: nvl(pqp_pty_shd.g_old_rec.pty_information5, hr_api.g_varchar2) <>

Line 1588: nvl(pqp_pty_shd.g_old_rec.pty_information4, hr_api.g_varchar2) <>

1584: nvl(pqp_pty_shd.g_old_rec.pty_information2, hr_api.g_varchar2) <>
1585: nvl(p_rec.pty_information2, hr_api.g_varchar2) or
1586: nvl(pqp_pty_shd.g_old_rec.pty_information3, hr_api.g_varchar2) <>
1587: nvl(p_rec.pty_information3, hr_api.g_varchar2) or
1588: nvl(pqp_pty_shd.g_old_rec.pty_information4, hr_api.g_varchar2) <>
1589: nvl(p_rec.pty_information4, hr_api.g_varchar2) or
1590: nvl(pqp_pty_shd.g_old_rec.pty_information5, hr_api.g_varchar2) <>
1591: nvl(p_rec.pty_information5, hr_api.g_varchar2) or
1592: nvl(pqp_pty_shd.g_old_rec.pty_information6, hr_api.g_varchar2) <>

Line 1590: nvl(pqp_pty_shd.g_old_rec.pty_information5, hr_api.g_varchar2) <>

1586: nvl(pqp_pty_shd.g_old_rec.pty_information3, hr_api.g_varchar2) <>
1587: nvl(p_rec.pty_information3, hr_api.g_varchar2) or
1588: nvl(pqp_pty_shd.g_old_rec.pty_information4, hr_api.g_varchar2) <>
1589: nvl(p_rec.pty_information4, hr_api.g_varchar2) or
1590: nvl(pqp_pty_shd.g_old_rec.pty_information5, hr_api.g_varchar2) <>
1591: nvl(p_rec.pty_information5, hr_api.g_varchar2) or
1592: nvl(pqp_pty_shd.g_old_rec.pty_information6, hr_api.g_varchar2) <>
1593: nvl(p_rec.pty_information6, hr_api.g_varchar2) or
1594: nvl(pqp_pty_shd.g_old_rec.pty_information7, hr_api.g_varchar2) <>

Line 1592: nvl(pqp_pty_shd.g_old_rec.pty_information6, hr_api.g_varchar2) <>

1588: nvl(pqp_pty_shd.g_old_rec.pty_information4, hr_api.g_varchar2) <>
1589: nvl(p_rec.pty_information4, hr_api.g_varchar2) or
1590: nvl(pqp_pty_shd.g_old_rec.pty_information5, hr_api.g_varchar2) <>
1591: nvl(p_rec.pty_information5, hr_api.g_varchar2) or
1592: nvl(pqp_pty_shd.g_old_rec.pty_information6, hr_api.g_varchar2) <>
1593: nvl(p_rec.pty_information6, hr_api.g_varchar2) or
1594: nvl(pqp_pty_shd.g_old_rec.pty_information7, hr_api.g_varchar2) <>
1595: nvl(p_rec.pty_information7, hr_api.g_varchar2) or
1596: nvl(pqp_pty_shd.g_old_rec.pty_information8, hr_api.g_varchar2) <>

Line 1594: nvl(pqp_pty_shd.g_old_rec.pty_information7, hr_api.g_varchar2) <>

1590: nvl(pqp_pty_shd.g_old_rec.pty_information5, hr_api.g_varchar2) <>
1591: nvl(p_rec.pty_information5, hr_api.g_varchar2) or
1592: nvl(pqp_pty_shd.g_old_rec.pty_information6, hr_api.g_varchar2) <>
1593: nvl(p_rec.pty_information6, hr_api.g_varchar2) or
1594: nvl(pqp_pty_shd.g_old_rec.pty_information7, hr_api.g_varchar2) <>
1595: nvl(p_rec.pty_information7, hr_api.g_varchar2) or
1596: nvl(pqp_pty_shd.g_old_rec.pty_information8, hr_api.g_varchar2) <>
1597: nvl(p_rec.pty_information8, hr_api.g_varchar2) or
1598: nvl(pqp_pty_shd.g_old_rec.pty_information9, hr_api.g_varchar2) <>

Line 1596: nvl(pqp_pty_shd.g_old_rec.pty_information8, hr_api.g_varchar2) <>

1592: nvl(pqp_pty_shd.g_old_rec.pty_information6, hr_api.g_varchar2) <>
1593: nvl(p_rec.pty_information6, hr_api.g_varchar2) or
1594: nvl(pqp_pty_shd.g_old_rec.pty_information7, hr_api.g_varchar2) <>
1595: nvl(p_rec.pty_information7, hr_api.g_varchar2) or
1596: nvl(pqp_pty_shd.g_old_rec.pty_information8, hr_api.g_varchar2) <>
1597: nvl(p_rec.pty_information8, hr_api.g_varchar2) or
1598: nvl(pqp_pty_shd.g_old_rec.pty_information9, hr_api.g_varchar2) <>
1599: nvl(p_rec.pty_information9, hr_api.g_varchar2) or
1600: nvl(pqp_pty_shd.g_old_rec.pty_information10, hr_api.g_varchar2) <>

Line 1598: nvl(pqp_pty_shd.g_old_rec.pty_information9, hr_api.g_varchar2) <>

1594: nvl(pqp_pty_shd.g_old_rec.pty_information7, hr_api.g_varchar2) <>
1595: nvl(p_rec.pty_information7, hr_api.g_varchar2) or
1596: nvl(pqp_pty_shd.g_old_rec.pty_information8, hr_api.g_varchar2) <>
1597: nvl(p_rec.pty_information8, hr_api.g_varchar2) or
1598: nvl(pqp_pty_shd.g_old_rec.pty_information9, hr_api.g_varchar2) <>
1599: nvl(p_rec.pty_information9, hr_api.g_varchar2) or
1600: nvl(pqp_pty_shd.g_old_rec.pty_information10, hr_api.g_varchar2) <>
1601: nvl(p_rec.pty_information10, hr_api.g_varchar2) or
1602: nvl(pqp_pty_shd.g_old_rec.pty_information11, hr_api.g_varchar2) <>

Line 1600: nvl(pqp_pty_shd.g_old_rec.pty_information10, hr_api.g_varchar2) <>

1596: nvl(pqp_pty_shd.g_old_rec.pty_information8, hr_api.g_varchar2) <>
1597: nvl(p_rec.pty_information8, hr_api.g_varchar2) or
1598: nvl(pqp_pty_shd.g_old_rec.pty_information9, hr_api.g_varchar2) <>
1599: nvl(p_rec.pty_information9, hr_api.g_varchar2) or
1600: nvl(pqp_pty_shd.g_old_rec.pty_information10, hr_api.g_varchar2) <>
1601: nvl(p_rec.pty_information10, hr_api.g_varchar2) or
1602: nvl(pqp_pty_shd.g_old_rec.pty_information11, hr_api.g_varchar2) <>
1603: nvl(p_rec.pty_information11, hr_api.g_varchar2) or
1604: nvl(pqp_pty_shd.g_old_rec.pty_information12, hr_api.g_varchar2) <>

Line 1602: nvl(pqp_pty_shd.g_old_rec.pty_information11, hr_api.g_varchar2) <>

1598: nvl(pqp_pty_shd.g_old_rec.pty_information9, hr_api.g_varchar2) <>
1599: nvl(p_rec.pty_information9, hr_api.g_varchar2) or
1600: nvl(pqp_pty_shd.g_old_rec.pty_information10, hr_api.g_varchar2) <>
1601: nvl(p_rec.pty_information10, hr_api.g_varchar2) or
1602: nvl(pqp_pty_shd.g_old_rec.pty_information11, hr_api.g_varchar2) <>
1603: nvl(p_rec.pty_information11, hr_api.g_varchar2) or
1604: nvl(pqp_pty_shd.g_old_rec.pty_information12, hr_api.g_varchar2) <>
1605: nvl(p_rec.pty_information12, hr_api.g_varchar2) or
1606: nvl(pqp_pty_shd.g_old_rec.pty_information13, hr_api.g_varchar2) <>

Line 1604: nvl(pqp_pty_shd.g_old_rec.pty_information12, hr_api.g_varchar2) <>

1600: nvl(pqp_pty_shd.g_old_rec.pty_information10, hr_api.g_varchar2) <>
1601: nvl(p_rec.pty_information10, hr_api.g_varchar2) or
1602: nvl(pqp_pty_shd.g_old_rec.pty_information11, hr_api.g_varchar2) <>
1603: nvl(p_rec.pty_information11, hr_api.g_varchar2) or
1604: nvl(pqp_pty_shd.g_old_rec.pty_information12, hr_api.g_varchar2) <>
1605: nvl(p_rec.pty_information12, hr_api.g_varchar2) or
1606: nvl(pqp_pty_shd.g_old_rec.pty_information13, hr_api.g_varchar2) <>
1607: nvl(p_rec.pty_information13, hr_api.g_varchar2) or
1608: nvl(pqp_pty_shd.g_old_rec.pty_information14, hr_api.g_varchar2) <>

Line 1606: nvl(pqp_pty_shd.g_old_rec.pty_information13, hr_api.g_varchar2) <>

1602: nvl(pqp_pty_shd.g_old_rec.pty_information11, hr_api.g_varchar2) <>
1603: nvl(p_rec.pty_information11, hr_api.g_varchar2) or
1604: nvl(pqp_pty_shd.g_old_rec.pty_information12, hr_api.g_varchar2) <>
1605: nvl(p_rec.pty_information12, hr_api.g_varchar2) or
1606: nvl(pqp_pty_shd.g_old_rec.pty_information13, hr_api.g_varchar2) <>
1607: nvl(p_rec.pty_information13, hr_api.g_varchar2) or
1608: nvl(pqp_pty_shd.g_old_rec.pty_information14, hr_api.g_varchar2) <>
1609: nvl(p_rec.pty_information14, hr_api.g_varchar2) or
1610: nvl(pqp_pty_shd.g_old_rec.pty_information15, hr_api.g_varchar2) <>

Line 1608: nvl(pqp_pty_shd.g_old_rec.pty_information14, hr_api.g_varchar2) <>

1604: nvl(pqp_pty_shd.g_old_rec.pty_information12, hr_api.g_varchar2) <>
1605: nvl(p_rec.pty_information12, hr_api.g_varchar2) or
1606: nvl(pqp_pty_shd.g_old_rec.pty_information13, hr_api.g_varchar2) <>
1607: nvl(p_rec.pty_information13, hr_api.g_varchar2) or
1608: nvl(pqp_pty_shd.g_old_rec.pty_information14, hr_api.g_varchar2) <>
1609: nvl(p_rec.pty_information14, hr_api.g_varchar2) or
1610: nvl(pqp_pty_shd.g_old_rec.pty_information15, hr_api.g_varchar2) <>
1611: nvl(p_rec.pty_information15, hr_api.g_varchar2) or
1612: nvl(pqp_pty_shd.g_old_rec.pty_information16, hr_api.g_varchar2) <>

Line 1610: nvl(pqp_pty_shd.g_old_rec.pty_information15, hr_api.g_varchar2) <>

1606: nvl(pqp_pty_shd.g_old_rec.pty_information13, hr_api.g_varchar2) <>
1607: nvl(p_rec.pty_information13, hr_api.g_varchar2) or
1608: nvl(pqp_pty_shd.g_old_rec.pty_information14, hr_api.g_varchar2) <>
1609: nvl(p_rec.pty_information14, hr_api.g_varchar2) or
1610: nvl(pqp_pty_shd.g_old_rec.pty_information15, hr_api.g_varchar2) <>
1611: nvl(p_rec.pty_information15, hr_api.g_varchar2) or
1612: nvl(pqp_pty_shd.g_old_rec.pty_information16, hr_api.g_varchar2) <>
1613: nvl(p_rec.pty_information16, hr_api.g_varchar2) or
1614: nvl(pqp_pty_shd.g_old_rec.pty_information17, hr_api.g_varchar2) <>

Line 1612: nvl(pqp_pty_shd.g_old_rec.pty_information16, hr_api.g_varchar2) <>

1608: nvl(pqp_pty_shd.g_old_rec.pty_information14, hr_api.g_varchar2) <>
1609: nvl(p_rec.pty_information14, hr_api.g_varchar2) or
1610: nvl(pqp_pty_shd.g_old_rec.pty_information15, hr_api.g_varchar2) <>
1611: nvl(p_rec.pty_information15, hr_api.g_varchar2) or
1612: nvl(pqp_pty_shd.g_old_rec.pty_information16, hr_api.g_varchar2) <>
1613: nvl(p_rec.pty_information16, hr_api.g_varchar2) or
1614: nvl(pqp_pty_shd.g_old_rec.pty_information17, hr_api.g_varchar2) <>
1615: nvl(p_rec.pty_information17, hr_api.g_varchar2) or
1616: nvl(pqp_pty_shd.g_old_rec.pty_information18, hr_api.g_varchar2) <>

Line 1614: nvl(pqp_pty_shd.g_old_rec.pty_information17, hr_api.g_varchar2) <>

1610: nvl(pqp_pty_shd.g_old_rec.pty_information15, hr_api.g_varchar2) <>
1611: nvl(p_rec.pty_information15, hr_api.g_varchar2) or
1612: nvl(pqp_pty_shd.g_old_rec.pty_information16, hr_api.g_varchar2) <>
1613: nvl(p_rec.pty_information16, hr_api.g_varchar2) or
1614: nvl(pqp_pty_shd.g_old_rec.pty_information17, hr_api.g_varchar2) <>
1615: nvl(p_rec.pty_information17, hr_api.g_varchar2) or
1616: nvl(pqp_pty_shd.g_old_rec.pty_information18, hr_api.g_varchar2) <>
1617: nvl(p_rec.pty_information18, hr_api.g_varchar2) or
1618: nvl(pqp_pty_shd.g_old_rec.pty_information19, hr_api.g_varchar2) <>

Line 1616: nvl(pqp_pty_shd.g_old_rec.pty_information18, hr_api.g_varchar2) <>

1612: nvl(pqp_pty_shd.g_old_rec.pty_information16, hr_api.g_varchar2) <>
1613: nvl(p_rec.pty_information16, hr_api.g_varchar2) or
1614: nvl(pqp_pty_shd.g_old_rec.pty_information17, hr_api.g_varchar2) <>
1615: nvl(p_rec.pty_information17, hr_api.g_varchar2) or
1616: nvl(pqp_pty_shd.g_old_rec.pty_information18, hr_api.g_varchar2) <>
1617: nvl(p_rec.pty_information18, hr_api.g_varchar2) or
1618: nvl(pqp_pty_shd.g_old_rec.pty_information19, hr_api.g_varchar2) <>
1619: nvl(p_rec.pty_information19, hr_api.g_varchar2) or
1620: nvl(pqp_pty_shd.g_old_rec.pty_information20, hr_api.g_varchar2) <>

Line 1618: nvl(pqp_pty_shd.g_old_rec.pty_information19, hr_api.g_varchar2) <>

1614: nvl(pqp_pty_shd.g_old_rec.pty_information17, hr_api.g_varchar2) <>
1615: nvl(p_rec.pty_information17, hr_api.g_varchar2) or
1616: nvl(pqp_pty_shd.g_old_rec.pty_information18, hr_api.g_varchar2) <>
1617: nvl(p_rec.pty_information18, hr_api.g_varchar2) or
1618: nvl(pqp_pty_shd.g_old_rec.pty_information19, hr_api.g_varchar2) <>
1619: nvl(p_rec.pty_information19, hr_api.g_varchar2) or
1620: nvl(pqp_pty_shd.g_old_rec.pty_information20, hr_api.g_varchar2) <>
1621: nvl(p_rec.pty_information20, hr_api.g_varchar2) ))
1622: or (p_rec.pension_type_id is null) then

Line 1620: nvl(pqp_pty_shd.g_old_rec.pty_information20, hr_api.g_varchar2) <>

1616: nvl(pqp_pty_shd.g_old_rec.pty_information18, hr_api.g_varchar2) <>
1617: nvl(p_rec.pty_information18, hr_api.g_varchar2) or
1618: nvl(pqp_pty_shd.g_old_rec.pty_information19, hr_api.g_varchar2) <>
1619: nvl(p_rec.pty_information19, hr_api.g_varchar2) or
1620: nvl(pqp_pty_shd.g_old_rec.pty_information20, hr_api.g_varchar2) <>
1621: nvl(p_rec.pty_information20, hr_api.g_varchar2) ))
1622: or (p_rec.pension_type_id is null) then
1623: --
1624: -- Only execute the validation if absolutely necessary:

Line 1708: (p_rec in pqp_pty_shd.g_rec_type

1704: -- Internal Row Handler Use Only.
1705: --
1706: -- ----------------------------------------------------------------------------
1707: procedure chk_df
1708: (p_rec in pqp_pty_shd.g_rec_type
1709: ) is
1710: --
1711: l_proc varchar2(72) := g_package || 'chk_df';
1712: --

Line 1717: nvl(pqp_pty_shd.g_old_rec.pty_attribute_category, hr_api.g_varchar2) <>

1713: begin
1714: hr_utility.set_location('Entering:'||l_proc,10);
1715: --
1716: if ((p_rec.pension_type_id is not null) and (
1717: nvl(pqp_pty_shd.g_old_rec.pty_attribute_category, hr_api.g_varchar2) <>
1718: nvl(p_rec.pty_attribute_category, hr_api.g_varchar2) or
1719: nvl(pqp_pty_shd.g_old_rec.pty_attribute1, hr_api.g_varchar2) <>
1720: nvl(p_rec.pty_attribute1, hr_api.g_varchar2) or
1721: nvl(pqp_pty_shd.g_old_rec.pty_attribute2, hr_api.g_varchar2) <>

Line 1719: nvl(pqp_pty_shd.g_old_rec.pty_attribute1, hr_api.g_varchar2) <>

1715: --
1716: if ((p_rec.pension_type_id is not null) and (
1717: nvl(pqp_pty_shd.g_old_rec.pty_attribute_category, hr_api.g_varchar2) <>
1718: nvl(p_rec.pty_attribute_category, hr_api.g_varchar2) or
1719: nvl(pqp_pty_shd.g_old_rec.pty_attribute1, hr_api.g_varchar2) <>
1720: nvl(p_rec.pty_attribute1, hr_api.g_varchar2) or
1721: nvl(pqp_pty_shd.g_old_rec.pty_attribute2, hr_api.g_varchar2) <>
1722: nvl(p_rec.pty_attribute2, hr_api.g_varchar2) or
1723: nvl(pqp_pty_shd.g_old_rec.pty_attribute3, hr_api.g_varchar2) <>

Line 1721: nvl(pqp_pty_shd.g_old_rec.pty_attribute2, hr_api.g_varchar2) <>

1717: nvl(pqp_pty_shd.g_old_rec.pty_attribute_category, hr_api.g_varchar2) <>
1718: nvl(p_rec.pty_attribute_category, hr_api.g_varchar2) or
1719: nvl(pqp_pty_shd.g_old_rec.pty_attribute1, hr_api.g_varchar2) <>
1720: nvl(p_rec.pty_attribute1, hr_api.g_varchar2) or
1721: nvl(pqp_pty_shd.g_old_rec.pty_attribute2, hr_api.g_varchar2) <>
1722: nvl(p_rec.pty_attribute2, hr_api.g_varchar2) or
1723: nvl(pqp_pty_shd.g_old_rec.pty_attribute3, hr_api.g_varchar2) <>
1724: nvl(p_rec.pty_attribute3, hr_api.g_varchar2) or
1725: nvl(pqp_pty_shd.g_old_rec.pty_attribute4, hr_api.g_varchar2) <>

Line 1723: nvl(pqp_pty_shd.g_old_rec.pty_attribute3, hr_api.g_varchar2) <>

1719: nvl(pqp_pty_shd.g_old_rec.pty_attribute1, hr_api.g_varchar2) <>
1720: nvl(p_rec.pty_attribute1, hr_api.g_varchar2) or
1721: nvl(pqp_pty_shd.g_old_rec.pty_attribute2, hr_api.g_varchar2) <>
1722: nvl(p_rec.pty_attribute2, hr_api.g_varchar2) or
1723: nvl(pqp_pty_shd.g_old_rec.pty_attribute3, hr_api.g_varchar2) <>
1724: nvl(p_rec.pty_attribute3, hr_api.g_varchar2) or
1725: nvl(pqp_pty_shd.g_old_rec.pty_attribute4, hr_api.g_varchar2) <>
1726: nvl(p_rec.pty_attribute4, hr_api.g_varchar2) or
1727: nvl(pqp_pty_shd.g_old_rec.pty_attribute5, hr_api.g_varchar2) <>

Line 1725: nvl(pqp_pty_shd.g_old_rec.pty_attribute4, hr_api.g_varchar2) <>

1721: nvl(pqp_pty_shd.g_old_rec.pty_attribute2, hr_api.g_varchar2) <>
1722: nvl(p_rec.pty_attribute2, hr_api.g_varchar2) or
1723: nvl(pqp_pty_shd.g_old_rec.pty_attribute3, hr_api.g_varchar2) <>
1724: nvl(p_rec.pty_attribute3, hr_api.g_varchar2) or
1725: nvl(pqp_pty_shd.g_old_rec.pty_attribute4, hr_api.g_varchar2) <>
1726: nvl(p_rec.pty_attribute4, hr_api.g_varchar2) or
1727: nvl(pqp_pty_shd.g_old_rec.pty_attribute5, hr_api.g_varchar2) <>
1728: nvl(p_rec.pty_attribute5, hr_api.g_varchar2) or
1729: nvl(pqp_pty_shd.g_old_rec.pty_attribute6, hr_api.g_varchar2) <>

Line 1727: nvl(pqp_pty_shd.g_old_rec.pty_attribute5, hr_api.g_varchar2) <>

1723: nvl(pqp_pty_shd.g_old_rec.pty_attribute3, hr_api.g_varchar2) <>
1724: nvl(p_rec.pty_attribute3, hr_api.g_varchar2) or
1725: nvl(pqp_pty_shd.g_old_rec.pty_attribute4, hr_api.g_varchar2) <>
1726: nvl(p_rec.pty_attribute4, hr_api.g_varchar2) or
1727: nvl(pqp_pty_shd.g_old_rec.pty_attribute5, hr_api.g_varchar2) <>
1728: nvl(p_rec.pty_attribute5, hr_api.g_varchar2) or
1729: nvl(pqp_pty_shd.g_old_rec.pty_attribute6, hr_api.g_varchar2) <>
1730: nvl(p_rec.pty_attribute6, hr_api.g_varchar2) or
1731: nvl(pqp_pty_shd.g_old_rec.pty_attribute7, hr_api.g_varchar2) <>

Line 1729: nvl(pqp_pty_shd.g_old_rec.pty_attribute6, hr_api.g_varchar2) <>

1725: nvl(pqp_pty_shd.g_old_rec.pty_attribute4, hr_api.g_varchar2) <>
1726: nvl(p_rec.pty_attribute4, hr_api.g_varchar2) or
1727: nvl(pqp_pty_shd.g_old_rec.pty_attribute5, hr_api.g_varchar2) <>
1728: nvl(p_rec.pty_attribute5, hr_api.g_varchar2) or
1729: nvl(pqp_pty_shd.g_old_rec.pty_attribute6, hr_api.g_varchar2) <>
1730: nvl(p_rec.pty_attribute6, hr_api.g_varchar2) or
1731: nvl(pqp_pty_shd.g_old_rec.pty_attribute7, hr_api.g_varchar2) <>
1732: nvl(p_rec.pty_attribute7, hr_api.g_varchar2) or
1733: nvl(pqp_pty_shd.g_old_rec.pty_attribute8, hr_api.g_varchar2) <>

Line 1731: nvl(pqp_pty_shd.g_old_rec.pty_attribute7, hr_api.g_varchar2) <>

1727: nvl(pqp_pty_shd.g_old_rec.pty_attribute5, hr_api.g_varchar2) <>
1728: nvl(p_rec.pty_attribute5, hr_api.g_varchar2) or
1729: nvl(pqp_pty_shd.g_old_rec.pty_attribute6, hr_api.g_varchar2) <>
1730: nvl(p_rec.pty_attribute6, hr_api.g_varchar2) or
1731: nvl(pqp_pty_shd.g_old_rec.pty_attribute7, hr_api.g_varchar2) <>
1732: nvl(p_rec.pty_attribute7, hr_api.g_varchar2) or
1733: nvl(pqp_pty_shd.g_old_rec.pty_attribute8, hr_api.g_varchar2) <>
1734: nvl(p_rec.pty_attribute8, hr_api.g_varchar2) or
1735: nvl(pqp_pty_shd.g_old_rec.pty_attribute9, hr_api.g_varchar2) <>

Line 1733: nvl(pqp_pty_shd.g_old_rec.pty_attribute8, hr_api.g_varchar2) <>

1729: nvl(pqp_pty_shd.g_old_rec.pty_attribute6, hr_api.g_varchar2) <>
1730: nvl(p_rec.pty_attribute6, hr_api.g_varchar2) or
1731: nvl(pqp_pty_shd.g_old_rec.pty_attribute7, hr_api.g_varchar2) <>
1732: nvl(p_rec.pty_attribute7, hr_api.g_varchar2) or
1733: nvl(pqp_pty_shd.g_old_rec.pty_attribute8, hr_api.g_varchar2) <>
1734: nvl(p_rec.pty_attribute8, hr_api.g_varchar2) or
1735: nvl(pqp_pty_shd.g_old_rec.pty_attribute9, hr_api.g_varchar2) <>
1736: nvl(p_rec.pty_attribute9, hr_api.g_varchar2) or
1737: nvl(pqp_pty_shd.g_old_rec.pty_attribute10, hr_api.g_varchar2) <>

Line 1735: nvl(pqp_pty_shd.g_old_rec.pty_attribute9, hr_api.g_varchar2) <>

1731: nvl(pqp_pty_shd.g_old_rec.pty_attribute7, hr_api.g_varchar2) <>
1732: nvl(p_rec.pty_attribute7, hr_api.g_varchar2) or
1733: nvl(pqp_pty_shd.g_old_rec.pty_attribute8, hr_api.g_varchar2) <>
1734: nvl(p_rec.pty_attribute8, hr_api.g_varchar2) or
1735: nvl(pqp_pty_shd.g_old_rec.pty_attribute9, hr_api.g_varchar2) <>
1736: nvl(p_rec.pty_attribute9, hr_api.g_varchar2) or
1737: nvl(pqp_pty_shd.g_old_rec.pty_attribute10, hr_api.g_varchar2) <>
1738: nvl(p_rec.pty_attribute10, hr_api.g_varchar2) or
1739: nvl(pqp_pty_shd.g_old_rec.pty_attribute11, hr_api.g_varchar2) <>

Line 1737: nvl(pqp_pty_shd.g_old_rec.pty_attribute10, hr_api.g_varchar2) <>

1733: nvl(pqp_pty_shd.g_old_rec.pty_attribute8, hr_api.g_varchar2) <>
1734: nvl(p_rec.pty_attribute8, hr_api.g_varchar2) or
1735: nvl(pqp_pty_shd.g_old_rec.pty_attribute9, hr_api.g_varchar2) <>
1736: nvl(p_rec.pty_attribute9, hr_api.g_varchar2) or
1737: nvl(pqp_pty_shd.g_old_rec.pty_attribute10, hr_api.g_varchar2) <>
1738: nvl(p_rec.pty_attribute10, hr_api.g_varchar2) or
1739: nvl(pqp_pty_shd.g_old_rec.pty_attribute11, hr_api.g_varchar2) <>
1740: nvl(p_rec.pty_attribute11, hr_api.g_varchar2) or
1741: nvl(pqp_pty_shd.g_old_rec.pty_attribute12, hr_api.g_varchar2) <>

Line 1739: nvl(pqp_pty_shd.g_old_rec.pty_attribute11, hr_api.g_varchar2) <>

1735: nvl(pqp_pty_shd.g_old_rec.pty_attribute9, hr_api.g_varchar2) <>
1736: nvl(p_rec.pty_attribute9, hr_api.g_varchar2) or
1737: nvl(pqp_pty_shd.g_old_rec.pty_attribute10, hr_api.g_varchar2) <>
1738: nvl(p_rec.pty_attribute10, hr_api.g_varchar2) or
1739: nvl(pqp_pty_shd.g_old_rec.pty_attribute11, hr_api.g_varchar2) <>
1740: nvl(p_rec.pty_attribute11, hr_api.g_varchar2) or
1741: nvl(pqp_pty_shd.g_old_rec.pty_attribute12, hr_api.g_varchar2) <>
1742: nvl(p_rec.pty_attribute12, hr_api.g_varchar2) or
1743: nvl(pqp_pty_shd.g_old_rec.pty_attribute13, hr_api.g_varchar2) <>

Line 1741: nvl(pqp_pty_shd.g_old_rec.pty_attribute12, hr_api.g_varchar2) <>

1737: nvl(pqp_pty_shd.g_old_rec.pty_attribute10, hr_api.g_varchar2) <>
1738: nvl(p_rec.pty_attribute10, hr_api.g_varchar2) or
1739: nvl(pqp_pty_shd.g_old_rec.pty_attribute11, hr_api.g_varchar2) <>
1740: nvl(p_rec.pty_attribute11, hr_api.g_varchar2) or
1741: nvl(pqp_pty_shd.g_old_rec.pty_attribute12, hr_api.g_varchar2) <>
1742: nvl(p_rec.pty_attribute12, hr_api.g_varchar2) or
1743: nvl(pqp_pty_shd.g_old_rec.pty_attribute13, hr_api.g_varchar2) <>
1744: nvl(p_rec.pty_attribute13, hr_api.g_varchar2) or
1745: nvl(pqp_pty_shd.g_old_rec.pty_attribute14, hr_api.g_varchar2) <>

Line 1743: nvl(pqp_pty_shd.g_old_rec.pty_attribute13, hr_api.g_varchar2) <>

1739: nvl(pqp_pty_shd.g_old_rec.pty_attribute11, hr_api.g_varchar2) <>
1740: nvl(p_rec.pty_attribute11, hr_api.g_varchar2) or
1741: nvl(pqp_pty_shd.g_old_rec.pty_attribute12, hr_api.g_varchar2) <>
1742: nvl(p_rec.pty_attribute12, hr_api.g_varchar2) or
1743: nvl(pqp_pty_shd.g_old_rec.pty_attribute13, hr_api.g_varchar2) <>
1744: nvl(p_rec.pty_attribute13, hr_api.g_varchar2) or
1745: nvl(pqp_pty_shd.g_old_rec.pty_attribute14, hr_api.g_varchar2) <>
1746: nvl(p_rec.pty_attribute14, hr_api.g_varchar2) or
1747: nvl(pqp_pty_shd.g_old_rec.pty_attribute15, hr_api.g_varchar2) <>

Line 1745: nvl(pqp_pty_shd.g_old_rec.pty_attribute14, hr_api.g_varchar2) <>

1741: nvl(pqp_pty_shd.g_old_rec.pty_attribute12, hr_api.g_varchar2) <>
1742: nvl(p_rec.pty_attribute12, hr_api.g_varchar2) or
1743: nvl(pqp_pty_shd.g_old_rec.pty_attribute13, hr_api.g_varchar2) <>
1744: nvl(p_rec.pty_attribute13, hr_api.g_varchar2) or
1745: nvl(pqp_pty_shd.g_old_rec.pty_attribute14, hr_api.g_varchar2) <>
1746: nvl(p_rec.pty_attribute14, hr_api.g_varchar2) or
1747: nvl(pqp_pty_shd.g_old_rec.pty_attribute15, hr_api.g_varchar2) <>
1748: nvl(p_rec.pty_attribute15, hr_api.g_varchar2) or
1749: nvl(pqp_pty_shd.g_old_rec.pty_attribute16, hr_api.g_varchar2) <>

Line 1747: nvl(pqp_pty_shd.g_old_rec.pty_attribute15, hr_api.g_varchar2) <>

1743: nvl(pqp_pty_shd.g_old_rec.pty_attribute13, hr_api.g_varchar2) <>
1744: nvl(p_rec.pty_attribute13, hr_api.g_varchar2) or
1745: nvl(pqp_pty_shd.g_old_rec.pty_attribute14, hr_api.g_varchar2) <>
1746: nvl(p_rec.pty_attribute14, hr_api.g_varchar2) or
1747: nvl(pqp_pty_shd.g_old_rec.pty_attribute15, hr_api.g_varchar2) <>
1748: nvl(p_rec.pty_attribute15, hr_api.g_varchar2) or
1749: nvl(pqp_pty_shd.g_old_rec.pty_attribute16, hr_api.g_varchar2) <>
1750: nvl(p_rec.pty_attribute16, hr_api.g_varchar2) or
1751: nvl(pqp_pty_shd.g_old_rec.pty_attribute17, hr_api.g_varchar2) <>

Line 1749: nvl(pqp_pty_shd.g_old_rec.pty_attribute16, hr_api.g_varchar2) <>

1745: nvl(pqp_pty_shd.g_old_rec.pty_attribute14, hr_api.g_varchar2) <>
1746: nvl(p_rec.pty_attribute14, hr_api.g_varchar2) or
1747: nvl(pqp_pty_shd.g_old_rec.pty_attribute15, hr_api.g_varchar2) <>
1748: nvl(p_rec.pty_attribute15, hr_api.g_varchar2) or
1749: nvl(pqp_pty_shd.g_old_rec.pty_attribute16, hr_api.g_varchar2) <>
1750: nvl(p_rec.pty_attribute16, hr_api.g_varchar2) or
1751: nvl(pqp_pty_shd.g_old_rec.pty_attribute17, hr_api.g_varchar2) <>
1752: nvl(p_rec.pty_attribute17, hr_api.g_varchar2) or
1753: nvl(pqp_pty_shd.g_old_rec.pty_attribute18, hr_api.g_varchar2) <>

Line 1751: nvl(pqp_pty_shd.g_old_rec.pty_attribute17, hr_api.g_varchar2) <>

1747: nvl(pqp_pty_shd.g_old_rec.pty_attribute15, hr_api.g_varchar2) <>
1748: nvl(p_rec.pty_attribute15, hr_api.g_varchar2) or
1749: nvl(pqp_pty_shd.g_old_rec.pty_attribute16, hr_api.g_varchar2) <>
1750: nvl(p_rec.pty_attribute16, hr_api.g_varchar2) or
1751: nvl(pqp_pty_shd.g_old_rec.pty_attribute17, hr_api.g_varchar2) <>
1752: nvl(p_rec.pty_attribute17, hr_api.g_varchar2) or
1753: nvl(pqp_pty_shd.g_old_rec.pty_attribute18, hr_api.g_varchar2) <>
1754: nvl(p_rec.pty_attribute18, hr_api.g_varchar2) or
1755: nvl(pqp_pty_shd.g_old_rec.pty_attribute19, hr_api.g_varchar2) <>

Line 1753: nvl(pqp_pty_shd.g_old_rec.pty_attribute18, hr_api.g_varchar2) <>

1749: nvl(pqp_pty_shd.g_old_rec.pty_attribute16, hr_api.g_varchar2) <>
1750: nvl(p_rec.pty_attribute16, hr_api.g_varchar2) or
1751: nvl(pqp_pty_shd.g_old_rec.pty_attribute17, hr_api.g_varchar2) <>
1752: nvl(p_rec.pty_attribute17, hr_api.g_varchar2) or
1753: nvl(pqp_pty_shd.g_old_rec.pty_attribute18, hr_api.g_varchar2) <>
1754: nvl(p_rec.pty_attribute18, hr_api.g_varchar2) or
1755: nvl(pqp_pty_shd.g_old_rec.pty_attribute19, hr_api.g_varchar2) <>
1756: nvl(p_rec.pty_attribute19, hr_api.g_varchar2) or
1757: nvl(pqp_pty_shd.g_old_rec.pty_attribute20, hr_api.g_varchar2) <>

Line 1755: nvl(pqp_pty_shd.g_old_rec.pty_attribute19, hr_api.g_varchar2) <>

1751: nvl(pqp_pty_shd.g_old_rec.pty_attribute17, hr_api.g_varchar2) <>
1752: nvl(p_rec.pty_attribute17, hr_api.g_varchar2) or
1753: nvl(pqp_pty_shd.g_old_rec.pty_attribute18, hr_api.g_varchar2) <>
1754: nvl(p_rec.pty_attribute18, hr_api.g_varchar2) or
1755: nvl(pqp_pty_shd.g_old_rec.pty_attribute19, hr_api.g_varchar2) <>
1756: nvl(p_rec.pty_attribute19, hr_api.g_varchar2) or
1757: nvl(pqp_pty_shd.g_old_rec.pty_attribute20, hr_api.g_varchar2) <>
1758: nvl(p_rec.pty_attribute20, hr_api.g_varchar2) ))
1759: or (p_rec.pension_type_id is null) then

Line 1757: nvl(pqp_pty_shd.g_old_rec.pty_attribute20, hr_api.g_varchar2) <>

1753: nvl(pqp_pty_shd.g_old_rec.pty_attribute18, hr_api.g_varchar2) <>
1754: nvl(p_rec.pty_attribute18, hr_api.g_varchar2) or
1755: nvl(pqp_pty_shd.g_old_rec.pty_attribute19, hr_api.g_varchar2) <>
1756: nvl(p_rec.pty_attribute19, hr_api.g_varchar2) or
1757: nvl(pqp_pty_shd.g_old_rec.pty_attribute20, hr_api.g_varchar2) <>
1758: nvl(p_rec.pty_attribute20, hr_api.g_varchar2) ))
1759: or (p_rec.pension_type_id is null) then
1760: --
1761: -- Only execute the validation if absolutely necessary:

Line 1845: ,p_rec in pqp_pty_shd.g_rec_type

1841: -- {End Of Comments}
1842: -- ----------------------------------------------------------------------------
1843: Procedure chk_non_updateable_args
1844: (p_effective_date in date
1845: ,p_rec in pqp_pty_shd.g_rec_type
1846: ) IS
1847: --
1848: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
1849: --

Line 1855: IF NOT pqp_pty_shd.api_updating

1851: --
1852: -- Only proceed with the validation if a row exists for the current
1853: -- record in the HR Schema.
1854: --
1855: IF NOT pqp_pty_shd.api_updating
1856: (p_pension_type_id => p_rec.pension_type_id
1857: ,p_effective_date => p_effective_date
1858: ,p_object_version_number => p_rec.object_version_number
1859: ) THEN

Line 2123: (p_rec in pqp_pty_shd.g_rec_type

2119: -- ----------------------------------------------------------------------------
2120: -- |---------------------------< insert_validate >----------------------------|
2121: -- ----------------------------------------------------------------------------
2122: Procedure insert_validate
2123: (p_rec in pqp_pty_shd.g_rec_type
2124: ,p_effective_date in date
2125: ,p_datetrack_mode in varchar2
2126: ,p_validation_start_date in date
2127: ,p_validation_end_date in out nocopy date

Line 2151: ,p_associated_column1 => pqp_pty_shd.g_tab_nam

2147: -- Validate Important Attributes
2148: --
2149: hr_api.validate_bus_grp_id
2150: (p_business_group_id => p_rec.business_group_id
2151: ,p_associated_column1 => pqp_pty_shd.g_tab_nam
2152: || '.BUSINESS_GROUP_ID');
2153: --
2154: -- after validating the set of important attributes,
2155: -- if Multiple Message Detection is enabled and at least

Line 2416: (p_rec in pqp_pty_shd.g_rec_type

2412: -- ----------------------------------------------------------------------------
2413: -- |---------------------------< update_validate >----------------------------|
2414: -- ----------------------------------------------------------------------------
2415: Procedure update_validate
2416: (p_rec in pqp_pty_shd.g_rec_type
2417: ,p_effective_date in date
2418: ,p_datetrack_mode in varchar2
2419: ,p_validation_start_date in date
2420: ,p_validation_end_date in out nocopy date

Line 2443: ,p_associated_column1 => pqp_pty_shd.g_tab_nam

2439: -- Validate Important Attributes
2440: --
2441: hr_api.validate_bus_grp_id
2442: (p_business_group_id => p_rec.business_group_id
2443: ,p_associated_column1 => pqp_pty_shd.g_tab_nam
2444: || '.BUSINESS_GROUP_ID');
2445: --
2446: -- After validating the set of important attributes,
2447: -- if Multiple Message Detection is enabled and at least

Line 2671: (p_rec in pqp_pty_shd.g_rec_type

2667: -- ----------------------------------------------------------------------------
2668: -- |---------------------------< delete_validate >----------------------------|
2669: -- ----------------------------------------------------------------------------
2670: Procedure delete_validate
2671: (p_rec in pqp_pty_shd.g_rec_type
2672: ,p_effective_date in date
2673: ,p_datetrack_mode in varchar2
2674: ,p_validation_start_date in date
2675: ,p_validation_end_date in date

Line 2763: ,pqp_pty_shd.g_old_rec.business_group_id

2759: hr_utility.set_location('Entering:'||l_proc, 5);
2760: --
2761: --
2762: chk_startup_action(false
2763: ,pqp_pty_shd.g_old_rec.business_group_id
2764: ,pqp_pty_shd.g_old_rec.legislation_code
2765: );
2766: IF hr_startup_data_api_support.g_startup_mode
2767: NOT IN ('GENERIC','STARTUP') THEN

Line 2764: ,pqp_pty_shd.g_old_rec.legislation_code

2760: --
2761: --
2762: chk_startup_action(false
2763: ,pqp_pty_shd.g_old_rec.business_group_id
2764: ,pqp_pty_shd.g_old_rec.legislation_code
2765: );
2766: IF hr_startup_data_api_support.g_startup_mode
2767: NOT IN ('GENERIC','STARTUP') THEN
2768: --