DBA Data[Home] [Help]

PACKAGE: APPS.CSI_SYSTEMS_H_PKG

Source


1 PACKAGE csi_systems_h_pkg AUTHID CURRENT_USER AS
2 /* $Header: csitsyhs.pls 115.13 2003/09/04 00:23:07 sguthiva ship $ */
3 -- start of comments
4 -- package name     : csi_systems_h_pkg
5 -- purpose          :
6 -- history          :
7 -- note             :
8 -- end of comments
9 
10 PROCEDURE insert_row(
11           px_system_history_id   IN OUT NOCOPY     NUMBER,
12           p_system_id                       NUMBER      :=fnd_api.g_miss_num,
13           p_transaction_id                  NUMBER      :=fnd_api.g_miss_num,
14           p_old_customer_id                 NUMBER      :=fnd_api.g_miss_num,
15           p_new_customer_id                 NUMBER      :=fnd_api.g_miss_num,
16           p_old_system_type_code            VARCHAR2    :=fnd_api.g_miss_char,
17           p_new_system_type_code            VARCHAR2    :=fnd_api.g_miss_char,
18           p_old_system_NUMBER               VARCHAR2    :=fnd_api.g_miss_char,
19           p_new_system_NUMBER               VARCHAR2    :=fnd_api.g_miss_char,
20           p_old_parent_system_id            NUMBER      :=fnd_api.g_miss_num,
21           p_new_parent_system_id            NUMBER      :=fnd_api.g_miss_num,
22           p_old_ship_to_contact_id          NUMBER      :=fnd_api.g_miss_num,
23           p_new_ship_to_contact_id          NUMBER      :=fnd_api.g_miss_num,
24           p_old_bill_to_contact_id          NUMBER      :=fnd_api.g_miss_num,
25           p_new_bill_to_contact_id          NUMBER      :=fnd_api.g_miss_num,
26           p_old_technical_contact_id        NUMBER      :=fnd_api.g_miss_num,
27           p_new_technical_contact_id        NUMBER      :=fnd_api.g_miss_num,
28           p_old_service_admin_contact_id    NUMBER      :=fnd_api.g_miss_num,
29           p_new_service_admin_contact_id    NUMBER      :=fnd_api.g_miss_num,
30           p_old_ship_to_site_use_id         NUMBER      :=fnd_api.g_miss_num,
31           p_new_ship_to_site_use_id         NUMBER      :=fnd_api.g_miss_num,
32           p_old_install_site_use_id         NUMBER      :=fnd_api.g_miss_num,
33           p_new_install_site_use_id         NUMBER      :=fnd_api.g_miss_num,
34           p_old_bill_to_site_use_id         NUMBER      :=fnd_api.g_miss_num,
35           p_new_bill_to_site_use_id         NUMBER      :=fnd_api.g_miss_num,
36           p_old_coterminate_day_month       VARCHAR2    :=fnd_api.g_miss_char,
37           p_new_coterminate_day_month       VARCHAR2    :=fnd_api.g_miss_char,
38           p_old_start_date_active           DATE        :=fnd_api.g_miss_date,
39           p_new_start_date_active           DATE        :=fnd_api.g_miss_date,
40           p_old_end_date_active             DATE        :=fnd_api.g_miss_date,
41           p_new_end_date_active             DATE        :=fnd_api.g_miss_date,
42           p_old_autocreated_FROM_system     NUMBER      :=fnd_api.g_miss_num,
43           p_new_autocreated_FROM_system     NUMBER      :=fnd_api.g_miss_num,
44           p_old_config_system_type          VARCHAR2    :=fnd_api.g_miss_char,
45           p_new_config_system_type          VARCHAR2    :=fnd_api.g_miss_char,
46           p_old_context                     VARCHAR2    :=fnd_api.g_miss_char,
47           p_new_context                     VARCHAR2    :=fnd_api.g_miss_char,
48           p_old_attribute1                  VARCHAR2    :=fnd_api.g_miss_char,
49           p_new_attribute1                  VARCHAR2    :=fnd_api.g_miss_char,
50           p_old_attribute2                  VARCHAR2    :=fnd_api.g_miss_char,
51           p_new_attribute2                  VARCHAR2    :=fnd_api.g_miss_char,
52           p_old_attribute3                  VARCHAR2    :=fnd_api.g_miss_char,
53           p_new_attribute3                  VARCHAR2    :=fnd_api.g_miss_char,
54           p_old_attribute4                  VARCHAR2    :=fnd_api.g_miss_char,
55           p_new_attribute4                  VARCHAR2    :=fnd_api.g_miss_char,
56           p_old_attribute5                  VARCHAR2    :=fnd_api.g_miss_char,
57           p_new_attribute5                  VARCHAR2    :=fnd_api.g_miss_char,
58           p_old_attribute6                  VARCHAR2    :=fnd_api.g_miss_char,
59           p_new_attribute6                  VARCHAR2    :=fnd_api.g_miss_char,
60           p_old_attribute7                  VARCHAR2    :=fnd_api.g_miss_char,
61           p_new_attribute7                  VARCHAR2    :=fnd_api.g_miss_char,
62           p_old_attribute8                  VARCHAR2    :=fnd_api.g_miss_char,
63           p_new_attribute8                  VARCHAR2    :=fnd_api.g_miss_char,
64           p_old_attribute9                  VARCHAR2    :=fnd_api.g_miss_char,
65           p_new_attribute9                  VARCHAR2    :=fnd_api.g_miss_char,
66           p_old_attribute10                 VARCHAR2    :=fnd_api.g_miss_char,
67           p_new_attribute10                 VARCHAR2    :=fnd_api.g_miss_char,
68           p_old_attribute11                 VARCHAR2    :=fnd_api.g_miss_char,
69           p_new_attribute11                 VARCHAR2    :=fnd_api.g_miss_char,
70           p_old_attribute12                 VARCHAR2    :=fnd_api.g_miss_char,
71           p_new_attribute12                 VARCHAR2    :=fnd_api.g_miss_char,
72           p_old_attribute13                 VARCHAR2    :=fnd_api.g_miss_char,
73           p_new_attribute13                 VARCHAR2    :=fnd_api.g_miss_char,
74           p_old_attribute14                 VARCHAR2    :=fnd_api.g_miss_char,
75           p_new_attribute14                 VARCHAR2    :=fnd_api.g_miss_char,
76           p_old_attribute15                 VARCHAR2    :=fnd_api.g_miss_char,
77           p_new_attribute15                 VARCHAR2    :=fnd_api.g_miss_char,
78           p_full_dump_flag                  VARCHAR2    := fnd_api.g_miss_char,
79           p_created_by                      NUMBER      :=fnd_api.g_miss_num,
80           p_creation_date                   DATE        :=fnd_api.g_miss_date,
81           p_last_updated_by                 NUMBER      :=fnd_api.g_miss_num,
82           p_last_update_date                DATE        :=fnd_api.g_miss_date,
83           p_last_update_login               NUMBER      :=fnd_api.g_miss_num,
84           p_object_version_number           NUMBER      :=fnd_api.g_miss_num,
85           p_old_name                        VARCHAR2    :=fnd_api.g_miss_char,
86           p_new_name                        VARCHAR2    :=fnd_api.g_miss_char,
87           p_old_description                 VARCHAR2    :=fnd_api.g_miss_char,
88           p_new_description                 VARCHAR2    :=fnd_api.g_miss_char,
89 		p_old_operating_unit_id           NUMBER      :=fnd_api.g_miss_num,
90 		p_new_operating_unit_id           NUMBER      :=fnd_api.g_miss_num);
91 
92 PROCEDURE Update_Row(
93           p_system_history_id               NUMBER  ,
94           p_system_id                       NUMBER  ,
95           p_transaction_id                  NUMBER  ,
96           p_old_customer_id                 NUMBER  ,
97           p_new_customer_id                 NUMBER  ,
98           p_old_system_type_code            VARCHAR2,
99           p_new_system_type_code            VARCHAR2,
100           p_old_system_number               VARCHAR2,
101           p_new_system_number               VARCHAR2,
102           p_old_parent_system_id            NUMBER  ,
103           p_new_parent_system_id            NUMBER  ,
104           p_old_ship_to_contact_id          NUMBER  ,
105           p_new_ship_to_contact_id          NUMBER  ,
106           p_old_bill_to_contact_id          NUMBER  ,
107           p_new_bill_to_contact_id          NUMBER  ,
108           p_old_technical_contact_id        NUMBER  ,
109           p_new_technical_contact_id        NUMBER  ,
110           p_old_service_admin_contact_id    NUMBER  ,
111           p_new_service_admin_contact_id    NUMBER  ,
112           p_old_ship_to_site_use_id         NUMBER  ,
113           p_new_ship_to_site_use_id         NUMBER  ,
114           p_old_install_site_use_id         NUMBER  ,
115           p_new_install_site_use_id         NUMBER  ,
116           p_old_bill_to_site_use_id         NUMBER  ,
117           p_new_bill_to_site_use_id         NUMBER  ,
118           p_old_coterminate_day_month       VARCHAR2,
119           p_new_coterminate_day_month       VARCHAR2,
120           p_old_start_date_active           DATE    ,
121           p_new_start_date_active           DATE    ,
122           p_old_end_date_active             DATE    ,
123           p_new_end_date_active             DATE    ,
124           p_old_autocreated_from_system     NUMBER  ,
125           p_new_autocreated_from_system     NUMBER  ,
126           p_old_config_system_type          VARCHAR2,
127           p_new_config_system_type          VARCHAR2,
128           p_old_context                     VARCHAR2,
129           p_new_context                     VARCHAR2,
130           p_old_attribute1                  VARCHAR2,
131           p_new_attribute1                  VARCHAR2,
132           p_old_attribute2                  VARCHAR2,
133           p_new_attribute2                  VARCHAR2,
134           p_old_attribute3                  VARCHAR2,
135           p_new_attribute3                  VARCHAR2,
136           p_old_attribute4                  VARCHAR2,
137           p_new_attribute4                  VARCHAR2,
138           p_old_attribute5                  VARCHAR2,
139           p_new_attribute5                  VARCHAR2,
140           p_old_attribute6                  VARCHAR2,
141           p_new_attribute6                  VARCHAR2,
142           p_old_attribute7                  VARCHAR2,
143           p_new_attribute7                  VARCHAR2,
144           p_old_attribute8                  VARCHAR2,
145           p_new_attribute8                  VARCHAR2,
146           p_old_attribute9                  VARCHAR2,
147           p_new_attribute9                  VARCHAR2,
148           p_old_attribute10                 VARCHAR2,
149           p_new_attribute10                 VARCHAR2,
150           p_old_attribute11                 VARCHAR2,
151           p_new_attribute11                 VARCHAR2,
152           p_old_attribute12                 VARCHAR2,
153           p_new_attribute12                 VARCHAR2,
154           p_old_attribute13                 VARCHAR2,
155           p_new_attribute13                 VARCHAR2,
156           p_old_attribute14                 VARCHAR2,
157           p_new_attribute14                 VARCHAR2,
158           p_old_attribute15                 VARCHAR2,
159           p_new_attribute15                 VARCHAR2,
160           p_full_dump_flag                  VARCHAR2,
161           p_created_by                      NUMBER  ,
162           p_creation_date                   DATE    ,
163           p_last_updated_by                 NUMBER  ,
164           p_last_update_date                DATE    ,
165           p_last_update_login               NUMBER  ,
166           p_object_version_number           NUMBER  ,
167           p_old_name                        VARCHAR2,
168           p_new_name                        VARCHAR2,
169           p_old_description                 VARCHAR2,
170           p_new_description                 VARCHAR2,
171 		p_old_operating_unit_id           NUMBER,
172 		p_new_operating_unit_id           NUMBER);
173 
174 end csi_systems_h_pkg;