[Home] [Help]
PACKAGE: APPS.IGS_SC_GEN_001
Source
1 PACKAGE IGS_SC_GEN_001 AS
2 /* $Header: IGSSC06S.pls 120.1 2005/09/08 15:37:27 appldev noship $ */
3 /******************************************************************
4 Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA
5 All rights reserved.
6 Created By : Don Shellito
7 Date Created By : April 8, 2003
8 Purpose : This package is to be used for the processing and
9 gathering of the security process for Oracle
10 Student System.
11 remarks : None
12 Change History
13 Who When What
14 -----------------------------------------------------------
15 ******************************************************************/
16 TYPE ATTRIB_REC IS RECORD(
17 ADVISOR VARCHAR2(4000) DEFAULT NULL,
18 ADVISOR_PERSON_ID VARCHAR2(4000) DEFAULT NULL,
19 APPLICATION_PROGRAM_CODE VARCHAR2(4000) DEFAULT NULL,
20 APPLICATION_TYPE VARCHAR2(4000) DEFAULT NULL,
21 INSTRUCTOR_ID VARCHAR2(4000) DEFAULT NULL,
22 INSTRUCTOR_PERSON_ID VARCHAR2(4000) DEFAULT NULL,
23 LOCATION VARCHAR2(4000) DEFAULT NULL,
24 NOMINATED_COURSE_CODE VARCHAR2(4000) DEFAULT NULL,
25 ORGANIZATIONAL_UNIT_CODE VARCHAR2(4000) DEFAULT NULL,
26 OWNING_ORG_UNIT_CODE VARCHAR2(4000) DEFAULT NULL,
27 PERSON_ID VARCHAR2(4000) DEFAULT NULL,
28 PERSON_TYPE VARCHAR2(4000) DEFAULT NULL,
29 PROGRAM_ATTEMPT_ADVISOR VARCHAR2(4000) DEFAULT NULL,
30 PROGRAM_ATTEMPT_LOCATION VARCHAR2(4000) DEFAULT NULL,
31 PROGRAM_ATT_OWNING_ORG_UNIT_CD VARCHAR2(4000) DEFAULT NULL,
32 PROGRAM_ATT_RESP_ORG_UNIT_CD VARCHAR2(4000) DEFAULT NULL,
33 PROGRAM_ATTEMPT_TYPE VARCHAR2(4000) DEFAULT NULL,
34 PROGRAM_OWNING_ORG_UNIT_CODE VARCHAR2(4000) DEFAULT NULL,
35 PROGRAM_RESP_ORG_UNIT_CODE VARCHAR2(4000) DEFAULT NULL,
36 PROGRAM_TYPE VARCHAR2(4000) DEFAULT NULL,
37 RESPONSIBLE_ORG_UNIT_CODE VARCHAR2(4000) DEFAULT NULL,
38 TEACHING_ORG_UNIT_CODE VARCHAR2(4000) DEFAULT NULL,
39 UNIT_LOCATION VARCHAR2(4000) DEFAULT NULL,
40 UNIT_MODE VARCHAR2(4000) DEFAULT NULL,
41 UNIT_ATT_ORG_UNIT_CODE VARCHAR2(4000) DEFAULT NULL,
42 UNIT_ATTEMPT_LOCATION VARCHAR2(4000) DEFAULT NULL,
43 UNIT_ATTEMPT_INSTRUCTOR VARCHAR2(4000) DEFAULT NULL,
44 UNIT_ATTEMPT_MODE VARCHAR2(4000) DEFAULT NULL,
45 OTHER_UNIT_ORG_UNIT_CODE VARCHAR2(4000) DEFAULT NULL,
46 OTHER_UNIT_LOCATION VARCHAR2(4000) DEFAULT NULL,
47 OTHER_UNIT_INSTRUCTOR VARCHAR2(4000) DEFAULT NULL,
48 OTHER_UNIT_MODE VARCHAR2(4000) DEFAULT NULL
49 );
50
51 PROCEDURE set_ctx(
52 p_name VARCHAR2
53 );
54 PROCEDURE unset_ctx(
55 p_name VARCHAR2
56 );
57
58 FUNCTION check_ins_security(
59 p_BO_NAME IN VARCHAR2,
60 p_object_name IN VARCHAR2,
61 p_attrib_tab IN attrib_rec,
62 p_msg_data OUT NOCOPY VARCHAR2)
63 RETURN BOOLEAN;
64
65 FUNCTION CHECK_SEL_UPD_DEL_SECURITY (
66 P_Tab_Name IN VARCHAR2,
67 P_Rowid IN ROWID,
68 P_Action IN VARCHAR2, --(U/D - Update/Delete)
69 P_Msg_data OUT NOCOPY VARCHAR2) -- return the error message in case of any exceptions.
70 RETURN BOOLEAN; -- TRUE if update/delete privileges are there else return FALSE
71
72 FUNCTION CHECK_PERSON_SECURITY (
73 P_Table_Name IN VARCHAR2,
74 P_Person_id IN NUMBER,
75 P_Action IN VARCHAR2, --(S/U - Select/Update)
76 P_Msg_data OUT NOCOPY VARCHAR2) -- return the error message in case of any exceptions.
77 RETURN BOOLEAN;
78
79 FUNCTION check_user_policy
80 ( P_BUSINESS_OBJECT IN varchar2, -- BO name
81 P_ACTION IN varchar2 , -- S,I,D,U
82 P_USER_ID IN number DEFAULT NULL) -- fnd user id)
83 RETURN VARCHAR2;
84
85 END IGS_SC_GEN_001;