1 PACKAGE pn_recovery_extract_pkg AUTHID CURRENT_USER AS
2 /* $Header: PNRCEXTS.pls 115.8 2003/06/13 02:07:46 ftanudja noship $ */
3
4 TYPE date_table_type IS TABLE OF DATE INDEX BY BINARY_INTEGER;
5 TYPE number_table_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
6
7 PROCEDURE extract_line_expense_area(
8 errbuf OUT NOCOPY VARCHAR2,
9 retcode OUT NOCOPY VARCHAR2,
10 p_location_code IN pn_locations.location_code%TYPE,
11 p_property_code IN pn_properties.property_code%TYPE,
12 p_as_of_date IN VARCHAR2,
13 p_from_date IN VARCHAR2,
14 p_to_date IN VARCHAR2,
15 p_currency_code IN pn_rec_exp_line.currency_code%TYPE DEFAULT NULL,
16 p_pop_exp_class_dtl IN VARCHAR2,
17 p_pop_area_class_dtl IN VARCHAR2,
18 p_keep_override IN VARCHAR2,
19 p_extract_code IN pn_rec_exp_line.expense_extract_code%TYPE,
20 p_called_from IN VARCHAR2 DEFAULT 'SRS');
21
22 PROCEDURE extract_expense(
23 errbuf OUT NOCOPY VARCHAR2,
24 retcode OUT NOCOPY VARCHAR2,
25 p_expense_class_id IN pn_rec_expcl.expense_class_id%TYPE,
26 p_as_of_date IN VARCHAR2,
27 p_from_date IN VARCHAR2,
28 p_to_date IN VARCHAR2,
29 p_expense_line_id IN pn_rec_exp_line.expense_line_id%TYPE,
30 p_keep_override IN VARCHAR2);
31
32 PROCEDURE extract_area(
33 errbuf OUT NOCOPY VARCHAR2,
34 retcode OUT NOCOPY VARCHAR2,
35 p_area_class_id IN pn_rec_arcl.area_class_id%TYPE,
36 p_as_of_date IN VARCHAR2,
37 p_from_date IN VARCHAR2,
38 p_to_date IN VARCHAR2,
39 p_keep_override IN VARCHAR2);
40
41 PROCEDURE purge_expense_lines_itf_data(
42 errbuf OUT NOCOPY VARCHAR2,
43 retcode OUT NOCOPY VARCHAR2,
44 p_extract_code IN pn_rec_exp_line.expense_extract_code%TYPE DEFAULT NULL,
45 p_location_code IN pn_locations.location_code%TYPE DEFAULT NULL,
46 p_property_code IN pn_properties.property_code%TYPE DEFAULT NULL,
47 p_from_date IN VARCHAR2 DEFAULT NULL,
48 p_to_date IN VARCHAR2 DEFAULT NULL,
49 p_transfer_flag IN pn_rec_exp_itf.transfer_flag%TYPE DEFAULT NULL,
50 p_delete_all_flag IN VARCHAR2 DEFAULT 'N');
51
52 PROCEDURE process_vacancy(p_start_date DATE,
53 p_end_date DATE,
54 p_area NUMBER,
55 p_date_table IN OUT NOCOPY date_table_type,
56 p_number_table IN OUT NOCOPY number_table_type,
57 p_add BOOLEAN);
58
59 END pn_recovery_extract_pkg;