DBA Data[Home] [Help]

APPS.CZ_IMP_AC_XFR dependencies on CZ_CUSTOMERS

Line 264: NOUPDATE_CUSTOMER_NAME := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CUSTOMER_NAME',inXFR_GROUP);

260:
261: -- Make sure that the DataSet exists
262: BEGIN
263: -- Get the Update Flags for each column
264: NOUPDATE_CUSTOMER_NAME := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CUSTOMER_NAME',inXFR_GROUP);
265: NOUPDATE_PARENT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','PARENT_ID',inXFR_GROUP);
266: NOUPDATE_DIVISION := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','DIVISION',inXFR_GROUP);
267: NOUPDATE_NOTE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','NOTE',inXFR_GROUP);
268: NOUPDATE_DESC_TEXT := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','DESC_TEXT',inXFR_GROUP);

Line 265: NOUPDATE_PARENT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','PARENT_ID',inXFR_GROUP);

261: -- Make sure that the DataSet exists
262: BEGIN
263: -- Get the Update Flags for each column
264: NOUPDATE_CUSTOMER_NAME := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CUSTOMER_NAME',inXFR_GROUP);
265: NOUPDATE_PARENT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','PARENT_ID',inXFR_GROUP);
266: NOUPDATE_DIVISION := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','DIVISION',inXFR_GROUP);
267: NOUPDATE_NOTE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','NOTE',inXFR_GROUP);
268: NOUPDATE_DESC_TEXT := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','DESC_TEXT',inXFR_GROUP);
269: NOUPDATE_CUSTOMER_STATUS := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CUSTOMER_STATUS',inXFR_GROUP);

Line 266: NOUPDATE_DIVISION := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','DIVISION',inXFR_GROUP);

262: BEGIN
263: -- Get the Update Flags for each column
264: NOUPDATE_CUSTOMER_NAME := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CUSTOMER_NAME',inXFR_GROUP);
265: NOUPDATE_PARENT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','PARENT_ID',inXFR_GROUP);
266: NOUPDATE_DIVISION := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','DIVISION',inXFR_GROUP);
267: NOUPDATE_NOTE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','NOTE',inXFR_GROUP);
268: NOUPDATE_DESC_TEXT := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','DESC_TEXT',inXFR_GROUP);
269: NOUPDATE_CUSTOMER_STATUS := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CUSTOMER_STATUS',inXFR_GROUP);
270: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','ORIG_SYS_REF',inXFR_GROUP);

Line 267: NOUPDATE_NOTE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','NOTE',inXFR_GROUP);

263: -- Get the Update Flags for each column
264: NOUPDATE_CUSTOMER_NAME := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CUSTOMER_NAME',inXFR_GROUP);
265: NOUPDATE_PARENT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','PARENT_ID',inXFR_GROUP);
266: NOUPDATE_DIVISION := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','DIVISION',inXFR_GROUP);
267: NOUPDATE_NOTE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','NOTE',inXFR_GROUP);
268: NOUPDATE_DESC_TEXT := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','DESC_TEXT',inXFR_GROUP);
269: NOUPDATE_CUSTOMER_STATUS := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CUSTOMER_STATUS',inXFR_GROUP);
270: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','ORIG_SYS_REF',inXFR_GROUP);
271: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','DELETED_FLAG',inXFR_GROUP);

Line 268: NOUPDATE_DESC_TEXT := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','DESC_TEXT',inXFR_GROUP);

264: NOUPDATE_CUSTOMER_NAME := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CUSTOMER_NAME',inXFR_GROUP);
265: NOUPDATE_PARENT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','PARENT_ID',inXFR_GROUP);
266: NOUPDATE_DIVISION := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','DIVISION',inXFR_GROUP);
267: NOUPDATE_NOTE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','NOTE',inXFR_GROUP);
268: NOUPDATE_DESC_TEXT := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','DESC_TEXT',inXFR_GROUP);
269: NOUPDATE_CUSTOMER_STATUS := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CUSTOMER_STATUS',inXFR_GROUP);
270: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','ORIG_SYS_REF',inXFR_GROUP);
271: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','DELETED_FLAG',inXFR_GROUP);
272: NOUPDATE_USER_STR01 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR01',inXFR_GROUP);

