[Home] [Help]
PACKAGE: APPS.PA_REPORT_TYPES_PUB
Source
1 package PA_REPORT_TYPES_PUB as
2 /* $Header: PARTYPPS.pls 120.1 2005/08/19 17:02:35 mwasowic noship $ */
3
4 PROCEDURE CREATE_REPORT_TYPE
5 (
6 p_api_version IN NUMBER := 1.0,
7 p_init_msg_list IN VARCHAR2 := 'T',
8 p_commit IN VARCHAR2 := 'F',
9 p_validate_only IN VARCHAR2 := 'F',
10 p_max_msg_count IN NUMBER := 100,
11 P_NAME IN VARCHAR2,
12 P_PAGE_ID IN NUMBER,
13 P_PAGE_LAYOUT IN VARCHAR2 := '^',
14 P_OVERRIDE_PAGE_LAYOUT IN VARCHAR2 := 'N',
15 P_DESCRIPTION IN VARCHAR2 := '',
16 P_GENERATION_METHOD IN VARCHAR2 :='',
17 P_START_DATE_ACTIVE IN DATE := trunc(sysdate),
18 P_END_DATE_ACTIVE IN DATE := to_date(null),
19
20 x_report_type_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
21 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
22 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
23 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
24 );
25
26
27 PROCEDURE Update_Report_Type
28 (
29 p_api_version IN NUMBER := 1.0,
30 p_init_msg_list IN VARCHAR2 := 'T',
31 p_commit IN VARCHAR2 := 'F',
32 p_validate_only IN VARCHAR2 := 'T',
33 p_max_msg_count IN NUMBER := 100,
34 P_REPORT_TYPE_ID IN NUMBER,
35 P_NAME IN VARCHAR2 := '^',
36 P_PAGE_ID IN NUMBER := -99,
37 P_PAGE_LAYOUT IN VARCHAR2 := '^',
38 P_OVERRIDE_PAGE_LAYOUT IN VARCHAR2 := '^',
39 P_DESCRIPTION IN VARCHAR2 := '^',
40 P_GENERATION_METHOD IN VARCHAR2 :='',
41 P_START_DATE_ACTIVE IN DATE := to_date('01/01/4712','DD/MM/YYYY'),
42 P_END_DATE_ACTIVE IN DATE := to_date('01/01/4712','DD/MM/YYYY'),
43 P_RECORD_VERSION_NUMBER IN NUMBER,
44
45 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
46 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
47 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
48 );
49
50 PROCEDURE Delete_Report_Type
51 (
52 p_api_version IN NUMBER := 1.0,
53 p_init_msg_list IN VARCHAR2 := 'T',
54 p_commit IN VARCHAR2 := 'F',
55 p_validate_only IN VARCHAR2 := 'T',
56 p_max_msg_count IN NUMBER := 100,
57
58 p_report_type_id IN NUMBER,
59 p_record_version_number IN NUMBER ,
60
61 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
62 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
63 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
64 );
65
66 END PA_REPORT_TYPES_PUB;
67