DBA Data[Home] [Help]

APPS.PAY_JP_ITAX_ARCHIVE_PKG dependencies on HR_UTILITY

Line 75: hr_utility.trace('jp_date: ' || p_date);

71: is
72: l_era_code varchar2(1);
73: l_char_date varchar2(7);
74: begin
75: hr_utility.trace('jp_date: ' || p_date);
76: --
77: if p_date is not null then
78: l_char_date := hr_jp_standard_pkg.to_jp_char(p_date, 'EYYMMDD');
79: l_era_code := substr(l_char_date, 1, 1);

Line 100: hr_utility.set_location('Entering: ' || c_proc, 10);

96: IS
97: c_proc CONSTANT VARCHAR2(61) := c_package || 'INITIALIZATION_CODE';
98: l_legislative_parameters pay_payroll_actions.legislative_parameters%type;
99: BEGIN
100: hr_utility.set_location('Entering: ' || c_proc, 10);
101: --
102: if g_payroll_action_id is null or g_payroll_action_id <> p_payroll_action_id then
103: hr_utility.trace('cache not available.');
104: --

Line 103: hr_utility.trace('cache not available.');

99: BEGIN
100: hr_utility.set_location('Entering: ' || c_proc, 10);
101: --
102: if g_payroll_action_id is null or g_payroll_action_id <> p_payroll_action_id then
103: hr_utility.trace('cache not available.');
104: --
105: select business_group_id,
106: effective_date,
107: legislative_parameters

Line 134: hr_utility.set_location('Leaving: ' || c_proc, 20);

130: --
131: g_payroll_action_id := p_payroll_action_id;
132: end if;
133: --
134: hr_utility.set_location('Leaving: ' || c_proc, 20);
135: END INITIALIZATION_CODE;
136: --
137: -- +------------------------------------------------------------------------------------------------+
138: -- |< RANGE_CODE >----------------------------------------------------------------------------------|

Line 147: hr_utility.set_location('Entering: ' || c_proc, 10);

143: p_sqlstr OUT NOCOPY VARCHAR2)
144: IS
145: c_proc CONSTANT VARCHAR2(61) := c_package || 'RANGE_CODE';
146: BEGIN
147: hr_utility.set_location('Entering: ' || c_proc, 10);
148: --
149: initialization_code(p_payroll_action_id);
150: --
151: p_sqlstr :=

Line 159: hr_utility.set_location('Leaving: ' || c_proc, 20);

155: WHERE ppa.payroll_action_id = :payroll_action_id
156: AND per.business_group_id + 0 = ppa.business_group_id
157: ORDER BY per.person_id';
158: --
159: hr_utility.set_location('Leaving: ' || c_proc, 20);
160: END RANGE_CODE;
161: --
162: -- +------------------------------------------------------------------------------------------------+
163: -- |< ASSIGNMENT_ACTION_CODE >----------------------------------------------------------------------|

Line 265: hr_utility.set_location('Entering: ' || c_proc, 10);

261: */
262: )
263: );
264: BEGIN
265: hr_utility.set_location('Entering: ' || c_proc, 10);
266: --
267: initialization_code(p_payroll_action_id);
268: --
269: -- RANGE_PERSON_ID, PAY_ACTION_PARAMETER_GROUPS(PAY_REPORT_FORMAT_PARAMETERS)

Line 273: hr_utility.set_location('Entering: ' || c_proc, 20);

269: -- RANGE_PERSON_ID, PAY_ACTION_PARAMETER_GROUPS(PAY_REPORT_FORMAT_PARAMETERS)
270: -- is not supported in this release.
271: --
272: FOR l_asg in csr_asg LOOP
273: hr_utility.set_location('Entering: ' || c_proc, 20);
274: --
275: SELECT pay_assignment_actions_s.nextval
276: INTO l_locking_action_id
277: FROM dual;

Line 286: hr_utility.set_location('Leaving: ' || c_proc, 100);

282: pactid => p_payroll_action_id,
283: chunk => p_chunk);
284: END LOOP;
285: --
286: hr_utility.set_location('Leaving: ' || c_proc, 100);
287: END ASSIGNMENT_ACTION_CODE;
288: -- +------------------------------------------------------------------------------------------------+
289: -- |< create_action_information >-------------------------------------------------------------------|
290: -- |Private procedure.------------------------------------------------------------------------------|

