PACKAGE: APPS.HRSUMREP

Source

1 package hrsumrep AUTHID CURRENT_USER as
2 /* $Header: hrsumrep.pkh 115.9 2004/06/21 07:39:06 jheer noship $ */
3 --
4 procedure delete_process_data(p_process_run_id in number);
5 --
6 procedure process_run(p_business_group_id number
7                      ,p_process_type varchar2
8                      ,p_template_id number
9                      ,p_process_name varchar2
10                      ,p_parameters hr_summary_util.prmTabType
11                      ,p_item_type_usage_id number default null
12                      ,p_store_data boolean default FALSE
13                      ,p_debug varchar2 default 'N'
14                      ,p_statement out NOCOPY varchar2
15                      ,p_retcode   out NOCOPY number);
16 --
17 procedure process_run(p_business_group_id number
18                      ,p_process_type varchar2
19                      ,p_template_id number
20                      ,p_process_name varchar2
21                      ,p_item_type_usage_id number default null
22                      ,p_store_data boolean default FALSE
23                      ,p_debug varchar2 default 'N'
24                      ,p_statement out NOCOPY varchar2);
25 --
26 procedure process_run(p_business_group_id number
27                      ,p_process_type varchar2
28                      ,p_template_id number
29                      ,p_process_name varchar2
30                      ,p_parameters hr_summary_util.prmTabType
31                      ,p_item_type_usage_id number default null
32                      ,p_store_data boolean default FALSE
33                      ,p_debug varchar2 default 'N'
34                      ,p_statement out NOCOPY varchar2);
35 --
36 procedure write_error (p_error in varchar2);
37 --
38 procedure write_stmt_log (p_stmt in varchar2);
39 --
40 TYPE ituRecType IS RECORD
41    (item_type_usage_id number
42    ,item_type_id number
43    ,datatype varchar2(1)
44    ,count_clause1  varchar2(240)
45    ,count_clause2 varchar2(240)
46    ,where_clause varchar2(4000)
47    ,it_name varchar2(240)
48    ,itu_name varchar2(240)
49    ,first_parameter number
50    ,number_of_parameters number);
51 TYPE ituTabType is TABLE of ituRecType INDEX BY BINARY_INTEGER;
52 --
53 TYPE ktyRecType IS RECORD
54    (key_type varchar2(240)
55    ,key_type_id number
56    ,key_other boolean
57    ,key_function varchar2(2000));
58 TYPE ktyTabType IS TABLE of ktyRecType INDEX BY BINARY_INTEGER;
59 --
60 nullituTab ituTabType;
61 nullktyTab ktyTabType;
62 --
63 ituTab ituTabType;
64 ktyTab ktyTabType;
65 --
66 
67 procedure process_run_form(p_business_group_id number
68                      ,p_process_type varchar2
69                      ,p_template_id number
70                      ,p_process_name varchar2
71                      ,p_item_type_usage_id number default null
72                      ,p_store_data boolean default FALSE
73                      ,p_debug  varchar2 default 'N'
74                      ,p_statement out NOCOPY varchar2);
75 
76 
77 end hrsumrep;