eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.PQP_GB_TP_EXTRACT_TRIGGERS

Source


1 PACKAGE pqp_gb_tp_extract_triggers AS
2 --  /* $Header: pqpgbtpt.pkh 120.0.12000000.2 2007/03/30 10:23:38 ckesanap noship $ */
3 --
4 --
5 --
6    PROCEDURE pqp_assignment_attribute_f_aru
7    (p_business_group_id in number
8    ,p_legislation_code in varchar2
9    ,p_effective_date in date
10    ,p_old_AAT_ATTRIBUTE1 in VARCHAR2
11    ,p_new_AAT_ATTRIBUTE1 in VARCHAR2
12    ,p_old_AAT_ATTRIBUTE10 in VARCHAR2
13    ,p_new_AAT_ATTRIBUTE10 in VARCHAR2
14    ,p_old_AAT_ATTRIBUTE11 in VARCHAR2
15    ,p_new_AAT_ATTRIBUTE11 in VARCHAR2
16    ,p_old_AAT_ATTRIBUTE12 in VARCHAR2
17    ,p_new_AAT_ATTRIBUTE12 in VARCHAR2
18    ,p_old_AAT_ATTRIBUTE13 in VARCHAR2
19    ,p_new_AAT_ATTRIBUTE13 in VARCHAR2
20    ,p_old_AAT_ATTRIBUTE14 in VARCHAR2
21    ,p_new_AAT_ATTRIBUTE14 in VARCHAR2
22    ,p_old_AAT_ATTRIBUTE15 in VARCHAR2
23    ,p_new_AAT_ATTRIBUTE15 in VARCHAR2
24    ,p_old_AAT_ATTRIBUTE16 in VARCHAR2
25    ,p_new_AAT_ATTRIBUTE16 in VARCHAR2
26    ,p_old_AAT_ATTRIBUTE17 in VARCHAR2
27    ,p_new_AAT_ATTRIBUTE17 in VARCHAR2
28    ,p_old_AAT_ATTRIBUTE18 in VARCHAR2
29    ,p_new_AAT_ATTRIBUTE18 in VARCHAR2
30    ,p_old_AAT_ATTRIBUTE19 in VARCHAR2
31    ,p_new_AAT_ATTRIBUTE19 in VARCHAR2
32    ,p_old_AAT_ATTRIBUTE2 in VARCHAR2
33    ,p_new_AAT_ATTRIBUTE2 in VARCHAR2
34    ,p_old_AAT_ATTRIBUTE20 in VARCHAR2
35    ,p_new_AAT_ATTRIBUTE20 in VARCHAR2
36    ,p_old_AAT_ATTRIBUTE3 in VARCHAR2
37    ,p_new_AAT_ATTRIBUTE3 in VARCHAR2
38    ,p_old_AAT_ATTRIBUTE4 in VARCHAR2
39    ,p_new_AAT_ATTRIBUTE4 in VARCHAR2
40    ,p_old_AAT_ATTRIBUTE5 in VARCHAR2
41    ,p_new_AAT_ATTRIBUTE5 in VARCHAR2
42    ,p_old_AAT_ATTRIBUTE6 in VARCHAR2
43    ,p_new_AAT_ATTRIBUTE6 in VARCHAR2
44    ,p_old_AAT_ATTRIBUTE7 in VARCHAR2
45    ,p_new_AAT_ATTRIBUTE7 in VARCHAR2
46    ,p_old_AAT_ATTRIBUTE8 in VARCHAR2
47    ,p_new_AAT_ATTRIBUTE8 in VARCHAR2
48    ,p_old_AAT_ATTRIBUTE9 in VARCHAR2
49    ,p_new_AAT_ATTRIBUTE9 in VARCHAR2
50    ,p_old_AAT_ATTRIBUTE_CATEGORY in VARCHAR2
51    ,p_new_AAT_ATTRIBUTE_CATEGORY in VARCHAR2
52    ,p_old_AAT_INFORMATION1 in VARCHAR2
53    ,p_new_AAT_INFORMATION1 in VARCHAR2
54    ,p_old_AAT_INFORMATION10 in VARCHAR2
55    ,p_new_AAT_INFORMATION10 in VARCHAR2
56    ,p_old_AAT_INFORMATION11 in VARCHAR2
57    ,p_new_AAT_INFORMATION11 in VARCHAR2
58    ,p_old_AAT_INFORMATION12 in VARCHAR2
59    ,p_new_AAT_INFORMATION12 in VARCHAR2
60    ,p_old_AAT_INFORMATION13 in VARCHAR2
61    ,p_new_AAT_INFORMATION13 in VARCHAR2
62    ,p_old_AAT_INFORMATION14 in VARCHAR2
63    ,p_new_AAT_INFORMATION14 in VARCHAR2
64    ,p_old_AAT_INFORMATION15 in VARCHAR2
65    ,p_new_AAT_INFORMATION15 in VARCHAR2
66    ,p_old_AAT_INFORMATION16 in VARCHAR2
67    ,p_new_AAT_INFORMATION16 in VARCHAR2
68    ,p_old_AAT_INFORMATION17 in VARCHAR2
69    ,p_new_AAT_INFORMATION17 in VARCHAR2
70    ,p_old_AAT_INFORMATION18 in VARCHAR2
71    ,p_new_AAT_INFORMATION18 in VARCHAR2
72    ,p_old_AAT_INFORMATION19 in VARCHAR2
73    ,p_new_AAT_INFORMATION19 in VARCHAR2
74    ,p_old_AAT_INFORMATION2 in VARCHAR2
75    ,p_new_AAT_INFORMATION2 in VARCHAR2
76    ,p_old_AAT_INFORMATION20 in VARCHAR2
77    ,p_new_AAT_INFORMATION20 in VARCHAR2
78    ,p_old_AAT_INFORMATION3 in VARCHAR2
79    ,p_new_AAT_INFORMATION3 in VARCHAR2
80    ,p_old_AAT_INFORMATION4 in VARCHAR2
81    ,p_new_AAT_INFORMATION4 in VARCHAR2
82    ,p_old_AAT_INFORMATION5 in VARCHAR2
83    ,p_new_AAT_INFORMATION5 in VARCHAR2
84    ,p_old_AAT_INFORMATION6 in VARCHAR2
85    ,p_new_AAT_INFORMATION6 in VARCHAR2
86    ,p_old_AAT_INFORMATION7 in VARCHAR2
87    ,p_new_AAT_INFORMATION7 in VARCHAR2
88    ,p_old_AAT_INFORMATION8 in VARCHAR2
89    ,p_new_AAT_INFORMATION8 in VARCHAR2
90    ,p_old_AAT_INFORMATION9 in VARCHAR2
91    ,p_new_AAT_INFORMATION9 in VARCHAR2
92    ,p_old_AAT_INFORMATION_CATEGORY in VARCHAR2
93    ,p_new_AAT_INFORMATION_CATEGORY in VARCHAR2
94    ,p_old_ASSIGNMENT_ATTRIBUTE_ID in NUMBER
95    ,p_new_ASSIGNMENT_ATTRIBUTE_ID in NUMBER
96    ,p_old_ASSIGNMENT_ID in NUMBER
97    ,p_new_ASSIGNMENT_ID in NUMBER
98    ,p_old_BUSINESS_GROUP_ID in NUMBER
99    ,p_new_BUSINESS_GROUP_ID in NUMBER
100    ,p_old_COMPANY_CAR_CALC_METHOD in VARCHAR2
101    ,p_new_COMPANY_CAR_CALC_METHOD in VARCHAR2
102    ,p_old_COMPANY_CAR_RATES_TABLE_ in NUMBER
103    ,p_new_COMPANY_CAR_RATES_TABLE_ in NUMBER
104    ,p_old_COMPANY_CAR_SECONDARY_TA in NUMBER
105    ,p_new_COMPANY_CAR_SECONDARY_TA in NUMBER
106    ,p_old_CONTRACT_TYPE in VARCHAR2
107    ,p_new_CONTRACT_TYPE in VARCHAR2
108    ,p_old_PRIMARY_CAPITAL_CONTRIBU in NUMBER
109    ,p_new_PRIMARY_CAPITAL_CONTRIBU in NUMBER
110    ,p_old_PRIMARY_CAR_FUEL_BENEFIT in VARCHAR2
111    ,p_new_PRIMARY_CAR_FUEL_BENEFIT in VARCHAR2
112    ,p_old_PRIMARY_CLASS_1A in VARCHAR2
113    ,p_new_PRIMARY_CLASS_1A in VARCHAR2
114    ,p_old_PRIMARY_COMPANY_CAR in NUMBER
115    ,p_new_PRIMARY_COMPANY_CAR in NUMBER
116    ,p_old_PRIMARY_PRIVATE_CONTRIBU in NUMBER
117    ,p_new_PRIMARY_PRIVATE_CONTRIBU in NUMBER
118    ,p_old_PRIVATE_CAR in NUMBER
119    ,p_new_PRIVATE_CAR in NUMBER
120    ,p_old_PRIVATE_CAR_CALC_METHOD in VARCHAR2
121    ,p_new_PRIVATE_CAR_CALC_METHOD in VARCHAR2
122    ,p_old_PRIVATE_CAR_ESSENTIAL_TA in NUMBER
123    ,p_new_PRIVATE_CAR_ESSENTIAL_TA in NUMBER
124    ,p_old_PRIVATE_CAR_RATES_TABLE_ in NUMBER
125    ,p_new_PRIVATE_CAR_RATES_TABLE_ in NUMBER
126    ,p_old_SECONDARY_CAPITAL_CONTRI in NUMBER
127    ,p_new_SECONDARY_CAPITAL_CONTRI in NUMBER
128    ,p_old_SECONDARY_CAR_FUEL_BENEF in VARCHAR2
129    ,p_new_SECONDARY_CAR_FUEL_BENEF in VARCHAR2
130    ,p_old_SECONDARY_CLASS_1A in VARCHAR2
131    ,p_new_SECONDARY_CLASS_1A in VARCHAR2
132    ,p_old_SECONDARY_COMPANY_CAR in NUMBER
133    ,p_new_SECONDARY_COMPANY_CAR in NUMBER
134    ,p_old_SECONDARY_PRIVATE_CONTRI in NUMBER
135    ,p_new_SECONDARY_PRIVATE_CONTRI in NUMBER
136    ,p_old_START_DAY in VARCHAR2
137    ,p_new_START_DAY in VARCHAR2
138    ,p_old_TP_ELECTED_PENSION in VARCHAR2
139    ,p_new_TP_ELECTED_PENSION in VARCHAR2
140    ,p_old_TP_FAST_TRACK in VARCHAR2
141    ,p_new_TP_FAST_TRACK in VARCHAR2
142    ,p_old_TP_IS_TEACHER in VARCHAR2
143    ,p_new_TP_IS_TEACHER in VARCHAR2
144    ,p_old_TP_SAFEGUARDED_GRADE in VARCHAR2
145    ,p_new_TP_SAFEGUARDED_GRADE in VARCHAR2
146    ,p_old_TP_SAFEGUARDED_RATE_ID in NUMBER
147    ,p_new_TP_SAFEGUARDED_RATE_ID in NUMBER
148    ,p_old_TP_SAFEGUARDED_RATE_TYPE in VARCHAR2
149    ,p_new_TP_SAFEGUARDED_RATE_TYPE in VARCHAR2
150    ,p_old_TP_SAFEGUARDED_SPINAL_PO in NUMBER
151    ,p_new_TP_SAFEGUARDED_SPINAL_PO in NUMBER
152    ,p_old_WORK_PATTERN in VARCHAR2
153    ,p_new_WORK_PATTERN in VARCHAR2
154    ,p_old_EFFECTIVE_END_DATE in DATE
155    ,p_new_EFFECTIVE_END_DATE in DATE
156    ,p_old_EFFECTIVE_START_DATE in DATE
157    ,p_new_EFFECTIVE_START_DATE in DATE
158    );
159 --
160 --
161 --
162   PROCEDURE pqp_assignment_attribute_f_ari
163   (p_business_group_id             IN      NUMBER
164   ,p_legislation_code              IN      VARCHAR2
165   ,p_effective_date                IN      DATE
166   ,p_new_assignment_attribute_id   IN      NUMBER
167   ,p_new_assignment_id             IN      NUMBER
168   ,p_new_effective_end_date        IN      DATE
169   ,p_new_effective_start_date      IN      DATE
170   );
171 --
172 --
173 --
174   PROCEDURE pqp_assignment_attribute_f_ard
175   (p_business_group_id in NUMBER,
176    p_legislation_code in VARCHAR2,
177    p_old_assignment_attribute_id in NUMBER,
178    p_old_effective_start_date in DATE,
179    p_new_effective_start_date in DATE,
180    p_old_effective_end_date in DATE,
181    p_new_effective_end_date in DATE,
182    p_old_assignment_id in NUMBER
183   );
184 --
185 --
186 --
187 END pqp_gb_tp_extract_triggers;