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.CZ_IMP_AC_XFR dependencies on CZ_ADDRESSES

Line 440: NOUPDATE_CUSTOMER_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','CUSTOMER_ID',inXFR_GROUP);

436:
437: -- Make sure that the DataSet exists
438: BEGIN
439: -- Get the Update Flags for each column
440: NOUPDATE_CUSTOMER_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','CUSTOMER_ID',inXFR_GROUP);
441: NOUPDATE_COUNTRY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','COUNTRY',inXFR_GROUP);
442: NOUPDATE_ADDR_LINE1 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','ADDR_LINE1',inXFR_GROUP);
443: NOUPDATE_ADDR_LINE2 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','ADDR_LINE2',inXFR_GROUP);
444: NOUPDATE_CITY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','CITY',inXFR_GROUP);

Line 441: NOUPDATE_COUNTRY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','COUNTRY',inXFR_GROUP);

437: -- Make sure that the DataSet exists
438: BEGIN
439: -- Get the Update Flags for each column
440: NOUPDATE_CUSTOMER_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','CUSTOMER_ID',inXFR_GROUP);
441: NOUPDATE_COUNTRY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','COUNTRY',inXFR_GROUP);
442: NOUPDATE_ADDR_LINE1 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','ADDR_LINE1',inXFR_GROUP);
443: NOUPDATE_ADDR_LINE2 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','ADDR_LINE2',inXFR_GROUP);
444: NOUPDATE_CITY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','CITY',inXFR_GROUP);
445: NOUPDATE_POSTAL_CODE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','POSTAL_CODE',inXFR_GROUP);

Line 442: NOUPDATE_ADDR_LINE1 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','ADDR_LINE1',inXFR_GROUP);

438: BEGIN
439: -- Get the Update Flags for each column
440: NOUPDATE_CUSTOMER_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','CUSTOMER_ID',inXFR_GROUP);
441: NOUPDATE_COUNTRY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','COUNTRY',inXFR_GROUP);
442: NOUPDATE_ADDR_LINE1 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','ADDR_LINE1',inXFR_GROUP);
443: NOUPDATE_ADDR_LINE2 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','ADDR_LINE2',inXFR_GROUP);
444: NOUPDATE_CITY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','CITY',inXFR_GROUP);
445: NOUPDATE_POSTAL_CODE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','POSTAL_CODE',inXFR_GROUP);
446: NOUPDATE_STATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','STATE',inXFR_GROUP);

Line 443: NOUPDATE_ADDR_LINE2 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','ADDR_LINE2',inXFR_GROUP);

439: -- Get the Update Flags for each column
440: NOUPDATE_CUSTOMER_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','CUSTOMER_ID',inXFR_GROUP);
441: NOUPDATE_COUNTRY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','COUNTRY',inXFR_GROUP);
442: NOUPDATE_ADDR_LINE1 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','ADDR_LINE1',inXFR_GROUP);
443: NOUPDATE_ADDR_LINE2 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','ADDR_LINE2',inXFR_GROUP);
444: NOUPDATE_CITY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','CITY',inXFR_GROUP);
445: NOUPDATE_POSTAL_CODE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','POSTAL_CODE',inXFR_GROUP);
446: NOUPDATE_STATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','STATE',inXFR_GROUP);
447: NOUPDATE_PROVINCE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','PROVINCE',inXFR_GROUP);

Line 444: NOUPDATE_CITY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','CITY',inXFR_GROUP);

440: NOUPDATE_CUSTOMER_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','CUSTOMER_ID',inXFR_GROUP);
441: NOUPDATE_COUNTRY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','COUNTRY',inXFR_GROUP);
442: NOUPDATE_ADDR_LINE1 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','ADDR_LINE1',inXFR_GROUP);
443: NOUPDATE_ADDR_LINE2 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','ADDR_LINE2',inXFR_GROUP);
444: NOUPDATE_CITY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','CITY',inXFR_GROUP);
445: NOUPDATE_POSTAL_CODE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','POSTAL_CODE',inXFR_GROUP);
446: NOUPDATE_STATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','STATE',inXFR_GROUP);
447: NOUPDATE_PROVINCE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','PROVINCE',inXFR_GROUP);
448: NOUPDATE_COUNTY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','COUNTY',inXFR_GROUP);

