APPS.HXC_RTR_UPLOAD_PKG dependencies on HXC_RETRIEVAL_RULE_COMPS

Line 78: l_retrieval_rule_comp_id hxc_retrieval_rule_comps.retrieval_rule_comp_id%TYPE;

74: , p_status VARCHAR2
75: , p_owner VARCHAR2
76: , p_custom_mode VARCHAR2 ) IS
77:
78: l_retrieval_rule_comp_id hxc_retrieval_rule_comps.retrieval_rule_comp_id%TYPE;
79: l_retrieval_rule_id hxc_retrieval_rules.retrieval_rule_id%TYPE;
80: l_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE;
81: l_ovn hxc_retrieval_rules.object_version_number%TYPE := NULL;
82: l_owner VARCHAR2(6);

Line 114: FROM hxc_retrieval_rule_comps rtc

110: , DECODE( NVL(rtc.last_updated_by,-1), 1, 'SEED', 'CUSTOM')
111: INTO l_retrieval_rule_comp_id
112: , l_ovn
113: , l_owner
114: FROM hxc_retrieval_rule_comps rtc
115: WHERE rtc.retrieval_rule_id = l_retrieval_rule_id
116: AND rtc.time_recipient_id = l_time_recipient_id
117: AND rtc.status = p_status;
118:

Line 122: hxc_retrieval_rule_comps_api.update_retrieval_rule_comps (

118:
119: IF ( p_custom_mode = 'FORCE' OR l_owner = 'SEED' )
120: THEN
121:
122: hxc_retrieval_rule_comps_api.update_retrieval_rule_comps (
123: p_retrieval_rule_id => l_retrieval_rule_id
124: , p_effective_date => sysdate
125: , p_status => p_status
126: , p_time_recipient_id => l_time_recipient_id

Line 135: hxc_retrieval_rule_comps_api.create_retrieval_rule_comps (

131:
132: EXCEPTION WHEN NO_DATA_FOUND
133: THEN
134:
135: hxc_retrieval_rule_comps_api.create_retrieval_rule_comps (
136: p_retrieval_rule_id => l_retrieval_rule_id
137: , p_effective_date => sysdate
138: , p_status => p_status
139: , p_time_recipient_id => l_time_recipient_id