[Home] [Help]
PACKAGE: APPS.PA_FP_PERIOD_MASKS_UTILS
Source
1 PACKAGE PA_FP_PERIOD_MASKS_UTILS AUTHID CURRENT_USER as
2 /* $Header: PAFPPMUS.pls 120.0 2005/05/29 12:30:00 appldev noship $ */
3
4
5 --***********Procedure for checking duplicate names*************
6 PROCEDURE NAME_VALIDATION
7 (p_name IN pa_period_masks_tl.name%TYPE,
8 p_period_mask_id IN pa_period_masks_b.period_mask_id%TYPE,
9 p_init_msg_flag IN VARCHAR2 DEFAULT 'N',
10 x_return_status OUT NOCOPY VARCHAR2,
11 x_msg_count OUT NOCOPY NUMBER,
12 x_msg_data OUT NOCOPY VARCHAR2);
13
14
15
16 --************Procedure for validating number of period*********
17 PROCEDURE NOP_VALIDATION
18 (p_num_of_periods IN PA_NUM_1000_NUM,
19 p_init_msg_flag IN VARCHAR2 DEFAULT 'N',
20 p_error_flag_tab IN OUT NOCOPY PA_VC_1000_150,
21 x_return_status OUT NOCOPY VARCHAR2,
22 x_msg_count OUT NOCOPY NUMBER,
23 x_msg_data OUT NOCOPY VARCHAR2);
24
25
26 --***********Procedure for maintaining the period mask details*********
27 /* PROCEDURE MAINTAIN_PERIOD_MASK_DTLS
28 (p_period_mask_id IN pa_period_masks_b.period_mask_id%TYPE,
29 p_num_of_periods IN PA_NUM_1000_NUM,
30 p_anchor_period_flag IN PA_VC_1000_150,
31 p_from_anchor_position IN PA_NUM_1000_NUM,
32 p_init_msg_flag IN VARCHAR2 DEFAULT 'N',
33 p_commit_flag IN VARCHAR2 DEFAULT 'N',
34 x_return_status OUT NOCOPY VARCHAR2,
35 x_msg_count OUT NOCOPY NUMBER,
36 x_msg_data OUT NOCOPY VARCHAR2); */
37
38
39 --************Function to allow delete*************************
40 FUNCTION IS_DELETE_ALLOWED
41 (p_period_mask_id IN pa_period_masks_b.period_mask_id%TYPE)
42 RETURN VARCHAR2;
43
44
45
46 END PA_FP_PERIOD_MASKS_UTILS;