DBA Data[Home] [Help]

APPS.HXC_TK_GRP_QUERY_CRITERIA_API dependencies on HXC_PREF_HIERARCHIES

Line 866: l_recurring_period_id hxc_pref_hierarchies.attribute1%TYPE;

862: RETURN varchar2 IS
863:
864: l_tc_period hxc_recurring_periods.name%TYPE;
865: l_pref_tab hxc_preference_evaluation.t_pref_table;
866: l_recurring_period_id hxc_pref_hierarchies.attribute1%TYPE;
867:
868: l_session_date DATE;
869:
870: CURSOR csr_get_tc_period ( p_rp_id VARCHAR2 ) IS

Line 937: l_recurring_period_id hxc_pref_hierarchies.attribute1%TYPE;

933: FUNCTION check_audit_enabled ( p_resource_id number )
934: RETURN VARCHAR2 IS
935:
936: l_pref_tab hxc_preference_evaluation.t_pref_table;
937: l_recurring_period_id hxc_pref_hierarchies.attribute1%TYPE;
938: l_session_date DATE;
939:
940: l_audit VARCHAR2(150);
941:

Line 989: l_recurring_period_id hxc_pref_hierarchies.attribute1%TYPE;

985: , p_period_type varchar2
986: , p_duration_in_days number )
987: RETURN BOOLEAN IS
988:
989: l_recurring_period_id hxc_pref_hierarchies.attribute1%TYPE;
990:
991: l_tc_period_ok BOOLEAN := FALSE;
992:
993: CURSOR csr_get_tc_period_type ( p_rp_id VARCHAR2 ) IS