APPS.PAY_CA_CITY_PKG dependencies on PAY_CA_CITY_PKG

Line 1: PACKAGE BODY PAY_CA_CITY_PKG as

1: PACKAGE BODY PAY_CA_CITY_PKG as
2: /* $Header: pycaukno.pkb 120.0 2011/03/03 10:51:20 rgottipa noship $ */
3: /*===========================================================================+
4: | Copyright (c) 1995 Oracle Corporation |
5: | All rights reserved. |

Line 8: PAY_CA_CITY_PKG

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

Line 547: 'PAY_CA_CITY_PKG.Insert_Row');

543: IF (C%NOTFOUND) THEN
544: CLOSE C;
545: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
546: hr_utility.set_message_token('PROCEDURE',
547: 'PAY_CA_CITY_PKG.Insert_Row');
548: hr_utility.set_message_token('STEP','1');
549: hr_utility.raise_error;
550: END if;
551:

Line 559: 'PAY_CA_CITY_PKG.Insert_Row');

555: IF (C2%NOTFOUND) THEN
556: CLOSE C2;
557: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
558: hr_utility.set_message_token('PROCEDURE',
559: 'PAY_CA_CITY_PKG.Insert_Row');
560: hr_utility.set_message_token('STEP','2');
561: hr_utility.raise_error;
562: END if;
563:

Line 571: 'PAY_CA_CITY_PKG.Insert_Row');

567: IF (C3%NOTFOUND) THEN
568: CLOSE C3;
569: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
570: hr_utility.set_message_token('PROCEDURE',
571: 'PAY_CA_CITY_PKG.Insert_Row');
572: hr_utility.set_message_token('STEP','3');
573: hr_utility.raise_error;
574: END if;
575:

Line 624: 'PAY_CA_CITY_PKG.lock_row');

620: if (C%NOTFOUND) then
621: CLOSE C;
622: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
623: hr_utility.set_message_token('PROCEDURE',
624: 'PAY_CA_CITY_PKG.lock_row');
625: hr_utility.set_message_token('STEP','1');
626: hr_utility.raise_error;
627: end if;
628: --

Line 635: 'PAY_CA_CITY_PKG.lock_row');

631: if (C2%NOTFOUND) then
632: CLOSE C2;
633: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
634: hr_utility.set_message_token('PROCEDURE',
635: 'PAY_CA_CITY_PKG.lock_row');
636: hr_utility.set_message_token('STEP','2');
637: hr_utility.raise_error;
638: end if;
639: --

Line 646: 'PAY_CA_CITY_PKG.lock_row');

642: if (C3%NOTFOUND) then
643: CLOSE C3;
644: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
645: hr_utility.set_message_token('PROCEDURE',
646: 'PAY_CA_CITY_PKG.lock_row');
647: hr_utility.set_message_token('STEP','3');
648: hr_utility.raise_error;
649: end if;
650:

Line 791: 'PAY_CA_CITY_PKG.delete_row');

787: --
788: if (SQL%NOTFOUND) then
789: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
790: hr_utility.set_message_token('PROCEDURE',
791: 'PAY_CA_CITY_PKG.delete_row');
792: hr_utility.set_message_token('STEP','3');
793: hr_utility.raise_error;
794: end if;
795: END Delete_Row;

Line 895: END PAY_CA_CITY_PKG;

891: RETURN;
892:
893: END chk_city_in_addr;
894:
895: END PAY_CA_CITY_PKG;