DBA Data[Home] [Help]

APPS.PAY_ETP_BUS_ND dependencies on STANDARD

Line 1760: -- |-----------------------< chk_standard_link_flag >-------------------------|

1756: hr_utility.set_location('Leaving:'||l_proc, 10);
1757: End;
1758: --
1759: -- ----------------------------------------------------------------------------
1760: -- |-----------------------< chk_standard_link_flag >-------------------------|
1761: -- ----------------------------------------------------------------------------
1762: -- {Start Of Comments}
1763: --
1764: -- Description:

Line 1767: -- a) Standard_link_flag cannot be 'Y' when the Processing_type is 'N'

1763: --
1764: -- Description:
1765: -- This procedure is used to validate the following business rules:
1766: --
1767: -- a) Standard_link_flag cannot be 'Y' when the Processing_type is 'N'
1768: -- or Multiple_entries_allowed_flag is 'Y'.
1769: --
1770: -- Prerequisites:
1771: -- This procedure is called from insert_validate and update_validate.

Line 1774: -- p_standard_link_flag

1770: -- Prerequisites:
1771: -- This procedure is called from insert_validate and update_validate.
1772: --
1773: -- In Parameters:
1774: -- p_standard_link_flag
1775: -- p_processing_type
1776: -- p_multiple_entries_allowed_flg
1777: --
1778: -- Post Success:

Line 1789: Procedure chk_standard_link_flag

1785: -- Internal Row Handler Use Only.
1786: --
1787: -- {End Of Comments}
1788: -- ----------------------------------------------------------------------------
1789: Procedure chk_standard_link_flag
1790: (p_effective_date in date
1791: ,p_standard_link_flag in varchar2
1792: ,p_processing_type in varchar2
1793: ,p_multiple_entries_allowed_flg in varchar2

Line 1791: ,p_standard_link_flag in varchar2

1787: -- {End Of Comments}
1788: -- ----------------------------------------------------------------------------
1789: Procedure chk_standard_link_flag
1790: (p_effective_date in date
1791: ,p_standard_link_flag in varchar2
1792: ,p_processing_type in varchar2
1793: ,p_multiple_entries_allowed_flg in varchar2
1794: ) is
1795: --

Line 1796: l_proc varchar2(72) := g_package||'chk_standard_link';

1792: ,p_processing_type in varchar2
1793: ,p_multiple_entries_allowed_flg in varchar2
1794: ) is
1795: --
1796: l_proc varchar2(72) := g_package||'chk_standard_link';
1797: --
1798: Begin
1799: hr_utility.set_location('Entering:'||l_proc, 5);
1800: --

Line 1804: ,p_standard_link_flag) Then

1800: --
1801: If hr_api.not_exists_in_hr_lookups
1802: (p_effective_date
1803: ,'YES_NO'
1804: ,p_standard_link_flag) Then
1805: --
1806: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1807: fnd_message.set_token('COLUMN','STANDARD_LINK_FLAG');
1808: fnd_message.set_token('LOOKUP_TYPE','YES_NO');

Line 1807: fnd_message.set_token('COLUMN','STANDARD_LINK_FLAG');

1803: ,'YES_NO'
1804: ,p_standard_link_flag) Then
1805: --
1806: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1807: fnd_message.set_token('COLUMN','STANDARD_LINK_FLAG');
1808: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1809: fnd_message.raise_error;
1810: --
1811: End If;

Line 1813: If (p_standard_link_flag = 'Y' and p_processing_type = 'N') Then

1809: fnd_message.raise_error;
1810: --
1811: End If;
1812: --
1813: If (p_standard_link_flag = 'Y' and p_processing_type = 'N') Then
1814: --
1815: fnd_message.set_name('PAY','PAY_6140_ELEMENT_NO_STANDARD');
1816: fnd_message.raise_error;
1817: --

Line 1815: fnd_message.set_name('PAY','PAY_6140_ELEMENT_NO_STANDARD');

1811: End If;
1812: --
1813: If (p_standard_link_flag = 'Y' and p_processing_type = 'N') Then
1814: --
1815: fnd_message.set_name('PAY','PAY_6140_ELEMENT_NO_STANDARD');
1816: fnd_message.raise_error;
1817: --
1818: End If;
1819: If (p_standard_link_flag = 'Y' and p_multiple_entries_allowed_flg = 'Y') Then

Line 1819: If (p_standard_link_flag = 'Y' and p_multiple_entries_allowed_flg = 'Y') Then

