APPS.CZ_ADMIN dependencies on DBMS_SQL

Line 78: DC_CURSOR:=DBMS_SQL.OPEN_CURSOR;

74: 'Invalid login name', fnd_log.LEVEL_ERROR);
75: ELSE
76: BEGIN
77:
78: DC_CURSOR:=DBMS_SQL.OPEN_CURSOR;
79: sCommand:='CREATE USER '||sLogin_name||' IDENTIFIED BY '||sLogin_name;
80: IF(sDefault_tspc IS NOT NULL)THEN
81: sCommand:=sCommand||' DEFAULT TABLESPACE '||sDefault_tspc;
82: END IF;

Line 86: DBMS_SQL.PARSE(DC_CURSOR,sCommand,DBMS_SQL.NATIVE);

82: END IF;
83: IF(sTempory_tspc IS NOT NULL)THEN
84: sCommand:=sCommand||' TEMPORARY TABLESPACE '||sTempory_tspc;
85: END IF;
86: DBMS_SQL.PARSE(DC_CURSOR,sCommand,DBMS_SQL.NATIVE);
87: RESULT:=DBMS_SQL.EXECUTE(DC_CURSOR);
88: DBMS_SQL.CLOSE_CURSOR(DC_CURSOR);
89:
90: EXCEPTION

Line 87: RESULT:=DBMS_SQL.EXECUTE(DC_CURSOR);

83: IF(sTempory_tspc IS NOT NULL)THEN
84: sCommand:=sCommand||' TEMPORARY TABLESPACE '||sTempory_tspc;
85: END IF;
86: DBMS_SQL.PARSE(DC_CURSOR,sCommand,DBMS_SQL.NATIVE);
87: RESULT:=DBMS_SQL.EXECUTE(DC_CURSOR);
88: DBMS_SQL.CLOSE_CURSOR(DC_CURSOR);
89:
90: EXCEPTION
91: WHEN OTHERS THEN

Line 88: DBMS_SQL.CLOSE_CURSOR(DC_CURSOR);

84: sCommand:=sCommand||' TEMPORARY TABLESPACE '||sTempory_tspc;
85: END IF;
86: DBMS_SQL.PARSE(DC_CURSOR,sCommand,DBMS_SQL.NATIVE);
87: RESULT:=DBMS_SQL.EXECUTE(DC_CURSOR);
88: DBMS_SQL.CLOSE_CURSOR(DC_CURSOR);
89:
90: EXCEPTION
91: WHEN OTHERS THEN
92: DBMS_SQL.CLOSE_CURSOR(DC_CURSOR);

Line 92: DBMS_SQL.CLOSE_CURSOR(DC_CURSOR);

88: DBMS_SQL.CLOSE_CURSOR(DC_CURSOR);
89:
90: EXCEPTION
91: WHEN OTHERS THEN
92: DBMS_SQL.CLOSE_CURSOR(DC_CURSOR);
93: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_ADMIN.ENABLE_END_USER',11276);
94: cz_utils.log_report('CZ_ADMIN', 'ENABLE_END_USER', null,
95: SQLERRM, fnd_log.LEVEL_UNEXPECTED);
96: END;

Line 100: DC_CURSOR:=DBMS_SQL.OPEN_CURSOR;

96: END;
97:
98: BEGIN
99:
100: DC_CURSOR:=DBMS_SQL.OPEN_CURSOR;
101: DBMS_SQL.PARSE(DC_CURSOR,'GRANT "CONNECT" TO '||sLogin_name,DBMS_SQL.NATIVE);
102: RESULT:=DBMS_SQL.EXECUTE(DC_CURSOR);
103: DBMS_SQL.CLOSE_CURSOR(DC_CURSOR);
104:

Line 101: DBMS_SQL.PARSE(DC_CURSOR,'GRANT "CONNECT" TO '||sLogin_name,DBMS_SQL.NATIVE);

97:
98: BEGIN
99:
100: DC_CURSOR:=DBMS_SQL.OPEN_CURSOR;
101: DBMS_SQL.PARSE(DC_CURSOR,'GRANT "CONNECT" TO '||sLogin_name,DBMS_SQL.NATIVE);
102: RESULT:=DBMS_SQL.EXECUTE(DC_CURSOR);
103: DBMS_SQL.CLOSE_CURSOR(DC_CURSOR);
104:
105: EXCEPTION

Line 102: RESULT:=DBMS_SQL.EXECUTE(DC_CURSOR);