Line 669: hr_utility.set_location('Entering: ' || c_proc, 10);

665: end delete_archive;
666: --
667: BEGIN
668: --
669: hr_utility.set_location('Entering: ' || c_proc, 10);
670: --
671: -- Lock first(not latest) record on PER_ALL_ASSIGNMENTS_F
672: -- to suppress other PAYJPITW processes archive the same information
673: -- at the same time.

Line 695: hr_utility.set_location(c_proc, 20);

691: -- Fetch same year's data
692: --
693: for l_wic_rec in csr_wic(l_assignment_id) loop
694: --
695: hr_utility.set_location(c_proc, 20);
696: --
697: l_archive := true;
698: --
699: -- Check whether the wic assact is already archived or not

Line 727: hr_utility.set_location(c_proc, 30);

723: raise no_data_found;
724: end if;
725: close csr_per;
726: --
727: hr_utility.set_location(c_proc, 30);
728: --
729: -- Employer Information
730: --
731: open csr_swot(l_wic_rec.itax_organization_id);

Line 739: hr_utility.set_location(c_proc, 40);

735: raise no_data_found;
736: end if;
737: close csr_swot;
738: --
739: hr_utility.set_location(c_proc, 40);
740: --
741: -- Certificate Information
742: --
743: -- Never call "pay_jp_wic_pkg.get_certificate_info" multiple times

Line 780: hr_utility.set_location(c_proc, 50);

776: --
777: l_wtm_user_desc_kanji := l_wtm_user_desc;
778: l_wtm_user_desc_kana := l_wtm_user_desc;
779: --
780: hr_utility.set_location(c_proc, 50);
781: --
782: -- Get old description and replace system derived description with those if available,
783: -- then delete all archive data.
784: -- This specification seems to be confusing for user, there's possibility to

Line 794: hr_utility.set_location(c_proc, 61);

790: l_assignment_id,
791: l_wic_rec.itax_organization_id,
792: l_wic_rec.itax_category) loop
793: --
794: hr_utility.set_location(c_proc, 61);
795: --
796: if g_inherit_archive_flag = 'Y' then
797: --
798: l_itw_user_desc_kanji := l_archive_rec.itw_user_desc_kanji;

Line 823: hr_utility.set_location(c_proc, 70);

819: l_archive_rec.effective_date);
820: --
821: end loop;
822: --
823: hr_utility.set_location(c_proc, 70);
824: --
825: -- JP_ITAX_PERSON
826: --
827: l_person_rec.action_context_id := p_assignment_action_id;

Line 1037: hr_utility.set_location(c_proc, 80);

1033: l_other2_rec.effective_date := l_wic_rec.effective_date;
1034: l_other2_rec.assignment_id := l_assignment_id;
1035: l_other2_rec.action_information1 := fnd_number.canonical_to_number(g_business_group_id);
1036: --
1037: hr_utility.set_location(c_proc, 80);
1038: --
1039: -- Construct ITW description
1040: --
1041: l_itw_system_desc1_kanji := null;

Line 1046: hr_utility.trace('itw description: ' || l_itw_descriptions(i).description_type);

1042: l_itw_system_desc2_kanji := null;
1043: --
1044: for i in 1..l_itw_descriptions.count loop
1045: --
1046: hr_utility.trace('itw description: ' || l_itw_descriptions(i).description_type);
1047: --
1048: -- Following replace is only for PAYJPITW pdf files.
1049: --
1050: if l_itw_descriptions(i).description_type = 'FIXED_RATE_TAX_REDUCTION' then

Line 1083: hr_utility.trace('wtm description: ' || l_wtm_descriptions(i).description_type);

1079: l_wtm_system_desc_kana := null;
1080: --
1081: for i in 1..l_wtm_descriptions.count loop
1082: --
1083: hr_utility.trace('wtm description: ' || l_wtm_descriptions(i).description_type);
1084: --
1085: concat_description(l_wtm_system_desc_kanji,l_wtm_descriptions(i).description_kanji,',');
1086: concat_description(l_wtm_system_desc_kana,l_wtm_descriptions(i).description_kana,',');
1087: --

Line 1095: hr_utility.trace('***** original descriptions *****');

