APPS.HXC_TK_GRP_QUERY_CRITERIA_API dependencies on HXC_PREFERENCE_EVALUATION

Line 865: l_pref_tab hxc_preference_evaluation.t_pref_table;

861: FUNCTION get_tc_period ( p_resource_id number )
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:

Line 887: hxc_preference_evaluation.resource_preferences(

883:
884: -- decided not to get the pref for all time
885: -- get preference as of session date
886:
887: hxc_preference_evaluation.resource_preferences(
888: p_resource_id => p_resource_id
889: , p_start_evaluation_date => hr_general.start_of_time
890: , p_end_evaluation_date => hr_general.end_of_time
891: , p_pref_table => l_pref_tab );

Line 899: hxc_preference_evaluation.resource_preferences(

895: FETCH csr_get_effective_date INTO l_session_date;
896: CLOSE csr_get_effective_date;
897:
898: l_recurring_period_id :=
899: hxc_preference_evaluation.resource_preferences(
900: p_resource_id => p_resource_id
901: , p_pref_code => 'TC_W_TCRD_PERIOD'
902: , p_attribute_n => 1
903: , p_evaluation_date => l_session_date );

Line 936: l_pref_tab hxc_preference_evaluation.t_pref_table;

932:
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);

Line 954: IF (hxc_preference_evaluation.resource_preferences(

950: FETCH csr_get_effective_date INTO l_session_date;
951: CLOSE csr_get_effective_date;
952:
953:
954: IF (hxc_preference_evaluation.resource_preferences(
955: p_resource_id => p_resource_id
956: , p_pref_code => 'TS_PER_AUDIT_REQUIREMENTS'
957: , p_attribute_n => 1
958: , p_evaluation_date => l_session_date )IS NOT NULL) THEN

Line 1005: hxc_preference_evaluation.resource_preferences(

1001:
1002: BEGIN
1003:
1004: l_recurring_period_id :=
1005: hxc_preference_evaluation.resource_preferences(
1006: p_resource_id => p_resource_id
1007: , p_pref_code => 'TC_W_TCRD_PERIOD'
1008: , p_attribute_n => 1 );
1009: