eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CCT_MIDDLEWARE_PARAM_PKG dependencies on CCT_MIDDLEWARE_PARAMS

Line 70: FROM CCT_MIDDLEWARE_PARAMS

66: ) IS
67:
68: CURSOR csr_chk_upgrade_need IS
69: SELECT 1
70: FROM CCT_MIDDLEWARE_PARAMS
71: WHERE NAME= P_NAME
72: and TYPE = P_TYPE
73: and LENGTH = P_LENGTH
74: and MIDDLEWARE_TYPE_ID = P_MIDDLEWARE_TYPE_ID

Line 81: FROM CCT_MIDDLEWARE_PARAMS

77:
78:
79: CURSOR csr_chk_param_exists IS
80: SELECT MIDDLEWARE_PARAM_ID
81: FROM CCT_MIDDLEWARE_PARAMS
82: WHERE NAME= P_NAME
83: and MIDDLEWARE_TYPE_ID = P_MIDDLEWARE_TYPE_ID;
84:
85: l_param_id cct_middleware_params.middleware_param_id%TYPE;

Line 85: l_param_id cct_middleware_params.middleware_param_id%TYPE;

81: FROM CCT_MIDDLEWARE_PARAMS
82: WHERE NAME= P_NAME
83: and MIDDLEWARE_TYPE_ID = P_MIDDLEWARE_TYPE_ID;
84:
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');

Line 99: INSERT INTO CCT_MIDDLEWARE_PARAMS

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)
102: select CCT_MIDDLEWARE_PARAMS_S.NEXTVAL+1000, P_MIDDLEWARE_TYPE_ID, P_NAME, P_TYPE, P_LENGTH,P_ORDERING_SEQUENCE,P_DOMAIN_LOOKUP_TYPE,sysdate, 1, sysdate, 1
103: from dual where not exists (SELECT 1 FROM CCT_MIDDLEWARE_PARAMS WHERE NAME=P_NAME and MIDDLEWARE_TYPE_ID = P_MIDDLEWARE_TYPE_ID);

Line 102: select CCT_MIDDLEWARE_PARAMS_S.NEXTVAL+1000, P_MIDDLEWARE_TYPE_ID, P_NAME, P_TYPE, P_LENGTH,P_ORDERING_SEQUENCE,P_DOMAIN_LOOKUP_TYPE,sysdate, 1, sysdate, 1

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)
102: select CCT_MIDDLEWARE_PARAMS_S.NEXTVAL+1000, P_MIDDLEWARE_TYPE_ID, P_NAME, P_TYPE, P_LENGTH,P_ORDERING_SEQUENCE,P_DOMAIN_LOOKUP_TYPE,sysdate, 1, sysdate, 1
103: from dual where not exists (SELECT 1 FROM CCT_MIDDLEWARE_PARAMS WHERE NAME=P_NAME and MIDDLEWARE_TYPE_ID = P_MIDDLEWARE_TYPE_ID);
104:
105: ELSIF (csr_chk_param_exists%FOUND) THEN
106: -- Update

Line 103: from dual where not exists (SELECT 1 FROM CCT_MIDDLEWARE_PARAMS WHERE NAME=P_NAME and MIDDLEWARE_TYPE_ID = P_MIDDLEWARE_TYPE_ID);

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)
102: select CCT_MIDDLEWARE_PARAMS_S.NEXTVAL+1000, P_MIDDLEWARE_TYPE_ID, P_NAME, P_TYPE, P_LENGTH,P_ORDERING_SEQUENCE,P_DOMAIN_LOOKUP_TYPE,sysdate, 1, sysdate, 1
103: from dual where not exists (SELECT 1 FROM CCT_MIDDLEWARE_PARAMS WHERE NAME=P_NAME and MIDDLEWARE_TYPE_ID = P_MIDDLEWARE_TYPE_ID);
104:
105: ELSIF (csr_chk_param_exists%FOUND) THEN
106: -- Update
107: Fetch csr_chk_param_exists into l_param_id;

Line 109: update CCT_MIDDLEWARE_PARAMS

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,
113: LENGTH = P_LENGTH,