DBA Data[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;