Line 445: NOUPDATE_POSTAL_CODE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','POSTAL_CODE',inXFR_GROUP);

441: NOUPDATE_COUNTRY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','COUNTRY',inXFR_GROUP);
442: NOUPDATE_ADDR_LINE1 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','ADDR_LINE1',inXFR_GROUP);
443: NOUPDATE_ADDR_LINE2 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','ADDR_LINE2',inXFR_GROUP);
444: NOUPDATE_CITY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','CITY',inXFR_GROUP);
445: NOUPDATE_POSTAL_CODE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','POSTAL_CODE',inXFR_GROUP);
446: NOUPDATE_STATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','STATE',inXFR_GROUP);
447: NOUPDATE_PROVINCE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','PROVINCE',inXFR_GROUP);
448: NOUPDATE_COUNTY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','COUNTY',inXFR_GROUP);
449: NOUPDATE_BILL_TO_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','BILL_TO_FLAG',inXFR_GROUP);

Line 446: NOUPDATE_STATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','STATE',inXFR_GROUP);

442: NOUPDATE_ADDR_LINE1 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','ADDR_LINE1',inXFR_GROUP);
443: NOUPDATE_ADDR_LINE2 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','ADDR_LINE2',inXFR_GROUP);
444: NOUPDATE_CITY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','CITY',inXFR_GROUP);
445: NOUPDATE_POSTAL_CODE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','POSTAL_CODE',inXFR_GROUP);
446: NOUPDATE_STATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','STATE',inXFR_GROUP);
447: NOUPDATE_PROVINCE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','PROVINCE',inXFR_GROUP);
448: NOUPDATE_COUNTY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','COUNTY',inXFR_GROUP);
449: NOUPDATE_BILL_TO_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','BILL_TO_FLAG',inXFR_GROUP);
450: NOUPDATE_SHIP_TO_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','SHIP_TO_FLAG',inXFR_GROUP);

Line 447: NOUPDATE_PROVINCE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','PROVINCE',inXFR_GROUP);

443: NOUPDATE_ADDR_LINE2 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','ADDR_LINE2',inXFR_GROUP);
444: NOUPDATE_CITY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','CITY',inXFR_GROUP);
445: NOUPDATE_POSTAL_CODE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','POSTAL_CODE',inXFR_GROUP);
446: NOUPDATE_STATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','STATE',inXFR_GROUP);
447: NOUPDATE_PROVINCE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','PROVINCE',inXFR_GROUP);
448: NOUPDATE_COUNTY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','COUNTY',inXFR_GROUP);
449: NOUPDATE_BILL_TO_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','BILL_TO_FLAG',inXFR_GROUP);
450: NOUPDATE_SHIP_TO_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','SHIP_TO_FLAG',inXFR_GROUP);
451: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','ORIG_SYS_REF',inXFR_GROUP);

Line 448: NOUPDATE_COUNTY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','COUNTY',inXFR_GROUP);

444: NOUPDATE_CITY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','CITY',inXFR_GROUP);
445: NOUPDATE_POSTAL_CODE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','POSTAL_CODE',inXFR_GROUP);
446: NOUPDATE_STATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','STATE',inXFR_GROUP);
447: NOUPDATE_PROVINCE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','PROVINCE',inXFR_GROUP);
448: NOUPDATE_COUNTY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','COUNTY',inXFR_GROUP);
449: NOUPDATE_BILL_TO_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','BILL_TO_FLAG',inXFR_GROUP);
450: NOUPDATE_SHIP_TO_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','SHIP_TO_FLAG',inXFR_GROUP);
451: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','ORIG_SYS_REF',inXFR_GROUP);
452: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','CREATION_DATE',inXFR_GROUP);

