APPS.PAY_US_CITY_PKG dependencies on PAY_US_CITY_PKG

Line 1: PACKAGE BODY PAY_US_CITY_PKG as

1: PACKAGE BODY PAY_US_CITY_PKG as
2: /* $Header: pyusukno.pkb 120.1 2005/08/17 09:48:12 rmonge noship $ */
3: /*===========================================================================+
4: | Copyright (c) 1995 Oracle Corporation |
5: | All rights reserved. |

Line 8: pay_us_city_pkg

4: | Copyright (c) 1995 Oracle Corporation |
5: | All rights reserved. |
6: +============================================================================+
7: Name
8: pay_us_city_pkg
9: Purpose
10: Supports the city block in the form pyusukcy (US CITIES).
11: Notes
12:

Line 597: 'pay_us_city_pkg.Insert_Row');

593: IF (C%NOTFOUND) THEN
594: CLOSE C;
595: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
596: hr_utility.set_message_token('PROCEDURE',
597: 'pay_us_city_pkg.Insert_Row');
598: hr_utility.set_message_token('STEP','1');
599: hr_utility.raise_error;
600: END if;
601:

Line 609: 'pay_us_city_pkg.Insert_Row');

605: IF (C2%NOTFOUND) THEN
606: CLOSE C2;
607: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
608: hr_utility.set_message_token('PROCEDURE',
609: 'pay_us_city_pkg.Insert_Row');
610: hr_utility.set_message_token('STEP','2');
611: hr_utility.raise_error;
612: END if;
613:

Line 621: 'pay_us_city_pkg.Insert_Row');

617: IF (C3%NOTFOUND) THEN
618: CLOSE C3;
619: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
620: hr_utility.set_message_token('PROCEDURE',
621: 'pay_us_city_pkg.Insert_Row');
622: hr_utility.set_message_token('STEP','3');
623: hr_utility.raise_error;
624: END if;
625:

Line 674: 'pay_us_city_pkg.lock_row');

670: if (C%NOTFOUND) then
671: CLOSE C;
672: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
673: hr_utility.set_message_token('PROCEDURE',
674: 'pay_us_city_pkg.lock_row');
675: hr_utility.set_message_token('STEP','1');
676: hr_utility.raise_error;
677: end if;
678: --

Line 685: 'pay_us_city_pkg.lock_row');

681: if (C2%NOTFOUND) then
682: CLOSE C2;
683: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
684: hr_utility.set_message_token('PROCEDURE',
685: 'pay_us_city_pkg.lock_row');
686: hr_utility.set_message_token('STEP','2');
687: hr_utility.raise_error;
688: end if;
689: --

Line 696: 'pay_us_city_pkg.lock_row');

692: if (C3%NOTFOUND) then
693: CLOSE C3;
694: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
695: hr_utility.set_message_token('PROCEDURE',
696: 'pay_us_city_pkg.lock_row');
697: hr_utility.set_message_token('STEP','3');
698: hr_utility.raise_error;
699: end if;
700:

Line 841: 'pay_us_city_pkg.delete_row');

837: --
838: if (SQL%NOTFOUND) then
839: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
840: hr_utility.set_message_token('PROCEDURE',
841: 'pay_us_city_pkg.delete_row');
842: hr_utility.set_message_token('STEP','3');
843: hr_utility.raise_error;
844: end if;
845: END Delete_Row;

Line 945: END PAY_US_CITY_PKG;

941: RETURN;
942:
943: END chk_city_in_addr;
944:
945: END PAY_US_CITY_PKG;