APPS.CZ_IMP_ALL dependencies on CZ_XFR_PROJECT_BILLS_S

Line 749: select nTop_ID,nOrg_ID,'0','OPTIONAL',cz_xfr_project_bills_s.NEXTVAL,COPY_CHILD_MODELS,server_id

745: END;
746:
747: insert into cz_xfr_project_bills (top_item_id,organization_id,deleted_flag,explosion_type,model_ps_node_id,
748: copy_addl_child_models,source_server)
749: select nTop_ID,nOrg_ID,'0','OPTIONAL',cz_xfr_project_bills_s.NEXTVAL,COPY_CHILD_MODELS,server_id
750: from dual where not exists
751: (select 1 from cz_xfr_project_bills where organization_id=nOrg_ID and
752: top_item_id=nTop_ID and explosion_type='OPTIONAL' and source_server = server_id);
753: update cz_xfr_project_bills set deleted_flag='0',copy_addl_child_models = COPY_CHILD_MODELS

Line 753: update cz_xfr_project_bills set deleted_flag='0',copy_addl_child_models = COPY_CHILD_MODELS

749: select nTop_ID,nOrg_ID,'0','OPTIONAL',cz_xfr_project_bills_s.NEXTVAL,COPY_CHILD_MODELS,server_id
750: from dual where not exists
751: (select 1 from cz_xfr_project_bills where organization_id=nOrg_ID and
752: top_item_id=nTop_ID and explosion_type='OPTIONAL' and source_server = server_id);
753: update cz_xfr_project_bills set deleted_flag='0',copy_addl_child_models = COPY_CHILD_MODELS
754: where organization_id=nOrg_ID and
755: top_item_id=nTop_ID and explosion_type='OPTIONAL' and source_server = server_id;
756: COMMIT;
757: EXCEPTION

Line 791: update cz_xfr_project_bills set

787: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.SETSINGLEBILLSTATE',11276,NULL);
788: RAISE;
789: END;
790:
791: update cz_xfr_project_bills set
792: deleted_flag=DECODE(UPPER(sState),'0','1','OFF','1','NO','1','DISABLE','1',
793: '1','0','ON','0','YES','0','ENABLE','0',DELETED_FLAG)
794: where organization_id=nOrg_ID and top_item_id=nTop_ID and explosion_type='OPTIONAL' AND
795: source_server = server_id;

Line 844: update cz_xfr_project_bills set

840: AND organization_id = nOrg_ID
841: AND concatenated_segments = sTop_ID
842: AND rownum = 1;
843:
844: update cz_xfr_project_bills set
845: deleted_flag='1'
846: where organization_id=nOrg_ID and top_item_id=nTop_ID
847: and source_server = server_id;
848: