APPS.CCT_MIDDLEWARE_PARAM_PKG dependencies on DBMS_OUTPUT

Line 89: dbms_output.put_line('Inside seed');

85: l_param_id cct_middleware_params.middleware_param_id%TYPE;
86: l_temp VARCHAR2(20);
87:
88: BEGIN
89: dbms_output.put_line('Inside seed');
90: OPEN csr_chk_upgrade_need;
91: FETCH csr_chk_upgrade_need into l_temp;
92: IF (csr_chk_upgrade_need%NOTFOUND) THEN
93: dbms_output.put_line('Inside seed - Upgrade needed');

Line 93: dbms_output.put_line('Inside seed - Upgrade needed');

89: dbms_output.put_line('Inside seed');
90: OPEN csr_chk_upgrade_need;
91: FETCH csr_chk_upgrade_need into l_temp;
92: IF (csr_chk_upgrade_need%NOTFOUND) THEN
93: dbms_output.put_line('Inside seed - Upgrade needed');
94: OPEN csr_chk_param_exists;
95: FETCH csr_chk_param_exists into l_param_id;
96: IF(csr_chk_param_exists%NOTFOUND) THEN
97: dbms_output.put_line('Inside seed - Upgrade needed - Need to create');

Line 97: dbms_output.put_line('Inside seed - Upgrade needed - Need to create');

93: dbms_output.put_line('Inside seed - Upgrade needed');
94: OPEN csr_chk_param_exists;
95: FETCH csr_chk_param_exists into l_param_id;
96: IF(csr_chk_param_exists%NOTFOUND) THEN
97: dbms_output.put_line('Inside seed - Upgrade needed - Need to create');
98: -- Create
99: INSERT INTO CCT_MIDDLEWARE_PARAMS
100: (MIDDLEWARE_PARAM_ID, MIDDLEWARE_TYPE_ID, NAME, TYPE, LENGTH,ORDERING_SEQUENCE,DOMAIN_LOOKUP_TYPE,
101: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY)

Line 108: dbms_output.put_line('Inside seed - Upgrade needed - Need to Update, l_param_id='||l_param_id);

104:
105: ELSIF (csr_chk_param_exists%FOUND) THEN
106: -- Update
107: Fetch csr_chk_param_exists into l_param_id;
108: dbms_output.put_line('Inside seed - Upgrade needed - Need to Update, l_param_id='||l_param_id);
109: update CCT_MIDDLEWARE_PARAMS
110: set MIDDLEWARE_TYPE_ID =P_MIDDLEWARE_TYPE_ID,
111: NAME = P_NAME,
112: TYPE = P_TYPE,

Line 127: dbms_output.put_line('Leaving seed');

123: CLOSE csr_chk_param_exists;
124:
125: END IF;
126: CLOSE csr_chk_upgrade_need;
127: dbms_output.put_line('Leaving seed');
128: EXCEPTION
129: WHEN others THEN
130: CLOSE csr_chk_upgrade_need;
131: CLOSE csr_chk_param_exists;