1091: l_wtm_system_desc_kana := hr_jp_standard_pkg.upper_kana(hr_jp_standard_pkg.to_hankaku(l_wtm_system_desc_kana, '?'));
1092: l_wtm_user_desc_kanji := hr_jp_standard_pkg.to_zenkaku(l_wtm_user_desc_kanji);
1093: l_wtm_user_desc_kana := hr_jp_standard_pkg.upper_kana(hr_jp_standard_pkg.to_hankaku(l_wtm_user_desc_kana, '?'));
1094: --
1095: hr_utility.trace('***** original descriptions *****');
1096: hr_utility.trace('itw_system_desc1_kanji: ' || l_itw_system_desc1_kanji);
1097: hr_utility.trace('itw_system_desc2_kanji: ' || l_itw_system_desc2_kanji);
1098: hr_utility.trace('itw_user_desc_kanji : ' || l_itw_user_desc_kanji);
1099: hr_utility.trace('wtm_system_desc_kanji : ' || l_wtm_system_desc_kanji);

Line 1096: hr_utility.trace('itw_system_desc1_kanji: ' || l_itw_system_desc1_kanji);

1092: l_wtm_user_desc_kanji := hr_jp_standard_pkg.to_zenkaku(l_wtm_user_desc_kanji);
1093: l_wtm_user_desc_kana := hr_jp_standard_pkg.upper_kana(hr_jp_standard_pkg.to_hankaku(l_wtm_user_desc_kana, '?'));
1094: --
1095: hr_utility.trace('***** original descriptions *****');
1096: hr_utility.trace('itw_system_desc1_kanji: ' || l_itw_system_desc1_kanji);
1097: hr_utility.trace('itw_system_desc2_kanji: ' || l_itw_system_desc2_kanji);
1098: hr_utility.trace('itw_user_desc_kanji : ' || l_itw_user_desc_kanji);
1099: hr_utility.trace('wtm_system_desc_kanji : ' || l_wtm_system_desc_kanji);
1100: hr_utility.trace('wtm_system_desc_kana : ' || l_wtm_system_desc_kana);

Line 1097: hr_utility.trace('itw_system_desc2_kanji: ' || l_itw_system_desc2_kanji);

1093: l_wtm_user_desc_kana := hr_jp_standard_pkg.upper_kana(hr_jp_standard_pkg.to_hankaku(l_wtm_user_desc_kana, '?'));
1094: --
1095: hr_utility.trace('***** original descriptions *****');
1096: hr_utility.trace('itw_system_desc1_kanji: ' || l_itw_system_desc1_kanji);
1097: hr_utility.trace('itw_system_desc2_kanji: ' || l_itw_system_desc2_kanji);
1098: hr_utility.trace('itw_user_desc_kanji : ' || l_itw_user_desc_kanji);
1099: hr_utility.trace('wtm_system_desc_kanji : ' || l_wtm_system_desc_kanji);
1100: hr_utility.trace('wtm_system_desc_kana : ' || l_wtm_system_desc_kana);
1101: hr_utility.trace('wtm_user_desc_kanji : ' || l_wtm_user_desc_kanji);

Line 1098: hr_utility.trace('itw_user_desc_kanji : ' || l_itw_user_desc_kanji);

1094: --
1095: hr_utility.trace('***** original descriptions *****');
1096: hr_utility.trace('itw_system_desc1_kanji: ' || l_itw_system_desc1_kanji);
1097: hr_utility.trace('itw_system_desc2_kanji: ' || l_itw_system_desc2_kanji);
1098: hr_utility.trace('itw_user_desc_kanji : ' || l_itw_user_desc_kanji);
1099: hr_utility.trace('wtm_system_desc_kanji : ' || l_wtm_system_desc_kanji);
1100: hr_utility.trace('wtm_system_desc_kana : ' || l_wtm_system_desc_kana);
1101: hr_utility.trace('wtm_user_desc_kanji : ' || l_wtm_user_desc_kanji);
1102: hr_utility.trace('wtm_user_desc_kana : ' || l_wtm_user_desc_kana);

Line 1099: hr_utility.trace('wtm_system_desc_kanji : ' || l_wtm_system_desc_kanji);

