APPS.PER_RO_ADDRESS dependencies on PER_RO_ADDRESS

Line 1: PACKAGE body per_ro_address AS

1: PACKAGE body per_ro_address AS
2: /* $Header: perrousrhk.pkb 120.0.12020000.4 2013/04/15 09:09:34 ssanjays noship $ */
3:
4: g_package VARCHAR2(33) := 'per_ro_address.';
5:

Line 4: g_package VARCHAR2(33) := 'per_ro_address.';

1: PACKAGE body per_ro_address AS
2: /* $Header: perrousrhk.pkb 120.0.12020000.4 2013/04/15 09:09:34 ssanjays noship $ */
3:
4: g_package VARCHAR2(33) := 'per_ro_address.';
5:
6: CURSOR c_get_style(p_address_id number) is
7: SELECT style,person_id
8: FROM per_addresses

Line 162: per_ro_address.check_ro_address(

158: return;
159: END IF;
160:
161: IF p_style = 'RO' THEN
162: per_ro_address.check_ro_address(
163: p_address_ID => NULL ,
164: p_address_type => p_address_type,
165: p_date_from => p_date_from ,
166: p_date_to => p_date_to ,

Line 202: per_ro_address.check_ro_address(

198: OPEN c_get_style(p_address_id);
199: FETCH c_get_style INTO l_style,l_person_id;
200: CLOSE c_get_style;
201: IF l_style='RO' THEN
202: per_ro_address.check_ro_address(
203: p_address_ID => p_address_id ,
204: p_address_type => p_address_type,
205: p_date_from => p_date_from ,
206: p_date_to => p_date_to ,

Line 243: per_ro_address.check_ro_address(

239: IF p_style='RO' THEN
240: OPEN c_get_style(p_address_id);
241: FETCH c_get_style INTO l_style,l_person_id;
242: CLOSE c_get_style;
243: per_ro_address.check_ro_address(
244: p_address_ID => p_address_id ,
245: p_address_type => p_address_type,
246: p_date_from => p_date_from ,
247: p_date_to => p_date_to ,

Line 258: END per_ro_address;

254: --
255: END update_ro_address_style;
256: --
257:
258: END per_ro_address;