APPS.PER_CONTACT_EXTRA_INFO_PKG dependencies on PER_CONTACT_EXTRA_INFO

Line 1: PACKAGE BODY per_contact_extra_info_pkg AS

1: PACKAGE BODY per_contact_extra_info_pkg AS
2: /* $Header: pecei01t.pkb 115.3 2002/03/19 18:05:16 pkm ship $ */
3: -- ---------------------------------------------------------------------------
4: -- |-------------------------< populate_info_exists >------------------------|
5: -- ---------------------------------------------------------------------------

Line 10: -- if a per_contact_extra_info record exists.

6: -- {Start Of Comments}
7: --
8: -- Description:
9: -- Accepts contact_relationship_id and information_type, and returns 'Y' if
10: -- if a per_contact_extra_info record exists.
11: --
12: -- Prerequisites:
13: -- None.
14: --

Line 39: x_contact_relationship_id IN per_contact_extra_info_f.contact_relationship_id%TYPE,

35: --
36: -- {End Of Comments}
37: -- ---------------------------------------------------------------------------
38: FUNCTION populate_info_exists(
39: x_contact_relationship_id IN per_contact_extra_info_f.contact_relationship_id%TYPE,
40: x_information_type IN per_contact_extra_info_f.information_type%TYPE)
41: RETURN VARCHAR2 IS
42: --
43: CURSOR c_cei IS

Line 40: x_information_type IN per_contact_extra_info_f.information_type%TYPE)

36: -- {End Of Comments}
37: -- ---------------------------------------------------------------------------
38: FUNCTION populate_info_exists(
39: x_contact_relationship_id IN per_contact_extra_info_f.contact_relationship_id%TYPE,
40: x_information_type IN per_contact_extra_info_f.information_type%TYPE)
41: RETURN VARCHAR2 IS
42: --
43: CURSOR c_cei IS
44: SELECT 'Y'

Line 45: FROM per_contact_extra_info cei

41: RETURN VARCHAR2 IS
42: --
43: CURSOR c_cei IS
44: SELECT 'Y'
45: FROM per_contact_extra_info cei
46: WHERE cei.contact_relationship_id = x_contact_relationship_id
47: AND cei.information_type = x_information_type;
48: --
49: l_return VARCHAR2(1) := 'N';

Line 57: END per_contact_extra_info_pkg;

53: CLOSE c_cei;
54: RETURN l_return;
55: END populate_info_exists;
56: --
57: END per_contact_extra_info_pkg;