1095: hr_utility.trace('***** original descriptions *****');
1096: hr_utility.trace('itw_system_desc1_kanji: ' || l_itw_system_desc1_kanji);
1097: hr_utility.trace('itw_system_desc2_kanji: ' || l_itw_system_desc2_kanji);
1098: hr_utility.trace('itw_user_desc_kanji : ' || l_itw_user_desc_kanji);
1099: hr_utility.trace('wtm_system_desc_kanji : ' || l_wtm_system_desc_kanji);
1100: hr_utility.trace('wtm_system_desc_kana : ' || l_wtm_system_desc_kana);
1101: hr_utility.trace('wtm_user_desc_kanji : ' || l_wtm_user_desc_kanji);
1102: hr_utility.trace('wtm_user_desc_kana : ' || l_wtm_user_desc_kana);
1103: --

Line 1100: hr_utility.trace('wtm_system_desc_kana : ' || l_wtm_system_desc_kana);

1096: hr_utility.trace('itw_system_desc1_kanji: ' || l_itw_system_desc1_kanji);
1097: hr_utility.trace('itw_system_desc2_kanji: ' || l_itw_system_desc2_kanji);
1098: hr_utility.trace('itw_user_desc_kanji : ' || l_itw_user_desc_kanji);
1099: hr_utility.trace('wtm_system_desc_kanji : ' || l_wtm_system_desc_kanji);
1100: hr_utility.trace('wtm_system_desc_kana : ' || l_wtm_system_desc_kana);
1101: hr_utility.trace('wtm_user_desc_kanji : ' || l_wtm_user_desc_kanji);
1102: hr_utility.trace('wtm_user_desc_kana : ' || l_wtm_user_desc_kana);
1103: --
1104: l_itw_system_desc1_kanji := rtrim(substrb(l_itw_system_desc1_kanji, 1, 240));

Line 1101: hr_utility.trace('wtm_user_desc_kanji : ' || l_wtm_user_desc_kanji);

1097: hr_utility.trace('itw_system_desc2_kanji: ' || l_itw_system_desc2_kanji);
1098: hr_utility.trace('itw_user_desc_kanji : ' || l_itw_user_desc_kanji);
1099: hr_utility.trace('wtm_system_desc_kanji : ' || l_wtm_system_desc_kanji);
1100: hr_utility.trace('wtm_system_desc_kana : ' || l_wtm_system_desc_kana);
1101: hr_utility.trace('wtm_user_desc_kanji : ' || l_wtm_user_desc_kanji);
1102: hr_utility.trace('wtm_user_desc_kana : ' || l_wtm_user_desc_kana);
1103: --
1104: l_itw_system_desc1_kanji := rtrim(substrb(l_itw_system_desc1_kanji, 1, 240));
1105: l_itw_system_desc2_kanji := rtrim(substrb(l_itw_system_desc2_kanji, 1, 300));

Line 1102: hr_utility.trace('wtm_user_desc_kana : ' || l_wtm_user_desc_kana);

1098: hr_utility.trace('itw_user_desc_kanji : ' || l_itw_user_desc_kanji);
1099: hr_utility.trace('wtm_system_desc_kanji : ' || l_wtm_system_desc_kanji);
1100: hr_utility.trace('wtm_system_desc_kana : ' || l_wtm_system_desc_kana);
1101: hr_utility.trace('wtm_user_desc_kanji : ' || l_wtm_user_desc_kanji);
1102: hr_utility.trace('wtm_user_desc_kana : ' || l_wtm_user_desc_kana);
1103: --
1104: l_itw_system_desc1_kanji := rtrim(substrb(l_itw_system_desc1_kanji, 1, 240));
1105: l_itw_system_desc2_kanji := rtrim(substrb(l_itw_system_desc2_kanji, 1, 300));
1106: l_itw_user_desc_kanji := rtrim(substrb(l_itw_user_desc_kanji, 1, 300));

Line 1112: hr_utility.trace('***** truncated descriptions *****');

1108: l_wtm_system_desc_kana := substr(l_wtm_system_desc_kana, 1, 100);
1109: l_wtm_user_desc_kanji := substr(l_wtm_user_desc_kanji, 1, 100);
1110: l_wtm_user_desc_kana := substr(l_wtm_user_desc_kana, 1, 100);
1111: --
1112: hr_utility.trace('***** truncated descriptions *****');
1113: hr_utility.trace('itw_system_desc1_kanji: ' || l_itw_system_desc1_kanji);
1114: hr_utility.trace('itw_system_desc2_kanji: ' || l_itw_system_desc2_kanji);
1115: hr_utility.trace('itw_user_desc_kanji : ' || l_itw_user_desc_kanji);
1116: hr_utility.trace('wtm_system_desc_kanji : ' || l_wtm_system_desc_kanji);

