DBA Data[Home] [Help]

APPS.PQH_REI_BUS dependencies on PQH_ROLE_INFO_TYPES

Line 77: -- pqh_role_info_types where active_inactive_flag is 'Y'.

73: -- {Start Of Comments}
74: --
75: -- Description:
76: -- Validates that the role information type exists in table
77: -- pqh_role_info_types where active_inactive_flag is 'Y'.
78: --
79: -- Pre Conditions:
80: -- Data must be existed in table pqh_role_info_types.
81: --

Line 80: -- Data must be existed in table pqh_role_info_types.

76: -- Validates that the role information type exists in table
77: -- pqh_role_info_types where active_inactive_flag is 'Y'.
78: --
79: -- Pre Conditions:
80: -- Data must be existed in table pqh_role_info_types.
81: --
82: -- In Parameters:
83: -- p_information_type
84: --

Line 103: p_information_type in pqh_role_info_types.information_type%type

99: -- {End Of Comments}
100: -- ----------------------------------------------------------------------------
101: Procedure chk_role_info_type
102: (
103: p_information_type in pqh_role_info_types.information_type%type
104: );
105:
106: -- ----------------------------------------------------------------------------
107: -- |---------------------------< chk_role_id >----------------------------|