APPS.EDW_SEC_REF dependencies on EDW_SEC_REF

Line 1: package body edw_sec_ref as

1: package body edw_sec_ref as
2: /* $Header: EDWSREFB.pls 115.2 2002/12/06 02:55:22 tiwang noship $*/
3:
4: -- This procedure disables security for a reference
5:

Line 11: x_object_name varchar2(30) := 'EDW_SEC_REF.DISABLE_SECURITY';

7: (application_short_name varchar2, responsibility_key varchar2,
8: fact_physical_name varchar2, fk_column_physical_name varchar2)
9: IS
10:
11: x_object_name varchar2(30) := 'EDW_SEC_REF.DISABLE_SECURITY';
12: x_object_type varchar2(30) := 'Disable Security Procedure';
13:
14: v_Errorcode number;
15: v_ErrorText varchar2(200);

Line 59: select count(*) into x_rec_count from edw_sec_ref_info_t

55:
56:
57: -- Check if row already exists
58:
59: select count(*) into x_rec_count from edw_sec_ref_info_t
60: where appl_id = x_appl_id
61: and resp_id = x_resp_id
62: and fact_id = x_fact_id
63: and fk_col_name = fk_column_physical_name;

Line 70: Insert into edw_sec_ref_info_t

66: IF (x_rec_count = 0) THEN
67:
68: -- Insert Row
69:
70: Insert into edw_sec_ref_info_t
71: (appl_id,
72: resp_id,
73: fact_id,
74: fact_name,

Line 127: x_object_name varchar2(30) := 'EDW_SEC_REF.ENABLE_SECURITY';

123: (application_short_name varchar2, responsibility_key varchar2,
124: fact_physical_name varchar2, fk_column_physical_name varchar2)
125: IS
126:
127: x_object_name varchar2(30) := 'EDW_SEC_REF.ENABLE_SECURITY';
128: x_object_type varchar2(30) := 'Enable Security Procedure';
129:
130: v_Errorcode number;
131: v_ErrorText varchar2(200);

Line 168: Delete from edw_sec_ref_info_t

164: and fk_col_name = fk_column_physical_name;
165:
166: -- Delete Row
167:
168: Delete from edw_sec_ref_info_t
169: where appl_id = x_appl_id
170: and resp_id = x_resp_id
171: and fact_id = x_fact_id
172: and fk_col_name = fk_column_physical_name;

Line 201: END edw_sec_ref;

197: END enable_security;
198:
199:
200:
201: END edw_sec_ref;