Line 1113: hr_utility.trace('itw_system_desc1_kanji: ' || l_itw_system_desc1_kanji);

1109: l_wtm_user_desc_kanji := substr(l_wtm_user_desc_kanji, 1, 100);
1110: l_wtm_user_desc_kana := substr(l_wtm_user_desc_kana, 1, 100);
1111: --
1112: hr_utility.trace('***** truncated descriptions *****');
1113: hr_utility.trace('itw_system_desc1_kanji: ' || l_itw_system_desc1_kanji);
1114: hr_utility.trace('itw_system_desc2_kanji: ' || l_itw_system_desc2_kanji);
1115: hr_utility.trace('itw_user_desc_kanji : ' || l_itw_user_desc_kanji);
1116: hr_utility.trace('wtm_system_desc_kanji : ' || l_wtm_system_desc_kanji);
1117: hr_utility.trace('wtm_system_desc_kana : ' || l_wtm_system_desc_kana);

Line 1114: hr_utility.trace('itw_system_desc2_kanji: ' || l_itw_system_desc2_kanji);

1110: l_wtm_user_desc_kana := substr(l_wtm_user_desc_kana, 1, 100);
1111: --
1112: hr_utility.trace('***** truncated descriptions *****');
1113: hr_utility.trace('itw_system_desc1_kanji: ' || l_itw_system_desc1_kanji);
1114: hr_utility.trace('itw_system_desc2_kanji: ' || l_itw_system_desc2_kanji);
1115: hr_utility.trace('itw_user_desc_kanji : ' || l_itw_user_desc_kanji);
1116: hr_utility.trace('wtm_system_desc_kanji : ' || l_wtm_system_desc_kanji);
1117: hr_utility.trace('wtm_system_desc_kana : ' || l_wtm_system_desc_kana);
1118: hr_utility.trace('wtm_user_desc_kanji : ' || l_wtm_user_desc_kanji);

Line 1115: hr_utility.trace('itw_user_desc_kanji : ' || l_itw_user_desc_kanji);

1111: --
1112: hr_utility.trace('***** truncated descriptions *****');
1113: hr_utility.trace('itw_system_desc1_kanji: ' || l_itw_system_desc1_kanji);
1114: hr_utility.trace('itw_system_desc2_kanji: ' || l_itw_system_desc2_kanji);
1115: hr_utility.trace('itw_user_desc_kanji : ' || l_itw_user_desc_kanji);
1116: hr_utility.trace('wtm_system_desc_kanji : ' || l_wtm_system_desc_kanji);
1117: hr_utility.trace('wtm_system_desc_kana : ' || l_wtm_system_desc_kana);
1118: hr_utility.trace('wtm_user_desc_kanji : ' || l_wtm_user_desc_kanji);
1119: hr_utility.trace('wtm_user_desc_kana : ' || l_wtm_user_desc_kana);

Line 1116: hr_utility.trace('wtm_system_desc_kanji : ' || l_wtm_system_desc_kanji);

1112: hr_utility.trace('***** truncated descriptions *****');
1113: hr_utility.trace('itw_system_desc1_kanji: ' || l_itw_system_desc1_kanji);
1114: hr_utility.trace('itw_system_desc2_kanji: ' || l_itw_system_desc2_kanji);
1115: hr_utility.trace('itw_user_desc_kanji : ' || l_itw_user_desc_kanji);
1116: hr_utility.trace('wtm_system_desc_kanji : ' || l_wtm_system_desc_kanji);
1117: hr_utility.trace('wtm_system_desc_kana : ' || l_wtm_system_desc_kana);
1118: hr_utility.trace('wtm_user_desc_kanji : ' || l_wtm_user_desc_kanji);
1119: hr_utility.trace('wtm_user_desc_kana : ' || l_wtm_user_desc_kana);
1120: --

Line 1117: hr_utility.trace('wtm_system_desc_kana : ' || l_wtm_system_desc_kana);

