1 PACKAGE PAY_LOADER_UTILS_PKG AS
2 /* $Header: pyldutil.pkh 120.3 2005/10/19 04:17 pgongada noship $ */
3
4 PROCEDURE load_rfm_row
5 ( p_report_type in varchar2
6 ,p_report_qualifier in varchar2
7 ,p_report_category in varchar2
8 ,p_effective_start_date in date
9 ,p_effective_end_date in date
10 ,p_legislation_code in varchar2
11 ,p_business_group_name in varchar2
12 ,p_range_code in varchar2
13 ,p_assignment_action_code in varchar2
14 ,p_initialization_code in varchar2
15 ,p_archive_code in varchar2
16 ,p_magnetic_code in varchar2
17 ,p_report_format in varchar2
18 ,p_report_name in varchar2
19 ,p_sort_code in varchar2
20 ,p_updatable_flag in varchar2
21 ,p_deinitialization_code in varchar2
22 ,p_temporary_action_flag in varchar2
23 ,p_display_name in varchar2
24 ,p_owner in varchar2
25 ,p_eof in number );
26
27 PROCEDURE translate_rfm_row
28 ( p_report_type in varchar2
29 ,p_report_qualifier in varchar2
30 ,p_report_category in varchar2
31 ,p_display_name in varchar2 );
32
33 PROCEDURE load_rfi_row
34 ( p_report_type in varchar2
35 ,p_report_qualifier in varchar2
36 ,p_report_category in varchar2
37 ,p_user_entity_name in varchar2
38 ,p_legislation_code in varchar2
39 ,p_effective_start_date in date
40 ,p_effective_end_date in date
41 ,p_archive_type in varchar2
42 ,p_updatable_flag in varchar2
43 ,p_display_sequence in number
44 ,p_owner in varchar2
45 ,p_eof in number );
46
47 PROCEDURE load_rfp_row
48 ( p_report_type in varchar2
49 ,p_report_qualifier in varchar2
50 ,p_report_category in varchar2
51 ,p_parameter_name in varchar2
52 ,p_parameter_value in varchar2
53 ,p_owner in varchar2 );
54
55 PROCEDURE load_mgb_row
56 ( p_block_name in varchar2
57 ,p_report_format in varchar2
58 ,p_main_block_flag in varchar2
59 ,p_cursor_name in varchar2
60 ,p_no_column_returned in number );
61
62 PROCEDURE load_mgr_row
63 ( p_block_name in varchar2
64 ,p_report_format in varchar2
65 ,p_sequence in number
66 ,p_formula_type_name in varchar2
67 ,p_formula_name in varchar2
68 ,p_legislation_code in varchar2
69 ,p_next_block_name in varchar2
70 ,p_next_report_format in varchar2
71 ,p_overflow_mode in varchar2
72 ,p_frequency in number
73 ,p_last_run_executed_mode in varchar2
74 ,p_action_level in varchar2 default null
75 ,p_block_label in varchar2 default null
76 ,p_block_row_label in varchar2 default null
77 ,p_xml_proc_name in varchar2 default null );
78
79 PROCEDURE load_egu_row
80 ( p_evg_name in varchar2
81 ,p_evg_leg_code in varchar2
82 ,p_evg_bus_grp_name in varchar2
83 ,p_els_name in varchar2
84 ,p_els_leg_code in varchar2
85 ,p_els_bus_grp_name in varchar2
86 ,p_egu_leg_code in varchar2
87 ,p_egu_bus_grp_name in varchar2
88 ,p_owner in varchar2 );
89
90 PROCEDURE load_ecu_row
91 ( p_usage_id in number
92 ,p_rt_name in varchar2
93 ,p_rt_effective_start_date in date
94 ,p_rt_effective_end_date in date
95 ,p_rt_business_group_name in varchar2
96 ,p_rt_legislation_code in varchar2
97 ,p_rt_shortname in varchar2
98 ,p_ec_classification_name in varchar2
99 ,p_ec_business_group_name in varchar2
100 ,p_ec_legislation_code in varchar2
101 ,p_effective_start_date in date
102 ,p_effective_end_date in date
103 ,p_business_group_name in varchar2
104 ,p_legislation_code in varchar2
105 ,p_owner in varchar2
106 ,p_eof_number in number);
107
108 END PAY_LOADER_UTILS_PKG;
109