Line 269: NOUPDATE_CUSTOMER_STATUS := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CUSTOMER_STATUS',inXFR_GROUP);

265: NOUPDATE_PARENT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','PARENT_ID',inXFR_GROUP);
266: NOUPDATE_DIVISION := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','DIVISION',inXFR_GROUP);
267: NOUPDATE_NOTE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','NOTE',inXFR_GROUP);
268: NOUPDATE_DESC_TEXT := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','DESC_TEXT',inXFR_GROUP);
269: NOUPDATE_CUSTOMER_STATUS := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CUSTOMER_STATUS',inXFR_GROUP);
270: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','ORIG_SYS_REF',inXFR_GROUP);
271: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','DELETED_FLAG',inXFR_GROUP);
272: NOUPDATE_USER_STR01 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR01',inXFR_GROUP);
273: NOUPDATE_USER_STR02 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR02',inXFR_GROUP);

Line 270: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','ORIG_SYS_REF',inXFR_GROUP);

266: NOUPDATE_DIVISION := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','DIVISION',inXFR_GROUP);
267: NOUPDATE_NOTE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','NOTE',inXFR_GROUP);
268: NOUPDATE_DESC_TEXT := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','DESC_TEXT',inXFR_GROUP);
269: NOUPDATE_CUSTOMER_STATUS := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CUSTOMER_STATUS',inXFR_GROUP);
270: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','ORIG_SYS_REF',inXFR_GROUP);
271: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','DELETED_FLAG',inXFR_GROUP);
272: NOUPDATE_USER_STR01 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR01',inXFR_GROUP);
273: NOUPDATE_USER_STR02 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR02',inXFR_GROUP);
274: NOUPDATE_USER_STR03 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR03',inXFR_GROUP);

Line 271: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','DELETED_FLAG',inXFR_GROUP);

267: NOUPDATE_NOTE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','NOTE',inXFR_GROUP);
268: NOUPDATE_DESC_TEXT := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','DESC_TEXT',inXFR_GROUP);
269: NOUPDATE_CUSTOMER_STATUS := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CUSTOMER_STATUS',inXFR_GROUP);
270: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','ORIG_SYS_REF',inXFR_GROUP);
271: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','DELETED_FLAG',inXFR_GROUP);
272: NOUPDATE_USER_STR01 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR01',inXFR_GROUP);
273: NOUPDATE_USER_STR02 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR02',inXFR_GROUP);
274: NOUPDATE_USER_STR03 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR03',inXFR_GROUP);
275: NOUPDATE_USER_STR04 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR04',inXFR_GROUP);

Line 272: NOUPDATE_USER_STR01 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR01',inXFR_GROUP);

268: NOUPDATE_DESC_TEXT := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','DESC_TEXT',inXFR_GROUP);
269: NOUPDATE_CUSTOMER_STATUS := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CUSTOMER_STATUS',inXFR_GROUP);
270: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','ORIG_SYS_REF',inXFR_GROUP);
271: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','DELETED_FLAG',inXFR_GROUP);
272: NOUPDATE_USER_STR01 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR01',inXFR_GROUP);
273: NOUPDATE_USER_STR02 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR02',inXFR_GROUP);
274: NOUPDATE_USER_STR03 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR03',inXFR_GROUP);
275: NOUPDATE_USER_STR04 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR04',inXFR_GROUP);
276: NOUPDATE_USER_NUM01 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM01',inXFR_GROUP);

Line 273: NOUPDATE_USER_STR02 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR02',inXFR_GROUP);

269: NOUPDATE_CUSTOMER_STATUS := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CUSTOMER_STATUS',inXFR_GROUP);
270: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','ORIG_SYS_REF',inXFR_GROUP);
271: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','DELETED_FLAG',inXFR_GROUP);
272: NOUPDATE_USER_STR01 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR01',inXFR_GROUP);
273: NOUPDATE_USER_STR02 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR02',inXFR_GROUP);
274: NOUPDATE_USER_STR03 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR03',inXFR_GROUP);
275: NOUPDATE_USER_STR04 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR04',inXFR_GROUP);
276: NOUPDATE_USER_NUM01 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM01',inXFR_GROUP);
277: NOUPDATE_USER_NUM02 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM02',inXFR_GROUP);

Line 274: NOUPDATE_USER_STR03 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR03',inXFR_GROUP);

