APPS.IGS_PE_GEN_001 dependencies on IGS_PE_PRIV_LEVEL

Line 16: prbhardw 18-Aug-2005 Bug No: 3690826 Changed use of IGS_PE_PRIV_LEVEL_V to IGS_PE_PRIV_LEVEL

12: Modified the procedures validate_hold_resp and release_hold
13: ssaleem 13-OCT-2003 modified the cursor query in get_person_encumb and included
14: Inactive condition
15: asbala 26-dec-03 3304598, added date check in cursor c1 of get_privacy_lvl_format_str
16: prbhardw 18-Aug-2005 Bug No: 3690826 Changed use of IGS_PE_PRIV_LEVEL_V to IGS_PE_PRIV_LEVEL
17: ssawhney 30-Aug-2005 Added function Get_Hold_Count
18: pkpatel 8-Sep-2005 Bug No: 3690826 (removed the cursor c2 in Get_Privacy_Lvl_Format_Str)
19: */
20: FUNCTION Get_Privacy_Lvl_Format_Str (

Line 21: p_person_id igs_pe_priv_level.person_id%TYPE

17: ssawhney 30-Aug-2005 Added function Get_Hold_Count
18: pkpatel 8-Sep-2005 Bug No: 3690826 (removed the cursor c2 in Get_Privacy_Lvl_Format_Str)
19: */
20: FUNCTION Get_Privacy_Lvl_Format_Str (
21: p_person_id igs_pe_priv_level.person_id%TYPE
22: ) RETURN VARCHAR2 AS
23: ------------------------------------------------------------------
24: --Created by : kumma , Oracle India
25: --Date created: 04-JUN-2002

Line 45: FROM IGS_PE_PRIV_LEVEL lvl, IGS_PE_DATA_GROUPS DG

41: ln_data_Group_Id NUMBER(15);
42:
43: cursor c1 (lnpersonid number) is
44: SELECT max(dg.lvl) Max_Level, lvl.data_group_id, lvl_description
45: FROM IGS_PE_PRIV_LEVEL lvl, IGS_PE_DATA_GROUPS DG
46: WHERE lvl.person_id = lnpersonid
47: AND TRUNC(SYSDATE) BETWEEN lvl.start_date AND NVL(lvl.end_date,TRUNC(SYSDATE))
48: and lvl.DATA_GROUP_ID = DG.DATA_GROUP_ID
49: GROUP BY lvl.data_group_id, lvl_description

Line 539: P_person_id igs_pe_priv_level.person_id%TYPE )

535:
536: END Get_Res_Status;
537:
538: FUNCTION GET_SS_PRIVACY_LVL (
539: P_person_id igs_pe_priv_level.person_id%TYPE )
540: RETURN VARCHAR2 AS
541: ------------------------------------------------------------------
542: --Created by : gmaheswa , Oracle India
543: --Date created: 29-JUN-2005

Line 561: FROM IGS_PE_PRIV_LEVEL lvl, IGS_PE_DATA_GROUPS DG

557: ln_data_Group_Id NUMBER(15);
558:
559: CURSOR cur_lvl_data_group (lnpersonid number) IS
560: SELECT max(dg.lvl) Max_Level, lvl.DATA_GROUP_ID , dg.lvl_description
561: FROM IGS_PE_PRIV_LEVEL lvl, IGS_PE_DATA_GROUPS DG
562: WHERE lvl.person_id = lnpersonid
563: AND TRUNC(SYSDATE) BETWEEN lvl.start_date AND NVL(lvl.end_date,TRUNC(SYSDATE))
564: and lvl.DATA_GROUP_ID = DG.DATA_GROUP_ID
565: GROUP BY lvl.data_group_id ,dg.lvl_description