1113: hr_utility.trace('itw_system_desc1_kanji: ' || l_itw_system_desc1_kanji);
1114: hr_utility.trace('itw_system_desc2_kanji: ' || l_itw_system_desc2_kanji);
1115: hr_utility.trace('itw_user_desc_kanji : ' || l_itw_user_desc_kanji);
1116: hr_utility.trace('wtm_system_desc_kanji : ' || l_wtm_system_desc_kanji);
1117: hr_utility.trace('wtm_system_desc_kana : ' || l_wtm_system_desc_kana);
1118: hr_utility.trace('wtm_user_desc_kanji : ' || l_wtm_user_desc_kanji);
1119: hr_utility.trace('wtm_user_desc_kana : ' || l_wtm_user_desc_kana);
1120: --
1121: /*

Line 1118: hr_utility.trace('wtm_user_desc_kanji : ' || l_wtm_user_desc_kanji);

1114: hr_utility.trace('itw_system_desc2_kanji: ' || l_itw_system_desc2_kanji);
1115: hr_utility.trace('itw_user_desc_kanji : ' || l_itw_user_desc_kanji);
1116: hr_utility.trace('wtm_system_desc_kanji : ' || l_wtm_system_desc_kanji);
1117: hr_utility.trace('wtm_system_desc_kana : ' || l_wtm_system_desc_kana);
1118: hr_utility.trace('wtm_user_desc_kanji : ' || l_wtm_user_desc_kanji);
1119: hr_utility.trace('wtm_user_desc_kana : ' || l_wtm_user_desc_kana);
1120: --
1121: /*
1122: --

Line 1119: hr_utility.trace('wtm_user_desc_kana : ' || l_wtm_user_desc_kana);

1115: hr_utility.trace('itw_user_desc_kanji : ' || l_itw_user_desc_kanji);
1116: hr_utility.trace('wtm_system_desc_kanji : ' || l_wtm_system_desc_kanji);
1117: hr_utility.trace('wtm_system_desc_kana : ' || l_wtm_system_desc_kana);
1118: hr_utility.trace('wtm_user_desc_kanji : ' || l_wtm_user_desc_kanji);
1119: hr_utility.trace('wtm_user_desc_kana : ' || l_wtm_user_desc_kana);
1120: --
1121: /*
1122: --
1123: -- If number of characters for WTM exceeds 100, output to log file

Line 1160: hr_utility.set_location(c_proc, 90);

1156: hr_jp_standard_pkg.to_table(l_wtm_user_desc_kana, 240, l_varchar2_tbl);
1157: l_other2_rec.action_information29 := get_index_at(l_varchar2_tbl, 1);
1158: l_other2_rec.action_information30 := get_index_at(l_varchar2_tbl, 2);
1159: --
1160: hr_utility.set_location(c_proc, 90);
1161: --
1162: -- JP_ITAX_HOUSING
1163: --
1164: l_housing_rec.action_context_id := p_assignment_action_id;

Line 1207: hr_utility.set_location('Leaving: ' || c_proc, 100);

1203: l_archive_rec.effective_date);
1204: --
1205: end loop;
1206: --
1207: hr_utility.set_location('Leaving: ' || c_proc, 100);
1208: --
1209: END ARCHIVE_CODE;
1210: -- +------------------------------------------------------------------------------------------------+
1211: -- |< DEINITIALIZATION_CODE >-----------------------------------------------------------------------|

Line 1239: hr_utility.set_location('Entering: ' || c_proc, 10);

1235: from pay_action_information pai
1236: where pai.action_context_id = paa.assignment_action_id
1237: and pai.action_context_type = 'AAP');
1238: BEGIN
1239: hr_utility.set_location('Entering: ' || c_proc, 10);
1240: --
1241: open csr_pa_exists;
1242: fetch csr_pa_exists into l_dummy;
1243: if csr_pa_exists%notfound then

Line 1244: hr_utility.set_location(c_proc, 20);

1240: --
1241: open csr_pa_exists;
1242: fetch csr_pa_exists into l_dummy;
1243: if csr_pa_exists%notfound then
1244: hr_utility.set_location(c_proc, 20);
1245: --
1246: initialization_code(p_payroll_action_id);
1247: --
1248: -- JP_ITAX_PACT

Line 1272: hr_utility.set_location('Leaving: ' || c_proc, 100);

1268: for l_rec in csr_assacts loop
1269: py_rollback_pkg.rollback_ass_action(l_rec.assignment_action_id);
1270: end loop;
1271: --
1272: hr_utility.set_location('Leaving: ' || c_proc, 100);
1273: END DEINITIALIZATION_CODE;
1274: --
1275: END PAY_JP_ITAX_ARCHIVE_PKG;