APPS.IGI_CHECK_VERSION dependencies on IGI_INST_VERSION

Line 7: | This will populate the IGI_INST_VERSION table. It will be run during |

3: /*===========================================================================+
4: | FUNCTION |
5: | IGI_CHECK_VER |
6: | DESCRIPTION |
7: | This will populate the IGI_INST_VERSION table. It will be run during |
8: | the autoupgrade process |
9: | |
10: | SCOPE |
11: | -- Public |

Line 83: EXECUTE IMMEDIATE 'create synonym '||l_schema||'.opsfV31_33 for '||l_schema||'.igi_inst_version';

79: IF (rowCnt > 0)
80: THEN
81: l_igi_prev_ver := NULL;
82: -- 31 or 33 version is now detected in script igi33syn.sql
83: EXECUTE IMMEDIATE 'create synonym '||l_schema||'.opsfV31_33 for '||l_schema||'.igi_inst_version';
84: EXECUTE IMMEDIATE 'create synonym '||l_schema||'.opsfV12_31_33 for '||l_schema||'.igi_inst_version';
85: ELSE
86: l_igi_prev_ver := '12';
87: EXECUTE IMMEDIATE 'create synonym '||l_schema||'.opsfV12 for '||l_schema||'.igi_inst_version';

Line 84: EXECUTE IMMEDIATE 'create synonym '||l_schema||'.opsfV12_31_33 for '||l_schema||'.igi_inst_version';

80: THEN
81: l_igi_prev_ver := NULL;
82: -- 31 or 33 version is now detected in script igi33syn.sql
83: EXECUTE IMMEDIATE 'create synonym '||l_schema||'.opsfV31_33 for '||l_schema||'.igi_inst_version';
84: EXECUTE IMMEDIATE 'create synonym '||l_schema||'.opsfV12_31_33 for '||l_schema||'.igi_inst_version';
85: ELSE
86: l_igi_prev_ver := '12';
87: EXECUTE IMMEDIATE 'create synonym '||l_schema||'.opsfV12 for '||l_schema||'.igi_inst_version';
88: EXECUTE IMMEDIATE 'create synonym '||l_schema||'.opsfV12_31_33 for '||l_schema||'.igi_inst_version';

Line 87: EXECUTE IMMEDIATE 'create synonym '||l_schema||'.opsfV12 for '||l_schema||'.igi_inst_version';

83: EXECUTE IMMEDIATE 'create synonym '||l_schema||'.opsfV31_33 for '||l_schema||'.igi_inst_version';
84: EXECUTE IMMEDIATE 'create synonym '||l_schema||'.opsfV12_31_33 for '||l_schema||'.igi_inst_version';
85: ELSE
86: l_igi_prev_ver := '12';
87: EXECUTE IMMEDIATE 'create synonym '||l_schema||'.opsfV12 for '||l_schema||'.igi_inst_version';
88: EXECUTE IMMEDIATE 'create synonym '||l_schema||'.opsfV12_31_33 for '||l_schema||'.igi_inst_version';
89: END IF;
90:
91: -- DBMS_OUTPUT.PUT_LINE ('version found = '|| l_igi_prev_ver);

Line 88: EXECUTE IMMEDIATE 'create synonym '||l_schema||'.opsfV12_31_33 for '||l_schema||'.igi_inst_version';

84: EXECUTE IMMEDIATE 'create synonym '||l_schema||'.opsfV12_31_33 for '||l_schema||'.igi_inst_version';
85: ELSE
86: l_igi_prev_ver := '12';
87: EXECUTE IMMEDIATE 'create synonym '||l_schema||'.opsfV12 for '||l_schema||'.igi_inst_version';
88: EXECUTE IMMEDIATE 'create synonym '||l_schema||'.opsfV12_31_33 for '||l_schema||'.igi_inst_version';
89: END IF;
90:
91: -- DBMS_OUTPUT.PUT_LINE ('version found = '|| l_igi_prev_ver);
92:

Line 113: insert INTO igi_inst_version

109: -- DBMS_OUTPUT.PUT_LINE ('IGI does not exist in this environment');
110: END IF;
111:
112: -- Insert version into table
113: insert INTO igi_inst_version
114: (
115: igi_opsfi_inst,
116: igi_prev_ver,
117: igi_igi_inst

Line 136: | This will check the IGI_INST_VERSION table. It will RETURN the |

132: /*===========================================================================+
133: | FUNCTION |
134: | IGI_CHECK_UPG |
135: | DESCRIPTION |
136: | This will check the IGI_INST_VERSION table. It will RETURN the |
137: | previous OPSF version used |
138: | |
139: | SCOPE |
140: | -- Public |

Line 157: FROM IGI_INST_VERSION;

153: l_igi_prev_ver VARCHAR2(2);
154: BEGIN
155: SELECT IGI_PREV_VER
156: INTO l_igi_prev_ver
157: FROM IGI_INST_VERSION;
158:
159:
160: -- DBMS_OUTPUT.PUT_LINE('this is version ' || l_igi_prev_ver);
161: RETURN l_igi_prev_ver;