APPS.HXC_REC_PERIODS_UPLOAD_PKG dependencies on HXC_RECURRING_PERIODS

Line 13: l_recurring_period_id hxc_recurring_periods.recurring_period_id%TYPE;

9: , p_duration_in_days IN NUMBER
10: , p_owner IN VARCHAR2
11: , p_custom_mode IN VARCHAR2 ) IS
12:
13: l_recurring_period_id hxc_recurring_periods.recurring_period_id%TYPE;
14: l_ovn hxc_recurring_periods.object_version_number%TYPE;
15: l_owner VARCHAR2(6);
16:
17: BEGIN

Line 14: l_ovn hxc_recurring_periods.object_version_number%TYPE;

10: , p_owner IN VARCHAR2
11: , p_custom_mode IN VARCHAR2 ) IS
12:
13: l_recurring_period_id hxc_recurring_periods.recurring_period_id%TYPE;
14: l_ovn hxc_recurring_periods.object_version_number%TYPE;
15: l_owner VARCHAR2(6);
16:
17: BEGIN
18:

Line 25: FROM hxc_recurring_periods

21: ,DECODE( NVL(last_updated_by,-1), 1, 'SEED', 'CUSTOM')
22: INTO l_recurring_period_id
23: ,l_ovn
24: ,l_owner
25: FROM hxc_recurring_periods
26: WHERE name = p_name;
27:
28: IF (p_custom_mode = 'FORCE' OR p_owner = 'SEED') THEN
29: hxc_recurring_periods_api.update_recurring_periods

Line 29: hxc_recurring_periods_api.update_recurring_periods

25: FROM hxc_recurring_periods
26: WHERE name = p_name;
27:
28: IF (p_custom_mode = 'FORCE' OR p_owner = 'SEED') THEN
29: hxc_recurring_periods_api.update_recurring_periods
30: (p_validate => false
31: ,p_recurring_period_id => l_recurring_period_id
32: ,p_object_version_number => l_ovn
33: ,p_name => p_name

Line 59: hxc_recurring_periods_api.create_recurring_periods

55:
56: EXCEPTION WHEN NO_DATA_FOUND
57: THEN
58:
59: hxc_recurring_periods_api.create_recurring_periods
60: (p_validate => false
61: ,p_recurring_period_id => l_recurring_period_id
62: ,p_object_version_number => l_ovn
63: ,p_name => p_name