DBA Data[Home] [Help]

PACKAGE: APPS.PA_PERIOD_MASKS_PUB

Source


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;