[Home] [Help]
PACKAGE: APPS.PA_CI_TYPES_PVT
Source
1 package PA_CI_TYPES_PVT AUTHID CURRENT_USER as
2 /* $Header: PACITYVS.pls 120.1.12010000.3 2009/09/30 19:18:10 cklee ship $ */
3 --------------------------------------------------------------------------------
4 -- ERRORS AND EXCEPTIONS
5 --------------------------------------------------------------------------------
6
7 G_EXCEPTION_ERROR EXCEPTION;
8 G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
9
10 PROCEDURE create_ci_type (
11 p_api_version IN NUMBER := 1.0,
12 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
13 p_commit IN VARCHAR2 := FND_API.g_false,
14 p_validate_only IN VARCHAR2 := FND_API.g_true,
15 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
16 p_name IN VARCHAR2,
17 p_short_name IN VARCHAR2,
18 p_description IN VARCHAR2,
19 p_ci_type_class_code IN VARCHAR2,
20 p_auto_number_flag IN VARCHAR2,
21 p_resolution_required_flag IN VARCHAR2,
22 p_approval_required_flag IN VARCHAR2,
23 p_source_attrs_enabled_flag IN VARCHAR2,
24 p_allow_all_usage_flag IN VARCHAR2,
25 p_start_date_active IN DATE,
26 p_end_date_active IN DATE,
27 p_classification_category IN VARCHAR2,
28 p_reason_category IN VARCHAR2,
29 p_resolution_category IN VARCHAR2,
30 p_attribute_category IN VARCHAR2,
31 p_attribute1 IN VARCHAR2,
32 p_attribute2 IN VARCHAR2,
33 p_attribute3 IN VARCHAR2,
34 p_attribute4 IN VARCHAR2,
35 p_attribute5 IN VARCHAR2,
36 p_attribute6 IN VARCHAR2,
37 p_attribute7 IN VARCHAR2,
38 p_attribute8 IN VARCHAR2,
39 p_attribute9 IN VARCHAR2,
40 p_attribute10 IN VARCHAR2,
41 p_attribute11 IN VARCHAR2,
42 p_attribute12 IN VARCHAR2,
43 p_attribute13 IN VARCHAR2,
44 p_attribute14 IN VARCHAR2,
45 p_attribute15 IN VARCHAR2,
46 p_created_by IN NUMBER DEFAULT fnd_global.user_id,
47 p_creation_date IN DATE DEFAULT SYSDATE,
48 p_last_update_login IN NUMBER DEFAULT fnd_global.user_id,
49 --start:| 16-FEB-2009 cklee R12.1.2 setup ehancement
50 P_APPROVAL_TYPE_CODE IN VARCHAR2 DEFAULT 'STANDARD',
51 P_SUBCONTRACTOR_REPORTING_FLAG IN VARCHAR2 DEFAULT 'N',
52 P_PREFIX_AUTO_NUMBER IN VARCHAR2 DEFAULT NULL,
53 --end:| 16-FEB-2009 cklee R12.1.2 setup ehancement
54 --|start 29-APR-2009 cklee R12.1.2 setup ehancement v2
55 P_IMPACT_BUDGET_TYPE_CODE IN VARCHAR2 DEFAULT 'NA',
56 P_COST_COL_FLAG IN VARCHAR2 DEFAULT 'N',
57 P_REV_COL_FLAG IN VARCHAR2 DEFAULT 'N',
58 P_DIR_COST_REG_FLAG IN VARCHAR2 DEFAULT 'N',
59 P_SUPP_COST_REG_FLAG IN VARCHAR2 DEFAULT 'N',
60 P_DIR_REG_REV_COL_FLAG IN VARCHAR2 DEFAULT 'N',
61 --|end 29-APR-2009 cklee R12.1.2 setup ehancement v2
62 x_ci_type_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
63 x_dist_list_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
64 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
65 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
66 x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
67 p_status_list_id IN NUMBER
68 );
69
70 PROCEDURE update_ci_type (
71 p_api_version IN NUMBER := 1.0,
72 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
73 p_commit IN VARCHAR2 := FND_API.g_false,
74 p_validate_only IN VARCHAR2 := FND_API.g_true,
75 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
76 p_ci_type_id IN NUMBER,
77 p_name IN VARCHAR2,
78 p_short_name IN VARCHAR2,
79 p_description IN VARCHAR2,
80 p_ci_type_class_code IN VARCHAR2,
81 p_auto_number_flag IN VARCHAR2,
82 p_resolution_required_flag IN VARCHAR2,
83 p_approval_required_flag IN VARCHAR2,
84 p_source_attrs_enabled_flag IN VARCHAR2,
85 p_allow_all_usage_flag IN VARCHAR2,
86 p_start_date_active IN DATE,
87 p_end_date_active IN DATE,
88 p_classification_category IN VARCHAR2,
89 p_reason_category IN VARCHAR2,
90 p_resolution_category IN VARCHAR2,
91 p_attribute_category IN VARCHAR2,
92 p_attribute1 IN VARCHAR2,
93 p_attribute2 IN VARCHAR2,
94 p_attribute3 IN VARCHAR2,
95 p_attribute4 IN VARCHAR2,
96 p_attribute5 IN VARCHAR2,
97 p_attribute6 IN VARCHAR2,
98 p_attribute7 IN VARCHAR2,
99 p_attribute8 IN VARCHAR2,
100 p_attribute9 IN VARCHAR2,
101 p_attribute10 IN VARCHAR2,
102 p_attribute11 IN VARCHAR2,
103 p_attribute12 IN VARCHAR2,
104 p_attribute13 IN VARCHAR2,
105 p_attribute14 IN VARCHAR2,
106 p_attribute15 IN VARCHAR2,
107 p_last_updated_by IN NUMBER DEFAULT fnd_global.user_id,
108 p_last_update_date IN DATE DEFAULT SYSDATE,
109 p_last_update_login IN NUMBER DEFAULT fnd_global.user_id,
110 --start:| 16-FEB-2009 cklee R12.1.2 setup ehancement
111 P_APPROVAL_TYPE_CODE IN VARCHAR2 DEFAULT 'STANDARD',
112 P_SUBCONTRACTOR_REPORTING_FLAG IN VARCHAR2 DEFAULT 'N',
113 P_PREFIX_AUTO_NUMBER IN VARCHAR2 DEFAULT NULL,
114 --end:| 16-FEB-2009 cklee R12.1.2 setup ehancement
115 --|start 29-APR-2009 cklee R12.1.2 setup ehancement v2
116 P_IMPACT_BUDGET_TYPE_CODE IN VARCHAR2 DEFAULT 'NA',
117 P_COST_COL_FLAG IN VARCHAR2 DEFAULT 'N',
118 P_REV_COL_FLAG IN VARCHAR2 DEFAULT 'N',
119 P_DIR_COST_REG_FLAG IN VARCHAR2 DEFAULT 'N',
120 P_SUPP_COST_REG_FLAG IN VARCHAR2 DEFAULT 'N',
121 P_DIR_REG_REV_COL_FLAG IN VARCHAR2 DEFAULT 'N',
122 --|end 29-APR-2009 cklee R12.1.2 setup ehancement v2
123 p_record_version_number IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
124 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
125 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
126 x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
127 p_status_list_id IN NUMBER,
128 p_obj_status_list_id IN NUMBER
129 );
130
131 PROCEDURE delete_ci_type (
132 p_api_version IN NUMBER := 1.0,
133 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
134 p_commit IN VARCHAR2 := FND_API.g_false,
135 p_validate_only IN VARCHAR2 := FND_API.g_true,
136 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
137 p_ci_type_id IN NUMBER,
138 p_record_version_number IN NUMBER,
139 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
140 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
141 x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
142 p_obj_status_list_id IN NUMBER
143 );
144
145 END pa_ci_types_pvt;