98: BEGIN
99:
100: DC_CURSOR:=DBMS_SQL.OPEN_CURSOR;
101: DBMS_SQL.PARSE(DC_CURSOR,'GRANT "CONNECT" TO '||sLogin_name,DBMS_SQL.NATIVE);
102: RESULT:=DBMS_SQL.EXECUTE(DC_CURSOR);
103: DBMS_SQL.CLOSE_CURSOR(DC_CURSOR);
104:
105: EXCEPTION
106: WHEN OTHERS THEN

Line 103: DBMS_SQL.CLOSE_CURSOR(DC_CURSOR);

99:
100: DC_CURSOR:=DBMS_SQL.OPEN_CURSOR;
101: DBMS_SQL.PARSE(DC_CURSOR,'GRANT "CONNECT" TO '||sLogin_name,DBMS_SQL.NATIVE);
102: RESULT:=DBMS_SQL.EXECUTE(DC_CURSOR);
103: DBMS_SQL.CLOSE_CURSOR(DC_CURSOR);
104:
105: EXCEPTION
106: WHEN OTHERS THEN
107: DBMS_SQL.CLOSE_CURSOR(DC_CURSOR);

Line 107: DBMS_SQL.CLOSE_CURSOR(DC_CURSOR);

103: DBMS_SQL.CLOSE_CURSOR(DC_CURSOR);
104:
105: EXCEPTION
106: WHEN OTHERS THEN
107: DBMS_SQL.CLOSE_CURSOR(DC_CURSOR);
108: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_ADMIN.ENABLE_END_USER',11276);
109: cz_utils.log_report('CZ_ADMIN', 'ENABLE_END_USER', null,
110: SQLERRM, fnd_log.LEVEL_UNEXPECTED);
111: END;

Line 115: DC_CURSOR:=DBMS_SQL.OPEN_CURSOR;

111: END;
112:
113: BEGIN
114:
115: DC_CURSOR:=DBMS_SQL.OPEN_CURSOR;
116: DBMS_SQL.PARSE(DC_CURSOR,'GRANT '||sDefault_role||' TO '||sLogin_name,DBMS_SQL.NATIVE);
117: RESULT:=DBMS_SQL.EXECUTE(DC_CURSOR);
118: DBMS_SQL.CLOSE_CURSOR(DC_CURSOR);
119:

Line 116: DBMS_SQL.PARSE(DC_CURSOR,'GRANT '||sDefault_role||' TO '||sLogin_name,DBMS_SQL.NATIVE);

112:
113: BEGIN
114:
115: DC_CURSOR:=DBMS_SQL.OPEN_CURSOR;
116: DBMS_SQL.PARSE(DC_CURSOR,'GRANT '||sDefault_role||' TO '||sLogin_name,DBMS_SQL.NATIVE);
117: RESULT:=DBMS_SQL.EXECUTE(DC_CURSOR);
118: DBMS_SQL.CLOSE_CURSOR(DC_CURSOR);
119:
120: EXCEPTION

Line 117: RESULT:=DBMS_SQL.EXECUTE(DC_CURSOR);

113: BEGIN
114:
115: DC_CURSOR:=DBMS_SQL.OPEN_CURSOR;
116: DBMS_SQL.PARSE(DC_CURSOR,'GRANT '||sDefault_role||' TO '||sLogin_name,DBMS_SQL.NATIVE);
117: RESULT:=DBMS_SQL.EXECUTE(DC_CURSOR);
118: DBMS_SQL.CLOSE_CURSOR(DC_CURSOR);
119:
120: EXCEPTION
121: WHEN OTHERS THEN

Line 118: DBMS_SQL.CLOSE_CURSOR(DC_CURSOR);

114:
115: DC_CURSOR:=DBMS_SQL.OPEN_CURSOR;
116: DBMS_SQL.PARSE(DC_CURSOR,'GRANT '||sDefault_role||' TO '||sLogin_name,DBMS_SQL.NATIVE);
117: RESULT:=DBMS_SQL.EXECUTE(DC_CURSOR);
118: DBMS_SQL.CLOSE_CURSOR(DC_CURSOR);
119:
120: EXCEPTION
121: WHEN OTHERS THEN
122: DBMS_SQL.CLOSE_CURSOR(DC_CURSOR);

Line 122: DBMS_SQL.CLOSE_CURSOR(DC_CURSOR);

118: DBMS_SQL.CLOSE_CURSOR(DC_CURSOR);
119:
120: EXCEPTION
121: WHEN OTHERS THEN
122: DBMS_SQL.CLOSE_CURSOR(DC_CURSOR);
123: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_ADMIN.ENABLE_END_USER',11276);
124: cz_utils.log_report('CZ_ADMIN', 'ENABLE_END_USER', null,
125: SQLERRM, fnd_log.LEVEL_UNEXPECTED);
126: END;