Line 449: NOUPDATE_BILL_TO_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','BILL_TO_FLAG',inXFR_GROUP);

445: NOUPDATE_POSTAL_CODE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','POSTAL_CODE',inXFR_GROUP);
446: NOUPDATE_STATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','STATE',inXFR_GROUP);
447: NOUPDATE_PROVINCE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','PROVINCE',inXFR_GROUP);
448: NOUPDATE_COUNTY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','COUNTY',inXFR_GROUP);
449: NOUPDATE_BILL_TO_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','BILL_TO_FLAG',inXFR_GROUP);
450: NOUPDATE_SHIP_TO_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','SHIP_TO_FLAG',inXFR_GROUP);
451: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','ORIG_SYS_REF',inXFR_GROUP);
452: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','CREATION_DATE',inXFR_GROUP);
453: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','LAST_UPDATE_DATE',inXFR_GROUP);

Line 450: NOUPDATE_SHIP_TO_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','SHIP_TO_FLAG',inXFR_GROUP);

446: NOUPDATE_STATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','STATE',inXFR_GROUP);
447: NOUPDATE_PROVINCE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','PROVINCE',inXFR_GROUP);
448: NOUPDATE_COUNTY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','COUNTY',inXFR_GROUP);
449: NOUPDATE_BILL_TO_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','BILL_TO_FLAG',inXFR_GROUP);
450: NOUPDATE_SHIP_TO_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','SHIP_TO_FLAG',inXFR_GROUP);
451: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','ORIG_SYS_REF',inXFR_GROUP);
452: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','CREATION_DATE',inXFR_GROUP);
453: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','LAST_UPDATE_DATE',inXFR_GROUP);
454: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','CREATED_BY',inXFR_GROUP);

Line 451: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','ORIG_SYS_REF',inXFR_GROUP);

447: NOUPDATE_PROVINCE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','PROVINCE',inXFR_GROUP);
448: NOUPDATE_COUNTY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','COUNTY',inXFR_GROUP);
449: NOUPDATE_BILL_TO_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','BILL_TO_FLAG',inXFR_GROUP);
450: NOUPDATE_SHIP_TO_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','SHIP_TO_FLAG',inXFR_GROUP);
451: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','ORIG_SYS_REF',inXFR_GROUP);
452: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','CREATION_DATE',inXFR_GROUP);
453: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','LAST_UPDATE_DATE',inXFR_GROUP);
454: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','CREATED_BY',inXFR_GROUP);
455: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','LAST_UPDATED_BY',inXFR_GROUP);

Line 452: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','CREATION_DATE',inXFR_GROUP);

448: NOUPDATE_COUNTY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','COUNTY',inXFR_GROUP);
449: NOUPDATE_BILL_TO_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','BILL_TO_FLAG',inXFR_GROUP);
450: NOUPDATE_SHIP_TO_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','SHIP_TO_FLAG',inXFR_GROUP);
451: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','ORIG_SYS_REF',inXFR_GROUP);
452: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','CREATION_DATE',inXFR_GROUP);
453: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','LAST_UPDATE_DATE',inXFR_GROUP);
454: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','CREATED_BY',inXFR_GROUP);
455: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','LAST_UPDATED_BY',inXFR_GROUP);
456: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','DELETED_FLAG',inXFR_GROUP);

Line 453: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','LAST_UPDATE_DATE',inXFR_GROUP);

449: NOUPDATE_BILL_TO_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','BILL_TO_FLAG',inXFR_GROUP);
450: NOUPDATE_SHIP_TO_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','SHIP_TO_FLAG',inXFR_GROUP);
451: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','ORIG_SYS_REF',inXFR_GROUP);
452: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','CREATION_DATE',inXFR_GROUP);
453: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','LAST_UPDATE_DATE',inXFR_GROUP);
454: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','CREATED_BY',inXFR_GROUP);
455: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','LAST_UPDATED_BY',inXFR_GROUP);
456: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','DELETED_FLAG',inXFR_GROUP);
457:

