182: inXFR_GROUP IN VARCHAR2)
183: RETURN NUMBER IS
184: BEGIN
185: DECLARE
186: NOUPDATE_FLAG CZ_XFR_FIELDS.NOUPDATE%TYPE;
187: BEGIN
188: SELECT NOUPDATE INTO NOUPDATE_FLAG
189: FROM CZ_XFR_FIELDS,CZ_XFR_TABLES
190: WHERE CZ_XFR_TABLES.DST_TABLE=TABLE_NAME AND CZ_XFR_FIELDS.DST_FIELD=COLUMN_NAME
185: DECLARE
186: NOUPDATE_FLAG CZ_XFR_FIELDS.NOUPDATE%TYPE;
187: BEGIN
188: SELECT NOUPDATE INTO NOUPDATE_FLAG
189: FROM CZ_XFR_FIELDS,CZ_XFR_TABLES
190: WHERE CZ_XFR_TABLES.DST_TABLE=TABLE_NAME AND CZ_XFR_FIELDS.DST_FIELD=COLUMN_NAME
191: AND CZ_XFR_TABLES.ORDER_SEQ=CZ_XFR_FIELDS.ORDER_SEQ
192: AND CZ_XFR_TABLES.XFR_GROUP=CZ_XFR_FIELDS.XFR_GROUP
193: AND CZ_XFR_FIELDS.XFR_GROUP=inXFR_GROUP AND ROWNUM=1;
186: NOUPDATE_FLAG CZ_XFR_FIELDS.NOUPDATE%TYPE;
187: BEGIN
188: SELECT NOUPDATE INTO NOUPDATE_FLAG
189: FROM CZ_XFR_FIELDS,CZ_XFR_TABLES
190: WHERE CZ_XFR_TABLES.DST_TABLE=TABLE_NAME AND CZ_XFR_FIELDS.DST_FIELD=COLUMN_NAME
191: AND CZ_XFR_TABLES.ORDER_SEQ=CZ_XFR_FIELDS.ORDER_SEQ
192: AND CZ_XFR_TABLES.XFR_GROUP=CZ_XFR_FIELDS.XFR_GROUP
193: AND CZ_XFR_FIELDS.XFR_GROUP=inXFR_GROUP AND ROWNUM=1;
194:
187: BEGIN
188: SELECT NOUPDATE INTO NOUPDATE_FLAG
189: FROM CZ_XFR_FIELDS,CZ_XFR_TABLES
190: WHERE CZ_XFR_TABLES.DST_TABLE=TABLE_NAME AND CZ_XFR_FIELDS.DST_FIELD=COLUMN_NAME
191: AND CZ_XFR_TABLES.ORDER_SEQ=CZ_XFR_FIELDS.ORDER_SEQ
192: AND CZ_XFR_TABLES.XFR_GROUP=CZ_XFR_FIELDS.XFR_GROUP
193: AND CZ_XFR_FIELDS.XFR_GROUP=inXFR_GROUP AND ROWNUM=1;
194:
195: RETURN TO_NUMBER(NVL(NOUPDATE_FLAG,'0'));
188: SELECT NOUPDATE INTO NOUPDATE_FLAG
189: FROM CZ_XFR_FIELDS,CZ_XFR_TABLES
190: WHERE CZ_XFR_TABLES.DST_TABLE=TABLE_NAME AND CZ_XFR_FIELDS.DST_FIELD=COLUMN_NAME
191: AND CZ_XFR_TABLES.ORDER_SEQ=CZ_XFR_FIELDS.ORDER_SEQ
192: AND CZ_XFR_TABLES.XFR_GROUP=CZ_XFR_FIELDS.XFR_GROUP
193: AND CZ_XFR_FIELDS.XFR_GROUP=inXFR_GROUP AND ROWNUM=1;
194:
195: RETURN TO_NUMBER(NVL(NOUPDATE_FLAG,'0'));
196:
189: FROM CZ_XFR_FIELDS,CZ_XFR_TABLES
190: WHERE CZ_XFR_TABLES.DST_TABLE=TABLE_NAME AND CZ_XFR_FIELDS.DST_FIELD=COLUMN_NAME
191: AND CZ_XFR_TABLES.ORDER_SEQ=CZ_XFR_FIELDS.ORDER_SEQ
192: AND CZ_XFR_TABLES.XFR_GROUP=CZ_XFR_FIELDS.XFR_GROUP
193: AND CZ_XFR_FIELDS.XFR_GROUP=inXFR_GROUP AND ROWNUM=1;
194:
195: RETURN TO_NUMBER(NVL(NOUPDATE_FLAG,'0'));
196:
197: EXCEPTION