1 PACKAGE PA_PERIOD_MASKS_PUB AUTHID CURRENT_USER AS
2 /* $Header: PAFPPMMS.pls 120.0 2005/05/30 09:32:02 appldev noship $ */
3 /***********Procedure for maintaining the period masks*********/
4 PROCEDURE maintain_period_masks(
5 p_period_mask_id IN NUMBER,
6 p_name IN VARCHAR2,
7 p_description IN VARCHAR2,
8 p_time_phase_code IN VARCHAR2,
9 p_effective_start_date IN pa_period_masks_b.effective_start_date%type ,
10 p_effective_end_date IN pa_period_masks_b.effective_end_date%type ,
11 p_record_version_number IN NUMBER,
12 p_num_of_periods IN PA_NUM_1000_NUM,
13 p_anchor_period_flag IN PA_VC_1000_150,
14 p_from_anchor_position IN PA_NUM_1000_NUM,
15 p_error_flag_tab IN OUT NOCOPY PA_VC_1000_150,
16 p_init_msg_flag IN VARCHAR2 DEFAULT 'N',
17 p_commit_flag IN VARCHAR2 DEFAULT 'N',
18 x_return_status OUT NOCOPY VARCHAR2,
19 x_msg_count OUT NOCOPY NUMBER,
20 x_msg_data OUT NOCOPY VARCHAR2 );
21
22 /***********Procedure for maintaining the period mask details*********/
23 PROCEDURE MAINTAIN_PERIOD_MASK_DTLS(
24 p_period_mask_id IN pa_period_masks_b.period_mask_id%TYPE,
25 p_num_of_periods IN PA_NUM_1000_NUM,
26 p_anchor_period_flag IN PA_VC_1000_150,
27 p_from_anchor_position IN PA_NUM_1000_NUM,
28 p_init_msg_flag IN VARCHAR2 DEFAULT 'N',
29 p_commit_flag IN VARCHAR2 DEFAULT 'N',
30 x_return_status OUT NOCOPY VARCHAR2,
31 x_msg_count OUT NOCOPY NUMBER,
32 x_msg_data OUT NOCOPY VARCHAR2 );
33
34 /***********Procedure for deleting period mask*********/
35 PROCEDURE delete_period_mask(
36 p_period_mask_id IN NUMBER,
37 p_record_version_number IN NUMBER,
38 p_init_msg_flag IN VARCHAR2 DEFAULT 'N',
39 p_commit_flag IN VARCHAR2 DEFAULT 'N',
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_msg_count OUT NOCOPY NUMBER,
42 x_msg_data OUT NOCOPY VARCHAR2 );
43
44 END PA_PERIOD_MASKS_PUB;