APPS.HXC_RTR_UPLOAD_PKG dependencies on HXC_RETRIEVAL_RULES

Line 10: l_retrieval_rule_id hxc_retrieval_rules.retrieval_rule_id%TYPE;

6: , p_ret_name VARCHAR2
7: , p_owner VARCHAR2
8: , p_custom_mode VARCHAR2 ) IS
9:
10: l_retrieval_rule_id hxc_retrieval_rules.retrieval_rule_id%TYPE;
11: l_retrieval_process_id hxc_retrieval_processes.retrieval_process_id%TYPE;
12: l_ovn hxc_retrieval_rules.object_version_number%TYPE := NULL;
13: l_owner VARCHAR2(6);
14:

Line 12: l_ovn hxc_retrieval_rules.object_version_number%TYPE := NULL;

8: , p_custom_mode VARCHAR2 ) IS
9:
10: l_retrieval_rule_id hxc_retrieval_rules.retrieval_rule_id%TYPE;
11: l_retrieval_process_id hxc_retrieval_processes.retrieval_process_id%TYPE;
12: l_ovn hxc_retrieval_rules.object_version_number%TYPE := NULL;
13: l_owner VARCHAR2(6);
14:
15: FUNCTION get_retrieval_process_id ( p_retrieval_process_name VARCHAR2 ) RETURN NUMBER IS
16:

Line 44: FROM hxc_retrieval_rules

40: , DECODE( NVL(last_updated_by,-1), 1, 'SEED', 'CUSTOM')
41: INTO l_retrieval_rule_id
42: , l_ovn
43: , l_owner
44: FROM hxc_retrieval_rules
45: WHERE name = P_NAME;
46:
47: IF ( p_custom_mode = 'FORCE' OR l_owner = 'SEED' )
48: THEN

Line 50: hxc_retrieval_rules_api.update_retrieval_rules (

46:
47: IF ( p_custom_mode = 'FORCE' OR l_owner = 'SEED' )
48: THEN
49:
50: hxc_retrieval_rules_api.update_retrieval_rules (
51: p_effective_date => sysdate
52: , p_retrieval_rule_id => l_retrieval_rule_id
53: , p_retrieval_process_id => l_retrieval_process_id
54: , p_name => p_name

Line 62: hxc_retrieval_rules_api.create_retrieval_rules (

58:
59: EXCEPTION WHEN NO_DATA_FOUND
60: THEN
61:
62: hxc_retrieval_rules_api.create_retrieval_rules (
63: p_effective_date => sysdate
64: , p_name => p_name
65: , p_retrieval_rule_id => l_retrieval_rule_id
66: , p_retrieval_process_id => l_retrieval_process_id

Line 79: l_retrieval_rule_id hxc_retrieval_rules.retrieval_rule_id%TYPE;

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

Line 81: l_ovn hxc_retrieval_rules.object_version_number%TYPE := NULL;

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);
83:
84: FUNCTION get_retrieval_rule_id ( p_retrieval_rule_name VARCHAR2 ) RETURN NUMBER IS
85:

Line 86: l_retrieval_rule_id hxc_retrieval_rules.retrieval_rule_id%TYPE;

82: l_owner VARCHAR2(6);
83:
84: FUNCTION get_retrieval_rule_id ( p_retrieval_rule_name VARCHAR2 ) RETURN NUMBER IS
85:
86: l_retrieval_rule_id hxc_retrieval_rules.retrieval_rule_id%TYPE;
87:
88: CURSOR csr_get_rtr_id IS
89: SELECT retrieval_rule_id
90: FROM hxc_retrieval_rules

Line 90: FROM hxc_retrieval_rules

86: l_retrieval_rule_id hxc_retrieval_rules.retrieval_rule_id%TYPE;
87:
88: CURSOR csr_get_rtr_id IS
89: SELECT retrieval_rule_id
90: FROM hxc_retrieval_rules
91: WHERE name = p_retrieval_rule_name;
92:
93: BEGIN
94: