APPS.PER_LETTER_TYPES_PKG dependencies on PER_LETTER_TYPES

Line 1: PACKAGE BODY PER_LETTER_TYPES_PKG as

1: PACKAGE BODY PER_LETTER_TYPES_PKG as
2: /* $Header: peltt01t.pkb 115.1 99/07/18 14:02:00 porting ship $ */
3:
4: procedure LETTER_TYPE_NOT_UNIQUE (
5: --

Line 20: from per_letter_types

16: g_dummy_number number;
17: --
18: cursor csr_duplicate is
19: select null
20: from per_letter_types
21: where upper(p_letter_type) = upper(letter_type_name)
22: and p_business_group_id = business_group_id + 0
23: and (p_letter_type_id is null
24: or (p_letter_type_id is not null

Line 84: cursor c1 is select per_letter_types_s.nextval

80: --
81: --
82: procedure get_next_sequence(p_letter_type_id in out number) is
83: --
84: cursor c1 is select per_letter_types_s.nextval
85: from sys.dual;
86: --
87: begin
88: --

Line 129: END PER_LETTER_TYPES_PKG;

125: close c1;
126: --
127: end get_concurrent_program;
128: --
129: END PER_LETTER_TYPES_PKG;