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_ALL dependencies on CZ_PRICE_GROUPS

Line 425: ELSIF(lower_table_name='cz_price_groups') THEN

421: Inserts, Updates, x_failed, Dups, inXFR_GROUP);
422: ELSIF(lower_table_name='cz_prices') THEN
423: CZ_IMP_PR_MAIN.MAIN_PRICE(inRun_ID, commit_size, max_err,
424: Inserts, Updates, x_failed, Dups, inXFR_GROUP);
425: ELSIF(lower_table_name='cz_price_groups') THEN
426: CZ_IMP_PR_MAIN.MAIN_PRICE_GROUP(inRun_ID, commit_size, max_err,
427: Inserts, Updates, x_failed, Dups, inXFR_GROUP);
428: ELSIF(lower_table_name='cz_localized_texts') THEN
429: CZ_IMP_PS_NODE.MAIN_INTL_TEXT(inRun_ID, commit_size, max_err,

Line 477: FROM CZ_PRICE_GROUPS

473: ------------------------------------------------------------------------------------------
474: PROCEDURE import_before_start IS
475: CURSOR C_GET_ID(nPriceGroupID number) IS
476: SELECT substr(ORIG_SYS_REF,1,instr(ORIG_SYS_REF,'.')-1)
477: FROM CZ_PRICE_GROUPS
478: WHERE to_number(substr(ORIG_SYS_REF,instr(ORIG_SYS_REF,'.')+1))=nPriceGroupID
479: AND instr(ORIG_SYS_REF,'.')<>0;
480: CURSOR C_SET_ID IS
481: SELECT PRICE_GROUP_ID FROM CZ_PRICE_GROUPS

Line 481: SELECT PRICE_GROUP_ID FROM CZ_PRICE_GROUPS

477: FROM CZ_PRICE_GROUPS
478: WHERE to_number(substr(ORIG_SYS_REF,instr(ORIG_SYS_REF,'.')+1))=nPriceGroupID
479: AND instr(ORIG_SYS_REF,'.')<>0;
480: CURSOR C_SET_ID IS
481: SELECT PRICE_GROUP_ID FROM CZ_PRICE_GROUPS
482: WHERE ORIG_SYS_REF IS NULL FOR UPDATE;
483:
484: nPriceGroupID CZ_PRICE_GROUPS.PRICE_GROUP_ID%TYPE;
485: sOrigSysRef CZ_PRICE_GROUPS.ORIG_SYS_REF%TYPE;

Line 484: nPriceGroupID CZ_PRICE_GROUPS.PRICE_GROUP_ID%TYPE;

480: CURSOR C_SET_ID IS
481: SELECT PRICE_GROUP_ID FROM CZ_PRICE_GROUPS
482: WHERE ORIG_SYS_REF IS NULL FOR UPDATE;
483:
484: nPriceGroupID CZ_PRICE_GROUPS.PRICE_GROUP_ID%TYPE;
485: sOrigSysRef CZ_PRICE_GROUPS.ORIG_SYS_REF%TYPE;
486: bIdFound BOOLEAN := FALSE;
487: xERROR BOOLEAN := FALSE;
488:

Line 485: sOrigSysRef CZ_PRICE_GROUPS.ORIG_SYS_REF%TYPE;

481: SELECT PRICE_GROUP_ID FROM CZ_PRICE_GROUPS
482: WHERE ORIG_SYS_REF IS NULL FOR UPDATE;
483:
484: nPriceGroupID CZ_PRICE_GROUPS.PRICE_GROUP_ID%TYPE;
485: sOrigSysRef CZ_PRICE_GROUPS.ORIG_SYS_REF%TYPE;
486: bIdFound BOOLEAN := FALSE;
487: xERROR BOOLEAN := FALSE;
488:
489: BEGIN

Line 502: UPDATE CZ_PRICE_GROUPS SET ORIG_SYS_REF=sOrigSysRef WHERE CURRENT OF C_SET_ID;

498: CLOSE C_GET_ID;
499:
500: IF(bIdFound) THEN
501: BEGIN
502: UPDATE CZ_PRICE_GROUPS SET ORIG_SYS_REF=sOrigSysRef WHERE CURRENT OF C_SET_ID;
503: EXCEPTION
504: WHEN OTHERS THEN
505: xERROR:=cz_utils.log_report(SQLERRM,1,'CZ_IMP_ALL.IMPORT_BEFORE_START',11276);
506: END;

Line 515: CURSOR C_GET_RELATED(sOrigSysRef CZ_PRICE_GROUPS.ORIG_SYS_REF%TYPE) IS

511: COMMIT;
512: END import_before_start;
513: ------------------------------------------------------------------------------------------
514: PROCEDURE import_after_complete(inRUN_ID IN PLS_INTEGER) IS
515: CURSOR C_GET_RELATED(sOrigSysRef CZ_PRICE_GROUPS.ORIG_SYS_REF%TYPE) IS
516: SELECT PRICE_GROUP_ID FROM CZ_PRICE_GROUPS
517: WHERE instr(ORIG_SYS_REF,'.')<>0 AND
518: substr(ORIG_SYS_REF,1,instr(ORIG_SYS_REF,'.')-1)=sOrigSysRef;
519: CURSOR C_GET_HOST IS

Line 516: SELECT PRICE_GROUP_ID FROM CZ_PRICE_GROUPS

512: END import_before_start;
513: ------------------------------------------------------------------------------------------
514: PROCEDURE import_after_complete(inRUN_ID IN PLS_INTEGER) IS
515: CURSOR C_GET_RELATED(sOrigSysRef CZ_PRICE_GROUPS.ORIG_SYS_REF%TYPE) IS
516: SELECT PRICE_GROUP_ID FROM CZ_PRICE_GROUPS
517: WHERE instr(ORIG_SYS_REF,'.')<>0 AND
518: substr(ORIG_SYS_REF,1,instr(ORIG_SYS_REF,'.')-1)=sOrigSysRef;
519: CURSOR C_GET_HOST IS
520: SELECT * FROM CZ_PRICE_GROUPS

Line 520: SELECT * FROM CZ_PRICE_GROUPS

516: SELECT PRICE_GROUP_ID FROM CZ_PRICE_GROUPS
517: WHERE instr(ORIG_SYS_REF,'.')<>0 AND
518: substr(ORIG_SYS_REF,1,instr(ORIG_SYS_REF,'.')-1)=sOrigSysRef;
519: CURSOR C_GET_HOST IS
520: SELECT * FROM CZ_PRICE_GROUPS
521: WHERE ORIG_SYS_REF IS NOT NULL AND instr(ORIG_SYS_REF,'.')=0
522: FOR UPDATE;
523: P_GET_HOST C_GET_HOST%ROWTYPE;
524:

Line 525: nPriceGroupID CZ_PRICE_GROUPS.PRICE_GROUP_ID%TYPE;

521: WHERE ORIG_SYS_REF IS NOT NULL AND instr(ORIG_SYS_REF,'.')=0
522: FOR UPDATE;
523: P_GET_HOST C_GET_HOST%ROWTYPE;
524:
525: nPriceGroupID CZ_PRICE_GROUPS.PRICE_GROUP_ID%TYPE;
526: bRelatedFound BOOLEAN := FALSE;
527: xERROR BOOLEAN := FALSE;
528: nAllocateBlock PLS_INTEGER:=1;
529: nAllocateCounter PLS_INTEGER;

Line 543: select desc_text from cz_price_groups

539: cursor c_listcontrol is
540: select price_list_id from cz_xfr_price_lists
541: where deleted_flag='0';
542: cursor c_pricegroup(nPriceListId number) is
543: select desc_text from cz_price_groups
544: where orig_sys_ref=to_char(nPriceListId)
545: and deleted_flag='0';
546:
547: nPriceListId cz_xfr_price_lists.price_list_id%type;

Line 548: sDescription cz_price_groups.desc_text%type;

544: where orig_sys_ref=to_char(nPriceListId)
545: and deleted_flag='0';
546:
547: nPriceListId cz_xfr_price_lists.price_list_id%type;
548: sDescription cz_price_groups.desc_text%type;
549: sDisabled cz_xfr_tables.disabled%type;
550: xERROR BOOLEAN := FALSE;
551:
552: begin

Line 556: from cz_xfr_tables where dst_table='CZ_PRICE_GROUPS' and xfr_group='IMPORT';

552: begin
553:
554: begin
555: select disabled into sDisabled
556: from cz_xfr_tables where dst_table='CZ_PRICE_GROUPS' and xfr_group='IMPORT';
557: exception
558: when others then
559: sDisabled:='1';
560: end;

Line 621: UPDATE CZ_PRICE_GROUPS SET

617: CLOSE C_GET_RELATED;
618:
619: IF(bRelatedFound)THEN
620: BEGIN
621: UPDATE CZ_PRICE_GROUPS SET
622: DESC_TEXT=P_GET_HOST.DESC_TEXT,
623: CURRENCY=P_GET_HOST.CURRENCY,
624: NAME=P_GET_HOST.NAME,
625: USER_NUM01=P_GET_HOST.USER_NUM01,

Line 641: UPDATE CZ_PRICE_GROUPS SET ORIG_SYS_REF=NULL

637: LAST_UPDATED_BY=P_GET_HOST.LAST_UPDATED_BY,
638: SECURITY_MASK=P_GET_HOST.SECURITY_MASK,
639: CHECKOUT_USER=P_GET_HOST.CHECKOUT_USER
640: WHERE PRICE_GROUP_ID=nPriceGroupID;
641: UPDATE CZ_PRICE_GROUPS SET ORIG_SYS_REF=NULL
642: WHERE CURRENT OF C_GET_HOST;
643: EXCEPTION
644: WHEN OTHERS THEN
645: xERROR:=cz_utils.log_report(SQLERRM,1,'CZ_IMP_ALL.IMPORT_AFTER_COMPLETE',11276,inRUN_ID);

Line 652: SELECT CZ_PRICE_GROUPS_S.NEXTVAL INTO nNextValue FROM DUAL;

648: BEGIN
649: nAllocateCounter:=nAllocateCounter+1;
650: IF(nAllocateCounter=nAllocateBlock)THEN
651: nAllocateCounter:=0;
652: SELECT CZ_PRICE_GROUPS_S.NEXTVAL INTO nNextValue FROM DUAL;
653: END IF;
654: INSERT INTO CZ_PRICE_GROUPS
655: (PRICE_GROUP_ID,DESC_TEXT,CURRENCY,ORIG_SYS_REF,
656: NAME,USER_NUM01,USER_NUM02,USER_NUM03,USER_NUM04,

Line 654: INSERT INTO CZ_PRICE_GROUPS

650: IF(nAllocateCounter=nAllocateBlock)THEN
651: nAllocateCounter:=0;
652: SELECT CZ_PRICE_GROUPS_S.NEXTVAL INTO nNextValue FROM DUAL;
653: END IF;
654: INSERT INTO CZ_PRICE_GROUPS
655: (PRICE_GROUP_ID,DESC_TEXT,CURRENCY,ORIG_SYS_REF,
656: NAME,USER_NUM01,USER_NUM02,USER_NUM03,USER_NUM04,
657: USER_STR01,USER_STR02,USER_STR03,USER_STR04,DELETED_FLAG,
658: SECURITY_MASK,CHECKOUT_USER,

Line 670: UPDATE CZ_PRICE_GROUPS SET ORIG_SYS_REF=NULL

666: P_GET_HOST.USER_STR03,P_GET_HOST.USER_STR04,P_GET_HOST.DELETED_FLAG,
667: P_GET_HOST.SECURITY_MASK,
668: P_GET_HOST.CHECKOUT_USER,
669: SYSDATE,SYSDATE,1,1);
670: UPDATE CZ_PRICE_GROUPS SET ORIG_SYS_REF=NULL
671: WHERE CURRENT OF C_GET_HOST;
672: EXCEPTION
673: WHEN OTHERS THEN
674: xERROR:=cz_utils.log_report(SQLERRM,1,'CZ_IMP_ALL.IMPORT_AFTER_COMPLETE',11276,inRUN_ID);