1815: fnd_message.set_name('PAY','PAY_6140_ELEMENT_NO_STANDARD');
1816: fnd_message.raise_error;
1817: --
1818: End If;
1819: If (p_standard_link_flag = 'Y' and p_multiple_entries_allowed_flg = 'Y') Then
1820: --
1821: fnd_message.set_name('PAY','HR_6952_PAY_ELE_NO_STD_MULTI');
1822: fnd_message.raise_error;
1823: --

Line 2350: -- a) Indirect_Only_Flag, Additional_Entry_Allowed_Flag, Standard_Link_Flag,

2346: --
2347: -- Description:
2348: -- This procedure is used to validate the following business rules:
2349: --
2350: -- a) Indirect_Only_Flag, Additional_Entry_Allowed_Flag, Standard_Link_Flag,
2351: -- Adjustment_Only_Flag, Post_Termination_Rule, Process_In_Run_Flag and
2352: -- Once_Each_Period_Flag can only be updated if:
2353: --
2354: -- i. There are no element links for the element.

Line 2375: -- p_Standard_Link_Flag

2371: -- In Parameters:
2372: -- p_element_type_id
2373: -- p_Indirect_Only_Flag
2374: -- p_Additional_Entry_Allowed_Flg
2375: -- p_Standard_Link_Flag
2376: -- p_Adjustment_Only_Flag
2377: -- p_Post_Termination_Rule
2378: -- p_Process_In_Run_Flag
2379: -- p_validation_start_date

Line 2398: ,p_standard_link_flag in varchar2

2394: Procedure chk_update_allowed
2395: (p_element_type_id in number
2396: ,p_indirect_only_flag in varchar2
2397: ,p_additional_entry_allowed_flg in varchar2
2398: ,p_standard_link_flag in varchar2
2399: ,p_adjustment_only_flag in varchar2
2400: ,p_post_termination_rule in varchar2
2401: ,p_process_in_run_flag in varchar2
2402: ,p_validation_start_date in date

Line 2421: (p_standard_link_flag <> pay_etp_shd_nd.g_old_rec.standard_link_flag)

2417: or
2418: (p_additional_entry_allowed_flg <>
2419: pay_etp_shd_nd.g_old_rec.additional_entry_allowed_flag)
2420: or
2421: (p_standard_link_flag <> pay_etp_shd_nd.g_old_rec.standard_link_flag)
2422: or
2423: (p_adjustment_only_flag <> pay_etp_shd_nd.g_old_rec.adjustment_only_flag)
2424: or
2425: (p_post_termination_rule <> pay_etp_shd_nd.g_old_rec.post_termination_rule)

Line 2847: chk_standard_link_flag

2843: (p_effective_date
2844: ,p_rec.processing_type
2845: ,p_rec.benefit_classification_id);
2846: --
2847: chk_standard_link_flag
2848: (p_effective_date
2849: ,p_rec.standard_link_flag
2850: ,p_rec.processing_type
2851: ,p_rec.multiple_entries_allowed_flag);

Line 2849: ,p_rec.standard_link_flag

2845: ,p_rec.benefit_classification_id);
2846: --
2847: chk_standard_link_flag
2848: (p_effective_date
2849: ,p_rec.standard_link_flag
2850: ,p_rec.processing_type
2851: ,p_rec.multiple_entries_allowed_flag);
2852: --
2853: chk_qualifying_factors

Line 3011: chk_standard_link_flag

3007: (p_effective_date
3008: ,p_rec.processing_type
3009: ,p_rec.benefit_classification_id);
3010: --
3011: chk_standard_link_flag
3012: (p_effective_date
3013: ,p_rec.standard_link_flag
3014: ,p_rec.processing_type
3015: ,p_rec.multiple_entries_allowed_flag);

Line 3013: ,p_rec.standard_link_flag

3009: ,p_rec.benefit_classification_id);
3010: --
3011: chk_standard_link_flag
3012: (p_effective_date
3013: ,p_rec.standard_link_flag
3014: ,p_rec.processing_type
3015: ,p_rec.multiple_entries_allowed_flag);
3016: --
3017: chk_qualifying_factors

Line 3060: ,p_rec.standard_link_flag

3056: chk_update_allowed
3057: (p_rec.element_type_id
3058: ,p_rec.indirect_only_flag
3059: ,p_rec.additional_entry_allowed_flag
3060: ,p_rec.standard_link_flag
3061: ,p_rec.adjustment_only_flag
3062: ,p_rec.post_termination_rule
3063: ,p_rec.process_in_run_flag
3064: ,p_validation_start_date