270: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','ORIG_SYS_REF',inXFR_GROUP);
271: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','DELETED_FLAG',inXFR_GROUP);
272: NOUPDATE_USER_STR01 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR01',inXFR_GROUP);
273: NOUPDATE_USER_STR02 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR02',inXFR_GROUP);
274: NOUPDATE_USER_STR03 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR03',inXFR_GROUP);
275: NOUPDATE_USER_STR04 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR04',inXFR_GROUP);
276: NOUPDATE_USER_NUM01 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM01',inXFR_GROUP);
277: NOUPDATE_USER_NUM02 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM02',inXFR_GROUP);
278: NOUPDATE_USER_NUM03 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM03',inXFR_GROUP);

Line 275: NOUPDATE_USER_STR04 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR04',inXFR_GROUP);

271: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','DELETED_FLAG',inXFR_GROUP);
272: NOUPDATE_USER_STR01 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR01',inXFR_GROUP);
273: NOUPDATE_USER_STR02 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR02',inXFR_GROUP);
274: NOUPDATE_USER_STR03 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR03',inXFR_GROUP);
275: NOUPDATE_USER_STR04 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR04',inXFR_GROUP);
276: NOUPDATE_USER_NUM01 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM01',inXFR_GROUP);
277: NOUPDATE_USER_NUM02 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM02',inXFR_GROUP);
278: NOUPDATE_USER_NUM03 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM03',inXFR_GROUP);
279: NOUPDATE_USER_NUM04 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM04',inXFR_GROUP);

Line 276: NOUPDATE_USER_NUM01 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM01',inXFR_GROUP);

272: NOUPDATE_USER_STR01 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR01',inXFR_GROUP);
273: NOUPDATE_USER_STR02 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR02',inXFR_GROUP);
274: NOUPDATE_USER_STR03 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR03',inXFR_GROUP);
275: NOUPDATE_USER_STR04 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR04',inXFR_GROUP);
276: NOUPDATE_USER_NUM01 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM01',inXFR_GROUP);
277: NOUPDATE_USER_NUM02 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM02',inXFR_GROUP);
278: NOUPDATE_USER_NUM03 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM03',inXFR_GROUP);
279: NOUPDATE_USER_NUM04 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM04',inXFR_GROUP);
280: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CREATION_DATE',inXFR_GROUP);

Line 277: NOUPDATE_USER_NUM02 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM02',inXFR_GROUP);

273: NOUPDATE_USER_STR02 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR02',inXFR_GROUP);
274: NOUPDATE_USER_STR03 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR03',inXFR_GROUP);
275: NOUPDATE_USER_STR04 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR04',inXFR_GROUP);
276: NOUPDATE_USER_NUM01 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM01',inXFR_GROUP);
277: NOUPDATE_USER_NUM02 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM02',inXFR_GROUP);
278: NOUPDATE_USER_NUM03 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM03',inXFR_GROUP);
279: NOUPDATE_USER_NUM04 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM04',inXFR_GROUP);
280: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CREATION_DATE',inXFR_GROUP);
281: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','LAST_UPDATE_DATE',inXFR_GROUP);

Line 278: NOUPDATE_USER_NUM03 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM03',inXFR_GROUP);

274: NOUPDATE_USER_STR03 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR03',inXFR_GROUP);
275: NOUPDATE_USER_STR04 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR04',inXFR_GROUP);
276: NOUPDATE_USER_NUM01 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM01',inXFR_GROUP);
277: NOUPDATE_USER_NUM02 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM02',inXFR_GROUP);
278: NOUPDATE_USER_NUM03 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM03',inXFR_GROUP);
279: NOUPDATE_USER_NUM04 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM04',inXFR_GROUP);
280: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CREATION_DATE',inXFR_GROUP);
281: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','LAST_UPDATE_DATE',inXFR_GROUP);
282: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CREATED_BY',inXFR_GROUP);

Line 279: NOUPDATE_USER_NUM04 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM04',inXFR_GROUP);

