APPS.HRI_EDW_DIM_PERSON_TYPE dependencies on HRI_EDW_USER_PERSON_TYPES

Line 32: /* combinations are held in the table hri_edw_user_person_types */

28: /******************************************************************************/
29: /* This procedure is used to build up a person type combination for a person. */
30: /* It takes a user person type and corresponding system person type belonging */
31: /* to a person, and populates global variables appropriately. User defined */
32: /* combinations are held in the table hri_edw_user_person_types */
33: /******************************************************************************/
34: PROCEDURE test_person_type( p_system_person_type IN VARCHAR2,
35: p_user_person_type IN VARCHAR2) IS
36:

Line 41: FROM hri_edw_user_person_types

37: l_map_to_type VARCHAR2(30);
38:
39: CURSOR user_type_cur IS
40: SELECT map_to_type
41: FROM hri_edw_user_person_types
42: WHERE system_person_type = p_system_person_type
43: AND user_person_type = p_user_person_type;
44:
45: BEGIN

Line 337: FROM hri_edw_user_person_types

333:
334: /* Selects the map to type for the row if it exists */
335: CURSOR row_exists_cur IS
336: SELECT map_to_type
337: FROM hri_edw_user_person_types
338: WHERE system_person_type = p_system_person_type
339: AND user_person_type = p_user_person_type;
340:
341: BEGIN

Line 360: INSERT INTO hri_edw_user_person_types

356: OPEN row_exists_cur;
357: FETCH row_exists_cur INTO l_map_to_type;
358: IF (row_exists_cur%NOTFOUND OR row_exists_cur%NOTFOUND IS NULL) THEN
359: /* If no row already exists for the given type combination, insert */
360: INSERT INTO hri_edw_user_person_types
361: ( system_person_type
362: , user_person_type
363: , map_to_type )
364: VALUES

Line 370: UPDATE hri_edw_user_person_types

366: , p_user_person_type
367: , p_map_to_type );
368: ELSIF (p_map_to_type <> l_map_to_type) THEN
369: /* Otherwise, if the map to type is different, update */
370: UPDATE hri_edw_user_person_types
371: SET map_to_type = p_map_to_type
372: WHERE system_person_type = p_system_person_type
373: AND user_person_type = p_user_person_type;
374: END IF;

Line 389: DELETE FROM hri_edw_user_person_types

385:
386: BEGIN
387:
388: /* Delete the row if it exists */
389: DELETE FROM hri_edw_user_person_types
390: WHERE system_person_type = p_system_person_type
391: AND user_person_type = p_user_person_type;
392:
393: END remove_user_row;