[Home] [Help]
PACKAGE: APPS.PA_REPORT_UTIL
Source
1 PACKAGE PA_REPORT_UTIL AUTHID CURRENT_USER AS
2 /* $Header: PARFRULS.pls 120.1 2005/08/19 16:52:29 mwasowic noship $ */
3 PROCEDURE get_default_val(
4 p_calling_screen IN VARCHAR2,
5 x_org_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
6 x_org_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
7 x_def_period_typ OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
8 x_def_period_typ_desc OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
9 x_def_period_yr OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
10 x_def_period_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
11 x_def_period_name_desc OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
12 x_def_show_percentages_by OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
13 x_billing_installed OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
14 x_prm_installed OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
15 x_login_person_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
16 x_login_person_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
17 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
18 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
19 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
20
21
22 --
23 -- Procedure : Get_Default_Val
24 -- Purpose : This procedure will populate the values for screen U1 ,and U2.
25 -- Parameters :
26 --
27
28 PROCEDURE validate_u1 (p_org_name IN VARCHAR2,
29 p_period_type_desc IN VARCHAR2,
30 p_select_yr IN NUMBER,
31 p_period_name IN VARCHAR2,
32 p_calling_mode IN VARCHAR2,
33 p_showprctgby IN VARCHAR2,
34 x_org_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
35 x_period_type OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
36 x_period_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
37 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
38 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
39 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
40 --
41 -- Procedure : Validate_U1
42 -- Purpose : This procedure will validate the passed values for screen U1.
43 -- Parameters :
44 --
45
46
47
48 PROCEDURE validate_u2 (p_mgr_name IN VARCHAR ,
49 p_org_name IN VARCHAR2,
50 p_org_id IN NUMBER,
51 p_mgr_id IN NUMBER,
52 p_assignment_sts IN VARCHAR2,
53 p_period_year IN NUMBER,
54 p_period_type_desc IN VARCHAR2,
55 p_period_name IN VARCHAR2,
56 p_util_category IN NUMBER,
57 p_Show_Percentage_By IN VARCHAR2,
58 p_Utilization_Method IN VARCHAR2,
59 p_calling_mode IN VARCHAR2,
60 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
61 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
62 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
63
64 --
65 -- Procedure : Validate_U2
66 -- Purpose : This procedure will validate the passed values for screen U2.
67 -- Parameters :
68 --
69
70 PROCEDURE get_default_period_val(
71 x_def_period OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
72 x_def_period_typ IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
73 x_def_period_yr IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
74 x_def_period_name IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
75 x_def_period_sts_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
76 x_def_period_sts OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
77 x_def_mon_or_qtr OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
78 x_def_period_num OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
79 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
80 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
81 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
82
83
84 --
85 -- Procedure : get_default_period_val
86 -- Purpose : This procedure will populate screen U3.
87 -- Parameters :
88 --
89
90
91
92 PROCEDURE Get_GE_Flag(
93 p_periodname IN VARCHAR2,
94 x_flag OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
95
96
97 --
98 -- Procedure : Get_GE_Flag
99 -- Purpose : This procedure will get the GE flag.
100 -- Parameters :
101 --
102 END PA_REPORT_UTIL;