275: NOUPDATE_USER_STR04 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_STR04',inXFR_GROUP);
276: NOUPDATE_USER_NUM01 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM01',inXFR_GROUP);
277: NOUPDATE_USER_NUM02 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM02',inXFR_GROUP);
278: NOUPDATE_USER_NUM03 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM03',inXFR_GROUP);
279: NOUPDATE_USER_NUM04 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM04',inXFR_GROUP);
280: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CREATION_DATE',inXFR_GROUP);
281: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','LAST_UPDATE_DATE',inXFR_GROUP);
282: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CREATED_BY',inXFR_GROUP);
283: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','LAST_UPDATED_BY',inXFR_GROUP);

Line 280: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CREATION_DATE',inXFR_GROUP);

276: NOUPDATE_USER_NUM01 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM01',inXFR_GROUP);
277: NOUPDATE_USER_NUM02 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM02',inXFR_GROUP);
278: NOUPDATE_USER_NUM03 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM03',inXFR_GROUP);
279: NOUPDATE_USER_NUM04 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM04',inXFR_GROUP);
280: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CREATION_DATE',inXFR_GROUP);
281: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','LAST_UPDATE_DATE',inXFR_GROUP);
282: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CREATED_BY',inXFR_GROUP);
283: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','LAST_UPDATED_BY',inXFR_GROUP);
284: NOUPDATE_SECURITY_MASK := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','SECURITY_MASK',inXFR_GROUP);

Line 281: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','LAST_UPDATE_DATE',inXFR_GROUP);

277: NOUPDATE_USER_NUM02 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM02',inXFR_GROUP);
278: NOUPDATE_USER_NUM03 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM03',inXFR_GROUP);
279: NOUPDATE_USER_NUM04 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM04',inXFR_GROUP);
280: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CREATION_DATE',inXFR_GROUP);
281: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','LAST_UPDATE_DATE',inXFR_GROUP);
282: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CREATED_BY',inXFR_GROUP);
283: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','LAST_UPDATED_BY',inXFR_GROUP);
284: NOUPDATE_SECURITY_MASK := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','SECURITY_MASK',inXFR_GROUP);
285: NOUPDATE_CHECKOUT_USER := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CHECKOUT_USER',inXFR_GROUP);

Line 282: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CREATED_BY',inXFR_GROUP);

278: NOUPDATE_USER_NUM03 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM03',inXFR_GROUP);
279: NOUPDATE_USER_NUM04 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM04',inXFR_GROUP);
280: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CREATION_DATE',inXFR_GROUP);
281: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','LAST_UPDATE_DATE',inXFR_GROUP);
282: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CREATED_BY',inXFR_GROUP);
283: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','LAST_UPDATED_BY',inXFR_GROUP);
284: NOUPDATE_SECURITY_MASK := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','SECURITY_MASK',inXFR_GROUP);
285: NOUPDATE_CHECKOUT_USER := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CHECKOUT_USER',inXFR_GROUP);
286: NOUPDATE_WAREHOUSE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','WAREHOUSE_ID',inXFR_GROUP);

Line 283: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','LAST_UPDATED_BY',inXFR_GROUP);

279: NOUPDATE_USER_NUM04 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','USER_NUM04',inXFR_GROUP);
280: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CREATION_DATE',inXFR_GROUP);
281: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','LAST_UPDATE_DATE',inXFR_GROUP);
282: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CREATED_BY',inXFR_GROUP);
283: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','LAST_UPDATED_BY',inXFR_GROUP);
284: NOUPDATE_SECURITY_MASK := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','SECURITY_MASK',inXFR_GROUP);
285: NOUPDATE_CHECKOUT_USER := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CHECKOUT_USER',inXFR_GROUP);
286: NOUPDATE_WAREHOUSE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','WAREHOUSE_ID',inXFR_GROUP);
287: NOUPDATE_PRICE_LIST_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','PRICE_LIST_ID',inXFR_GROUP);

Line 284: NOUPDATE_SECURITY_MASK := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','SECURITY_MASK',inXFR_GROUP);

280: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CREATION_DATE',inXFR_GROUP);
281: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','LAST_UPDATE_DATE',inXFR_GROUP);
282: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CREATED_BY',inXFR_GROUP);
283: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','LAST_UPDATED_BY',inXFR_GROUP);
284: NOUPDATE_SECURITY_MASK := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','SECURITY_MASK',inXFR_GROUP);
285: NOUPDATE_CHECKOUT_USER := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CHECKOUT_USER',inXFR_GROUP);
286: NOUPDATE_WAREHOUSE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','WAREHOUSE_ID',inXFR_GROUP);
287: NOUPDATE_PRICE_LIST_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','PRICE_LIST_ID',inXFR_GROUP);
288:

