APPS.CCT_ALTER_WEB_SCHEMA_PKG dependencies on CCT_ROUTE_PARAMS

Line 74: UPDATE CCT_ROUTE_PARAMS

70: UPDATE CCT_STATIC_ROUTES
71: SET object_version_number = 0
72: where object_version_number IS NULL;
73:
74: UPDATE CCT_ROUTE_PARAMS
75: SET object_version_number = 0
76: where object_version_number IS NULL;
77:
78: UPDATE CCT_ROUTES

Line 95: l_str varchar2(200):= 'ALTER TABLE ' || schema_name || '.' ||'CCT_ROUTE_PARAMS MODIFY ( OPERATION DEFAULT '''||'='||''' )';

91:
92: END;
93:
94: PROCEDURE update_route_param_operator(schema_name IN VARCHAR2) is
95: l_str varchar2(200):= 'ALTER TABLE ' || schema_name || '.' ||'CCT_ROUTE_PARAMS MODIFY ( OPERATION DEFAULT '''||'='||''' )';
96: BEGIN
97:
98: SAVEPOINT CCTUPG1;
99:

Line 100: EXECUTE IMMEDIATE 'LOCK TABLE ' || schema_name || '.' ||'CCT_ROUTE_PARAMS IN EXCLUSIVE MODE';

96: BEGIN
97:
98: SAVEPOINT CCTUPG1;
99:
100: EXECUTE IMMEDIATE 'LOCK TABLE ' || schema_name || '.' ||'CCT_ROUTE_PARAMS IN EXCLUSIVE MODE';
101: EXECUTE IMMEDIATE l_str;
102: COMMIT ; -- used to release the table lock.
103:
104: UPDATE CCT_ROUTE_PARAMS

Line 104: UPDATE CCT_ROUTE_PARAMS

100: EXECUTE IMMEDIATE 'LOCK TABLE ' || schema_name || '.' ||'CCT_ROUTE_PARAMS IN EXCLUSIVE MODE';
101: EXECUTE IMMEDIATE l_str;
102: COMMIT ; -- used to release the table lock.
103:
104: UPDATE CCT_ROUTE_PARAMS
105: SET operation = '='
106: where operation IS NULL;
107:
108: COMMIT ; -- used to release the table lock.