APPS.PER_PCE_BUS dependencies on PER_CAGR_ENTITLEMENTS

Line 34: ,p_collective_agreement_id IN per_cagr_entitlements.collective_agreement_ID%TYPE

30: -- {End Of Comments}
31: -- ---------------------------------------------------------------------------
32: PROCEDURE set_security_group_id
33: (p_cagr_entitlement_id IN NUMBER
34: ,p_collective_agreement_id IN per_cagr_entitlements.collective_agreement_ID%TYPE
35: );
36: --
37: --
38: -- ---------------------------------------------------------------------------

Line 67: ,p_collective_agreement_id IN per_cagr_entitlements.collective_agreement_ID%TYPE

63: -- {End Of Comments}
64: -- ---------------------------------------------------------------------------
65: FUNCTION return_legislation_code
66: (p_cagr_entitlement_id IN NUMBER
67: ,p_collective_agreement_id IN per_cagr_entitlements.collective_agreement_ID%TYPE
68: )
69: RETURN VARCHAR2 ;
70: --
71: --

Line 207: (p_cagr_entitlement_id IN per_cagr_entitlements.cagr_entitlement_id%TYPE

203: -- {End Of Comments}
204: -- ----------------------------------------------------------------------------
205: --
206: PROCEDURE chk_start_date
207: (p_cagr_entitlement_id IN per_cagr_entitlements.cagr_entitlement_id%TYPE
208: ,p_start_date IN per_cagr_entitlements.start_date%TYPE
209: ,p_end_date IN per_cagr_entitlements.end_date%TYPE
210: ,p_collective_Agreement_id IN per_cagr_entitlements.collective_agreement_id%TYPE
211: );

Line 208: ,p_start_date IN per_cagr_entitlements.start_date%TYPE

204: -- ----------------------------------------------------------------------------
205: --
206: PROCEDURE chk_start_date
207: (p_cagr_entitlement_id IN per_cagr_entitlements.cagr_entitlement_id%TYPE
208: ,p_start_date IN per_cagr_entitlements.start_date%TYPE
209: ,p_end_date IN per_cagr_entitlements.end_date%TYPE
210: ,p_collective_Agreement_id IN per_cagr_entitlements.collective_agreement_id%TYPE
211: );
212: --

Line 209: ,p_end_date IN per_cagr_entitlements.end_date%TYPE

205: --
206: PROCEDURE chk_start_date
207: (p_cagr_entitlement_id IN per_cagr_entitlements.cagr_entitlement_id%TYPE
208: ,p_start_date IN per_cagr_entitlements.start_date%TYPE
209: ,p_end_date IN per_cagr_entitlements.end_date%TYPE
210: ,p_collective_Agreement_id IN per_cagr_entitlements.collective_agreement_id%TYPE
211: );
212: --
213: -- ----------------------------------------------------------------------------

Line 210: ,p_collective_Agreement_id IN per_cagr_entitlements.collective_agreement_id%TYPE

206: PROCEDURE chk_start_date
207: (p_cagr_entitlement_id IN per_cagr_entitlements.cagr_entitlement_id%TYPE
208: ,p_start_date IN per_cagr_entitlements.start_date%TYPE
209: ,p_end_date IN per_cagr_entitlements.end_date%TYPE
210: ,p_collective_Agreement_id IN per_cagr_entitlements.collective_agreement_id%TYPE
211: );
212: --
213: -- ----------------------------------------------------------------------------
214: -- |-----------------------------< chk_end_date >-----------------------------|

Line 242: (p_cagr_entitlement_id IN per_cagr_entitlements.cagr_entitlement_id%TYPE

238: --
239: -- {End Of Comments}
240: -- ----------------------------------------------------------------------------
241: PROCEDURE chk_end_date
242: (p_cagr_entitlement_id IN per_cagr_entitlements.cagr_entitlement_id%TYPE
243: ,p_start_date IN per_cagr_entitlements.start_date%TYPE
244: ,p_end_date IN per_cagr_entitlements.end_date%TYPE
245: ,p_effective_date IN DATE
246: );

Line 243: ,p_start_date IN per_cagr_entitlements.start_date%TYPE

239: -- {End Of Comments}
240: -- ----------------------------------------------------------------------------
241: PROCEDURE chk_end_date
242: (p_cagr_entitlement_id IN per_cagr_entitlements.cagr_entitlement_id%TYPE
243: ,p_start_date IN per_cagr_entitlements.start_date%TYPE
244: ,p_end_date IN per_cagr_entitlements.end_date%TYPE
245: ,p_effective_date IN DATE
246: );
247: END per_pce_bus;

Line 244: ,p_end_date IN per_cagr_entitlements.end_date%TYPE

240: -- ----------------------------------------------------------------------------
241: PROCEDURE chk_end_date
242: (p_cagr_entitlement_id IN per_cagr_entitlements.cagr_entitlement_id%TYPE
243: ,p_start_date IN per_cagr_entitlements.start_date%TYPE
244: ,p_end_date IN per_cagr_entitlements.end_date%TYPE
245: ,p_effective_date IN DATE
246: );
247: END per_pce_bus;