Line 454: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','CREATED_BY',inXFR_GROUP);

450: NOUPDATE_SHIP_TO_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','SHIP_TO_FLAG',inXFR_GROUP);
451: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','ORIG_SYS_REF',inXFR_GROUP);
452: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','CREATION_DATE',inXFR_GROUP);
453: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','LAST_UPDATE_DATE',inXFR_GROUP);
454: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','CREATED_BY',inXFR_GROUP);
455: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','LAST_UPDATED_BY',inXFR_GROUP);
456: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','DELETED_FLAG',inXFR_GROUP);
457:
458: OPEN c_xfr_ADDRESS;

Line 455: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','LAST_UPDATED_BY',inXFR_GROUP);

451: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','ORIG_SYS_REF',inXFR_GROUP);
452: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','CREATION_DATE',inXFR_GROUP);
453: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','LAST_UPDATE_DATE',inXFR_GROUP);
454: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','CREATED_BY',inXFR_GROUP);
455: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','LAST_UPDATED_BY',inXFR_GROUP);
456: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','DELETED_FLAG',inXFR_GROUP);
457:
458: OPEN c_xfr_ADDRESS;
459: LOOP

Line 456: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','DELETED_FLAG',inXFR_GROUP);

452: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','CREATION_DATE',inXFR_GROUP);
453: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','LAST_UPDATE_DATE',inXFR_GROUP);
454: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','CREATED_BY',inXFR_GROUP);
455: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','LAST_UPDATED_BY',inXFR_GROUP);
456: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESSES','DELETED_FLAG',inXFR_GROUP);
457:
458: OPEN c_xfr_ADDRESS;
459: LOOP
460: IF (nCommitCount>= COMMIT_SIZE) THEN

Line 474: INSERT INTO CZ_ADDRESSES (ADDRESS_ID,CUSTOMER_ID, COUNTRY,ADDR_LINE1,

470: EXIT WHEN (NOT x_xfr_ADDRESS_f Or nFailed >= Max_Err);
471:
472: IF (p_xfr_ADDRESS.DISPOSITION = 'I') THEN
473: BEGIN
474: INSERT INTO CZ_ADDRESSES (ADDRESS_ID,CUSTOMER_ID, COUNTRY,ADDR_LINE1,
475: ADDR_LINE2,CITY,POSTAL_CODE,STATE,PROVINCE,
476: COUNTY,BILL_TO_FLAG,SHIP_TO_FLAG,ORIG_SYS_REF,
477: CREATION_DATE,LAST_UPDATE_DATE,CREATED_BY,LAST_UPDATED_BY,DELETED_FLAG
478: ) VALUES(

Line 506: UPDATE CZ_ADDRESSES SET

502: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_AC_XFR.XFR_ADDRESS',11276);
503: END ;
504: ELSIF (p_xfr_ADDRESS.DISPOSITION = 'M') THEN
505: BEGIN
506: UPDATE CZ_ADDRESSES SET
507: CUSTOMER_ID=DECODE(NOUPDATE_CUSTOMER_ID,0, p_xfr_ADDRESS.CUSTOMER_ID ,CUSTOMER_ID),
508: COUNTRY=DECODE(NOUPDATE_COUNTRY,0, p_xfr_ADDRESS.COUNTRY ,COUNTRY),
509: ADDR_LINE1=DECODE(NOUPDATE_ADDR_LINE1,0, p_xfr_ADDRESS.ADDR_LINE1 ,ADDR_LINE1),
510: ADDR_LINE2=DECODE(NOUPDATE_ADDR_LINE2,0, p_xfr_ADDRESS.ADDR_LINE2,ADDR_LINE2),