Line 285: NOUPDATE_CHECKOUT_USER := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CHECKOUT_USER',inXFR_GROUP);

281: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','LAST_UPDATE_DATE',inXFR_GROUP);
282: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CREATED_BY',inXFR_GROUP);
283: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','LAST_UPDATED_BY',inXFR_GROUP);
284: NOUPDATE_SECURITY_MASK := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','SECURITY_MASK',inXFR_GROUP);
285: NOUPDATE_CHECKOUT_USER := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CHECKOUT_USER',inXFR_GROUP);
286: NOUPDATE_WAREHOUSE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','WAREHOUSE_ID',inXFR_GROUP);
287: NOUPDATE_PRICE_LIST_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','PRICE_LIST_ID',inXFR_GROUP);
288:
289: OPEN c_xfr_CUSTOMER;

Line 286: NOUPDATE_WAREHOUSE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','WAREHOUSE_ID',inXFR_GROUP);

282: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CREATED_BY',inXFR_GROUP);
283: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','LAST_UPDATED_BY',inXFR_GROUP);
284: NOUPDATE_SECURITY_MASK := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','SECURITY_MASK',inXFR_GROUP);
285: NOUPDATE_CHECKOUT_USER := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CHECKOUT_USER',inXFR_GROUP);
286: NOUPDATE_WAREHOUSE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','WAREHOUSE_ID',inXFR_GROUP);
287: NOUPDATE_PRICE_LIST_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','PRICE_LIST_ID',inXFR_GROUP);
288:
289: OPEN c_xfr_CUSTOMER;
290: LOOP

Line 287: NOUPDATE_PRICE_LIST_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','PRICE_LIST_ID',inXFR_GROUP);

283: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','LAST_UPDATED_BY',inXFR_GROUP);
284: NOUPDATE_SECURITY_MASK := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','SECURITY_MASK',inXFR_GROUP);
285: NOUPDATE_CHECKOUT_USER := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','CHECKOUT_USER',inXFR_GROUP);
286: NOUPDATE_WAREHOUSE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','WAREHOUSE_ID',inXFR_GROUP);
287: NOUPDATE_PRICE_LIST_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMERS','PRICE_LIST_ID',inXFR_GROUP);
288:
289: OPEN c_xfr_CUSTOMER;
290: LOOP
291: IF (nCommitCount>= COMMIT_SIZE) THEN

Line 304: INSERT INTO CZ_CUSTOMERS (

300: x_xfr_CUSTOMER_f:=c_xfr_CUSTOMER%FOUND;
301: EXIT WHEN (NOT x_xfr_CUSTOMER_f Or nFailed >= Max_Err);
302: IF (p_xfr_CUSTOMER.DISPOSITION = 'I') THEN
303: BEGIN
304: INSERT INTO CZ_CUSTOMERS (
305: ORIG_SYS_REF,CUSTOMER_ID,CUSTOMER_NAME,PARENT_ID,
306: DIVISION,NOTE,DESC_TEXT,CUSTOMER_STATUS,DELETED_FLAG,
307: USER_STR01,USER_STR02,USER_STR03,
308: USER_STR04,USER_NUM01,USER_NUM02,USER_NUM03,USER_NUM04,

Line 340: UPDATE CZ_CUSTOMERS SET

336: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_AC_XFR.XFR_CUSTOMER',11276);
337: END ;
338: ELSIF (p_xfr_CUSTOMER.DISPOSITION = 'M') THEN
339: BEGIN
340: UPDATE CZ_CUSTOMERS SET
341: CUSTOMER_NAME=DECODE(NOUPDATE_CUSTOMER_NAME,0, p_xfr_CUSTOMER.CUSTOMER_NAME ,CUSTOMER_NAME),
342: PARENT_ID=DECODE(NOUPDATE_PARENT_ID,0, p_xfr_CUSTOMER.PARENT_ID ,PARENT_ID),
343: DIVISION=DECODE(NOUPDATE_DIVISION,0, p_xfr_CUSTOMER.DIVISION ,DIVISION),
344: NOTE=DECODE(NOUPDATE_NOTE,0, p_xfr_CUSTOMER.NOTE ,NOTE),